Data Integration Engineer – Oracle ODI

Sequoia Connect

9h•Hybrid

About The Position

Our client is a rapidly growing, automation-led service provider specializing in IT, business process outsourcing (BPO), and consulting services. With a strong focus on digital transformation, cloud solutions, and AI-driven automation, they help businesses optimize operations and enhance customer experiences. Backed by a global workforce of over 32,000 employees, our client fosters a culture of innovation, collaboration, and continuous learning, making it an exciting environment for professionals looking to advance their careers. Committed to excellence, our client serves 31 Fortune 500 companies across industries such as financial services, healthcare, and manufacturing. Their approach is driven by the Automate Everything, Cloudify Everything, and Transform Customer Experiences strategy, ensuring they stay ahead in an evolving digital landscape. As a company that values growth and professional development, our client offers global career opportunities, a dynamic work environment, and exposure to high-impact projects. With 54 offices worldwide and a presence in 39 delivery centers across 28 countries, employees benefit from an international network of expertise and innovation. Their commitment to a 'customer success, first and always' philosophy ensures a rewarding and forward-thinking workplace for driven professionals. We are currently searching for a Senior Data Integration Engineer – Oracle ODI :

Requirements

7–10 years of experience in data integration and ETL development.
Strong hands-on experience with Oracle Data Integrator (ODI 12c) .
Strong experience with Oracle Database 12c/19c .
Advanced knowledge of ETL and Data Warehousing concepts .
Strong Oracle PL/SQL development skills .
Experience with Unix shell scripting and Python scripting .
Hands-on experience with version control tools such as SVN or Git .
Strong experience writing complex SQL queries .
Ability to understand, debug, and support existing applications .
Strong analytical, problem-solving, and communication skills .
Advanced Oral English.
Native Spanish.

Nice To Haves

Experience working with Microsoft SQL Server as a data source.
Exposure to REST API–based integrations.
Experience working in Agile environments.

Responsibilities

Analyze client requirements by reviewing functional and technical documentation.
Design and develop data integration solutions using Oracle Data Integrator (ODI 12c) .
Participate in analysis and design phases , including creation of application design templates.
Prepare Low-Level Design (LLD) documents and detailed technical design documentation.
Develop reusable ETL components to be used across applications.
Perform code reviews and prepare IQA documentation for application components.
Write, optimize, and maintain complex SQL and PL/SQL code .
Integrate data from multiple source systems (Oracle, SQL Server, Excel, delimited files, REST APIs).
Debug, support, and enhance existing applications , including production support ticket resolution.
Collaborate within Agile teams and follow SDLC best practices .