Software Developer ETL - Senior Job at Teckhorizon Inc, Ontario, CA

b2M3RlB5UnM0bzg0Z3lhaTFIR3FnWkJYRHc9PQ==
  • Teckhorizon Inc
  • Ontario, CA

Job Description

Job Title: Senior Software Developer ETL

Client: Office of the Public Guardian and Trustee (OPGT), Ontario Public Service
Location: Hybrid
Work Hours: 7.25 hours/day, Monday to Friday, between 8:00 AM 5:00 PM

Scope of Work

The OPGT requires a Senior Software Developer ETL to support data validation and quality assurance in the migration of legacy applications to the new Microsoft Dynamics 365 Customer Engagement (CE) platform. This role is critical to ensuring data integrity, transformation accuracy, and seamless integration in preparation for the system go-live.

Responsibilities

  • Analyze legacy data structures, quality, and relationships.
  • Review and understand existing data migration code and mappings.
  • Develop and execute data test plans, test cases, and reconciliation reports.
  • Monitor and validate data migration completeness and accuracy.
  • Modify ETL scripts and pipelines to resolve data quality and mapping issues.
  • Create KPIs to measure migration progress and quality.
  • Provide post-migration support and issue resolution.
  • Document all testing activities, changes, and results.
  • Participate in knowledge transfer activities and ongoing team collaboration.
  • Comply with government security, privacy, architecture, and conflict of interest guidelines.

Mandatory Requirements

  • 5+ years of hands-on ETL development experience, including data extraction, transformation, and loading.
  • Proficiency in SQL, with experience in Azure SQL Databases and Dataverse.
  • Solid knowledge of Microsoft Dynamics 365 Customer Engagement (CE).

Nice-to-Have Qualifications

  • Azure Certifications (e.g., Azure Fundamentals, Azure Data Engineer Associate, Azure Database Administrator Associate).
  • Experience with Azure Synapse, Data Factory, Power Platform, and related tools.
  • Familiarity with Azure DevOps, version control, and CI/CD practices.
  • Knowledge of data governance, quality assurance, and privacy standards in cloud environments.
  • Experience in Dynamics 365 data models, including entities, relationships, and Power Platform integration.

Job Tags

Work at office, Monday to Friday,

Similar Jobs

Empire Today

Dedicated Carpet Installer Job at Empire Today

[' Are you looking for flooring installation jobs? Stop hunting for work Empire Today has work for flooring installers right now! We are looking for experienced contractors looking to grow their installation business. Daily Work!! Empire can provide 12+ installations... 

JSR Corporation

Analytical Chemist Job at JSR Corporation

 ...JSR Micro is seeking a skilled Analytical Chemist with 3-6 years of experience in a laboratory or Quality Control environment. The ideal candidate will have a solid foundation in trace metals analysis, chromatography, spectroscopy, and wet chemistry techniques, along... 

Phoenix Healthcare LLC

Clinical Liaison Job at Phoenix Healthcare LLC

 ...is to develop, coordinate, direct and administer the facility marketing and public relations programs and services. Must have Clinical Liaisons background. Duties and Responsibilities Administrative Functions Plan, develop, organize, implement, evaluate and direct... 

Advanced Decision Vectors, LLC

Security Management Specialist (Active TS/SCI) Job at Advanced Decision Vectors, LLC

 ...unclassified contract security requirements, contractor clearances, and secure facility compliance. This role requires a deep understanding of DoD security procedures, coordination with Facility Security Officers (FSOs), and administration of security databases to ensure mission... 

Gpac

Experienced Freight Broker Opportunity Job at Gpac

 ...dynamic, growing logistics firm offering cutting-edge solutions and exceptional service. We are currently seeking an experienced Freight Broker with a proven track record in building a book of business to join our team working in the hot North Carolina market! This is a...