Informatica Developer

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

Job summary

ExlService Holdings, Inc. seeks a Data Management and Analytics professional with 6–9 years of ETL & Informatica experience to design, develop, and maintain Informatica-based ETL/ELT workflows.

You will build mappings and workflows for cloud and on-prem integrations, perform cross-source data loading, and troubleshoot performance issues. The role requires strong communication skills, solid ETL/data warehousing knowledge, and experience with SQL and relational databases such as Oracle and

Qualifications

• Graduate in Computer Science, Information Technology, or a related field; 6–9 years of ETL & Informatica experience.
• Strong verbal and written communication skills.
• 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

• 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

Informatica

SQL

ETL

Data warehousing

REST/SOAP integrations

Git

CI/CD

Agile methodologies

Communication skills

Education

Bachelor's degree in Computer Science/Information Technology or related field

Tools

Informatica

Oracle

Netezza

REST API integrations

Git

CI/CD tooling

Job description

• Job Role Data Management and Analytics-Data Informatics
• Experience (In Years) 6-9
• 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

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. 5+ years of experience in ETL & Informatica