We are hiring !!!

Integration and Data Migration Specialist

Hybrid – Oakville (2 days on site)

Remote can be considered for outstanding incumbents

About YDC https://ydcpro.com/

https://www.linkedin.com/company/102551773/admin/dashboard/

Please email your word format resume to [email protected]

YDC (YDCPro) is a North American based technology consulting and talent solutions firm with HQ in Toronto, Canada, helping organizations accelerate digital transformation. Since 2016, it has focused on artificial intelligence, data analytics, cloud computing, and application development, delivering tailored solutions that improve efficiency and business performance.

Position Overview

We are seeking an Integration and Data Migration Specialist to support the analysis, design,

development, and execution of project-specific data integration and one-time data migration activities. In this position, the role is responsible for successfully transferring data from legacy/source systems into modern destination platforms for dedicated project rollouts, followed by providing post-go-live support to resolve subsequent data-related issues.

This position requires strong hands-on experience with Java and SQL (Oracle and

PostgreSQL). The role demands the capability to read existing source data repositories,

comprehend complex database schemas, analyze data relationships, build reliable integration paths, and develop robust, compiled migration scripts and applications. Candidates with strong

Linux shell environment and scripting experience are highly preferred to manage file systems and automate execution tasks.

The ideal candidate possesses a robust background in software engineering with a solid emphasis on Java POJO and data manipulation frameworks, database development, DBA concepts, stored procedures, and data validation. In addition, proficiency with modern agentic AI development tools such as Claude Code, OpenAI Codex, or similar GenAI coding assistants is required to improve productivity, automate repetitive analysis, and accelerate code development.





Key Responsibilities

Collaborate with engineering, product, and project teams to define data integration requirements and establish project-specific migration paths.

Analyze legacy and active source data repositories to identify database structures, table relationships, constraints, indexes, data quality issues, and migration dependencies.

Design and implement project-specific integration logic and one-time migration scripts to convert source data into target destination formats.

Develop and maintain core data logic, standalone conversion utilities, and migration tools utilizing Java, SQL, PL/SQL, PostgreSQL functions/procedures.

Utilize Linux shell scripting (e.g., Bash) to handle large data file manipulations, automate server-side Java application execution tasks and manage cron jobs or environment paths.

Build repeatable, verifiable, and auditable migration workflows, including batch extraction,

transformation, loading, validation, rollback, and final reconciliation.

Perform complex data mapping between diverse source and target systems, thoroughly documenting transformation rules, mapping logic, and project assumptions.

Optimize execution performance for large datasets using database tuning, indexing strategies, batching, and transaction management during designated migration windows.

Validate data integrity through rigorous reconciliation reports, automated quality checks,

and exception handling protocols prior to system cutover.

Provide hypercare and dedicated post-go-live support, troubleshooting data mismatches,

missing fields, or functional database and Java application issues discovered following system deployment.

Required Technical Skills

- Java / Java POJO SQL / Oracle / PostgreSQL
- PL/SQL / Stored Procedures
- Data Integration & Data Migration
- Data Mapping / Transformation
- Linux / Bash Shell Scripting
- Data Validation / Reconciliation
- GenAI / Agentic AI Coding Tools (Claude Code, OpenAI Codex or similar)

Please email your resume to [email protected]

YDCPRO Ltd. Suite 2700/27th floor,

161 Bay Street TD Tower – Toronto – ON, M5J 2S1.

Website: https://www.ydcpro.com/

📌 Integration and Data Migration Specialist (Ontario)
🏢 YDC Pro
📍 Ontario