Integration and Data Migration Specialist

We are hiring !!!

Integration and Data Migration Specialist

Hybrid – Oakville (2 days on site) - Oakville ON Canada

Strong hands-on experience with Java / Java pojo nice to have and SQL (Oracle and PostgreSQL).

About YDC

https://ydcpro.com/

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

Please email your word format resume to mycareer@ydcpro.com

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 strong

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 mycareer@ydcpro.com

YDCPRO Ltd. Suite 2700/27th floor,

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

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