Ab Initio ETL Developer

The Applications Development Intermediate Programmer Analyst is an intermediate level position responsible for participation in the establishment and implementation of new or revised application systems and programs in coordination with the Technology team. The overall objective of this role is to contribute to applications systems analysis and programming activities.
 

Key Responsibilities
 Technical Leadership
• Lead end-to-end design and development of ETL workflows using Ab Initio (GDE, Co>Operating System, Conduct-IT, Control Center)
• Define and enforce best practices for graph design, parallelism, and performance optimization
• Conduct code reviews and ensure adherence to enterprise standards
 Data Engineering & Development
• Develop complex Ab Initio graphs, PSETs, and Conduct-IT plans for scalable data processing
• Build and manage high-volume batch and real-time pipelines using Ab Initio and messaging systems (TIBCO, queues)
• Perform data extraction, transformation, and validation using SQL (Oracle, Teradata) and UNIX scripting
 Architecture & Design
• Design and implement metadata-driven ETL frameworks and reusable components
• Architect data migration and staging layers for large-scale transformation programs
• Ensure scalability, fault tolerance, and high-performance using Ab Initio parallelism techniques
s execution
 Support to Production activities
• Troubleshoot ETL failures, performance bottlenecks, and data issues
• Perform root cause analysis and ensure high system reliability and uptime

Required Skills & Experience
 Core Skills
• 3+ years of hands-on experience in Ab Initio ETL Development
• Strong expertise in:
• GDE (Graphical Development Environment)
• Co>Operating System
o Conduct-IT, Control Center
o Ab Initio components (Rollup, Join, Normalize, Scan, Sort, etc.)
o Parallelism (data, pipeline, component)
• Strong SQL skills with Oracle and Teradata
• Proficiency in UNIX Shell scripting
 Good to Have
• Experience with data archival and object storage (Amazon S3, Dell ECS)
• Familiarity with schedulers like Autosys / Control-M
• Scripting (Unix Shell, Python)
• Basic knowledge of Java or C
 Domain Knowledge
• Strong experience in Banking & Financial Services (BFS)
• Exposure to capital markets, trade processing, payments, or SWIFT systems
• Understanding of data migration, reconciliation, and regulatory data handling
 

Qualifications:

• 3+ years of relevant experience in Ab Initio ETL Development, Perform data extraction, transformation, and validation using SQL (Oracle, Teradata) and UNIX scripting
• Intermediate level experience in Applications Development role
• Consistently demonstrates clear and concise written and verbal communication
• Demonstrated problem-solving and decision-making skills
• 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.

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

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

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

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

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

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

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.