Senior Software Developer- ETL

We are seeking a Senior ETL Software Developer to lead the architectural design and execution of high-complexity data and file migration initiatives. This role is focused on the digital transformation of legacy systems into modernized cloud solutions. You will be responsible for the end-to-end migration lifecycle, including data profiling, cleansing, mapping, and the migration of large volumes of document attachments. The ideal candidate will bridge the gap between legacy RDBMS structures and modern Azure Cloud environments, ensuring data integrity through rigorous post-migration audits and reconciliation.

Pay Rate: $555.49-$591.05/Diem

Advantages
- Mission-Critical Impact: Direct the migration of massive, sensitive data sets that form the backbone of modernized public service applications.

- Cloud Modernization: Gain deep, hands-on experience in one of the most significant digital transformations using the latest Azure cloud data tools.

- Strategic Leadership: Move beyond simple coding to oversee all facilities of the migration process, providing specialized advice on scalability and data integrity.

- Stable Engagement: Benefit from a long-term contract with a significant extension option, providing continuity in a high-priority environment.

Responsibilities
- Migration Strategy: Provide best-practice solutions for the transition of structured data and unstructured files from legacy platforms to modernized cloud solutions.

- Full Lifecycle ETL: Lead the Extraction, Transformation, and Loading (ETL) process using tools like Informatica or Azure Data Factory.

- Data Profiling & Cleansing: Analyze legacy data sources to identify quality issues; suggest and implement pre-migration cleansing and data reconciliation.

- Technical Implementation: Write complex SQL and PL-SQL queries to handle intricate table relationships and ensure precise data mapping.

- Cloud Integration: Manage migrations into Azure SQL Database and handle file storage transitions (Azure BLOB, SharePoint, Oracle BLOBs).

- Documentation: Develop and maintain critical artifacts including ETL mappings, comprehensive data dictionaries, and migration strategy plans.

- Testing & Audit: Define and execute testing strategies, mock conversions, and post-migration audits to verify the completeness and accuracy of converted data.

Qualifications
- ETL Seniority: 7+ years of experience in developing and documenting ETL processes specifically for large-scale data conversion and migration.

- Technical Stack: Extensive experience with Oracle, MS SQL Server, and Azure SQL Database.

- Cloud Expertise: Proven proficiency in Azure Data Factory and cloud-based DB technologies.

- File Migration: Specific experience in migrating document attachments and binary objects (BLOBs) from legacy systems.

- Information Management: Deep understanding of master data vs. transactional data interdependencies and information lifecycle policies.

- Mainframe Knowledge: Familiarity with non-relational data structures, mainframe data formats, and segments is a significant advantage.

- Communication: Demonstrated ability to present migration strategies to executive stakeholders and manage client relationships across all levels.

Summary
If you are a Senior ETL Specialist with a track record of successfully navigating the complexities of legacy-to-cloud migrations, we encourage you to apply today!

Only qualified candidates will be contacted for the next steps. We look forward to hearing from you.

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 accessibility@randstad.ca to ensure their ability to fully participate in the interview process.