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.
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.
Powered by JazzHR
Oracle ODS Developer • Islamabad, Federal Teritory, PK
AM–5:00 PM Pacific Standard Time, Monday–Friday.We're seeking a Senior Software Architect to design, build, and evolve large-scale backend systems for production use.You'll lead system-level design... Show more
As a DevOps Engineer, you will design, implement, and maintain the infrastructure that supports our applications and services — and, just as importantly, you will keep that infrastructure reliable ... Show more
At TechBiz Global, we are providing recruitment service to our TOP clients from our portfolio.We are currently seeking a Continuous Integration & Verification Infrastructure Engineer to join on... Show more
Monday to Saturday | 9:00 PM – 6:00 AM.Communicate directly with clients to understand and gather complete project requirements.Conduct client meetings and maintain professional communication throu... Show more
TOP clients from our portfolio.We are currently looking for a.DFT & Post-Silicon Validation.Are you passionate about Design for Testability (DFT) for complex SoCs and SoC chiplets in package? W... Show more
At TechBiz Global, we are providing recruitment service to our TOP clients from our portfolio.We are currently seeking a Senior Data Engineer Data Architect to join one of our.If you're looking fo... Show more
At TechBiz Global, we are providing recruitment service to our TOP clients from our portfolio.If you're looking for an exciting opportunity to grow in a innovative environment, this could be the pe... Show more
At TechBiz Global, we are providing recruitment service to our TOP clients from our portfolio.If you're looking for an exciting opportunity to grow in a innovative environment, this could be the pe... Show more
Reboot Monkey is a global datacenter services provider headquartered in Haarlem, Netherlands, operating.We deliver colocation, IP transit, smart hands, remote hands, and managed datacenter services... Show more
Ikonic, Plot # 176, Korang Road, near Rahat Bakers, I-10/3, Islamabad.IKONIC is a US-based IT company headquartered in Miami, Florida, serving clients globally for over 9 years.Were known for build... Show more
Designation: Business Development Executive.Salary: Negotiable (Subject to UK Market Experience).Conduct market research to identify potential clients and understand their needs and preferences.Lea... Show more
Reboot Monkey is a global datacenter services provider headquartered in Haarlem, Netherlands, operating.We deliver colocation, IP transit, smart hands, remote hands, and managed datacenter services... Show more
