Senior Software Developer - ETL

We are seeking an experienced Senior Software Developer - ETL to support the analysis, design, development, and implementation of enterprise data warehousing, Business Intelligence (BI), and reporting solutions. In this role, you will be responsible for building and optimizing complex ETL mappings using Informatica to extract, transform, and load data from OLTP databases into enterprise data warehouses and data marts. Working within an Agile SDLC framework, you will write advanced Oracle SQL/PL/SQL procedures, design interactive dashboards, maintain BusinessObjects (BOE) and Crystal Reports, and build Power BI analytics solutions.

Location: Toronto, ON (Fully Onsite – 5 days/week required)

Duration: 6-month contract.

Advantages
End-to-End BI Stack: Full ownership across Informatica ETL pipelines, Oracle PL/SQL databases, and multi-tool reporting platforms (Power BI, BOE, Crystal Reports).

Enterprise Scale: Hands-on experience working with large-scale relational databases, dimensional data models, and complex data warehousing ecosystems.

Technical Leadership: Opportunities to mentor junior developers, facilitate design walkthroughs, and lead technical discussions within an Agile framework.

Dedicated Onsite Collaboration: Collaborate directly alongside senior technical leads and database architects in a focused 5-day per week workspace.

Responsibilities
ETL & Data Pipeline Engineering: Design, build, test, and maintain robust Informatica mappings, transformations, workflows, and ETL scripts to transfer data efficiently between transactional systems, data warehouses, and specialized data marts.

Database & PL/SQL Development: Write, optimize, and debug complex Oracle SQL queries, stored procedures, packages, triggers, and PL/SQL scripts to support backend data integration and data warehouse operations.

BI & Report Development: Design, develop, and maintain enterprise reports and interactive analytics dashboards using Power BI, SAP BusinessObjects Enterprise (BOE), Web Intelligence (WebI), and Crystal Reports.

Data Warehouse Architecture & Modeling: Perform dimensional data modeling, database schema design, and system architecture planning for business intelligence platforms.

Testing & Defect Resolution: Perform unit testing, integration testing, data validation, performance tuning, and defect fixing to ensure data accuracy and system efficiency.

Agile Collaboration & Mentorship: Participate in Agile ceremonies, collaborate with cross-functional technical teams, lead technical discussions, and mentor junior developers.

Documentation & Technical Support: Prepare comprehensive technical specs, data flow diagrams, and system documentation while providing post-implementation operational support.

Qualifications
ETL & Informatica Development: 5+ years of hands-on experience designing, developing, testing, and debugging ETL pipelines using Informatica (Strictly Required).

Oracle SQL & PL/SQL: 5+ years of experience designing, developing, and optimizing complex Oracle SQL queries and PL/SQL stored procedures (Strictly Required).

BI & Enterprise Reporting: 5+ years of experience designing and developing enterprise reports and dashboards using Power BI, Crystal Reports, and BusinessObjects Enterprise (BOE) (Strictly Required).

Data Warehousing & Dimensional Modeling: 5+ years of experience in data warehousing analysis, RDBMS design concepts, dimensional data modeling, and business intelligence systems deployment (Strictly Required).

Agile Delivery & SDLC: Full working knowledge of Software Development Life Cycle (SDLC) methodologies, particularly Agile development frameworks (Strictly Required).

Nice-to-Have Assets:
Prior software development or data warehousing experience within a public sector or broader public sector environment.

Familiarity with web application architectures, middleware gateways, or web accessibility standards (AODA/WCAG).

Summary
If you're interested in the "Senior Software Developer - ETL" role based in Toronto, we encourage you to apply online at www.randstad.ca.
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 [email protected] to ensure their ability to fully participate in the interview process.

This posting is for existing and upcoming vacancies.