We are seeking a Solutions Designer to lead the design, development, and optimization of data-centric solutions in a hybrid environment (3 days onsite, 2 days remote). This role involves using Oracle, Informatica, and Cognos technologies to drive ETL processes, database migrations, and reporting solutions.
Advantages
...
•Hybrid Work Model: Enjoy a balance of in-office collaboration and remote flexibility.
•Challenging Projects: Work on complex data warehousing initiatives involving Oracle, SQL Server, and ETL transformations.
•Cutting-Edge Technology: Leverage industry-standard tools like Informatica, Cognos, SQL Server, and Azure DevOps.
•Professional Growth: Enhance skills in ETL design, database performance optimization, and BI solutioning.
•Collaborative Environment: Partner with cross-functional teams, share knowledge, and create high-impact solutions.
Responsibilities
•Analyze, design, and develop ETL components (Mappings, Workflows, Data Marts) using Informatica.
•Establish ETL routines and scripts based on project requirements and best practices.
•Design solutions for data migration and integration between Oracle and SQL Server, optimizing database performance.
•Conduct unit testing, system testing (SIT, UAT), and code walkthroughs for quality assurance.
•Manage code packages in version control systems like TFS or VSS.
•Participate in agile or waterfall SDLC, ensuring alignment with project milestones.
•Work with senior management, architects, and business teams to align solutions with objectives.
•Provide technical guidance, create architecture documents, and maintain detailed design artifacts.
•Oversee deployment processes and coordinate knowledge transfer for seamless hand-offs.
•Fine-tune database performance via indexing, query optimization, and partitioning.
•Identify and resolve production issues, propose fixes, and manage unplanned deployments.
•Champion continuous improvement initiatives, including star schema design and performance enhancements.
Qualifications
•Demonstrated expertise with Informatica ETL solutions and Cognos for data warehousing/BI projects.
•Experience with Oracle (11.x and 12.x) and SQL Server databases, including PL/SQL, T-SQL, and database performance tuning.
•Skilled at converting Oracle PL/SQL objects to T-SQL code in SQL Server environments.
•Proficiency in version control systems (Visual Source Safe, Team Foundation Server) for managing code changes.
•Strong knowledge of SDLC (both Agile and Waterfall) and proven track record in system testing.
•Familiarity with star schema multi-dimensional modeling and business intelligence solutions.
•Experience with data transfer technologies (e.g., SSIS, SSRS, SSAS, MQ).
•Excellent analytical, problem-solving, and communication skills for multi-client/partner environments.
Summary
Join us as a Solutions Designer and play a pivotal role in crafting robust ETL and data-driven applications. You’ll work on challenging projects, optimize critical databases, and leverage best-in-class tools to ensure high-quality solutions. Apply now to drive innovation and support data-intensive enterprise needs!
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.
show more
We are seeking a Solutions Designer to lead the design, development, and optimization of data-centric solutions in a hybrid environment (3 days onsite, 2 days remote). This role involves using Oracle, Informatica, and Cognos technologies to drive ETL processes, database migrations, and reporting solutions.
Advantages
•Hybrid Work Model: Enjoy a balance of in-office collaboration and remote flexibility.
•Challenging Projects: Work on complex data warehousing initiatives involving Oracle, SQL Server, and ETL transformations.
•Cutting-Edge Technology: Leverage industry-standard tools like Informatica, Cognos, SQL Server, and Azure DevOps.
•Professional Growth: Enhance skills in ETL design, database performance optimization, and BI solutioning.
•Collaborative Environment: Partner with cross-functional teams, share knowledge, and create high-impact solutions.
Responsibilities
•Analyze, design, and develop ETL components (Mappings, Workflows, Data Marts) using Informatica.
•Establish ETL routines and scripts based on project requirements and best practices.
•Design solutions for data migration and integration between Oracle and SQL Server, optimizing database performance.
...
•Conduct unit testing, system testing (SIT, UAT), and code walkthroughs for quality assurance.
•Manage code packages in version control systems like TFS or VSS.
•Participate in agile or waterfall SDLC, ensuring alignment with project milestones.
•Work with senior management, architects, and business teams to align solutions with objectives.
•Provide technical guidance, create architecture documents, and maintain detailed design artifacts.
•Oversee deployment processes and coordinate knowledge transfer for seamless hand-offs.
•Fine-tune database performance via indexing, query optimization, and partitioning.
•Identify and resolve production issues, propose fixes, and manage unplanned deployments.
•Champion continuous improvement initiatives, including star schema design and performance enhancements.
Qualifications
•Demonstrated expertise with Informatica ETL solutions and Cognos for data warehousing/BI projects.
•Experience with Oracle (11.x and 12.x) and SQL Server databases, including PL/SQL, T-SQL, and database performance tuning.
•Skilled at converting Oracle PL/SQL objects to T-SQL code in SQL Server environments.
•Proficiency in version control systems (Visual Source Safe, Team Foundation Server) for managing code changes.
•Strong knowledge of SDLC (both Agile and Waterfall) and proven track record in system testing.
•Familiarity with star schema multi-dimensional modeling and business intelligence solutions.
•Experience with data transfer technologies (e.g., SSIS, SSRS, SSAS, MQ).
•Excellent analytical, problem-solving, and communication skills for multi-client/partner environments.
Summary
Join us as a Solutions Designer and play a pivotal role in crafting robust ETL and data-driven applications. You’ll work on challenging projects, optimize critical databases, and leverage best-in-class tools to ensure high-quality solutions. Apply now to drive innovation and support data-intensive enterprise needs!
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.
show more
