Oracle Data Integrator ETL Lead Kansas City, MO

Entire Hire

Apply to this job
Kansas City, MO, us on site Until 8/22/2026 First posted March 22, 2025 Last posted March 22, 2025
Job description
 What We Do WITH Employers

We offer Permanent and Executive Search staffing. Serving a broad spectrum of industries and have candidates that are qualified in their fields. We are able to meet the most diverse staffing requirements. All our consultants have been in your "corporate hiring shoes with a mix of agency background". Exceptional recruiters always find the right "fit" regardless of the role they are working on.

Our qualified candidates assume positions covering a wide range of employment areas: Office Administration, Accounting, Engineering, Finance,  Customer Service, Call Centre, Human Resources, Information Technology, Sales & Marketing, Logistics, Pharmaceutical, Medical, Legal, Bilingual Services, Retail and Management & Executive Search.

The ETL Lead is responsible for successful development of extract/transform/load solutions.

The ETL Lead will also code and test software based upon software specifications and designs; use sound software engineering principles to ensure that developed code is modifiable efficient, reliable understandable, and fault tolerant; provides software process management and control throughout the coding portion of the software development process.

In addition, the ETL Lead will create designs that supports requirements; lead production team to schedule ETL jobs; overseeing all ETL activities; provide support/mentor to ETL developers; design and develop processes, procedures and standards in support of ETL functionality; and create test plans and support executing test plans.

Willing to travel after local assignment in Kansas City is complete

Required

  • High School Diploma/GED
  • At least 3 years experience in leading a team of ETL developers through designing and implementing Extract/Transform/Load solutions
  • At least 3 years experience in Oracle Data Integrator (ODI) 11G to code ETL programs and test the same. Require strong development experience of writing ODI scripts to migrate data from ERP (Oracle) to OBIEE.
  • At least 1 year experience in working between different platforms and databases (OBIEE, OBIA and ERP products)
  • At least 1 year experience in working with a production team to schedule ETL jobs
  • At least 1 year experience in creating test plans and executing the same
  • At least 1 year experience in SQL queries
  • Basic knowledge in labor category field and a demonstrated ability to independently work on complex assignments
  • English: Fluent


Preferred

  • Bachelor's Degree
  • Basic knowledge in Business Intelligence/Data Warehousing; Oracle RDBMS; Oracle Data Integrator; Oracle Business Intelligence Enterprise Edition.


CLIENT is committed to creating a diverse environment and is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status.

****We Are Looking To HIRE quickly ****

No Phone Calls/Emails etc please those chosen for an interview will be contacted

We look forward to receiving your application!
All your information will be kept confidential according to EEO guidelines.

About this role

Summary

Lead ETL development using Oracle Data Integrator, manage team, design and test solutions.

Job title

Oracle Data Integrator ETL Lead

Experience level

3+ years

Industry

staffing and recruitment

Location requirements

Kansas City, MO, remote work not specified

Salary

Not specified

Management role

Yes

Skills & keywords

Required skills

ETLoracle data integratorsqlteam leadershiptest planning

Preferred skills

business intelligencedata warehousingoracle rdbmsoracle bi

Specializations

ETLoracle data integratorsqlbidata warehousing
Locations

Structured locations inferred from the posting.

Kansas City, MO, USA

On-site City