Oracle RDBMS & Datastage ETL Engineer

SmartRecruiters, Inc.; Plano (TX); On-site; USD 90,000 - 120,000; Full time

Job summary

Career Guidant in Plano, TX, is seeking a backend DW/BI developer with Datastage ETL expertise. You will design data models, build ETL jobs, and optimize Oracle SQL within a team that supports global delivery. The role emphasizes data integrity, performance tuning, and collaboration across project lifecycles.

You should have 2+ years in DW/BI technologies, Unix/Linux skills, and experience in design and architecture reviews. Travel may be required for client engagements and project deployments.

Qualifications

• Bachelor's degree or foreign equivalent required; or 3 years of progressive experience in lieu of education.
• 2+ years in back end RDBMS design, data modeling, and ETL development.
• Hands-on Datastage design, development, and administration experience.

Responsibilities

• Design, develop and maintain Datastage ETL jobs for DW/BI projects.
• Analyze data models, optimize SQL, and implement data loading techniques.
• Collaborate with teams on lifecycle activities and architecture reviews.

Skills

Datastage ETL

Unix/Linux

Oracle SQL/PLSQL

Data Modeling

DW/BI

Autosys/Tivoli

Performance Tuning

SQL Optimization

Team Collaboration

Problem Solving

Education

Bachelor's degree or equivalent

Tools

Datastage 8.5+

Oracle SQL/TOAD

Unix shell scripting

Job description

Career Guidant in Plano, TX, is seeking a backend DW/BI developer with Datastage ETL expertise. You will design data models, build ETL jobs, and optimize Oracle SQL within a team that supports global delivery. The role emphasizes data integrity, performance tuning, and collaboration across project lifecycles.

You should have 2+ years in DW/BI technologies, Unix/Linux skills, and experience in design and architecture reviews. Travel may be required for client engagements and project deployments.