ETL Developer - #196284

Data Warehouse ETL Developer, Remote contract opportunity

This is a remote, one year contract, starting in August, and requires an Enhanced Reliability Federal Security Clearance.

On behalf of our public sector client, we are seeking an ETL Developer, to design, develop, and maintain the data warehouse and analytics architecture to meet our client’s enterprise business analysis and reporting needs.

The resource will also provide support to the organization’s business requirements in the application and consumption of information from the Enterprise Data Warehouse (EDW) or from other source systems.

The resource will work with architects and business partners to fashion out the technical vision for applications in the Data Warehouse, and will ensure the functionality, security, availability and accuracy of the information within the Data Warehouse environment.


Primary Responsibilities:

• Designs, maintains, and provides support for data warehouse systems and related data marts
• Translates business requirements into viable technical solutions
• Participates in the testing of developed technical solutions
• Participates in the investigation and resolution of complex Data Warehouse issues
• Proactively identifies opportunities for process, systems, and other efficiency improvements
• Works effectively in the team and contributes to team effectiveness through personal style
• Designs data integration/ETL jobs using DataStage and its foundation tools in a SQL Server and Windows environment
• *There is a requirement for the resource to work on weekend and holidays (on a rotation) from 9:00AM to 11:00AM and be available on-call during this period, for any incidents that may arise.
  
  
  

Skills

• Minimum of eight years of related experience and knowledge
• Recent experience working with Cognos Data Manager
• 5+ years’ experience with IBMs ETL tool, IBM InfoSphere DataStage
• Relational data base concepts and design
• Technical testing techniques and tools
• Logical and physical data modeling
• Requirements analysis
• Technical design skills
• Proficient technical writing skills
• Ability to translate business questions and requirements into technical solutions
• Demonstrated application of technical problem solving and analytical tools and techniques
• Experience with SQL Server
  
  
  

Assets

• Bilingualism in both official languages (English and French)
• Experience with IBM Cognos Business Intelligence Technologies (Report Studio, Framework Manager, Transformer and Query Studio)