Oracle ODS Developer
Full-time
Datamatics Technologies
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.
Vacancy posted 1 day ago
Similar jobs that could be interesting for youBased on the Oracle ODS Developer in Islamabad vacancy
- ...Business Analytics is seeking a skilled Oracle WebCenter Developer with 2 to 3 years of experience in Oracle WebCenter application development and support. The ideal candidate holds a bachelor's degree in Computer Science, Information Technology, Software Engineering,...
- In this position, you will take ownership of Oracle ADF application development tasks throughout the Software Development Life Cycle.... ...Business Analytixs strategic goals. Responsibilities Design, develop, and maintain Oracle ADF applications using ADF Faces, Business...
- ..., and South Asia. To learn more, visit . Role Summary – Oracle Fusion Technical Consultant We are looking for a strong Oracle... ...by designing and building integrations (OIC). Responsible for Developing new Inbound and Outbound integrations ERP Cloud with good...
- ...fit for you. Role Overview We are seeking experienced Oracle Retail Cloud Functional and Techno-Functional Consultants to support... ...with FRICEW components Proven capability in designing, developing, testing, deploying, and maintaining FRICEW objects...
- ...providing high quality of support. Key Responsibilities Oracle Fusion HCM Technical profile with below expertise from Fusion HCM... ...Interact with the project team members responsible for developing reports, interfaces, data conversion programs, and application...
- ...Organizational Development Manager in Islamabad. The hybrid role offers a monthly salary of PKR 299,000-349,000. Responsibilities include leading OD initiatives using Workday and Culture Amp, designing change management programs, and partnering with leadership on strategic...
Code Ninety
Islamabad1 day ago - ...and other people in need. Our company purpose is to use technology to make the world a better place. And we’re currently hiring developers to join us on this journey! We are a company based in Sweden with developers in all parts of the planet! We're looking for an...
- 10Pearls, LLC is seeking an Oracle Fusion Technical Consultant to solve complex business problems through effective integration solutions. This role requires a minimum of 12 years of experience in Oracle Applications, with a strong focus on Oracle Fusion Cloud Modules...
10Pearls, LLC
Islamabad21 hours ago - ...delivering IT solutions, converting business requirements to technical specifications, and guiding a team for projects related to Oracle HCM Cloud Fusion. The ideal candidate should have a solid technical background in Oracle Fusion HCM, including experience with HCM...
10Pearls, LLC
Islamabad21 hours ago - ...AWS technologies and database development. Responsibilities include leading data pipeline implementations and mentoring engineers. Strong expertise in Oracle PL/SQL, PostgreSQL, and data warehousing is essential. This is a full-time hybrid position. #J-18808-Ljbffr...
NorthBay Solutions LLC
Islamabad1 day ago - ...This role will play a strategic leadership position in defining QA practices, driving innovation, and ensuring scalability across Oracle Fusion Financials platforms. The Impact: As a senior SDET, you will drive end-to-end quality engineering strategies for Oracle...
S&P Global, Inc.
Islamabad1 day ago - ...variety of hard data analytics and enterprise problems . You will be responsible for ensuring that the framework and products we develop meet the established design, implementation, and quality goals. What You’ll Do Be a part of a globally distributed team of...
- ...Job Description: Android Developer (Keyboard Development Experience) Position: Android Developer Experience Required: 5+ Years Location: Pakistan (Hybrid) Contract Duration: 2 Months Timings: 5 pm - 2 am Job Overview We are looking for an experienced...
- ...Digifloat is seeking a talented Mobile Application Developer (Flutter) to develop and maintain high-performance Driver and Rider mobile applications . The ideal candidate will have hands-on experience building scalable, user-friendly, and real-time mobile solutions...
- ...About the role GetChainVerse is hiring a Blockchain Developer to join a multidisciplinary project team in Islamabad to design and implement blockchain-based solutions for cross-border trade, provenance tracking, and regulatory compliance. The role reports to the technical...
- ...professionals who are passionate about delivering high quality work. About the role We are looking for a skilled Full Stack Developer with strong expertise in React.js and Node.js to join our growing team. The ideal candidate will be responsible for developing...
- ...(based on your availability), provides the opportunity to work on real-life projects, learn modern web development practices, and develop skills under the guidance of experienced developers. We are creating a pool of our own trained interns with a plan of global expansion...
- ...Position: Senior Backend Developer Location: Remote (Pakistan) Job Type: Full-time Work Schedule: 9:00 AM–5:00 PM Pacific Standard Time, Monday–Friday Role Overview: We are seeking a Senior Backend Developer with at least 5 years of professional experience...Remote job
- ...We are looking for an experienced Make.com (formerly Integromat) Custom App Developer to design, build, and maintain custom integrations and automation modules for various APIs. The ideal candidate should have a strong understanding of RESTful APIs, JSON structures,...
- ...We are seeking a highly skilled Full Stack Developer with expertise in .NET Core and Angular to join our dynamic development team.... ...Work with relational databases (MySQL, PostgreSQL, MS-SQL, Oracle) and optimize queries. Implement NoSQL/ Oracle databases (MongoDB...
Dplit
Islamabad1 day ago - ...Position: Junior Full Stack Developer Location: On-site, Bahria Town Phase 4, Rawalpindi Schedule: Monday – Friday, 9:00 AM – 6:00 PM About the Role We are looking for a Junior Full Stack Engineer to join our growing team at ContentStudio which is a leading...
- ...with accuracy and timeliness. Conduct regular checks to verify proper functioning of hardware and software systems. Design, develop, and optimize websites for usability, performance, and SEO. Conduct A/B testing and other performance measures to improve user experience...Remote job
- ...create scalable, high-performance digital solutions that empower businesses in today’s competitive landscape. Responsibilities: Develop, customize, and maintain professional Shopify stores. Integrate payment gateways, apps, and third-party tools to enhance store...
Irsolutions
Islamabad2 days ago - ...At Algoryte, we are looking for a talented and creative Unity Game Developer to work at the highest level of virtual and augmented reality. You will be responsible for implementing game functionality, translating design ideas, concepts, and requirements into a functional...
Algoryte
Islamabad3 days ago - Share Job :# WordPress Developer **Company:** IKONIC Solution **Location:** Pakistan, Islamabad **Experience:** 2-6 year **Salary:** 0 **Employment Type:****Job Description:****Responsibilities:** -Designing and implementing new features, functionality and manage websites...
Glan Management Consultancy
Islamabad21 hours ago - ...to reach your best potential, come and join the rebel movement. Job Description We are looking for experienced Flutter Developers (mid to senior level) with a strong command of Dart and a deep understanding of the Flutter ecosystem. You will be responsible for...
Dplit
Islamabad4 days ago - ...Job Summary: We are seeking a skilled and enthusiastic Software Developer to join our dynamic team. The ideal candidate will be responsible for designing, developing, testing, and maintaining software applications that meet the needs of the organization and its customers...
CG Innovatech
Islamabad21 hours ago - ...Job Description: Backend Developer (Up to 8 Years Experience) Role Summary We are looking for a skilled Backend Developer with up to 8 years of experience to design, build, and maintain robust, scalable server-side applications. The role requires strong programming...
Datamatics-Global-Services-Ltd
Islamabad4 days ago - ...Role summary We are seeking a Web3 Developer to join project-focused teams supporting trade, supply chain transparency, and digital regulatory pilots. The role contributes to design, development, and deployment of blockchain-based prototypes, smart contracts, and backend...
- ...ensure IFRS/GAAP compliance across the organization. The role requires 5–7 years of fixed asset accounting experience, hands-on Oracle FA expertise, and strong reconciliation skills. Onsite, full-time position with competitive benefits and growth opportunities. #J...
Convo, Corp.
Islamabad2 hours ago
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Oracle ODS Developer. Be the first to apply!
