Informatica Developer

We are seeking an experienced Informatica PowerCenter Developer with strong expertise in SQL development and stored procedures. The candidate will be responsible for designing, developing, and maintaining ETL processes, ensuring data accuracy, performance, and scalability across complex data integration environments.

Key Responsibilities

• Design, develop, and implement ETL workflows using Informatica PowerCenter.

• Develop, optimize, and maintain SQL stored procedures, functions, and triggers to support business requirements.

• Collaborate with business analysts, data architects, and stakeholders to understand requirements and translate them into technical solutions.

• Perform data analysis, profiling, and validation to ensure data quality and integrity across multiple sources.

• Troubleshoot, debug, and optimize Informatica mappings, sessions, and workflows for performance improvements.

• Implement error handling, logging, and auditing within ETL processes.

• Support data migrations, enhancements, and production deployments.

• Provide BAU support and work on continuous enhancements of existing ETL solutions.

• Document technical specifications, workflows, and support procedures.

Required Skills & Experience

• 5+ years of hands-on experience with Informatica PowerCenter (mappings, workflows, transformations).

• Strong proficiency in SQL (Oracle, SQL Server, or similar) with proven experience in writing and optimizing complex stored procedures.

• Solid understanding of RDBMS concepts, data modeling, and performance tuning.

• Experience with ETL performance optimization and debugging production issues.

• Familiarity with data warehousing concepts, star/snowflake schema, and dimensional modeling.

• Exposure to scheduling tools (Control-M, Autosys, or similar).

• Strong problem-solving skills and ability to work in a fast-paced, team-oriented environment.

• Excellent communication skills (verbal and written).

Nice-to-Have Skills

• Experience with Informatica IICS / Cloud ETL.

• Knowledge of Python, Shell scripting, or Unix commands for automation.

• Experience with reporting/visualization tools (Tableau, Power BI).

• Understanding of DevOps CI/CD pipelines for ETL deployment.

Education

Bachelor’s degree in Computer Science, Information Systems, or related field (or equivalent experience).

Job Types: Full-time, Permanent, Contractual / Temporary

Pay: ₹1,400,000.00 - ₹1,800,000.00 per year

Benefits:

• Paid sick time
• Paid time off

Experience:

• Informatica: 5 years (Required)

Work Location: In person