ETL Developer - SQL/Data Warehousing (4-10 yrs)

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.