Talent.com

Sas developer Jobs in Whitby, ON

Create a job alert for this search

Sas developer • whitby on

Last updated: 12 hours ago

Syniti ETL Developer

Randstad CanadaOshawa, Ontario, CA
TemporaryTemporary
Quick Apply

Our client, is seeking an experienced, highly analytical Syniti ETL Developer to join a critical enterprise data cleansing and SAP S/4HANA migration initiative in Oshawa, Ontario.In this hands-on d... Show more

 • New!

Account Representative

Dan Piedimonte - Desjardins Insurance AgentAjax, Ontario, Canada
Permanent, Full-timePermanent, Full-time

Full-Time Account Representative.We hire people who use their skills and passion at work because our customers deserve to interact with us at our best.Choose a career with Desjardins and take the f... Show more

2027 Winter Co-op Data Engineering Software Developer

General MotorsOshawa
Full-timeFull-time

This posting is not for an existing vacancy within the organization and is open to new applications.As part of the application process, Artificial Intelligence will be used in the hiring process fo... Show more

 • New!
People also ask
Syniti ETL Developer

Syniti ETL Developer

Randstad CanadaOshawa, Ontario, CA
12 hours ago
Job type
  • Temporary
  • Quick Apply
Job description

Our client, is seeking an experienced, highly analytical Syniti ETL Developer to join a critical enterprise data cleansing and SAP S/4HANA migration initiative in Oshawa, Ontario.

In this hands-on data engineering and migration role, you will drive end-to-end data profiling, cleansing, transformation, and conversion workflows scheduled to kick off in January 2027. Working across legacy enterprise asset management systems (such as Asset Suite 9 / Oracle) and modern SAP S/4HANA target architectures, you will configure core Syniti Knowledge Platform (SKP / DSP / ADM) modules—including Migrate, Catalog, Quality, Construct, and Match—to build data quality scorecards, design Construct enrichment web applications for business stewards, develop complex SQL transformation logic, and execute mock and cutover loads via the SAP S/4HANA Migration Cockpit.

Contract Duration: 8-Month Contract (Target Start Date: January 2027; full-time engagement)

Work Location: Oshawa, ON (Hybrid – 4 days per week on-site, 1 day remote)

Security Clearance Requirement: Candidates must be eligible to obtain the required nuclear security clearance



Advantages
Mission-Critical Energy & Nuclear Infrastructure Impact: Play a pivotal role cleansing, governing, and migrating foundational enterprise asset and supply chain data for a major power generation utility.

8-Month Full-Lifecycle Migration Mandate: Experience the complete data conversion lifecycle—from initial source profiling and rule configuration through mock loads, reconciliation, and production cutover.

Deep Syniti & SAP S/4HANA Tech Stack: Work hands-on across the full Syniti suite (Migrate, Catalog, Quality, Construct, Match) paired with SAP S/4HANA Migration Cockpit and enterprise SQL platforms.

Collaborative Business & Technical Alignment: Partner directly with Data Stewards, SMEs, and Data Migration Leads to replace manual spreadsheets with interactive Construct web applications and automated quality scorecards.



Responsibilities
Syniti Environment Setup & Source Connectivity: Configure Syniti projects, waves, process areas, objects, users, and roles aligned to release plans; establish system connections and data snapshots against legacy Oracle databases (Asset Suite 9), register metadata in Catalog, and manage object promotion across DEV, QA, and PROD tenants.

Data Profiling & Quality Scorecards: Profile source datasets to uncover completeness, validity, consistency, duplication, and referential integrity gaps; build and schedule rules in Syniti Quality and produce recurring object- and business-unit-level scorecards and dashboards.

Source Cleansing & Construct Applications: Build remediation reports and worklists routing errors to Data Stewards/SMEs; configure Syniti Construct web applications for interactive enrichment and approval, tune Match jobs for duplicate resolution/survivorship, and prepare audited write-back files for Asset Suite 9.

S/4HANA Conversion, Load & Reconciliation: Design target datasets aligned to SAP S/4HANA structures; build field/value mappings and cross-reference tables in Map, write SQL transformation/validation rules in Transform, generate staging outputs (plus BAPI/IDoc loads where required) for the SAP S/4HANA Migration Cockpit, and execute mock and cutover loads with full pre/post-load reconciliation reports.

Data Governance & Delivery Hygiene: Configure ongoing data quality monitoring between waves and post-go-live; maintain reusable rule libraries and specifications in Catalog, document runbooks, track defects/risks for the Data Migration Lead, and walk business SMEs through Syniti outputs.



Qualifications
Data Migration & Syniti Experience (4–8 Years): 4 to 8 years of progressive experience in enterprise data migration or data quality delivery, including at least 3+ years of hands-on configuration and development in Syniti (SKP, or legacy DSP / ADM platforms).

Full-Cycle SAP S/4HANA Migration: Proven track record delivering at least one full-cycle SAP S/4HANA or SAP ECC data migration on Syniti—spanning initial design, mock loads, error resolution, and production cutover.

Core Syniti Module Mastery: Demonstrated hands-on build experience across Migrate (ADMM) (waves, mapping, ETL/Transform rules, load files, reconciliation), Catalog (connections, snapshots, metadata, rule library), Quality (rules, thresholds, dashboards), and Construct (Full and Enrichment Construction web apps and worklists).

SQL & Database Proficiency: Strong hands-on SQL skills writing, debugging, and tuning transformation and validation logic in MS SQL Server, paired with solid working knowledge of Oracle SQL for source data extraction.

SAP S/4HANA Load Methods & Master Data: Practical experience using the SAP S/4HANA Migration Cockpit (staging table approach) and familiarity with BAPI/IDoc loads, alongside working knowledge of SAP master data structures for at least two domains: Plant Maintenance / EAM (Functional Location, Equipment, Maintenance Plan, Task List, Measuring Point), Material Master, BOM, or Business Partner / Supplier.

Stakeholder Communication & Security Eligibility: Comfortable walking business users through data errors to agree on remediation fixes, and eligible to obtain the required nuclear security clearance.

Preferred Assets & Nice-to-Haves
Syniti Certified Developer (Migrate learning path) certification (strongly preferred).

SAP S/4HANA certification (Data Migration, Plant Maintenance, or Materials Management).

Hands-on experience with Syniti Match (fuzzy, phonetic, and rules-based deduplication and survivorship), Syniti Replicate, Syniti Governance / MDM (SAP MDG integration), or Syniti AI classification/enrichment capabilities.



Summary
If you are a seasoned Syniti ETL Developer who pairs 3+ years of hands-on Syniti (Migrate, Catalog, Quality, Construct) and full-cycle SAP S/4HANA migration experience with strong MS SQL Server and Oracle SQL skills, this 8-month hybrid contract opportunity in Oshawa is an ideal next step. Bring your data quality rigor, conversion precision, and collaborative problem-solving skills to our client's enterprise transformation team today!

Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.

Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.