Data Migration Developer – Calgary

Reports To

Data Services Manager

Position Summary:

We are currently looking to fill a Data Migration Developer position. The successful candidate will prepare initial data loads for new customers of 3esi applications and will ensure the integrity of the data migration. The Data Migration Developer also develops ETL tools for integrating customer data and 3esi applications.

Key Responsibilities:

  • Ensure quality and timeliness of data migration and development of ETL tools
  • Liaise with customer support to track existing deployments and update/upgrade ETL tools as needed
  • Maintain and contribute to source code repository for ETL migrations and tools
  • Understand business problems and resolve data issues by working with Business Analysts and Project Management staff
  • Participate in pair programming and peer review of ETL development
  • Compare migrated numbers for accuracy against the source data

Key Competencies:

  • Strong software design and development capabilities, with a focus on data
  • Provide accurate estimates of tasks/projects
  • Strong analytical skills.
  • Effective oral and written communication skills.
  • Ability to work independently and as a team member.
  • Self-starter who is organized, and learns quickly

Qualifications:

  • Strong experience in TSQL and/or PLSQL
  • Familiar with XML, Java. JDBC, and JavaScript or VBScript
  • Knowledge of Pentaho/Kettle ETL tool an asset
  • Domain knowledge of oil and gas industry, and its applications
  • Previous experience doing data migrations
  • Experience with data dictionaries and data mapping
  • 3+ years application development experience

Education:

  • B.Sc. Software Engineering or equivalent