Ab-Initio ETL Developer, Assistant Vice President

The Ab-Initio ETL Developer is an intermediate-level position responsible for the design, development, and implementation of robust and scalable data integration solutions. The successful candidate will be a key member of the Strategic Ledger program, a critical initiative focused on transforming upstream data into the CIT template for loading into Oracle Financials SaaS. This role is a core part of the Technology team, focusing on building and maintaining the firm's critical data pipelines using the Ab Initio platform. The overall objective is to contribute to high-quality data systems analysis and programming activities that support our strategic financial data objectives.

Responsibilities:

• Design, develop, and maintain high-performance, resilient, and scalable ETL processes using the Ab Initio suite of products (GDE, Co>Operating System, EME) to transform upstream data into the required format for Oracle Financials SaaS.
• Conduct detailed data analysis, data profiling, and data quality assessments to ensure the integrity of data moving through the Strategic Ledger pipelines.
• Translate business requirements from the Strategic Ledger program into technical specifications for ETL jobs and data models.
• Develop and optimize complex SQL queries for data extraction, transformation, and loading across various database platforms.
• Create and manage metadata within the Ab Initio Enterprise Meta>Environment (EME), ensuring proper version control and adherence to development standards for the program.
• Develop Unix/Linux shell scripts for job automation, scheduling, and file manipulation related to the data transformation process.
• Monitor and control all phases of the development process, including analysis, design, construction, testing, and implementation.
• Provide operational support for production applications, troubleshoot issues, and perform performance tuning to meet business SLAs.
• Utilize in-depth specialty knowledge of ETL and Ab Initio to analyze complex >------------------------------------------------------

  Job Family Group:

  Technology

  ------------------------------------------------------

  Job Family:

  Applications Development

  ------------------------------------------------------

  Time Type:

  Full time

  ------------------------------------------------------

  Most Relevant Skills

  Please see the requirements listed above.

  ------------------------------------------------------

  Other Relevant Skills

  For complementary skills, please see above and/or contact the recruiter.

  ------------------------------------------------------

  Citi is an equal opportunity employer, and qualified candidates will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other characteristic protected by law.

  If you are a person with a disability and need a reasonable accommodation to use our search tools and/or apply for a career opportunity review Accessibility at Citi.
  
  View Citi’s EEO Policy Statement and the Know Your Rights poster.