Job Summary :

We are seeking an experienced Oracle Data Integrator (ODI) Developer to design, develop, and support ETL/ELT solutions and enterprise data integration projects. The ideal candidate will have strong ODI, SQL, and Data Warehouse expertise with experience in building scalable and high-performance data pipelines.

Key Responsibilities :

- Develop and maintain ETL/ELT processes using Oracle Data Integrator (ODI).

- Create ODI mappings, packages, procedures, variables, and load plans.

- Build and support data warehouse and data integration solutions.

- Optimize ETL performance and troubleshoot data processing issues.

- Perform testing, deployments, and production support activities.

- Monitor ETL jobs, resolve failures, and conduct root cause analysis.

- Collaborate with business and technical teams to gather requirements and deliver solutions.

- Maintain technical documentation and follow development best practices.

Required Skills :

- 3+ years of hands-on ODI (11g/12c) development experience.

- Strong SQL and PL/SQL programming skills.

- Experience with Oracle Database and Data Warehouse concepts.

- Knowledge of ETL/ELT methodologies and performance tuning.

- Understanding of dimensional modeling (Star & Snowflake Schema).

- Experience with Linux/Unix and shell scripting.

Preferred Skills :

- Experience with Oracle Data Warehouse, GoldenGate, or Data Pump.

- Exposure to OCI, AWS, or Azure cloud platforms.

- Knowledge of Git, CI/CD, and DevOps practices.

- Experience with data governance, data quality, and BI/reporting tools.

Qualifications :

- Bachelor's degree in Computer Science, IT, Engineering, or related field.

- Oracle certifications are an added advantage.