The Data Engineer 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 Oracle 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 data-related problems and recommend efficient solutions.
Collaborate with data architects, business analysts, and other technology groups to ensure solutions are aligned with enterprise standards and business needs.
Ensure essential procedures are followed and help define operating standards and processes for the ETL framework.
Serve as an advisor or coach to new or lower-level analysts, sharing expertise in Ab Initio and data integration best practices.
Appropriately assess risk when business decisions are made, demonstrating particular consideration for the firm's reputation and safeguarding Citigroup, its clients, and assets. This includes driving compliance with applicable laws, rules, and regulations related to data handling, adhering to Policy, applying sound ethical judgment, and escalating, managing, and reporting control issues with transparency.
Qualifications:
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.
Working knowledge of consulting/project management techniques/methods is beneficial.
Recommended Qualifications:
- 5-8 years of relevant experience
- Experience in systems analysis and programming of software applications
- Experience in managing and implementing successful projects
- Working knowledge of consulting/project management techniques/methods
- Ability to work under pressure and manage deadlines or unexpected changes in expectations or requirements
Education:
- Bachelor’s degree/University degree or equivalent experience
This job description provides a high-level review of the types of work performed. Other job-related duties may be assigned as required.
------------------------------------------------------
Job Family Group: Technology------------------------------------------------------
Job Family:Applications Development------------------------------------------------------
Time Type:Full time------------------------------------------------------
Primary Location:Tampa Florida United States------------------------------------------------------
Primary Location Full Time Salary Range:$96,960.00 - $145,440.00
In addition to salary, Citi’s offerings may also include, for eligible employees, discretionary and formulaic incentive and retention awards. Citi offers competitive employee benefits, including: medical, dental & vision coverage; 401(k); life, accident, and disability insurance; and wellness programs. Citi also offers paid time off packages, including planned time off (vacation), unplanned time off (sick leave), and paid holidays. For additional information regarding Citi employee benefits, please visit citibenefits.com. Available offerings may vary by jurisdiction, job level, and date of hire.
------------------------------------------------------
Most Relevant Skills Please see the requirements listed above.------------------------------------------------------
Other Relevant Skills For complementary skills, please see above and/or contact the recruiter.------------------------------------------------------
Anticipated Posting Close Date:Jun 22, 2026------------------------------------------------------
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.
Skills Required
- Hands-on experience in data systems analysis and ETL development.
- Proven, in-depth expertise with the Ab Initio platform (GDE, Co>Operating System, EME).
- Strong proficiency in SQL and experience with relational databases (Oracle, Teradata).
- Solid experience with Unix/Linux environments and shell scripting.
- Strong understanding of data warehousing concepts, data modeling, and ETL best practices.
- Bachelor's degree or equivalent experience.
- Demonstrated experience managing and implementing data-centric projects, preferably in financial services.
- Experience with large-scale data transformation projects and loading into financial systems (e.g., Oracle Financials, SAP).
- Experience with job scheduling tools (e.g., Autosys).
- Working knowledge of consulting/project management techniques/methods.
Citi Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Citi and has not been reviewed or approved by Citi.
-
Healthcare Strength — Benefits coverage is positioned as comprehensive, including health, dental, and vision insurance plus on-site clinics, prescription drug support, and disability coverage. Family-building support such as fertility assistance is described as a notable differentiator within the overall package.
-
Retirement Support — Retirement benefits are framed as strong, highlighted by a 401(k) with matching and additional plan options like a Roth 401(k). Financial support is reinforced through discounts and broader financial guidance resources tied to the benefits ecosystem.
-
Wellbeing & Lifestyle Benefits — Wellbeing support extends beyond insurance through programs like an Employee Assistance Program, counseling/legal resources, and gym or wellness reimbursement. These offerings increase the perceived total rewards value even when cash compensation sentiment varies by role.
Citi Insights
What We Do
Citi's mission is to serve as a trusted partner to our clients by responsibly providing financial services that enable growth and economic progress. Our core activities are safeguarding assets, lending money, making payments and accessing the capital markets on behalf of our clients. We have 200 years of experience helping our clients meet the world's toughest challenges and embrace its greatest opportunities. We are Citi, the global bank – an institution connecting millions of people across hundreds of countries and cities.
