Data Warehouse ETL Developer/Informatica Developer

Job Summary: We are seeking a skilled Data Warehouse / ETL Developer with expertise in Informatica PowerCenter to design, develop, and maintain enterprise-level ETL solutions. The ideal candidate will have hands-on experience in data warehousing concepts, ETL processes, and strong problem-solving skills to ensure high-quality, timely, and accurate data integration. Key Responsibilities: <span lang="EN-US" style="mso-fareast-font-family:"Times New Roman"; mso-ansi-language:EN-US"> Design, develop, and deploy ETL mappings, workflows, and sessions using Informatica PowerCenter. <span lang="EN-US" style="mso-fareast-font-family:"Times New Roman"; mso-ansi-language:EN-US"> Extract data from heterogeneous source systems (e.g., Oracle, SQL Server, flat files, SAP) and load into target data warehouse environments. <span lang="EN-US" style="mso-fareast-font-family:"Times New Roman"; mso-ansi-language:EN-US"> Collaborate with business analysts and data architects to understand data requirements and translate them into efficient ETL solutions. <span lang="EN-US" style="mso-fareast-font-family:"Times New Roman"; mso-ansi-language:EN-US"> Optimize ETL processes for performance, scalability, and maintainability. <span lang="EN-US" style="mso-fareast-font-family:"Times New Roman"; mso-ansi-language:EN-US"> Conduct data validation, reconciliation, and troubleshooting to ensure data quality and integrity. <span lang="EN-US" style="mso-fareast-font-family:"Times New Roman"; mso-ansi-language:EN-US"> Maintain ETL documentation, including data flow diagrams, technical specifications, and process design documents. <span lang="EN-US" style="mso-fareast-font-family:"Times New Roman"; mso-ansi-language:EN-US"> Participate in code reviews, unit testing, and UAT support. <span lang="EN-US" style="mso-fareast-font-family:"Times New Roman"; mso-ansi-language:EN-US"> Monitor ETL jobs and workflows, identify bottlenecks, and implement improvements. <span lang="EN-US" style="mso-fareast-font-family:"Times New Roman"; mso-ansi-language:EN-US"> Provide production support and resolve data-related issues in a timely manner. Required Skills and Qualifications: <span lang="EN-US" style="mso-fareast-font-family: "Times New Roman";mso-ansi-language:EN-US"> Bachelor’s degree <span lang="EN-US" style="mso-fareast-font-family:"Times New Roman";mso-ansi-language: EN-US"> in Computer Science, Information Technology, or a related field. <span lang="EN-US" style="mso-fareast-font-family: "Times New Roman";mso-ansi-language:EN-US"> 8-10+ years of experience <span lang="EN-US" style="mso-fareast-font-family:"Times New Roman";mso-ansi-language: EN-US"> in ETL development using Informatica PowerCenter . <span lang="EN-US" style="mso-fareast-font-family:"Times New Roman"; mso-ansi-language:EN-US"> Strong understanding of data warehousing concepts , dimensional modeling, and star/snowflake schemas. <span lang="EN-US" style="mso-fareast-font-family:"Times New Roman"; mso-ansi-language:EN-US"> Experience with SQL, PL/SQL , and performance tuning of database queries. <span lang="EN-US" style="mso-fareast-font-family:"Times New Roman"; mso-ansi-language:EN-US"> Knowledge of data quality, data governance, and best practices in ETL development. <span lang="EN-US" style="mso-fareast-font-family:"Times New Roman"; mso-ansi-language:EN-US"> Strong analytical, problem-solving, and communication skills. <span lang="EN-US" style="mso-fareast-font-family:"Times New Roman"; mso-ansi-language:EN-US"> Experience with version control systems and ETL deployment processes. Preferred Qualifications: <span lang="EN-US" style="mso-fareast-font-family:"Times New Roman"; mso-ansi-language:EN-US"> Exposure to real-time ETL and data streaming technologies. <span lang="EN-US" style="mso-fareast-font-family:"Times New Roman"; mso-ansi-language:EN-US"> Knowledge of scheduling tools such as Informatica Workflow Manager and IBM Workload Automation