Integration and Data Migration Specialist
Location: Oakville, Ontario - Hybrid (Open to remote for an exceptional candidate)
Employment Type: Contract to hire
Contract Duration: 1 year
Experience Level: Intermediate to Senior
Who is the Employer?
The Raise has partnered with our client, an innovative technology organization undergoing significant modernization and digital transformation initiatives. As part of their continued growth, they are seeking a highly skilled 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 is an exciting opportunity for a hands-on data professional who enjoys solving complex data challenges, working with modern database technologies, and leveraging emerging AI-assisted development tools to accelerate engineering productivity.
Who Are You?
You are a highly analytical and technically strong Integration and Data Migration Specialist who thrives on understanding complex data ecosystems and transforming legacy data into modern, scalable platforms.
You have extensive experience working with Oracle and PostgreSQL databases and are comfortable investigating source systems, analyzing database schemas, understanding business rules, and building reliable migration solutions. You can think like both a Database Administrator and a Software Developer, combining technical expertise with strong problem-solving skills.
You are also comfortable using modern AI-assisted engineering tools such as Claude Code, OpenAI Codex, GitHub Copilot, Cursor, or similar technologies to improve productivity while applying sound engineering judgment to ensure accuracy, security, and reliability.
What You'll Be Doing
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.
As an Integration and Data Migration Specialist, you will support the analysis, design, development, testing, and execution of data migration activities from legacy systems into modern target platforms.
Practically speaking, you will:
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.
GenAI & Agentic Engineering Responsibilities-
The successful candidate will be comfortable leveraging modern AI-assisted development tools as part of their daily workflow.
What You Will Bring
Education & Experience
-
Bachelor's Degree in Computer Science, Software Engineering, Information Technology, Data Engineering, or a related discipline.
-
4-6 years of proven IT experience including delivering data migration projects involving enterprise-scale databases.
Technical Qualifications
- Java Development: Strong hands-on experience with Java, including Java POJOs, standalone applications, conversion utilities, and data manipulation frameworks.
- SQL & Database Development: Advanced SQL skills with Oracle and PostgreSQL, including complex queries, data extraction, transformation, and validation.
- PL/SQL & Stored Procedures: Experience developing and working with PL/SQL, PostgreSQL functions/procedures, stored procedures, and database logic.
- Database / DBA Concepts: Strong understanding of database schemas, table relationships, constraints, indexes, transactions, and database performance tuning.
- Data Migration: Hands-on experience designing and executing one-time data migrations, including extraction, transformation, loading (ETL), validation, reconciliation, rollback, and cutover activities.
- Data Integration: Experience designing and implementing data integration paths between legacy/source systems and modern target platforms.
- Data Mapping & Transformation: Strong experience with complex source-to-target data mapping, transformation rules, data relationships, dependencies, and data quality issues.
- Data Validation & Reconciliation: Experience performing data integrity checks, reconciliation, exception handling, and automated data quality validation.
- Linux & Shell Scripting: Strong experience in Linux environments, particularly Bash/shell scripting, file manipulation, automation, environment/path management, and cron jobs.
- Large-Scale Data Processing: Experience optimizing migration and database processes for large datasets, including batching, indexing, transaction management, and performance tuning.
- Software Engineering: Strong software engineering background with the ability to read and understand existing code, databases, schemas, and data repositories and develop reliable migration utilities/scripts.
- GenAI / AI Coding Tools: Required experience using modern AI-assisted coding/development tools, such as Claude Code, OpenAI Codex, or similar GenAI coding assistants, to accelerate development and automate repetitive technical tasks.
- Post-Go-Live Support: Experience troubleshooting data mismatches, missing data/fields, database issues, and Java application issues during hypercare and post-production support.
Core Must-Have Technical Skills
Java | SQL | Oracle | PostgreSQL | PL/SQL | Data Migration | Data Integration | Data Mapping & Transformation | Database Development/DBA Concepts | Linux | Bash/Shell Scripting | Stored Procedures | ETL | Data Validation & Reconciliation | Database Performance Tuning | GenAI Coding Assistants
Ideal Candidate Profile
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.
Looking for meaningful work? We can help
Raise is an established hiring firm with over 65 years of experience. We believe strongly in making the world a better place through work, which is why we’re a certified B Corporation and donate 10% of our profits to charity.
We strive to build teams that reflect the diversity of the communities we work in. We encourage all qualified applicants to apply, including people from traditionally underrepresented groups such as
women, visible minorities, Indigenous peoples, people identifying as LGBTQ2SI, veterans, and people with visible/nonvisible disabilities.
We have a dedicated webpage for accommodations where you can learn more about what we offer, and request accommodation: https://raise.jobs/accommodations/
In order to submit candidates for roles, our clients will sometimes require personal information to confirm the identity of applicants and their legal status to work. Raise will never ask you for personal or banking information unless you have been selected for a job. If you are ever unsure about the legitimacy of this or another job posting by Raise (or have any other questions), please contact us at +1 800-567-9675 or [email protected]
#LI-AJ1
#IMW
