ETL Developer Analyst

Citigroup Inc.; Chennai District; On-site; INR 8,00,000 - 12,00,000; Full time

Job summary

A global financial services company seeks an Intermediate Programmer Analyst in Chennai, responsible for ETL development using Ab Initio or Talend. The role requires 4-6 years of experience, strong SQL skills, and expertise in data processing workflows. Candidates should have a Bachelor's degree and be adept at troubleshooting and collaboration within teams.

Qualifications

• 4-6 years of relevant experience with Talend, Ab Initio.
• Experience with ETL optimization, debugging, and performance tuning.
• Strong knowledge of database systems including Oracle, SQL Server, PostgreSQL.

Responsibilities

• Design, develop, and implement ETL workflows.
• Optimize data processing and troubleshoot performance issues.
• Collaborate with teams to define data requirements.

Skills

ETL development

Ab Initio

Talend

SQL

PL/SQL

data warehousing concepts

problem-solving

teamwork skills

Education

Bachelor’s degree or equivalent experience

Tools

Git

SVN

AWS

Azure

GCP

Job description

Job Description

The Applications Development Intermediate Programmer Analyst is an intermediate level position responsible for ETL development in Ab Initio 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

• 4-6 years of relevant experience working with Talend, 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.

Job Family Group: Technology

Job Family: Applications Development

Time Type: Full time

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.