Design, develop, and maintain Oracle ODS and data warehouse solutions; build ETL with ODI; create/optimize SQL and PL/SQL; tune databases; produce reports with Oracle BI/OBIEE/Oracle Analytics; validate data and troubleshoot production issues; document solutions and follow best practices.
Job Title: Oracle ODS Developer
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.
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.
- 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.
Similar Jobs
Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
Serve as the ledger Subject Matter Expert driving GL and sub-ledger integration, accounting treatments, ledger process mapping, reconciliations, controls and period-end close. Translate finance requirements into functional specifications, partner with technology on target ledger architecture, support audits and governance, mentor finance team members, and approve functional readiness for releases.
Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
Build, manage, and automate scalable GCP infrastructure using Terraform. Provision core GCP services, develop CI/CD pipelines, implement monitoring and security best practices, collaborate with data engineers, and continuously improve platform reliability and automation under the platform lead.
Top Skills:
BashBigQueryCloud ComposerCloud SqlCompute EngineDataflowDataprocGCPGitlab CiGoogle Cloud BuildGoogle Cloud Operations (Stackdriver)Google Cloud Storage (Gcs)IamJenkinsPythonTerraformVpc
Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
Lead design and delivery of GCP data platforms using BigQuery, Pub/Sub, and Dataflow. Architect high-volume ingestion and ETL pipelines, drive cloud migrations, mentor engineers, ensure security, cost optimization, and stakeholder alignment to deliver analytics and ML-ready data solutions.
Top Skills:
AWSBigQueryCloud BuildCloud ComposerCloud LoggingCloud MonitoringClouderaDatabricksDataflowDataprocEtl FrameworksGoogle Cloud Platform (Gcp)IamPub/SubSnowflakeVertex Ai
What you need to know about the Mumbai Tech Scene
From haggling for the best price at Chor Bazaar to the bustle of Crawford Market, the energy of Mumbai's traditional markets is a key part of the city's charm. And while these markets will always have their place, the city also boasts a thriving e-commerce scene, ranking among the largest in the region. Driven by online sales in everything from snacks to licensed sports merchandise to children's apparel, the local industry is worth billions, with companies actively recruiting to meet the demands of continued growth.
