Data Engineer - Informatica Power Center
Summary
Builds and maintains Informatica PowerCenter ETL workflows to move and transform enterprise data into data warehouses using SQL and Unix scripting.
We are looking for an experienced Informatica PowerCenter Developer with strong hands-on expertise in ETL development, data integration, and data warehousing. The candidate will be responsible for developing and maintaining Informatica workflows, mappings, and ETL processes, working with multiple data sources and databases, and ensuring efficient and reliable data movement across enterprise systems.
Responsibilities
- Develop, implement, and maintain ETL workflows using Informatica PowerCenter.
- Create and manage mappings, mapplets, sessions, and workflows.
- Extract, transform, and load data from multiple source systems into data warehouses.
- Develop complex SQL queries for data extraction, transformation, validation, and reconciliation.
- Perform data cleansing, transformation, validation, and quality checks.
- Monitor ETL workflows and troubleshoot job failures and production issues.
- Optimize Informatica mappings and workflows for performance and scalability.
- Analyze business and technical requirements and translate them into ETL solutions.
- Prepare and maintain source-to-target mapping documents and technical documentation.
- Perform unit testing, integration testing, and support UAT activities.
- Support data migration, data warehouse, and enterprise data integration projects.
- Coordinate with business analysts, data engineers, database teams, and other stakeholders.
- Support deployment of ETL workflows across development, testing, and production environments.
- Provide production support and resolve data-related issues within agreed SLAs.
Requirements
- 3–6 years of hands-on experience with Informatica PowerCenter.
- Strong experience with Informatica Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
- Hands‑on experience developing Mappings, Mapplets, Sessions, and Workflows.
- Strong knowledge of Informatica transformations including Lookup, Expression, Aggregator, Joiner, Router, Update Strategy, Sorter, and Source Qualifier.
- Strong SQL skills with experience in Oracle, SQL Server, PostgreSQL, or similar databases.
- Good understanding of ETL concepts, Data Warehousing, and Data Integration.
- Experience with ETL performance tuning and troubleshooting.
- Understanding of Fact and Dimension tables, Star Schema, and Snowflake Schema.
- Experience with Unix/Linux shell scripting is preferred.
- Exposure to Informatica IICS/IDMC is an advantage.
- Experience with data migration and large-volume data processing is preferred.
- Exposure to Hadoop, Hive, Spark, or Kafka is a plus.
- Bachelor's degree in Computer Science, IT, Software Engineering, Data Engineering, or a related field.