Oracle Data Integrator ETL Lead Kansas City, MO

Entire Hire; Glasgow; On-site; GBP 60,000 - 80,000; Full time

Job summary

A staffing solutions company is seeking an experienced Oracle Data Integrator ETL Lead in Glasgow. You will be responsible for developing and managing ETL processes, leading a team of developers, and collaborating with production for job scheduling. The ideal candidate has strong experience with ODI 11G, SQL, and creating effective test plans. This position offers the opportunity to work in a dynamic environment with a focus on software engineering principles.

Qualifications

• 3 years experience leading ETL developers.
• Experienced with ODI 11G for ETL programs.
• 1 year working with production teams on scheduling.

Responsibilities

• Lead the development of ETL solutions.
• Code and test software based on specifications.
• Mentor ETL developers and oversee ETL activities.

Skills

Team leadership in ETL

ODI programming

SQL queries

Test plan creation

Education

High School Diploma/GED

Bachelor's Degree

Tools

Oracle Data Integrator

Oracle RDBMS

Business Intelligence/Data Warehousing

Job description

Oracle Data Integrator ETL Lead – Kansas City, MO

Full‑time position.

What We Do WITH Employers

We offer Permanent and Executive Search staffing. Serving a broad spectrum of industries and having 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.

Responsibilities

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; provide software process management and control throughout the coding portion of the software development process. In addition, the ETL Lead will create designs that support requirements; lead production team to schedule ETL jobs; oversee all ETL activities; provide support/mentoring 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

Qualifications

• 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 working between different platforms and databases (OBIEE, OBIA and ERP products)
• At least 1 year experience working with a production team to schedule ETL jobs
• At least 1 year experience 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

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.

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.