Senior DataStage ETL Engineer for Data Warehousing

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