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 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 [email protected]
YDCPRO Ltd. Suite 2700/27th floor,
161 Bay Street TD Tower – Toronto – ON, M5J 2S1.
Website: https://www.ydcpro.com/
