ETL Developer-6 Month Contract

Toronto, ON M5V 3J1

Employment Type: Contract Industry: Other Area(s) Job Number: 60820

ETL Developer-6 Month Contract

Location: Toronto

Number of Positions: 4


Our client, a leader in the insurance industry, has asked Bagg Technology Resources to assist them in finding 4 ETL Developers to join their team on a contractual basis.

Why Join?

This is an excellent opportunity to work for a large government organization that can help maximize your potential and develop your career while helping the people of Ontario.

Key Responsibilities

Information Management Analyst

  • Identify and define client requirements for the purpose of constructing a suitable solution to meet the business needs
  • Support the design and build specialized and customized applications for reporting and analytical purpose
  • Test the applications including preparation and documentation of test criteria and review test results
  • Support quality management and assurance on data and applications to ensure security and integrity of data
  • Application Specialist
  • Translate business requirements into specifications, including translating system design into program design specifications and its documentation
  • Construct  programs for installation and install system, including completion of related documentation
  • Business Transformation
  • Construct, direct and implement ETL processes, including data capture, data quality, testing, and validation methods
  • Ensure successful data model and database implementation

ETL Development

  • Support the development, deployment, configuration and validation of DataStage code for the PSA data environment
  • Performance tuning complex large data loads and long running jobs to optimize run time, resource utilization and increase maintainability
  • Troubleshoot and resolution of production failures
  • Assist with the technical walkthroughs of DataStage Interfaces for design improvements and development peer reviews
  • Impact analysis for new implementations on existing systems
  • Validate the DataStage ETL application after any code changes
  • Participate in cross training and knowledge transfer sessions with other teams (e.g. Production Support)


  • 7+ years proven experience developing enterprise information management solutions (Data Warehouse & Business Intelligence solutions) with multiple implementations
  • 5+ years’ proven experience on IBM Infosphere DataStage 11.x, including admin and development (all components and stages)
  • 5+ years proven experience on Oracle Database 11g/12c including Oracle Stored Procedures, Oracle Performance Tuning
  • 5+ years’ experience in data modeling, database design, development and implementation
  • Proven experience creating documentation including, but not limited to requirements, technical specifications, and source to target mappings
  • Proven communication (verbal, written, and presentation) skills with ability to convey technology solutions to all stakeholders


To apply, please click Apply Online or submit your resume by email to:

View all of our job postings at

Accommodations are available upon request to support your participation during all stages   of the recruitment process.


Send an email reminder to:

Share This Job:

Related Jobs:

Login to save this search and get notified of similar positions.