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

Domino's Franchise

Customer Service Rep $15.00 hourly Pay Job at Domino's Franchise

You'll be working for a company that's fun and flexible. Not to mention, it's work experience you're going to use for a long time to come. You've had our pizza delivered to you, now help us be the best in pizza delivery. Go on, boss, show us what you've got. Apply ...

LST Group LLC

Heavy Haul Carrier Sales Rep Job at LST Group LLC

 ...Are you a Heavy Haul carrier sales rep looking for a new role? LST Group is currently seeking a Heavy Haul/Oversized Freight Team Lead. If you are the go to for oversized loads at your current employer, we want to talk to you. The ideal candidate has 5+ years... 

Sweet P's Pre-K

Private School Teacher Job at Sweet P's Pre-K

Summary ALL Green Fields School is hiring! If you are idealistic, self-motivated, and passionate about making a meaningful difference; if teaching highly motivated, gifted students, in a small classroom setting appeals to you; and if being associated with a school...

Breight Recruitment

Director of IT Job at Breight Recruitment

 ...We're looking for an experienced and strategic Director of IT who isn't afraid to get their hands dirty. You'll be the one to optimize our technologyfrom the infrastructure and applications to our data systems. This is a key leadership role where you'll make sure our... 

Gold Star TEFL Recruitment

English Teaching Positions in Nanchang Job at Gold Star TEFL Recruitment

 ...China -Well-established school The Job World International English, one of Chinas largest English Training School with 47...  ...students are trained to attain a productive skill in listening, speaking and writing using our intensive language training. We aim to create...