Informatica Senior Engineer

Informatica Developer, you will be responsible for designing, developing, and maintaining ETL solutions using Informatica PowerCenter. You will work closely with business analysts, database administrators, and other stakeholders to ensure that data is efficiently extracted, transformed, and loaded into the data warehouse for reporting and analysis.

Key Responsibilities

• Design, develop, and implement ETL workflows using Informatica PowerCenter.
• Extract data from multiple sources (databases, flat files, APIs, etc.) and transform it according to business requirements.
• Implement data integration solutions, perform data cleansing, and ensure data accuracy and consistency.
• Collaborate with business analysts and data architects to understand data requirements.
• Create and maintain mappings, sessions, and workflows in Informatica.
• Monitor and optimize ETL processes to ensure they meet performance standards.
• Perform unit testing and resolve defects during the development phase.
• Design and implement data validation and error handling routines in Informatica.
• Create and maintain technical documentation for all ETL processes.
• Troubleshoot and resolve issues related to ETL processes, data integration, and performance optimization.
• Work on the deployment of ETL jobs in different environments (Development, QA, Production).
• Collaborate with DBAs to optimize database queries and performance.
• Adhere to data governance and security policies during ETL development.

• Proven experience in Informatica PowerCenter and strong knowledge of ETL concepts.
• Solid understanding of relational databases such as Oracle, SQL Server, or DB2.
• Strong proficiency in SQL for querying and data manipulation.
• Experience in designing and implementing complex ETL workflows, mappings, and transformations.
• Knowledge of data warehousing concepts and architecture.
• Familiarity with data modeling and integration techniques.
• Strong debugging and troubleshooting skills in an ETL environment.
• Familiarity with version control systems (e.g., Git, SVN) and software deployment processes.
• Ability to work collaboratively in a team environment.
• Strong communication skills, both written and verbal.

• Experience with cloud-based ETL solutions (AWS, Azure, Google Cloud) and tools like Informatica Cloud Data Integration.
• Knowledge of big data platforms (Hadoop, Spark) and related technologies.
• Experience with other Informatica tools like Informatica MDM, Data Quality, or Informatica PowerExchange.
• Knowledge of Agile methodologies and working in an Agile environment.