Citi Group Data Quality Lead Analyst 

United States, Texas, Irving 

822100592

Duties: Develop and automate Data warehouse projects and store it in databases including Teradata, IBM DB2, Cognos, Oracle PL SQL, using Data Analysis, Data Processing, Code Optimization, and Performance Tuning skills. Design, develop and maintain extract, transform, and load (“ETL”) applications using Ab Initio software, XML, HTML, batch and real time process. Capture business requirements to develop business, logical and technical architectures, including data architecture, solution architecture, data models, data quality plans, data integration, API Management. Implement Ab Initio process to ensure business critical data is validated and data quality is maintained throughout the process. Schedule multiple ETL jobs using Autosys and Control-M scheduler. Develop ETL process to read Hadoop source files, process and store files in Hive tables for business user’s easy access. Review the application's current architecture and provide suggestions to improve the applications based on changing data trends and business requirements. Develop applications to validate and process source system files in DQIP model, using XML, HTML, Unix Shell Script. Conduct proof of concept (POC) to develop innovative solutions, provide depth analysis of issues and services with latest offerings from enterprise software such as Ab Initio in order to enhance the existing infrastructure with latest upgrades. Manage resource allocation for smooth deliverable of projects and business reporting issues. Engage with multiple stakeholders including business, operations and peer technology groups to discuss, analyze the requirement and streamline intake process. Prepare and optimize the technical product backlog across all lines of business. A telecommuting/hybrid work schedule may be permitted within a commutable distance from the worksite, in accordance with Citi policies and protocols.

Requirements: Requires a Bachelor’s degree (or foreign equivalent) in Computer Science, Computer Engineering, Software Engineering or related field and 6 years of progressively responsible, post-baccalaureate experience as a Software Engineer, Applications Development Senior Programmer Analyst, ETL Developer, or related position involving Ab Initio ETL standards in Data warehouse applications. 6 years of experience must include: Ab initio, Informatica, Data Stage; Teradata, IBM DB2, Cognos, Oracle PL SQL; Autosys, Control-M, Erwin, XML, HTML, CSS, Unix Shell Scripts; Data Analysis, Data Processing, Code Optimization, Performance tuning; Automating Business Process and Models; Microsoft Visio, Web Services, Crystal Reports; and HP Quality Center, ALM, VSS, EME, XSD. At least 3 years must include: Hadoop, HDFS, Big Data, Hive, Spark. Applicants submit resumes at https://jobs.citi.com/. Please reference Job ID #24743112. EO Employer.

Wage Range: $157,352 to $165,000

Anticipated Posting Close Date:

View the " " poster. View the .

View the .

View the