Job Title: Oracle ODS Developer
Location: Remote
Experience: 3–5 Years

Job Summary
We are seeking a skilled Oracle ODS Developer with 3–5 years of hands-on experience in Oracle database development, Operational Data Store (ODS), ETL development, and data warehousing. The ideal candidate should have robust expertise in Oracle Database, SQL, PL/SQL, Oracle Data Integrator (ODI), and reporting solutions. The candidate will be responsible for designing, developing, optimizing, and maintaining Oracle-based ODS and data warehouse solutions while ensuring high performance, scalability, and data integrity.
Key Responsibilities
Design, develop, and maintain Oracle Operational Data Store (ODS) solutions.
Develop and optimize SQL and PL/SQL procedures, packages, functions, triggers, and scripts.
Design, develop, and support ETL processes using Oracle Data Integrator (ODI).
Build and maintain data warehouse structures including fact tables, dimension tables, and staging areas.
Design and implement logical and physical data models based on business requirements.




Optimize database performance through SQL tuning, indexing, partitioning, and query optimization.
Develop and maintain reporting solutions using Oracle BI, OBIEE, Oracle Analytics, or similar Oracle reporting tools.
Perform data validation, reconciliation, and quality assurance activities.
Troubleshoot production issues and provide timely resolution.
Collaborate with business analysts, architects, and application teams to deliver high-quality data solutions.
Prepare technical documentation for database objects, ETL workflows, and deployment processes.
Ensure adherence to database development standards, security policies, and best practices.

Required Technical Skills
Oracle Database (11g / 12c / 19c)
SQL and PL/SQL Development
Oracle Data Integrator (ODI)
ETL Design and Development
Operational Data Store (ODS)
Data Warehousing Concepts
Data Modeling (Star Schema / Snowflake Schema)

📌 Oracle Ods Developer Mumbai
🏢 Datamatics Technologies
📍 Mumbai