Oracle Data Integrator ETL Specialist Kansas City, MO

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

Job summary

A recruitment firm in Scotland is seeking an ETL Specialist to develop efficient extract/transform/load solutions. The ideal candidate will lead a team, code using Oracle Data Integrator, and manage ETL jobs across platforms. Preferred qualifications include a Bachelor’s Degree and knowledge of data warehousing. A commitment to a diverse work environment is essential. This is a full-time position with an emphasis on collaboration and innovation in a fast-paced setting.

Qualifications

• Minimum of 1 year experience in leading ETL development.
• Proficient in Oracle Data Integrator (ODI) 11G for coding ETL programs.
• Experience with SQL queries and scheduling ETL jobs.

Responsibilities

• Develop extract/transform/load solutions efficiently.
• Code, test, and manage ETL software development processes.
• Lead production teams to schedule and oversee ETL activities.

Skills

Leading a team of ETL developers

Oracle Data Integrator (ODI) 11G

Scheduling ETL jobs

Creating and executing test plans

SQL queries

Education

High School Diploma/GED

Bachelor's Degree

Tools

Oracle RDBMS

Oracle Business Intelligence Enterprise Edition

Job description

• Full-time

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

Job Description

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

The ETL Specialist 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 Specialist 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

Qualifications

Required

• High School Diploma/GED
• At least 1 year experience in leading a team of ETL developers through designing and implementing Extract/Transform/Load solutions
• At least 1 year experience in Oracle Data Integrator (ODI) 11G to code ETL programs and test the same. Require 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
• At least 1 year experience in working with a production team to schedule ETL jobs (OBIEE, OBIA and ERP products)
• At least 1 year experience in Creating and executing test plans
• 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.

Additional Information

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.