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

Mayo Clinic

Child Life Specialist - Children of Adult Patients Job at Mayo Clinic

 ...for eligible expenses. Retirement: Competitive retirement package to secure your future. Responsibilities The Child Life Specialist promotes effective coping through play, preparation, education, and self-expression activities. Provides emotional support for... 

Delta-T Group Inc.

Truancy Case Management (weekly compensation up to $3,600 monthly) Job at Delta-T Group Inc.

 ...client is accepting newly graduated individuals with any major under the Human Services umbrella (psychology, sociology, social work, criminal justice) SUMMARY OF CLIENT'S DESCRIPTION OF THIS OPPORTUNITY *Provide attendance support by removing barriers to attendance... 

HRBoost

Fractional HR Consultant Job at HRBoost

 ...Fractional HR Consultant On-Site | Beloit, WI & Rockford, IL Part-Time | Approx. 20 Hours/Week HRBoost is seeking an experienced and adaptable Fractional HR Consultant to provide dedicated, on-site HR support for a client with facilities in Beloit, WI, and Rockford... 

UPMC Presbyterian

Nursing Assistant / Patient Care Technician - Trauma Units at UPMC Presbyterian Job at UPMC Presbyterian

 ...Are you looking to establish a fulfilling, hands-on health care career while elevating the patient experience? As a Nursing Assistant or Patient Care Technician with UPMC Presbyterian, youll make a meaningful difference on our team by working with our Life Changers to... 

Lamers Bus Lines, Inc.

School Bus Driver Monroe Job at Lamers Bus Lines, Inc.

Now Hiring School Bus Drivers Paid CDL Training + Flexible Hours!Looking for a rewarding part-time job with a flexible schedule and great benefits? Join Lamers Bus Lines as a School Bus Driver or Charter Driver today!Were hiring school bus drivers and charter bus...