Lead Informatica Developer

ExlService Holdings, Inc.; Pune District; On-site; INR 1,800,000 - 2,800,000; Full time

Job summary

ExlService Holdings, Inc. in Pune seeks an experienced ETL Developer to lead data management and analytics initiatives. The role focuses on development and optimization of Informatica ETL/ELT workflows, partnering with stakeholders to deliver reliable data solutions.

The candidate will perform data extraction, transformation, and loading across multiple sources, requiring strong SQL and hands-on Informatica expertise in an Agile setting.

Qualifications

• Graduate in Computer Science, Information Technology, or a related field.
• 8+ Years of experience in ETL & Informatica

Responsibilities

• Direct interaction with client stakeholders for requirements gathering, management, and delivery status reporting.
• Design, develop, and maintain ETL/ELT workflows using Informatica
• Build and optimize mappings, tasks, and workflows for cloud and on-prem integrations
• Perform data extraction, transformation, and loading across multiple data sources
• Troubleshoot and resolve data integration and performance issues
• Collaborate with business and technical teams in an Agile environment
• Collaborate with BI and data teams to ensure data quality, automation and availability
• Refresh the Facts and Dimension tables using appropriate update strategy

Skills

Verbal communication

Written communication

ETL concepts

SQL

Education

Bachelor's degree in Computer Science or Information Technology

Tools

Informatica

Git

CI/CD

Agile methodologies

Job description

• Job Role Data Management and Analytics-Data development/developers
• Experience (In Years) 9-12
• Job Location Pune

Job Description

Strong Verbal and written Communication skills

Strong hands-on experience with Informatica

Solid understanding of ETL concepts and data warehousing

Experience with advanced SQL

Experience with relational databases (Oracle, Netezza, etc.)

Knowledge of REST/SOAP integrations is a plus

Experience with Git, CI/CD, and Agile methodologies

Responsibilities

Direct interaction with client stakeholders for requirements gathering, management, and delivery status reporting.

Design, develop, and maintain ETL/ELT workflows using Informatica

Build and optimize mappings, tasks, and workflows for cloud and on-prem integrations

Perform data extraction, transformation, and loading across multiple data sources

Troubleshoot and resolve data integration and performance issues

Collaborate with business and technical teams in an Agile environment

Collaborate with BI and data teams to ensure data quality, automation and availability

Refresh the Facts and Dimension tables using appropriate update strategy

Qualifications

Graduate in Computer Science, Information Technology, or a related field.

8+ Years of experience in ETL & Informatica