onsite
Ab Initio ETL Developer - Citi
Software Engineer
Intermediate Ab Initio ETL Developer responsible for designing, developing, and maintaining data integration solutions using Ab Initio, SQL, and data modeling techniques to support enterprise applications.
About the role
Key Responsibilities
- Design, develop, and maintain Ab Initio ETL processes to extract, transform, and load data from diverse source systems into target data warehouses.
- Collaborate with business analysts and data architects to translate business requirements into technical specifications and data models.
- Perform performance tuning, debugging, and optimization of Ab Initio graphs and SQL queries to ensure high throughput and reliability.
- Document data flows, process logic, and data lineage for audit and compliance purposes.
- Participate in code reviews, unit testing, and integration testing to maintain code quality and adherence to best practices.
Requirements
- 3+ years of experience with Ab Initio and ETL development in a production environment.
- Strong proficiency in SQL and relational database concepts.
- Experience with data modeling, data warehousing, and data integration patterns.
- Familiarity with version control (Git) and CI/CD pipelines for data workflows.
- Excellent problem‑solving skills and ability to work collaboratively in a cross‑functional team.