ETL SAP BODs Specialist

Posted 11 months ago

ETL SAP BODs Specialist


Duration:  2 years

Location: Toronto, ON

Knowledge & 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


  • 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

Job URL:

Apply Online