Data Manager

** + years of IT experience as ETL Developer in Requirements gathering, analysis, design, coding, documentation and implementation, Testing and support of Data Warehouse applications using Informatica Power Center.

Aviva Canada is one of the leading property and casualty insurance groups in Canada providing home, auto and business insurance to more than three million customers. The company is a wholly owned subsidiary of UK-based Aviva plc and has more than 3,000 employees, 25 locations and approximately 1,500 independent broker partners. Aviva Canada is the second largest general insurance business in the Aviva Group. General insurance is a key growth area for Aviva and a core component of the Group’s customer composite strategy, providing customers with life insurance, general insurance, health insurance and asset management. This project is responsible to migrate data from RBC Insurance provider to AVIVA so extracted data from different sources like Oracle, Flat Files and load into target tables. Actively involved as a developer for preparing design documents and interacted with data modelers to understand the data model and ETL logic.

Responsibilities:

Involved in gathering requirements with business users.

Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica power center.

As Australia’s largest superannuation service provider, Superpartners exclusively collaborate with not-for-profit industry superannuation funds to create a better future for members. For 30 years, Superpartners has supported some of the country’s largest and most respected industry funds to provide tailored solutions and a seamless service experience to their members and employers.

As part of this project, we migrated data from oracle to SQL Server since oracle server based application was replaced by the new application called spRIGHT.

Roles & Responsibilities:

Work closely with Project Manager to develop and update the task plan for ETL work and to keep the manager aware of any critical task issues and dependencies on other teams.

Ensure the ETL code delivered is running, conforms to specifications and design guidelines.

Developed reusable transformations and mapplets, which can be used for multiple mappings

Support development teams with performance tuning and troubleshooting issues.

Developed ETL stage mappings to pull the data from the source system to the staging area.

Perform root cause analysis on all processes, resolve all production issues, validate all data, perform routine tests on databases, and provide support to all ETL applications.

Monitor all business requirements, validate all designs, schedule all ETL processes, and prepare documents for all data flow diagrams.

Analyze and interpret all complex data on all target systems and analyze and provide resolutions to all data issues and coordinate with data analyst to validate all requirements, perform interviews with all users and developers.

Developed error tables and audit table for loading bad records.

Provide observations of the overall system and suggest automated steps to full-fill the business operations and the requirements.

This application is used for Hospital Maintenance which Includes Patient Records Maintenance. Medication for Patients, Scheduling Component for Doctors, Drug Interaction Reports etc. As part of this project, we migrated data from oracle and various file sources into to SQL Server.

Roles & Responsibilities:

Preparing ETL Deployment guides and adding the required workflows to Deployment group for smooth migration of code to higher environments.