Posted yesterday
Syniti ETL Developer
@ Randstad Canada
Oshawa, Ontario
Overview
Randstad Canada is hiring an 8-month contract Syniti ETL Developer for a client's enterprise data cleansing and SAP S/4HANA migration in Oshawa, Ontario, starting January 2027. The role covers profiling, cleansing, transformation and conversion workflows, plus Syniti configuration and mock and cutover loads. The posting states a hybrid arrangement of 4 days on-site and 1 day remote, full-time, with a nuclear security clearance requirement.
Pay:
$0.66 an hour
Responsibilities:
- Configure Syniti projects, waves, objects, users and source connections
- Profile source data and build Syniti Quality rules and scorecards
- Build remediation worklists and Construct enrichment web applications
- Design S/4HANA mappings and SQL transformation and validation rules
- Execute mock and cutover loads with pre/post-load reconciliation
Requirements summary:
- 4 to 8 years of enterprise data migration or data quality experience
- 3+ years hands-on Syniti (SKP, DSP or ADM) configuration
- At least one full-cycle SAP S/4HANA or ECC migration on Syniti
- Strong MS SQL Server and Oracle SQL skills
- Eligible to obtain a nuclear security clearance
Tools & skills
Source and dates
Employer career site / ATS feed · careerpage
- Employer posting date
- 2026-11-16
- First seen by our source
- 2026-11-17
- Source record updated
- 2026-11-17
These dates describe the source record, not a live verification that the employer is still hiring. Check the original posting.
Job details
| Seniority | Mid level |
| Department | Software development |
| Experience | 4+ years |
| Schedule | day |
| Travel | air: none · ground: none |
| Work setting | Office, Client sites |
| Position | Mostly sitting |
| Physical demands | physical low · computer high |
| Languages | English |
| Encouraged to apply | Women, Indigenous peoples, People with disabilities, Racialized people, 2SLGBTQ+ |
| Security clearance | Other clearance |
Summary and details written by AI from the posting; the employer’s posting is the authority.
Randstad Canada
Saved company profile
Historical company information from a saved The Jobs API profile (LinkedIn/Crunchbase fields). It is not live-verified; figures may have changed. Missing values remain unknown.
partner for talent.
Full company description
As the Canadian leader in recruitment and HR, and one of Canada’s best places to work, we have a uniquely human approach to work. We deliver HR innovation with human interaction at its core. At the unique intersection of technology and humanity, we deliver data-driven insights coupled with a people-first experience that is inherently human. Human Forward. Learn more at www.randstad.ca.
- LinkedIn followers
- 455,966
- People associated on LinkedIn
- 1,207
- Reported office locations
- 777 Bay Street, Suite 2000, PO Box 128, Toronto, ON M5G 2C8, CA
- 525 Avenue Viger Ouest, Suite 501, Montréal, Quebec H2Z 1G6, CA
- 4295 King St E, Suite 401, Kitchener, Ontario N2P 0C6, CA
- 311 6 Ave SW, Intact Place, East Tower, Suite 1640, Calgary, AB T2P 3H2, CA
- 6345 Dixie Rd, Suite 6, Mississauga, ON L5T 2E6, CA
- 244 Pall Mall St, Suite 400, London, ON N6A 5P6, CA
- 4 Cedar Pointe Dr, Unit D, Barrie, Ontario L4N 5R7, CA
- 2456 Queen St E, Unit 201, Brampton, Ontario L6S 5X9, CA
- 10 Stanley St, Suite 4A, Brantford, Ontario N3S 7N4, CA
- 7055 Boulevard Taschereau, Suite 100, Brossard, Quebec J4Z 1A7, CA
- 1100 Walkers Line, Suite 105, Burlington, Ontario L7N 2G3, CA
- 10655 Southport Rd SW, Suite 1200, Calgary, Alberta T2W 4Y1, CA
- 495 36 St NE, Suite 140, Calgary, Alberta T2A 6K3, CA
- 321 6 Ave SW, Suite W940 (West Tower), Calgary, Alberta T2P 0B2, CA
- 415 Hespeler Rd, Unit 3A, Cambridge, Ontario N1R 6J1, CA
- 6001 60 Ave, Delta, British Columbia V4K 4E2, CA
- 787 Rue St-Pierre, Suite 303, Drummondville, Quebec J2C 3X2, CA
- 10025 102A Ave NW, Suite 1902, Edmonton, Alberta T5J 2Z2, CA
- 2305 111 St NW, Edmonton, Alberta T6J 5E5, CA
- 5 Boulevard Mountain, Granby, Quebec J2G 9M5, CA
- 450 Speedvale Ave W, Unit 103, Guelph, Ontario N1H 7Y6, CA
- 1809 Barrington St, CIBC Building, Unit 501, Halifax, Nova Scotia B3J 3K8, CA
- 275 James St N, Unit 2, Hamilton, Ontario L8R 2L4, CA
- 7655 Boulevard Newman, Suite 75, Montreal, Quebec H8N 1X7, CA
- 2530 Boulevard Daniel-Johnson, Laval, Quebec H7T 2R3, CA
- 2528 Boulevard Daniel-Johnson, Laval, Quebec H7T 2R3, CA
- 5410 Boulevard Guillaume-Couture, Suite 84, Lévis, Quebec G6V 4Z2, CA
- 460 Rue St-Charles O, Suite A, Longueuil, Quebec J4Z 1A7, CA
- 80 Tiverton Ct, Suite 400, Markham, Ontario L3R 0G4, CA
- 7357 Woodbine Ave, Suite 2, Markham, Ontario L3R 1A7, CA
- 4080 Confederation Pkwy, Suite 501, Mississauga, Ontario L5B 0G1, CA
- 6345 Dixie Rd, Suite 6, Mississauga, Ontario L5T 2E6, CA
- 809 Columbia St, New Westminster, British Columbia V3M 1B9, CA
- 20 York Mills Rd, Unit 208, Toronto, Ontario M2P 2C2, CA
- 1600 Carling Ave, Suite 410, Ottawa, Ontario K1Z 1G3, CA
- 2222 Carling Ave, Suite 2, Ottawa, Ontario K2A 1H3, CA
- 4810 Boul Saint-Jean, Montréal, Quebec H9H 4B2, CA
- 755 Boulevard Saint-Jean, Suite 130, Pointe-Claire, Quebec H9R 5M9, CA
- 815 Boulevard Lebourgneuf, Suite 201, Québec, Québec G2J 0C1, CA
- 2010 11th Ave, 7th Floor, Regina, Saskatchewan S4P 0J3, CA
- 208 Boulevard du Curé-Labelle, Sainte-Thérèse, Quebec J7E 2X7, CA
- 3500 Boulevard de la Côte-Vertu, Suite 175, Saint-Laurent, Quebec H4R 2X7, CA
- 6335 Rue Jean-Talon Est, Saint-Léonard, Quebec H1S 3E7, CA
- 310 Wall St, Saskatoon, Saskatchewan S7K 1N7, CA
- 124 Rue Wellington Nord, Suite 300, Sherbrooke, Quebec J1H 5X8, CA
- 701 W Georgia St, Suite 200, Vancouver, British Columbia V7Y 1C6, CA
- 730 View St, Suite 420, Victoria, British Columbia V8W 3Y7, CA
- 100 Regina St S, Suite 140, Waterloo, Ontario N2J 4P9, CA
- 114 Dundas St E, Unit 103, Whitby, Ontario L1N 2H7, CA
- 245 Portage Ave, Winnipeg, Manitoba, CA
- 1 Lombard Pl, Suite 1535, Winnipeg, Manitoba R3B 0X3, CA
- 386 Boulevard Charest E, Quebec, QC G1K 3H4, CA
- Other recorded names
- Randstad Canada
- Specialties
- HR Consulting
- IT Recruitment
- Engineering Recruitment
- Staffing and HR
- HR Services
- Recruitment
- HR Outsourcing
- Temporary Hiring
- Permanent Hiring
- Recruiting
- Permanent Jobs
- Temp Jobs
- Hiring Strategy
- Human Resources
- Staffing
- Finding Jobs
- Employer Branding
- Jobs
- and Contract Jobs
- Profile identifies a recruitment agency
- Yes
As the Canadian leader in recruitment and HR, and one of Canada’s best places to work, we have a uniquely human approach to work. We deliver HR innovation with human interaction at its core. At the unique intersection of technology and humanity, we deliver data-driven insights coupled with a people-first experience that is inherently human. Human Forward. Learn more at www.randstad.ca.
| Field | Value |
|---|---|
| Industry | Staffing and Recruiting |
| Company size | 501-1,000 employees |
| Headquarters | Toronto, ON |
| Organization type | Public Company |
| Year founded | 1997 |
| Specialties | HR ConsultingIT RecruitmentEngineering RecruitmentStaffing and HRHR ServicesRecruitmentHR OutsourcingTemporary HiringPermanent HiringRecruiting |
| Open jobs on Jobsy | 9,747 |
| View page |
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 [email protected] to ensure their ability to fully participate in the interview process.
This posting is for existing and upcoming vacancies.
Journal
Only you can see this. Kept on this device, and in your account when you sign in.