Location: Remote
Experience: 3–5 Years
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 strong 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.
-
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.
-
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
-
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.
-
Strong expertise in SQL, PL/SQL, and Oracle Data Integrator (ODI).
-
Solid understanding of ETL architecture, data integration, and data warehousing concepts.
-
Experience in designing and implementing data models.
-
Strong experience in database and SQL performance tuning.
-
Experience developing reports using Oracle BI, OBIEE, Oracle Analytics, or similar Oracle reporting platforms.
-
Strong analytical, troubleshooting, and problem-solving skills.
-
Excellent communication and documentation skills.
-
Experience working in large enterprise or government projects.
-
Knowledge of Oracle Exadata or Oracle Cloud Infrastructure (OCI) is an advantage.
-
Familiarity with Agile or Scrum methodologies.
-
Oracle Database or Oracle ODI certifications will be considered a plus.
u99gU4jN3b
