Data Extraction Specialist

CMiC•Toronto, ON

7d•CA$75,000 - CA$85,000•Hybrid

About The Position

The Data Extraction Specialist is responsible for the creation, maintenance, and execution of CMiC Data Mapping and Extraction scripts, which will be used for extracting data from multiple legacy systems for import into CMiC database. This position requires the ability to effectively communicate with customers, flexibility to work outside of regular working hours, and willingness to learn CMiC software in order to evaluate best ways of matching customer’s data with CMiC data structure.

Requirements

Minimum 3-5 years professional programming experience using SQL and PL/SQL
Minimum 3-5yrs experience with Sage DB and SQL Server Management Studio (SSMS) (Must Have)
Minimum 3-5 years of experience extracting/converting data from multiple systems, such as Sage, Viewpoint, Coins, JD Edwards, Bill Smart or Jonas, to an Oracle Database.
MUST have 3-5 years of experience working with Oracle 11g, 12c, 18c, 19c Databases
Experience with SQLServer and MySQL
Candidates will also need to travel outside of Canada, as necessary
Advanced Knowledge and Experience with MS Excel (formulas, etc.)
A self-starter who takes initiatives but seeks the assistance of others when necessary
Excellent problem solving and customer service abilities
Excellent verbal and written communication skills
University Degree, preferably in Computer Science
MUST have the flexibility to work "off" hours such as: 5pm-9pm (weekdays) and some weekends, when necessary

Responsibilities

Analyze and document scope of work for Data Extraction projects
Provide estimates for Data Mapping and Extraction scripts creation
Design, develop, and maintain scripts and queries for Data Mapping and Extraction tasks from multiple legacy systems on different platforms.
Examine, design, develop, and maintain SQL scripts and queries for Data Conversion tasks
Work with external Data Extraction programmers to understand and resolve issues with incoming data
Assist customers with Data Mapping and Extraction activities
Work with data owners to verify data accuracy and integrity
Develop and execute database queries as needed
Performs data corrections through analyzing data for errors and formulating corrective procedures
Work with other team members to efficiently troubleshoot issues related to Data Conversion
Provide ongoing status and feedback of the Data Conversion process to all parties involved
Other related duties as assigned.