# 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 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. ## 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) - 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. - 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. ## Preferred 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.