Application Development

Job Description - 

Skill : Oracle Data Integrator (ODI), ETL processes, data warehousing concepts, SQL/PLSQL, and Oracle databases
Years of exeperience : 5 to 9 years
Location : Pune / Noida / Chennai / Bangalore

Nice-to-Have : Experience with Oracle GoldenGate.Exposure to cloud-based integration solutions.Knowledge of Python or other scripting languages for automation.

 

Required Skills :

5 to 7 years of experience in Data Integration and ETL development.Strong hands-on experience with Oracle Data Integrator (ODI 11g/12c).Proficient in Oracle Database, SQL, and PL/SQL development.Experience with Data Warehousing concepts, Star Schema, and Dimensional Modeling.Strong understanding of ETL/ELT processes and data migration techniques.

Job Summary :

We are seeking an experienced Oracle Data Integration Developer with 5 to 7 years of hands-on experience in designing, developing, and supporting enterprise data integration solutions. The ideal candidate should have strong expertise in Oracle Data Integrator (ODI), ETL processes, data warehousing concepts, SQL/PLSQL, and Oracle databases. The candidate will work closely with business stakeholders, data architects, and application teams to deliver reliable and scalable data integration solutions.

 

Key Responsibilities :

Design, develop, test, and deploy ETL/ELT data integration solutions using Oracle Data Integrator (ODI).
Develop and maintain data mappings, packages, procedures, and load plans.
Create and optimize SQL and PL/SQL code for data transformation and validation.Integrate data from multiple source systems into data warehouses and reporting platforms.
Monitor, troubleshoot, and resolve data integration and performance issues.
Perform impact analysis and support change management activities.
Ensure adherence to data governance, security, and quality standards.
Collaborate with business analysts, solution architects, and database administrators.
Participate in code reviews and ensure best practices are followed.
Support production deployments and provide post-implementation support.
Experience in performance tuning of ODI mappings and Oracle queries.
Knowledge of Unix/Linux shell scripting.
Familiarity with source control and deployment processes.
Strong analytical, problem-solving, and communication skills.

 

Preferred Skills :

Experience with Oracle Cloud Infrastructure (OCI).Knowledge of Oracle Analytics, BI reporting tools, or Power BI.Experience with data quality, data governance, and metadata management.Exposure to Agile/Scrum methodologies.Oracle ODI Certification is a plus.

 

Educational Qualifications :

Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.Relevant Oracle certifications will be an added advantage.

Key Competencies:

Strong stakeholder management skills.Excellent problem-solving and troubleshooting abilities.Ability to work independently and collaboratively in a team environment.Strong documentation and communication skills.