DataStage ETL Developer

System Canada; United States; On-site; USD 90,000 - 130,000; Full time

Job summary

System Canada is seeking a senior ETL/Data Warehouse specialist to design, develop, test and deploy ETL processes supporting ODS and data marts. You will translate business needs into technical specifications, map data from source systems, and ensure reliable production support and release management.

Requirements include 10+ years in data warehousing/BI, training in ETL tools, and hands-on experience with IBM DataStage. A B.Sc.

Qualifications

• Must have data warehouse and BI solution training.
• B.Sc. or related degree is advantageous.
• 10+ years of relevant experience.

Responsibilities

• Design, develop, test and deploy ETL for ODS and data mart projects, as well as application and management reports.
• Provide technical support, troubleshooting and upgrade setup or support on ETL and database related issues.
• Research and evaluate alternative IT solutions to meet business information needs for management information.
• Perform root cause analysis, performance monitoring and application related issues.
• Review IT work products from the team members for completeness and quality.
• Accurately translate business requirement to technical documentation and test case or results.
• Analyze and map data from source systems to target operational data stores and data marts.
• Maintain and provide application support in production.
• Code or folder migration from one environment to another as part of release management.
• Participation in all aspects of quality assurance.
• Active participation in systems integration and user acceptance testing.
• IBM: DataStage Tool
• Conventional and data warehouse modelling skills to understand data models and mappings.
• System analysis and design skills to design and document data extractions and transformations.
• Expert knowledge of ETL tool capabilities to exploit or avoid aspects in designs.
• Good organization, planning and basic management skills.
• Good interpersonal and communication skills.
• Decision making and problem solving skills.

Skills

ETL development

Data mapping

Data modelling

System analysis

Data warehousing

Documentation

Communication

Problem solving

Education

B.Sc. or related degree

Tools

DataStage

Job description

System Canada resources have a broad range of skills in different technologies.The large skill-set has been made possible by a conscious focus on strengthening our skills base. Every person selected for our team brings something new, something that adds to our offerings. We learn continuously, both on the job and through formal training programs.

Visit us at: http://www.SystemCanada.com

System Canada is an equal opportunity employer.

Job Description

DUTIES:

• Design, develop, test and deploy ETL for ODS and data mart projects, as well as application and management reports.
• Provide technical support, troubleshooting and upgrade setup or support on ETL and database related issues.
• Research and evaluate alternative IT solutions to make appropriate recommendations to meet the business needs for management information.
• Perform root cause analysis, performance monitoring and application related issues.
• Review IT work products from the team members for completeness and quality.
• Accurately translate business requirement to technical documentation and test case or results.
• Analyze and map data from source systems to target operational data stores and data marts.
• Maintain and provide application support in production.
• Code or folder migration from one environment to another as part of release management.
• Participation in all aspects of quality assurance.
• Active participation in systems integration and user acceptance testing.
• IBM: DataStage Tool
• Conventional and data warehouse modelling skills are required, in order to understand the
• various data models and to define the mappings between them.
• System analysis and design skills are necessary to design and document the data extractions and
• transformations.
• Expert knowledge of the capabilities of the ETL tools being used, to know what their capabilities and shortcomings are – in order to exploit or avoid those aspects in the ETL program designs.
• Good organization, planning and basic management skills.
• Good interpersonal and communication skills.
• Decision making and problem solving skills.

Qualifications

• Relevant data warehouse and BI solution training is must.
• B.Sc. or related degree is advantageous.
• 10 + years