About the Role

Scope of work and role outline

Design, develop, and implement complex ETL processes using Oracle Data Integrator (ODI) to extract data from various Oracle source systems.
Role Details

Know more about your Role

In this role, you will (Responsibilities)

Transform raw data into a structured format suitable for the Oracle Data Warehouse, ensuring data quality, consistency, and integrity. Develop and optimize ODI mappings, interfaces, packages, and scenarios for efficient data loading. Required Skills and Qualifications: Proven expertise in designing and developing ETL solutions using Oracle Data Integrator (ODI), including knowledge of various ODI components (Designer, Operator, Topology, Security, etc.). Strong proficiency in SQL and PL/SQL for data manipulation, querying, and performance tuning within an Oracle environment. In-depth understanding of Oracle database architecture, concepts, and best practices. Solid experience with Oracle as a source data system. Experience in loading data into Oracle Data Warehouses (DW), including an understanding of star schema, snowflake schema, and dimensional modeling concepts. Familiarity with data warehousing principles, concepts, and methodologies (e.g., Kimball, Inmon). Experience with performance tuning of ODI mappings and Oracle SQL queries. Strong analytical and problem-solving skills with attention to detail. Preferred Skills and Qualifications (Nice-to-Have): Experience with other ETL tools (e.g., Informatica, DataStage) is a plus. Knowledge of other Oracle technologies (e.g., GoldenGate). Experience with cloud platforms (e.g., OCI) and cloud data warehousing solutions. Familiarity with version control systems (e.g., Git). Experience with scripting languages (e.g., Python, Shell Scripting).

What you’ll need to succeed (Requirements)
We are a high caliber team who appreciate and support one another. Our people uphold an energetic, collaborative and inclusive workplace where everyone can thrive.
  • Cognizant is a global community with more than 300,000 associates around the world.
  • We don’t just dream of a better way – we make it happen.
  • We take care of our people, clients, company, communities and climate by doing what’s right.
  • We foster an innovative environment where you can build the career path that’s right for you.
Nice to Have
Key job details

Essential information at a glance

Apply Now

Submit your application and join our team