ETL Developer - SQL/Data Warehousing

Job Title : ETL Developer - ODI Developer Location : Chennai, Tamil Nadu, India (Full-time WFO) Overview : We are seeking an experienced and dynamic ETL Developer with 4 to 7 years of expertise to join our team in Chennai. The ideal candidate will have hands-on development experience in ETL using ODI 11G/12C or IICS (Informatica Intelligent Cloud Services), along with proficiency in Oracle SQL and PL/SQL programming. The role involves working on data integration and migration, ensuring data accuracy, and optimizing ETL processes within a data warehouse or data mart environment. Key Responsibilities : - Design, develop, and implement ETL processes using Oracle Data Integrator (ODI) 11G/12C or IICS. - Develop, test, and optimize SQL queries and PL/SQL procedures for extracting, transforming, and loading data. - Collaborate with cross-functional teams to ensure smooth data migration and integration into Data Warehouses and Data Marts. - Troubleshoot and resolve any ETL and database performance issues. - Continuously improve ETL workflows to enhance efficiency and scalability. - Monitor and maintain existing ETL jobs and ensure data quality standards are met. - Participate in client-facing interactions and provide technical expertise during face-to-face interviews. Qualifications : - B.E. or any relevant qualification. - 4 to 7 years of experience in ETL development, with hands-on expertise in either ODI 11G/12C or IICS. - Strong experience in Oracle SQL and PL/SQL programming. - Solid understanding of data migration techniques and data integration principles. - Experience working with Data Warehouses and/or Data Marts. - Strong problem-solving skills and the ability to work collaboratively in a fast-paced environment. Client Interview : This position requires a face-to-face client interview. (ref:hirist.tech)

Location: chennai, IN

Posted Date: 3/7/2025