ETL Specialist

Job CategoryInformation Technology
Position TypeContract
Application Deadline January 3, 2020
Experience RequiredN/A
Job DurationTemporary
Education RequiredN/A

*Resource Profile:

The WSIB is looking for one ETL Specialist, to translate detailed solution design specifications into ETL processes and assist with the ETL configuration, testing and implementation of Phase 3 of WSIB’s Compass tool.  The work encompasses data capture, data quality, testing, and validation methods, as part of the end-to-end ETL process of this enterprise web-based business solution

* Knowledge & Skills

3+ years in Information Technology or Information Management
3+ years of IBM Infosphere DataStage ETL tool (version 8.5 or greater)
3+ years of experience with writing SQL queries and stored procedures with relational databases (DB2, Oracle, SQL Server)
Experience with Business Intelligence methodologies and Technologies like Relational databases (Oracle, MySql, etc) , OLAP , Visualization business Intelligence (Microsoft PowerBI, Tableau, Qlikview, etc), Enterprise Business Intelligence Solutions (ie Cognos), ETL (SQL, Information, Datastage, etc)
Experience being a member of a design, development project team building Business Intelligence and reporting solutions
2+ year experience of Guidewire (GW) Insurance Suite including BillingCenter,  PolicyCenter, ClaimCenter, Contact Manager, and DataHub (DH).
2+ years’ experience with WSIB data source systems: Prevention Data Mart (PDM), Operations Data Mart (ODM), and REP.
Working knowledge of Microsoft Windows, Unix operating systems, Oracle server, Oracle Database, Oracle Stored Procedures, Oracle Performance Tuning, database design, development and implementation, SQL, PL/SQL, MS-SQL Server, XML, UNIX
Proven communication (verbal, written, and presentation) skills with ability to convey technology solutions to all stakeholders

*Resource Responsibilities:

ETL Development 
Assist in analysis, coding and testing of ETL processes, as well as technical documentation and deployment preparation.
Participate in requirements analysis, architecture sessions and create detailed ETL specifications 
Construct new and efficient ETL processes for data provisioning and data integration from multiple WSIB source systems (REP, PDM, ODM, DataHub)
Support the deployment, configuration and validation of code for the Compass tool data environment and ensure successful data model and database implementation
Assist with data capture, data quality, and validation methods
Information Management Analyst
Leveraging the existing data model for the Compass tool, translate business requirements for Phase 3 into specifications for the purpose of recommending a suitable solution to meet the business needs
Liaise and coordinate with internal project resources in detailed systems deliverables and technical problem resolution
Utilize documentation including, but not limited to requirements, technical specifications, and source to target mappings
Assist with executing SQL (Structured Query Language) scripts
Assist with developing run books, release notes, deployment instructions and control reports for data movement
Reporting & Analytics Application Specialist
Assist with ensuring the new implementation of Compass Phase 3 does not impact the data integrity and design of the existing application by validating the ETL application after any code changes in lower environments
Performance tuning complex large data loads and long running jobs to optimize run time, resource utilization and increase maintainability of the Compass application
Code, test, implement and maintain reporting and analytics systems that comply with access and privacy legislation and WSIB policies

To apply please send updated resume to: