Oracle Advanced Engineering-Oracle Data Integrator- SQL- PLSQL-Senior

The Opportunity

Your Key Responsibilities

• 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.

Skills and Attributes for Success

• 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.

Ideally, You'll Also Have

What We Look For

• 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.

What we offer you

• 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.
• Are you ready to shape your future with confidence? Apply today.
• 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.
• Our Commitment: 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.
• Professional Development: 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.
• People and Culture: 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.
• Benefits: 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.
• How to Apply: If you are passionate to join us and are aligned with our commitment to building a better working world, we invite you to apply by completing our user-friendly form with personal and professional information and by providing your consent to data privacy.
• Successful candidates advance to a competency-based interview. If mutual interest persists, a job offer awaits.
• “We are an equal opportunity employer and are committed to Diversity, Equity & Inclusion”.
• EY | Building a better working world
• 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.