Informatica Developer

Job Description Informatica Developer.

We are seeking an experienced Informatica PowerCenter Developer to join our growing data engineering team. In this role, you will be responsible for designing, developing, testing, and maintaining ETL processes using Informatica PowerCenter to support the data integration needs of the organization. You will work closely with business analysts, data architects, and other stakeholders to implement data solutions that enable informed decision-making across the organization.

Key Responsibilities:

• ETL Development: Design, develop, and deploy efficient ETL processes (Mappings and Workflows) using Informatica PowerCenter for various data integration and migration tasks.
• Perform complex data transformations, cleansing, standardizing and aggregation operations within the ETL workflows to align data with business needs using Informatica transformations.
• Implement data validation and quality checks to ensure the integrity and consistency of the data being integrated.
• Optimize ETL Mapping, workflows and sessions to improve performance and reduce processing time, ensuring that data loads meet the business requirements.
• Develop and manage data mapping, connections, and transformations between various source systems (e.g., relational databases SQL Server, flat files, etc.) and target systems (e.g., SQL Server, Snowflake, Flat Files etc.).
• Resolve issues related to ETL processes, data mapping, and transformation logic. Debug and monitor sessions for errors and failures.
• Create and maintain technical documentation, including process flow diagrams, Functional specification document, ETL mappings documents etc.
• Perform unit testing and prepare the Unit Testing documents for all ETL processes.
• Experience working with databases like Oracle, SQL Server.
• Should have experience in the Stored Procedures, Functions, writing complex queries, and optimizing SQL performance.
• Experience in the scripting like Windows PowerShell and batch script.
• Experience in the Scheduling Tool Autosys.