Informatica Developer

We are looking for an experienced Informatica Developer to design, develop, and maintain data integration and ETL solutions. The candidate will work with business and technical teams to extract, transform, and load data from multiple sources into enterprise data warehouses and data platforms.

Key Responsibilities

• Design, develop, and maintain ETL workflows and mappings using Informatica.
• Develop complex Informatica mappings, mapplets, workflows, and sessions .
• Extract data from multiple source systems and load data into target databases and data warehouses.
• Perform data transformation, cleansing, validation, and integration .
• Analyze business requirements and translate them into technical ETL specifications.
• Develop reusable ETL components and follow coding and development standards.
• Monitor ETL workflows and troubleshoot production issues.
• Optimize ETL jobs for performance and scalability .
• Perform data analysis and validation using SQL.
• Work with Data Architects, Business Analysts, Developers, and QA teams.
• Implement error handling, logging, and recovery mechanisms.
• Support deployment of Informatica code across development, testing, and production environments.
• Prepare technical documentation for ETL processes and data flows.
• Participate in data migration and data warehouse projects.

Required Technical Skills

Informatica

• Informatica PowerCenter
• Informatica Designer
• Workflow Manager
• Workflow Monitor
• Repository Manager
• Mappings
• Mapplets
• Sessions
• Workflows
• Transformations
• Lookups
• Joiner
• Aggregator
• Router
• Filter
• Sorter
• Update Strategy
• Sequence Generator

Database / SQL

• SQL
• Oracle
• SQL Server
• PostgreSQL
• MySQL
• Database concepts
• Stored Procedures
• Views
• Indexes

Data Warehousing

• ETL / ELT
• Data Warehousing
• Star Schema
• Snowflake Schema
• Fact and Dimension Tables
• Slowly Changing Dimensions ( SCD Type 1/2)
• Data Migration
• Data Quality

Cloud / Big Data – Preferred

• Informatica Intelligent Data Management Cloud (IDMC)
• Informatica Cloud Data Integration ( CDI )
• AWS
• Azure
• Snowflake
• Databricks
• Amazon S3

Other Tools

• Git
• Jenkins
• Jira
• Linux/Unix
• Shell scripting

Key Responsibilities in Production Support

• Monitor daily ETL workflows and identify failures.
• Troubleshoot mapping, workflow, database, and data-related issues.
• Analyze source-to-target data discrepancies.
• Perform root-cause analysis.
• Restart and recover failed workflows.
• Coordinate with database and application teams to resolve production issues.
• Meet SLA requirements for incident resolution.

Experience

• 9+ years of experience in Informatica ETL development .
• Strong experience with Informatica PowerCenter .
• Strong SQL and database knowledge.
• Experience with data warehouse and ETL development.
• Experience working in Agile development environments is preferred.