Oracle Advanced Engineering-Oracle Data Integrator- SQL- PLSQL-Senior
EY
Get more replies from employers
Send a job-specific resume in minutes.
Benefits offered by this job
Job summary
EY is seeking a Senior ODI Data Engineer in Chennai to design, develop, and maintain enterprise-scale ODI data integration solutions. The role involves ETL/ELT implementations, data migration, and collaboration with cross-functional teams to deliver high-quality data platforms.
The ideal candidate will have strong ODI 12c/14c experience, Oracle Database expertise, and a solid grasp of data warehousing concepts and cloud platforms.
Qualifications
- Experience with ODI 12c/14c in designing and developing ODI interfaces and mappings.
- Strong Oracle Database, PL/SQL programming, and SQL performance tuning skills.
- Proven ability to design ETL/ELT solutions for data warehousing initiatives.
- Understanding of dimensional modelling and data integration best practices.
- Experience with Unix/Linux scripting and job scheduling tools.
- Familiarity with cloud platforms (OCI, AWS, Azure) is a plus.
Responsibilities
- Design, develop, and maintain ODI workflows and mappings.
- Create and optimize PL/SQL packages, procedures, and complex SQL.
- Develop data integration, migration, and transformation processes.
- Profile performance and tune ODI interfaces and Oracle objects.
- Translate business requirements into ETL designs and specs.
- Monitor production data pipelines and resolve issues promptly.
- Ensure data quality, governance, and security alignment.
Skills
Tools
Job description
Job Description:
At EY, you’ll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture and technology to become the best version of you. And we’re counting on your unique voice and perspective to help EY become even better, too. Join us and build an exceptional experience for yourself, and a better working world for all.
At EY, we’re all in to shape your future with confidence.
We’ll help you succeed in a globally connected powerhouse of diverse teams and take your career wherever you want it to go.
Join EY and help to build a better working world.
- Global Delivery Services refers to EY's worldwide network of service delivery centers. The GDS team plays an important role in EY’s strategy by ensuring effective support to EY’s growth agenda.
- Our journey started in 2002 with approximately 200 people. Today we stand at 80,000+ professionals in ten locations around the world. We operate in Argentina, China, Hungary, India, Philippines, Poland, Sri Lanka, Mexico, Spain and the United Kingdom.
- Client service is focused on providing Consulting, Assurance, Tax, Strategy & Transactions, and Knowledge support to our clients around the world. The teams enable account teams worldwide to provide seamless, high-quality, value-added support, helping deliver exceptional client service.
- Enablement Services provides cost-effective, high-skilled, and innovative services to support EY’s global and local enablement teams. Markets, BMC, AWS, Finance and Accounting, Risk Management, Procurement, People Shared Services, IT Service Delivery and IT Global Infrastructure services, are among the services offered by Enablement Services.
- Our innovation specialists serve the GDS Client Service and Enablement Services teams, along with Service Lines, Core Business Services and Sectors. The team brings the desired environment, technologies and skilled teams together for facilitation, rapid prototyping and innovative thinking. The competencies offered include analytics, digital, user experience, mobile technology, infrastructure, Microsoft technologies and open innovation.
- Join a dynamic data engineering team responsible for designing, developing, and maintaining enterprise-scale data integration solutions.
- Work on complex ETL/ELT implementations using Oracle Data Integrator (ODI) and PL/SQL to support business-critical reporting and data warehousing initiatives.
- Collaborate with cross-functional teams to deliver high-quality, scalable, and performance-optimized data solutions.
- Design, develop, and maintain ETL/ELT workflows using Oracle Data Integrator (ODI).
- Create, optimize, and troubleshoot PL/SQL packages, procedures, functions, triggers, and complex SQL queries.
- Develop and support data integration, data migration, and data transformation processes.
- Perform performance tuning of ODI interfaces, mappings, and Oracle database objects.
- Analyze business requirements and translate them into technical specifications and ETL designs.
- Monitor and resolve production issues, ensuring data accuracy and timely delivery.
- Implement data quality checks, validation rules, and error-handling mechanisms.
- Collaborate with business analysts, data architects, and stakeholders during project delivery.
- Participate in code reviews, testing, deployment, and documentation activities.
- Ensure adherence to data governance, security, and development standards.
- Strong hands-on experience with Oracle Data Integrator (ODI) 12c/14c.
- Expertise in Oracle Database, PL/SQL programming, and SQL performance tuning.
- Experience in designing and developing ETL/ELT solutions and data warehousing concepts.
- Good understanding of dimensional modelling, star/snowflake schemas, and data integration best practices.
- Experience with Unix/Linux shell scripting and job scheduling tools.
- Strong analytical, problem-solving, and troubleshooting skills.
- Ability to work independently and manage multiple priorities in a fast-paced environment.
- Excellent communication and stakeholder management skills.
- Knowledge of Agile/Scrum methodologies is an advantage.
- Exposure to cloud platforms such as Oracle Cloud Infrastructure (OCI), Azure, or AWS.
- Knowledge of data governance, data quality, and metadata management practices.
- Familiarity with source control tools such as Git, SVN, or Azure DevOps.
- Oracle certifications in ODI, PL/SQL, or Database Administration.
- Experience working in large-scale enterprise or global delivery environments.
- A proactive professional with a passion for data engineering and continuous learning.
- Strong ownership mindset with the ability to drive tasks independently.
- An individual who can effectively collaborate with technical and business stakeholders.
- Someone who demonstrates attention to detail, commitment to quality, and a customer-focused approach.
- A team player capable of mentoring junior team members and contributing to a culture of innovation and excellence.
At EY, we’ll develop you with future-focused skills and equip you with world-class experiences. We’ll empower you in a flexible environment, and fuel you and your extraordinary talents in a diverse and inclusive culture of globally connected teams. Learn more.
To help create an equitable and inclusive experience during the recruitment process, please inform us as soon as possible about any disability-related adjustments or accommodations you may need.
As a commitment, we persistently endeavour to embody our values, fulfil our purpose, and champion inclusiveness. Our dedication is to cultivate EY into an environment where diverse perspectives are celebrated, creating a supportive atmosphere for individuals to authentically be themselves and contribute their utmost.
From entry-level employees to senior leaders, we believe in continuous learning. We offer opportunities to build new skills, take on leadership roles, and connect and grow through mentorship.
In our dynamic workplace, diversity, equity, and inclusiveness are ingrained in our culture. We're united by a commitment to create an environment where every individual's differences are valued, practices are equitable, fostering a sense of belonging. Our shared values include integrity, respect, teaming, inclusiveness, energy, enthusiasm, courage to lead, and building relationships based on doing the right thing.
Embark on a transformative career journey with us and indulge in a suite of premium benefits, encompassing exclusive health and wellness packages, enticing rewards, and cutting-edge learning opportunities that empower you to continually grow and excel in your professional and personal development.
EY exists to build a better working world, helping to create long-term value for clients, people and society and build trust in the capital markets.
Enabled by data and technology, diverse EY teams in over 150 countries provide trust through assurance and help clients grow, transform and operate.
Working across assurance, consulting, law, strategy, tax and transactions, EY teams ask better questions to find new answers for the complex issues facing our world today.
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
