Consultant - Client

Date: 12 Sept 2025

Location:

2nd Floor, InfoTech Centre, 14, Haryana, India, Digital En

Country/Region: In

Category:

OBJECTIVE OF ROLE

We are looking for an experienced Oracle Data Integrator (ODI) Developer to join our Enterprise Data Warehouse (EDW) development team. The ideal candidate will be responsible for designing, architecting, and implementing ETL solutions while ensuring high performance, scalability, and reliability of the data ecosystem.

KEY RESPONSIBILITIES

• Design, develop, and implement ETL solutions using Oracle Data Integrator (ODI).

• Collaborate with stakeholders to analyze requirements and translate them into robust data models.

• Create and optimize star schemas, hierarchies, dimensions, measures, and subject areas for reporting and analytics.

• Perform performance tuning, partitioning strategies, and advanced PL/SQL optimizations.

• Manage and optimize Oracle database components, including materialized views and query plans.

• Review and create detailed ETL design specifications and mapping documents.

• Integrate data from multiple sources, ensuring data consistency and quality.

• Support and enhance large-scale data warehouse systems to meet business needs.

• Collaborate with BI teams using tools like Power BI or Tableau for reporting and analytics.

EXPERIENCE

• Strong expertise in Oracle Data Integrator (ODI) and ETL architecture.

• In-depth understanding of Data Warehousing and Dimensional Modeling concepts.

• Proficiency in Advanced PL/SQL, performance tuning, and partitioning strategies.

• Hands-on experience with Oracle database management (materialized views, explain plans, etc.).

• Familiarity with BI tools such as Power BI and Tableau.

• Good understanding of Master Data Management (MDM), data modeling principles, and data federation.

• Strong analytical, problem-solving, and debugging skills.

QUALIFICATION

Bachelor’s or Master’s degree in Computer Science, Information Technology, or a related field.
Minimum 6 years of experience in ETL development with Oracle Data Integrator

ABOUT US

IGT Solutions (IGT) is committed to simplifying complex customer interactions while delivering a seamless experience. It provides integrated BPM, Technology and Digital Services & Solutions for clients across industries. IGT Solutions is a next-gen customer experience (CX) company, defining and delivering transformative experiences for the global and most innovative brands using digital technologies. With the combination of Digital and Human Intelligence, IGT becomes the preferred partner for managing (end-to-end) CX journeys across Travel and Hi-tech industries.

Established in 1998, with 100% focus on customer experience, IGT employs more than 20,000+ customer experience and technology specialists providing services to 75+ marquee customers globally. IGT’s global footprint consists of 23 delivery centers in China, Philippines, Malaysia, India, UAE, Romania, Indonesia, Spain, Colombia and the USA

EQUAL OPPORTUNITY DISCLAIMER

It is our policy to provide equal employment opportunities to all individuals based on job-related qualifications and ability to perform a job, without regard to age, gender, gender identity, sexual orientation, race, color, religion, creed, national origin, disability, genetic information, veteran status, citizenship or marital status, and to maintain a non-discriminatory environment free from intimidation, harassment or bias based upon these grounds.

ADDRESS & LOCATION

India, Haryana, 2nd Floor, InfoTech Centre, 14/2 Old Delhi Gurgaon Road, Dundahera, Gurugram - 122016, Haryana, India