The Applications Development Intermediate Programmer Analyst is an intermediate level position responsible for ETL development in AbInitio or Talend. The overall objective of this role is to design, develop, and optimize ETL workflows and data integration solutions using Ab Initio or Talend. The role involves working closely with business and technology teams to ensure seamless data processing and transformation.

Responsibilities:

• Design, develop, and implement ETL (Extract, Transform, Load) pipelines using Ab Initio or Talend.

• Work with structured, semi-structured, and unstructured data from multiple sources.
• Optimize data processing and transformation workflows for efficiency and scalability.
• Troubleshoot and resolve performance issues in ETL processes.
• Collaborate with data architects, analysts, and business teams to define data requirements.
• Ensure data quality, integrity, and governance standards are met.
• Develop and maintain metadata and documentation for ETL processes.
• Implement and manage job scheduling and automation tools.

Preferred Qualifications:

• Certifications in Ab Initio, Talend, or cloud technologies are a plus.
• Experience with CI/CD pipelines for ETL deployment.

Qualifications:

• 2-5 years of relevant experience working with Ab Initio (GDE, Express>IT, Conduct>IT) or Talend (Data Fabric, Open Studio, etc.). Strong knowledge of SQL, PL/SQL, and database systems (Oracle, SQL Server, PostgreSQL, etc.).
• Experience with ETL optimization, debugging, and performance tuning.
• Experience in API integration, web services, and cloud platforms (AWS, Azure, GCP) is a plus. Strong understanding of data warehousing concepts and ETL best practices. Hands-on experience with version control tools (Git, SVN, etc.).
• Strong analytical and problem-solving skills. Excellent communication and teamwork skills.
• 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.

Additional preferred skill set - Spark/Scala, Python, Java w/Springboot

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

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.