Job Title: Oracle ODS Developer:
Location: Remote
Experience: 3-5 Years
- Job Summary:
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.
- 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)
- Database Performance Tuning
- Query Optimization
- Oracle BI / OBIEE / Oracle Analytics or equivalent Oracle reporting tools
- Database Backup, Recovery, and Data Integrity concepts
- Version Control and Release Management

Required Qualifications:
- Bachelor's degree in Computer Science, Information Technology, Software Engineering, or a related discipline.
- 3-5 years of experience in Oracle database development and ODS/Data Warehouse environments.
- Hands-on experience with Oracle Database 11g, 12c, or 19c.
- Solid expertise in SQL, PL/SQL, and Oracle Data Integrator (ODI).
- Solid understanding of ETL architecture,

📌 Oracle Ods Developer (Bengaluru)
🏢 Datamatics Technologies
📍 Bengaluru