Informatica Developer

We are looking for an experienced Informatica Developer to join our team for a long-term engagement with one of Indias largest FMCG companies. The candidate will work onsite from our clients Kolkata office, collaborating with cross-functional data and analytics teams to build, optimize, and maintain ETL pipelines and data workflows in a high-performance enterprise environment.

Key Responsibilities:

1. Design, develop, and maintain ETL processes using Informatica PowerCenter / IICS.

2. Develop and optimize Oracle PL/SQL stored procedures, functions, and triggers for data integration and transformation.

3. Work closely with business analysts and data architects to understand data requirements and deliver efficient solutions.

4. Create and maintain database models, data dictionaries, and mapping documents.

5. Automate recurring data operations using Shell Scripting and schedule jobs as per business needs.

6. Perform data validation, debugging, and performance tuning for Informatica workflows and SQL queries.

7. Collaborate with QA and production support teams to ensure smooth deployment and data accuracy.

Required Skills & Experience

1. 3-4 years of hands-on experience with Informatica PowerCenter / IICS.

2. Strong command over Oracle PL/SQL, DBMS concepts, and query optimization techniques.

3. Experience in Shell Scripting for automation and data movement.

4. Understanding of ETL design principles, data warehousing concepts, and performance tuning.

5. Excellent problem-solving and communication skills.

6. Ability to work independently and coordinate with client teams onsite.

Good to Have

• Exposure to data analytics or FMCG domain projects.
• Experience in working within agile delivery environments.