JOBSEARCHER

Senior Informatica ETL Developer

Job Description:We are looking for an experienced Informatica ETL Developer with strong expertise in Informatica PowerCenter and modern cloud integration technologies.Key Responsibilities:Design, develop, and maintain complex ETL/data integration solutions using Informatica PowerCenter 10.x and IDMC/IICS.Work extensively with Informatica tools including Mapping Designer, Repository Manager, Workflow Manager, Workflow Monitor, Informatica Server, and Repository Server Manager.Develop ETL workflows for loading and transforming data into Data Warehouses and Data Marts.Integrate data from multiple sources including Oracle, SQL Server, XML, Flat Files, and other relational databases.Create and optimize Stored Procedures, Views, and complex SQL/PLSQL queries.Gather business requirements and prepare technical design documents for ETL processes.Perform performance tuning, monitoring, debugging, and production support activities.Participate in all phases of SDLC including analysis, design, development, testing, deployment, and documentation.Work closely with onsite/offshore teams and business stakeholders.Required Skills:6+ years of hands-on experience with Informatica ETL tools.Strong expertise in Informatica PowerCenter and IICS/IDMC.Experience with ETL, Data Warehouse/Data Mart development, OLTP/OLAP concepts.Strong Oracle SQL, PL/SQL, and SQL Server experience.Hands-on experience with performance tuning and session monitoring.Experience integrating data from multiple enterprise data sources.Strong analytical, troubleshooting, and communication skills.