The Data Engineer ETL Developer is an intermediate-level position focused on designing, developing, and implementing data integration solutions for the Oracle Ledger program. This role is essential for transforming upstream data into the CIT template for Oracle Financials SaaS. The successful candidate will work within the Technology team to build and maintain critical data pipelines using the Ab Initio platform. The position emphasizes high-quality data systems analysis and programming to support strategic financial data objectives.

• Hands-on experience in data systems analysis and ETL development.
• Proven, in-depth expertise with the Ab Initio platform (GDE, Co>Operating System, EME) is mandatory.
• Strong proficiency in SQL and experience with relational databases (e.g., Oracle, Teradata).
• Solid experience with Unix/Linux environments and shell scripting.
• Demonstrated experience in managing and implementing successful data-centric projects, preferably within the financial services industry.
• Strong understanding of data warehousing concepts, data modeling, and ETL best practices.
• Experience with large-scale data transformation projects and loading data into financial systems (e.g., Oracle Financials, SAP) is highly desirable.
• Ability to work under pressure, manage deadlines, and adapt to unexpected changes in requirements.
• Excellent problem-solving and analytical skills.
• Experience with job scheduling tools (e.g., Autosys) is a plus.

• Design, develop, and maintain high-performance, resilient, and scalable ETL processes using the Ab Initio suite of products.
• Conduct detailed data analysis, data profiling, and data quality assessments to ensure data integrity.
• Translate business requirements into technical specifications for ETL jobs and data models.
• Develop and optimize complex SQL queries for data extraction, transformation, and loading.
• Create and manage metadata within the Ab Initio Enterprise Meta>Environment (EME).
• Develop Unix/Linux shell scripts for job automation, scheduling, and file manipulation.
• Monitor and control all phases of the development process, including analysis, design, construction, testing, and implementation.
• Provide operational support for production applications and troubleshoot issues.
• Utilize in-depth specialty knowledge of ETL and Ab Initio to analyze complex data-related problems.
• Collaborate with data architects, business analysts, and other technology groups to ensure alignment with enterprise standards.

• Citi offers a comprehensive benefits package including competitive pay, stock programs, healthcare coverage, retirement plans, paid time off, parental leave, and programs supporting employee wellbeing and professional development.