ETL Datastage Consultant

Posted 6 Days Ago
Be an Early Applicant
Lansing, MI
5-7 Years Experience
Consulting
The Role
The ETL Datastage Consultant will design, develop, and troubleshoot ETL jobs using IBM DataStage and QualityStage, analyze data systems, and provide training and support for the ETL toolset. Responsibilities include creating ETL solutions, performing testing, and developing specifications for ETL jobs, with a focus on efficient data movement to a consolidated data warehouse.
Summary Generated by Built In

Company 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

o IBM Information Analyzer

o Unix Environment

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

•Specifications development for ETL jobs

•Custom script development using SQL

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

Top Skills

SQL
The Company
New York, NY
22 Employees
On-site Workplace

What We Do

Xinnovit is a leading technology, consulting and business services firm. From strategy, operations and management to organizational transformation, we work with companies across various industries to deliver sustained shareholder value growth. Our in-depth industry knowledge, technology and business expertise, combined with our innovative thinking helps organizations to anticipate change, improve operations.

Jobs at Similar Companies

Energy CX Logo Energy CX

Strategic Account Executive

Greentech • Professional Services • Business Intelligence • Consulting • Energy • Financial Services • Utilities
Easy Apply
Chicago, IL, USA
55 Employees
Hybrid
Chicago, IL, USA
120 Employees

Eastwall Logo Eastwall

Cloud Data Engineer

Artificial Intelligence • Cloud • Information Technology • Software • Consulting • App development • Big Data Analytics
Remote
United States
20 Employees
125K-160K Annually

Similar Companies Hiring

Premier International Thumbnail
Information Technology • Database • Consulting
Chicago, IL
120 Employees
Eastwall Thumbnail
Software • Information Technology • Consulting • Cloud • Big Data Analytics • Artificial Intelligence • App development
Denver, CO
20 Employees
Energy CX Thumbnail
Utilities • Professional Services • Greentech • Financial Services • Energy • Consulting • Business Intelligence
Chicago, IL
55 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account