ETL SAP BODs Specialist
Job Description

ETL SAP BODs Specialist

On behalf of our client in the Insurance Sector, PROCOM is looking for a ETL SAP BODs Specialist.

ETL SAP BODs Specialist – Job Description

  • Our client is looking for ETL SAP BODS Specialist to translate detailed solution design specifications into ETL processes and be responsible for the ETL configuration, testing and implementation of the Guidewire v10 DataHub (DH) data store and InfoCenter (IC) Business Intelligence (BI) warehouse to enable an end-to-end solution for reporting and analytics based on enterprise needs.

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, workflow diagrams for quality systems development of Business Intelligence (BI) warehouse and data migration from GWv7 and legacy system to GWv10 DH/ IC
  • Work with data pipelines to migrate GW data to other target systems
  • Provide ETL SAP BODS expertise in the latest GW DH/ IC versions
  • Support the deployment, configuration and validation of code for the Guidewire DH/IC data environment and ensure successful data model and database implementation
  • Assist with data capture, data quality, and validation methods

Information Management Analyst

  • Translate business requirements into specifications for the purpose of recommending a suitable solution to meet the business needs, including translating system design into program design specifications and its documentation
  • Liaise and coordinate with internal and external consultants 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 and perform data analysis
  • Assist with developing run books, release notes, deployment instructions and control reports for data movement

Business Transformation

  • Collaborate with multiple stakeholders, teams and assist in data conversion from GWv7 to GW v10, the conversion of CC/CM/PC/BC data to DH and migration from other legacy systems.
  • Assist IT partners with information and application data conversions and extractions
  • Support the specialized and customized applications for reporting and analytical purpose
  • Support quality management and assurance on data and applications to ensure security and integrity of data

Reporting & Analytics Application Specialist

  • Perform Impact analysis for new implementations on existing reporting and analytic systems and validate the ETL application after any code changes
  • Performance tuning complex large data loads and long running jobs to optimize run time, resource utilization and increase maintainability
  • Assist with software architecture and patters such as SOA, OO, Analysis and Design, Component Architecture Event/ Message Driven, debugging
  • Code, test, implement and maintain reporting and analytics systems that comply with access and privacy legislation and policies
  • Participate in all levels of testing i.e. unit, system, integration, regression, performance, security, usability, optimization/configuration and coordinates user acceptance testing of reporting and analytic systems
  • Participate in cross training and knowledge transfer sessions with other teams (e.g. Production Support)
  • Participate as a team member in the execution of project plans providing technical expertise and advice re: architecture, development tools, work effort estimates

ETL SAP BODs Specialist – Mandatory Skills

  • 7+ years’ experience in data integration (ETL) design and development, testing, monitoring, troubleshooting and data extraction from diverse data sources (e.g. SAP, Oracle, SQL Server, DB2, Excel, etc.) into target systems.
  • 7+ years proven experience developing enterprise information management solutions (Data Warehouse, Business Intelligence & Data Analytics solutions) with multiple implementations
  • 5+ year experience of Guidewire (GW) Insurance Suite including BillingCenter, PolicyCenter, ClaimCenter, Contact Manager, DataHub (DH) and InfoCenter (IC) & GW Data Management tools;
  • Expertise in SAP BODS admin and development as well as demonstrated experience in Guidewire DH/ IC implementation projects.
  • 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
  • Shell script, dBase, FoxPro, Spring, EJB, SOAP, Eclipse, MQ, IBM Infosphere DataStage
  • Proven communication (verbal, written, and presentation) skills with ability to convey technology solutions to all stakeholders

ETL SAP BODs Specialist - Assignment Start Date

ASAP – 24 months to start

ETL SAP BODs Specialist - Assignment Location

Downtown Toronto

Job Requirements


Company Overview

For 35 years, Procom has been pushing the envelope in North American IT staffing solutions. Driven by a senior management team of seasoned recruitment professionals, we have offices in 14 locations in the US and Canada and service all major IT markets.

When we started out in 1978, tech jobs were just being integrated into the workplace. We have been a part of shaping the landscape of IT in Canada ever since, placing IT consultants in major businesses in all sectors, including banking, telecommunications, and retail.

Through all the peaks and valleys of the IT industry, we have consistently done one thing: helping IT professionals discover the next chapter in their career.

Submit your email address to begin the application process for the ETL SAP BODs Specialist job
Email is invalid Email address is needed