(Senior) IT Solution Architect H/F
Randstad
We are seeking a Senior Solutions Designer with deep expertise in Informatica ETL and the Oracle/Cognos ecosystem. In this role, you will be responsible for the architectural design and technical delivery of hosting technology solutions. You will lead the migration, transformation, and optimization of data across complex environments, specifically focusing on the conversion of Oracle-based systems to SQL Server architectures while ensuring high-performance Business Intelligence (BI) delivery.
Technical Leadership: Lead complex modernization efforts for multi-platform, multi-tier information technology systems.
- Directly influence the data architecture used for critical provincial business intelligence and reporting.
- Comprehensive Stack: Work across a wide array of top-tier tools including Informatica, Cognos, Power BI, Databricks, and Azure.
- Design technology solutions based on client specifications, best practices, and cost models to meet high-volume data requirements.
- Design, develop, and unit test project ETL components, including mappings, workflows, mapplets, and data marts using Informatica.
- Database Migration: Lead schema conversion between Oracle and SQL Server, converting PL/SQL stored procedures, triggers, and functions into T-SQL code.
- Data Modeling: Utilize PowerDesigner to review data models, execute changes, and generate DDL scripts for hierarchical and star-schema multidimensional models.
- Performance Optimization: Fine-tune database performance through indexing, query optimization, and partitioning within SQL Server and Oracle environments.
- Business Intelligence: Design and implement reports and dashboards using Cognos 10+ and Microsoft Power BI, focusing on KPI development and data visualization.
- Collaboration: Work closely with project managers and business stakeholders to ensure technical specifications accurately reflect business needs.
- Code Management: Maintain the full application code package using TFS, VSS, and Azure DevOps, documenting all changes and facilitating deployment.
Extensive experience designing and implementing Informatica ETL solutions.
- Proven design experience in environments where Oracle, Informatica, and Cognos are used together for data warehousing.
- Data Modeling Tools: Proficiency in PowerDesigner for data model reviews and DDL script generation.
- Database Depth: Advanced development experience with Oracle (11.x) and SQL Server, including T-SQL and PL/SQL expertise.
- Hands-on experience with Microsoft MQ, SSIS, SSRS, and SSAS.
- Demonstrated success in Agile and Waterfall SDLC environments, including system testing (SIT, SAT, UAT).
- Technical Communication: Ability to translate complex high-volume data themes into clear technical requirements and executive-level presentations.
If you're interested in the Solutions Designer role based in Toronto, we encourage you to apply online at
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 Voir email sur randstad.com.
- ...Position: Senior Solutions Designer Duration: 1 Year assignment (contract) Client Location: Toronto ( Onsite/Hybrid : 7.25 hours/day between 8:00 AM and 5:00 PM, Monday to Friday) Engagement Model: Professional Services Engagement – B2B (Incorporated Entities Only...SeniorСontratTravail temporaireLundi au vendredi
- ...Position: Senior Solutions Designer Duration: 1.5 Years assignment (contract) Client Location: Toronto ( Onsite : 7.25 hours/day between 8:00 AM and 5:00 PM, Monday to Friday) Engagement Model: Professional Services Engagement – B2B (Incorporated Entities Only)...SeniorСontratTravail temporaireStageLundi au vendredi
- ...you have at least 7+ years of experience designing solutions with Oracle Siebel CRM or Adobe AEM... ...have experience with developing business design document, functional & non- functional requirements... ...for you! Our client is looking for a Senior Solutions Designer for a 9 month...SeniorContrat Longue DuréeRemplacementСontratTravail temporaire
- ...Description: Ensure Accessibility standards are met (AODA) Design of hosting technology solutions based on the client’s service specifications, standards, policies, best practices Planning, implementing and supporting complex CRM systems Documenting processes...SeniorContrat Longue DuréeСontratHoraires flexibles
- ...Position: Senior Solutions Designer Duration: 1 Year assignment (contract) Client Location: Toronto ( Onsite : 7.25 hours/day between 8:00 AM and 5:00 PM, Monday to Friday) Engagement Model: Professional Services Engagement – B2B (Incorporated Entities Only) Note...SeniorContrat Longue DuréeСontratTravail temporaireLundi au vendredi
- ...have experience in structured methodologies for the development, design, implementation and maintenance of applications and web sites?... ...be a great opportunity for you! Our client is looking for a Senior Solutions Designer for a 6 month contract in Toronto. This is an...SeniorСontratLundi au vendredi
- We are seeking a highly experienced Senior Solutions Designer - CRM to lead the design and implementation of technology solutions for complex CRM applications. This pivotal role requires at least 7+ years of experience designing and implementing solutions across Oracle Siebel...SeniorContrat Longue DuréeTravail temporaire
- We are looking for a skilled Intermediate Solutions Designer to join our team in Toronto. This role is perfect for a technical professional with a deep specialization in HL7 FHIR standards and modern cloud integration. You will be responsible for designing hosting technology...Contrat Longue DuréeСontrat
- Do you have expertise in defining and maintaining solution architecture, integration patterns, and deployment strategies? Do you have hands... ...for you! Our client is looking for an Intermediate Solutions Designer for a 9 month contract in Toronto. This is an onsite role....Contrat Longue DuréeRemplacementСontratTravail temporaireStage
$95k - $145k par année
Solution Architect/Designer Position Description This role is hybrid and requires you to be at our Client office at a minimum 2 days per week... ...responsibilities Design & Develop : Provide comprehensive senior level technical consulting to senior IT management and technical...SeniorTravail au bureau2 jours par semaine- ...Position: Intermediate Solutions Designer Duration: 1 Year assignment (contract) Client Location: Toronto ( Onsite : 7.25 hours/day between 8:00 AM and 5:00 PM, Monday to Friday) Engagement Model: Professional Services Engagement – B2B (Incorporated Entities Only)...СontratTravail temporaireLundi au vendredi
- ...Position: Intermediate CRM - Solutions Designer Duration: 4 Months assignment (contract) Client Location: Toronto ( Onsite/Hybrid : 7.25 hours/day between 8:00 AM and 5:00 PM, Monday to Friday) Engagement Model: Professional Services Engagement – B2B (Incorporated...СontratTravail temporaireLundi au vendredi
- ...SOAP and REST API, web-integration? If so, this would be a great opportunity for you! Our client is looking for an Intermediate Solutions Designer for a 12 month contract in Toronto. This is an onsite role. Rate: 591.52-626.46 Advantages • Earn a competitive rate...Сontrat
- ...Position: Intermediate CRM - Solutions Designer Duration: 4 Months assignment (contract) Client Location: Toronto ( Onsite/Hybrid : 7.25 hours/day between 8:00 AM and 5:00 PM, Monday to Friday) Engagement Model: Professional Services Engagement – B2B (Incorporated...СontratTravail temporaireLundi au vendredi
$70k - $80k par année
...official website (monks.com/careers). About The Role As a Senior Designer for one of the largest automotive companies in the world, you'... ...culturally relevant, high-impact creative and digital solutions, Monks solves key critical business challenges across the entire...SeniorContrat Longue DuréeStageTravail au bureauZone localeTravail à distance- ...Job Title: Guidewire ClaimCenter Solution Designer Location: Toronto Work Type: Hybrid (2 Days Onsite) Experience: 13+ Years Education: Engineering Degree Required Role Overview We are seeking an experienced Guidewire ClaimCenter Solution...Contrat Longue DuréeСontratTravail temporaire
$125k - $145k par année
...Job Description Responsibilities: Scalable Architecture : Design and implement scalable, secure, and high-performance solutions tailored to wealth and asset management platforms. Business Alignment : Collaborate closely with business stakeholders to gather requirements...SeniorEmploi permanentStage$133.2k - $177.8k par année
..., join eBay – a company you can be proud to be with! As a Senior Product Designer for eBay, you will work side-by-side with designers and cross... ...and engineering partners that pave the way for intuitive solutions. With a dedication to craft, you will contribute to key features...SeniorRecrutement immédiat- ...Synopsis of the role We're looking for a Senior Solutions Architect to lead the design and implementation of cutting-edge solutions on GCP. This senior role requires a visionary with deep expertise in cloud-native development, microservices, and CI/CD practices. You'll...Senior
$105k - $234k par année
...Transformation Practice, you will collaborate with senior leaders, manage junior practitioners, and... ...team, focusing on Insurance Solutions, you will: Lead and deliver large-scale... ...Collaborate with cross-functional teams to design and implement innovative technology solutions...SeniorEmploi permanentTemps pleinHoraires flexibles- ...already established in the region. We are looking for a Founding Solutions Consultant to partner with our Founding Account Executives to... ...Presence: Exceptional communication skills with the ability to command a room of senior stakeholders (CMOs, VPs of Analytics, CTOs)....SeniorRecrutement immédiat
- ...sustainability! Job Description About The Role The Senior Electrical Designer is responsible for leading the design and development of... ...with multidisciplinary teams to integrate electrical solutions seamlessly into overall project designs. The Senior Electrical...SeniorTravail au bureau
$80k - $138k par année
...coaching -- What will your typical day look like? As a Senior Consultant in the Insurance Solutions group within our Technology & Transformation Practice,... ...from scoping and planning, requirements gathering, design, development, testing ~ Experience in custom software...SeniorEmploi permanentHoraires flexibles- We are seeking a Senior UX Designer to lead user-centered design initiatives through the full product lifecycle: Discovery, Alpha, Beta, and... ...problems into intuitive, mobile-first, and responsive digital solutions. You will be a key member of a balanced Agile (Scrum) team, acting...SeniorСontratTravail à distance
- ...Position: Senior UX Designer Duration: 1 Years assignment (contract) Client Location: Toronto ( Onsite/Hybrid : 7.25 hours/day between... ...product vision, conduct user research, prototype and validate solutions, drive accessibility compliance, and collaborate closely with...SeniorСontratTravail temporaireLogé Sur PlaceLundi au vendredi
- ...experience in building Azure and AWS cloud solutions and interface with vendors and the... ...enterprise architecture community to support the design of compliant solutions which meet... ...Zurich Canada is currently looking for a Senior Cloud Solution Architect to work with other...SeniorTravail au bureauZone localeLe monde entier3 jours par semaine
$90k - $110k par année
...Senior Solutions Advisor, Hybrid Security Reports to: Director , Integrated Security Solutions... ...advisor responsible for identifying, designing, and advancing integrated guarding and... ...intersection of sales strategy, solution design, and client success — applying ECAM’s...SeniorContrat Longue DuréeСontratTravail au bureauTravail à distance- ...Position: Senior UX Designer Duration: 1 Year assignment (contract) Client Location: Toronto ( Onsite/Hybrid : 7.25 hours/day between 8:00 AM and 5:00 PM, Monday to Friday) Engagement Model: Professional Services Engagement – B2B (Incorporated Entities Only) Note...SeniorСontratTravail temporaireLundi au vendredi
$133.2k - $177.8k par année
...And The Role The OneExperience team within eBay’s Core Product Design organization is a comprehensive, cross-functional design team... ...motion design. Dedicated to creating cohesive and innovative design solutions, we focus on evolving our product and brand experience to...SeniorRecrutement immédiat- ...team that wants you to grow and succeed. The Business Suite Solution Advisor is a strategic role focused on driving demand, maturing... ...expectations, and offering support necessary for team success. Design opportunity execution plans, align resources to specific activities...SeniorTaux horaireEmploi permanentTemps pleinZone localeLe monde entierHoraires flexibles
Voulez-vous recevoir plus d'offres d'emploi ?
S'abonner et recevoir des offres d'emploi similaires à (Senior) IT Solution Architect H/F. Soyez parmi les premiers à postuler !
- solution sales manager Toronto, ON
- solution architect contract Toronto, ON
- aws solutions architect Toronto, ON
- cloud solution architect Toronto, ON
- power platform solution architect Toronto, ON
- senior solution architect Toronto, ON
- senior react developer Toronto, ON
- senior qa analyst Toronto, ON
- senior technical writer Toronto, ON
- senior sales Toronto, ON
