Datastage Developer

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

Job Description

Job Title: Sr. DataStage Developer

Duration: 1 year

Location: Detroit, MI

# of Positions: 3

Job Description:

• Strong hands on experience working in ETL DataStage environment v7.2 and above.
• Support ETL jobs in production. Troubleshoot and provide solutions in case of failures.
• Ensure all deliverables conform to ETL best practices and standards.
• Experience using ERwin to design data models.
• Experience using the DataStage Java Integration and XML Output stages.
• Experience with writing Oracle procedures, functions, packages, database triggers and troubleshooting PL/SQL and SQL.
• Complete understanding of data warehouse architecture, star schemas and snowflakes.
• Experience in data profiling, data analysis, data quality checking
• Strong verbal and written communication skills

Additional Information

All your information will be kept confidential according to EEO guidelines.