Senior DataStage ETL Engineer | DW & Oracle

Reliable Software Resources Inc; Detroit (MI); On-site; USD 90,000 - 120,000; Full time

Job summary

A prominent software consultancy is seeking a Sr. DataStage Developer for a project in Detroit, MI. The ideal candidate will have strong hands-on experience in an ETL DataStage environment and expertise in Oracle procedures, along with excellent troubleshooting skills. Responsibilities include supporting ETL jobs, ensuring best practices, and designing data models. Strong communication skills are essential for this role. Join a team that values your expertise in optimizing data workflows.

Qualifications

• Strong hands-on experience in ETL DataStage environment v7.2 and above.
• Experience troubleshooting ETL jobs in production.
• Understanding of data warehouse architecture, star schemas, and snowflakes.

Responsibilities

• Support ETL jobs in production and resolve any failures.
• Ensure deliverables conform to ETL best practices.
• Design data models using ERwin.

Skills

ETL DataStage environment

Oracle procedures

Data modeling with ERwin

Strong communication skills

PL/SQL and SQL troubleshooting

Data profiling

Data analysis

Data quality checking

Job description

A prominent software consultancy is seeking a Sr. DataStage Developer for a project in Detroit, MI. The ideal candidate will have strong hands-on experience in an ETL DataStage environment and expertise in Oracle procedures, along with excellent troubleshooting skills. Responsibilities include supporting ETL jobs, ensuring best practices, and designing data models. Strong communication skills are essential for this role. Join a team that values your expertise in optimizing data workflows.