Application Developer

TEEMA; Regina; Hybrid; CAD 80,000 - 100,000; Full time

Job summary

A government contractor in Canada is seeking an experienced Application Developer for a 15+ month contract, focusing on the Disaster Recovery Program. The role involves designing ETL processes, analyzing data compliance, and mentoring junior resources. Candidates with a Bachelor's degree in IT/Engineering and strong skills in Informatica, SQL, and data management are preferred. Remote candidates from anywhere in Canada are welcome to apply. Competitive compensation will be offered for this specialized role.

Benefits

Remote work flexibility

Opportunity for contract extension

Qualifications

• Minimum of five years experience as a Data Engineer or similar role.
• Minimum of two years experience using Informatica software.
• Experience with SQL, data management, and ETL processes.

Responsibilities

• Design and build data extraction and transformation infrastructures.
• Identify and implement internal process improvements.
• Analyze datasets for compliance with data sharing agreements.

Skills

Data Engineering

ETL Development

SQL

Informatica

Python

Education

Bachelor's degree in IT, Engineering or Computer Science

Diploma in related Data Management/IT

Tools

Informatica

SQL Server

Oracle

Job description

Job Title: Application Developer Job ID: 84675 Location: Regina, Saskatchewan

Overview

Our government client in Regina, SK is looking for an Application Developer for a 15+ month contract to start, with possible extensions, reference #C19003703. This position is preferred to be local to the Regina area but candidates can be remote located anywhere in Canada.

What you will be doing

Our client is currently looking for one (1) Application Developer Resource for its Disaster Recovery Program to create and document new technical tool components of the Disaster Recovery Program, ensuring those tools support the needs of the Program. Having a dedicated developer enables continuous improvement, integration of new process tools, and rapid response to evolving business.

• Design and build the infrastructure required for optimal extracting, transformation, and loading of data from a wide variety of data sources using Informatica, Structured Query Language (SQL), SQL Server Integration Services (SSIS), Application Programming Interface (API) and other technologies.
• Architect relational and multi-dimensional databases from structured, semi-structured and unstructured data with development techniques including star and snowflake schemas, ETL, Slow Changing Dimensions (SCD), Fact and Cube development in a data management framework in conjunction with the Provincial Data Platform Infrastructure.
• Identify, design and implement internal process improvements: automate manual processes, optimize data delivery, re-design data pipelines for greater scalability.
• Build analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiencies, and other key business performance metrics.
• Develop, maintain, optimize, troubleshoot, debug, monitor, backup and recovery operations for the ETL environment.
• Analyze datasets to ensure compliance with data sharing agreements and legislation restrictions, and for alignment with data architecture guidelines.
• Mentor, support and train Information Analyst and Junior Data Management resources, as required.

What you must have

• Have a minimum of five (5) years proven experience working as a Data Engineer or similar role.
• Possess either a bachelor’s degree in information technology, Engineering or Computer Science; or a diploma in related Data Management/Information Technology stream, along with three (3) additional years experience (over the required five (5) years) working as a Data Engineer or similar role.
• Have a minimum of two (2) years proven experience using Informatica software (i.e., Power Centre, Integration Services, Workflow Manager, IDMC and TDM) in an integrated support environment.

Expert knowledge of

• Oracle and SQL Server Database Management Systems and tools.
• ETL and data pipeline development experience; providing technical consulting and guidance to development teams for the design and development of highly complex or critical ETL architecture.
• Computer programming languages such as PL/SQL, R, Python.
• Operating systems such as Unix, Linux, and Windows.
• Shell Scripting language.
• Data Application Programming Interface (API).
• Algorithms and data structures.

Extensive experience with

• Information management, logic modeling, conceptual, business process, and workflow design.
• Requirements gathering, analysis, plan, design, develop, implement and maintain Data Management systems.
• Critical, constructive and creative problem-solving skills that involve issue identification, development of objectives, development of an action plan overseeing what needs to done, while identifying the resources required to ensure quality products.
• Cloud platform for data management.

Plus

• Microsoft Certified: Azure Data Engineer Associate would be considered an asset.
• Experience working with healthcare data would be considered an asset.

Thank you for your interest in this opportunity. If you are selected to move forward in the process, we will contact you directly. If you do not hear from us, we encourage you to continue visiting our website for other roles that may be a good fit.

For more information about TEEMA and to consider other career opportunities, please visit our website at www.teemagroup.com