Informatica developer

Job Title: Informatica Developer

Location: Mumbai, India

Experience Required: 3 to 7 years

Job Description:

We are seeking a skilled and motivated Informatica Developer to join our dynamic team in Mumbai. The ideal candidate will have solid experience in designing and developing ETL solutions using Informatica PowerCenter. You will be working closely with data analysts, business stakeholders, and other developers to ensure timely and high-quality data integration solutions.

Key Responsibilities:

1. Design, develop, and maintain ETL workflows using Informatica PowerCenter to support business intelligence and data warehousing projects.

2. Collaborate with business analysts and stakeholders to understand data requirements and transform them into technical solutions.

3. Develop complex mappings and transformations to integrate, clean, and standardize data from multiple sources.

4. Optimize ETL performance by identifying and resolving bottlenecks and tuning Informatica mappings and sessions.

5. Ensure data quality and integrity through robust validation and exception handling processes.

6. Manage deployment and version control for Informatica code using best practices.

7. Document technical specifications, design, and mapping documents to support development and future maintenance.

8. Work with relational databases (Oracle, SQL Server, etc.) and manual files, writing efficient SQL queries for data extraction and validation.

9. Monitor daily ETL jobs and resolve issues proactively to ensure data availability and accuracy.

10. Perform root cause analysis and debugging for production issues and develop fixes with minimal impact.

Required Skills & Qualifications:

3 to 7 years of hands-on experience in Informatica PowerCenter.

Experience with data warehousing concepts and dimensional modeling.

Excellent problem-solving and communication skills.

Preferred Skills:

Must have experience on Informatica Power Center

Preferred Good SQL knowledge and data warehousing concepts

Location : Mumbai only

Exp : 4 - 7 yrsRole & responsibilities

Preferred candidate profile

Perks and benefits