ETL Datastage Consultant

Xinnovit; Lansing (MI); On-site; USD 70,000 - 90,000; Full time

Job summary

A leading technology consulting firm is seeking an experienced ETL Developer in Lansing, Michigan. The ideal candidate will possess extensive ETL development experience and work with various data analysis tools like IBM DataStage and QualityStage. Responsibilities include designing ETL solutions, troubleshooting jobs, and providing training and support for the ETL toolset. This position involves critical tasks that ensure efficient data management, making it essential for supporting various operational systems.

Qualifications

• 5 years experience with ETL development.
• 1 year experience with Unix.
• Ability to design and analyze ETL jobs.

Responsibilities

• Create ETL jobs using IBM DataStage and QualityStage.
• Analyze and prepare reports on data systems.
• Provide technical support and training on ETL tools.

Skills

ETL development

Unix

Data analysis

SQL

Tools

IBM DataStage

IBM QualityStage

IBM Information Analyzer

Job description

Xinnovit is a global leader in technology consulting, outsourcing, and workforce management solutions.

Our mission is to enable our clients to become more agile and competitive with the help of innovative technologies. We empower our clients to respond faster and more intuitively to changing market dynamics.

The business environment is complex, often under significant constraints and pressures from various sources. We have the knowledge, experience and capabilities to provide our clients the tools they require to achieve better, faster and effective transformation that make them the leaders in their industry.

Our Goals Are:

• To use our expertise to the benefit of our clients and partners through open communication and collaboration.

• To ensure sustainable and profitable long-term growth.

• To provide a return on investment to shareholders.

• To promote employee development.

Job Description

Ideal candidates would have 5 yrs experience with ETL development and 1 yr Unix work.

Development support is required to assist with the following tasks:

•Create ETL jobs using IBM DataStage and QualityStage

•Analyze and prepare reports on data systems using IBM Information Analyzer

•Schedule ETL jobs as needed

•Perform testing and troubleshooting of ETL jobs

•Develop technical specifications supporting development of ETL jobs

•Extract, transform and load systems to move data from the various operational systems in which it is collected to a cleansed, consolidated data warehouse.

•Some custom script development – possibly using SQL/ or Unisys

•Work with developers and end user query developers to design and improve database queries.

•Provide introductory level training to DTMB personnel and others on these tools and processes.

•Provide backup system administration functions for the ETL toolset

•Provide technical on-call assistance, as required, in support of the ETL tool

Other: Data Analysis Tools:

o IBM DataStage

o IBM Quality Stage

TASKS:

Technical support is required to assist with the following tasks:

•Design ETL solutions using IBM DataStage, QualityStage and IBM Information Analyzer

•ETL job review and troubleshooting

•Provide technical on-call assistance, as required, in support of the ETL tool.

Additional Information

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