Talent.com

Ssis Jobs in Toronto, ON

Create a job alert for this search

Ssis • toronto on

Last updated: 7 hours ago
  • Promoted
  • New!
Intermediate Specialized IT Consultant

Intermediate Specialized IT Consultant

CYNET SYSTEMSToronto, ON, Canada
Full-time
Works in partnership with clients, advising them on information technology in order to meet their business objectives or overcome problems, works to improve structure and efficiency of an organizat...Show moreLast updated: 15 hours ago
  • Promoted
  • New!
AWS Data Engineer

AWS Data Engineer

TEEMAToronto, ON, Canada
Full-time
Design and implement cloud-based data pipelines using AWS services (e.S3, Glue, Lambda, Redshift, RDS, EMR).Extract, transform, and load (ETL) data from various sources, including Netezza and other...Show moreLast updated: 7 hours ago
  • Promoted
Solutions Architect

Solutions Architect

Russell TobinToronto, ON, Canada
Temporary
Duration : 10+ months contract with possibilities of extension.Location : Toronto, ON (Hybrid).We are seeking a highly experienced. Dynamics 365 Customer Engagement (CE) Data Migration Specialist.The ...Show moreLast updated: 15 days ago
RQ08053 Solutions Designer

RQ08053 Solutions Designer

Randstad CanadaNorth York, Ontario, CA
Temporary
Quick Apply
Are you a BI Solutions Designer with hands-on expertise in Power BI, SSIS, and Cognos? Our client seeks a Solutions Designer to lead the design, development, and deployment of scalable business int...Show moreLast updated: 30+ days ago
  • Promoted
  • New!
.NET Developer

.NET Developer

BevertecToronto, ON, Canada
Full-time
NET Developer (Backend / Full Stack).We are looking for a Senior C# / .NET Developer with a focus on backend and full-stack development. The ideal candidate will have experience in Azure technologies an...Show moreLast updated: 7 hours ago
  • Promoted
  • New!
Power BI consultant

Power BI consultant

Newport WilliamsToronto, ON, Canada
Full-time
Get AI-powered advice on this job and more exclusive features.This is a Hybrid role at 777 Bay Street, Toronto.An Specialized I&IT Consultant is required to develop BI solutions using both Cognos a...Show moreLast updated: 7 hours ago
Java / Scala Developer

Java / Scala Developer

CB CanadaToronto, Ontario, Canada
Full-time
On behalf of our client in the Banking Sector, PROCOM is looking for a Senior Java Developer.Senior Java Developer – Mandatory Skills. Experience Scala and Akka - 3 years.Linux shell scripting - 3 y...Show moreLast updated: 1 day ago
  • Promoted
  • New!
Solutions Developer

Solutions Developer

Global Technical TalentToronto, ON, Canada
Full-time
Hybrid (In office 2 days a week - Monday is the anchor day).Summary of day-to-day Responsibilities.The Solutions Developer works with Business system analysis to understand requirements and assist ...Show moreLast updated: 7 hours ago
  • Promoted
  • New!
Senior Solutions Designer

Senior Solutions Designer

Cynet Systems IncToronto, ON, Canada
Full-time
Works in partnership with clients, advising them on information technology in order to meet their business objectives or overcome problems, works to improve structure and efficiency of an organizat...Show moreLast updated: 7 hours ago
  • Promoted
RQ09075 - Solutions Designer - Senior

RQ09075 - Solutions Designer - Senior

Rubicon PathToronto, ON, Canada
Full-time
Note : This contract will require the consultant to work from the office location 3 days per week with the remaining 2 days being worked remotely. BI solutions using both Cognos and Microsoft Power B...Show moreLast updated: 28 days ago
ETL Developer

ETL Developer

Astra North Infoteck Inc.ON, ON, ca
Full-time
Quick Apply
Strong hands-on experience with developing ETL solutions with PySpark and Python.Create ELT data pipeline, optimize Spark clusters on containerized environments. Good knowledge of S3 bucket, Kuberne...Show moreLast updated: 29 days ago
  • Promoted
  • New!
Production Support Executive

Production Support Executive

Tata Consultancy ServicesToronto, ON, Canada
Full-time
Be among the first 25 applicants.Get AI-powered advice on this job and more exclusive features.Direct message the job poster from Tata Consultancy Services. HR Talent Acquisition Specialist | MBA in...Show moreLast updated: 7 hours ago
3X Senior Data Engineer to build data solutions and migrate SSIS packages from legacy systems to MuleSoft. - 100% REMOTE (PST Hours)

3X Senior Data Engineer to build data solutions and migrate SSIS packages from legacy systems to MuleSoft. - 100% REMOTE (PST Hours)

S.i. SystemsToronto
Remote
Permanent
X Senior Data Engineer to build data solutions and migrate SSIS packages from legacy systems to MuleSoft.Permanent Opportunity, % Remote - Must be able to work PST hours. Hands-on working experience...Show moreLast updated: 30+ days ago
  • Promoted
Power APP, BI & SSIS and SSRS at $65 to $75 per hour

Power APP, BI & SSIS and SSRS at $65 to $75 per hour

eSMART INNOVATIONSToronto, ON, Canada
Full-time
NET helps to drive critical business decisions by enhancing the USER INPUT FORMS and reporting infrastructure, taking ownership of various data sets and data elements, designing, managing, and depl...Show moreLast updated: 28 days ago
  • Promoted
  • New!
Senior Microsoft Data Developer

Senior Microsoft Data Developer

CG Consulting GroupToronto, ON, Canada
Full-time
Client is a Toronto-based IT consulting boutique that strives for excellence in customer service and delivery in financial services and fintech industry. They focus on technology advisory services, ...Show moreLast updated: 7 hours ago
  • Promoted
Solutions Developer

Solutions Developer

freelance.caToronto, Canada
Full-time
The company is a global leader in technology consulting.With 9,600 experts worldwide, we guide our clients through digital transformation by developing innovative solutions.In Canada, we excel in I...Show moreLast updated: 30+ days ago
  • Promoted
Data Engineer (Snowflake)

Data Engineer (Snowflake)

Insight GlobalToronto, ON, Canada
Temporary
Month Contract + Possible Extensions4x Onsite Monday-Thursday in Downtown, TorontoMinimum of 7 years of experience working in developing and following structured work processes in data engineeringM...Show moreLast updated: 11 days ago
  • Promoted
Sr. Dynamics 365 CE Developers

Sr. Dynamics 365 CE Developers

J&M Group, IncToronto, ON, Canada
Full-time
Must have strong technical skills on MS Dynamics 365 and earlier with online & on-premises environment.Strong Experience in designing Security model and Out of the Box Configurations.Experience...Show moreLast updated: 28 days ago
Intermediate Specialized IT Consultant

Intermediate Specialized IT Consultant

CYNET SYSTEMSToronto, ON, Canada
15 hours ago
Job type
  • Full-time
Job description

Job Description

Job Description

Job Description : Responsibilities :

  • Works in partnership with clients, advising them on information technology in order to meet their business objectives or overcome problems, works to improve structure and efficiency of an organization s I&IT systems.
  • The I&IT Consultant may be used to provide strategic guidance to organizations with regard to Information Management & IT technology, IT infrastructures and the enablement of major business processes through enhancements to IT.
  • Provides subject matter expertise in their field and highly expert technical assistance.
  • Acts as the technical advisor / expert on all aspects of a specific deliverable
  • Provides the quality assurance / quality control of specific deliverables.
  • Anticipates and resolves problems to ensure that the deliverables are completed within budget, to the highest quality, meeting or exceeding expectations
  • Develops processes and procedures for implementing deliverables.
  • Prepares reports and presentations including options, recommendations, implementation plans, etc.
  • Works with clients to define the scope of a project and to determine requirements
  • Defines software, hardware and network requirements.
  • Analyzes I&IT requirements giving independent and objective advice on the use of I&IT.
  • Designs, tests, installs and monitors new systems and develops solutions and implementation of new systems.
  • Familiar with change-management principles and methodology.
  • Knowledge and understanding of Information Management principles, concepts, policies and practices.

Must Haves :

  • Strong experience in developing reports and dashboards in Power BI.
  • Solid experience in designing, developing, and deploying SSIS packages for ETL processes.
  • Solid knowledge of MS SQL Server, including T-SQL, stored procedures, and query optimization.
  • Familiar with data extraction, transformation, and loading (ETL) from various sources to target systems.
  • Strong product experience such as Power BI, Cognos, Oracle, MS-SQL, Visual Studio, SSIS, Attunity, ODAC, .NET framework, GIT and SQL-based reporting tools.
  • General Skills :

  • Ensure seamless integration of new and existing systems, applications, and platforms.
  • Evaluate and recommend technology stacks, platforms, and tools to support business goals.
  • Design systems with a focus on security, compliance, and data privacy standards.
  • Work closely with stakeholders such as business units, development teams, IT infrastructure teams to ensure alignment with project goals.
  • Ensure solutions are scalable, reliable, and can be optimized for future growth.
  • Provide technical support and participate in the development, package creation, code merge, testing and release activities.
  • Primary interface between technical teams (Dev, QA) and business stakeholders, focusing on requirements clarification and UAT.
  • Develop and manage solutions using Power BI, Cognos, Oracle, MS-SQL, Visual Studio, SSIS, Attunity, ODAC, .NET framework, GIT and SQL-based reporting tools.
  • Desirable Skills :

  • Demonstrated experience in guiding the architecture leveraging Azure cloud services, including effective standard use of Microsoft Stack tools and services critical for the integrity, quality and pace of delivery.
  • Demonstrated deep Microsoft stack experience (5+ Years) with at least past 4 years of Microsoft Azure Data Factory experience.
  • Proficiency in Microsoft Azure services, including Azure Data Factory, SSIS, SSAS, SSRS, Power BI, and other relevant tools.
  • Strong knowledge of data integration techniques, data warehousing, and ETL processes.
  • Familiarity with database management and SQL Server environments.
  • Strong problem-solving skills and ability to work collaboratively in a team.
  • Data modelling experience with both star and snowflake schemas in MS SQL as well as Oracle databases.
  • Experience with Cognos / Informatica reporting solutions.
  • Experience with migration from Cognos / Informatica to Power BI solutions.
  • Strong development experience with ETL using SQL Server SSIS.
  • Experience with designing and implementing interactive and visually appealing reports and dashboards using SQL Server Reporting Services (SSRS) and Power BI
  • Experience with Microsoft DevOps, pipelines, datasets, triggers, and other Azure Data Factory components.
  • Experience and Skill Set Requirements :

  • Technical Experience - 30%
  • The ideal candidate should possess 5+ years of experience as a I&IT Consultant, with a focus on the following project environments :
  • Required Skills (3-4 years) : Power BI, MS SQL Server, SSIS, Informatica ETL, Cognos Development, Data Migration & Transformation
  • Preferred Skills (2-3 years) : Oracle, Visual Studio, .NET Framework, Java, Cloud Services, Data Warehousing, Advanced Data Analytics, Version Control.
  • Technical Skills :

  • Demonstrated experience in guiding the architecture leveraging Azure cloud services, including effective standard use of Microsoft Stack tools and services critical for the integrity, quality and pace of delivery.
  • Demonstrated deep Microsoft stack experience (10 Years) with at least past 4 years of Microsoft Azure Data Factory experience.
  • Proficiency in Microsoft Azure services, including Azure Data Factory, SSIS, SSAS, SSRS, Power BI, and other relevant tools.
  • Strong knowledge of data integration techniques, data warehousing, and ETL processes.
  • Familiarity with database management and SQL Server environments.
  • Strong problem-solving skills and ability to work collaboratively in a team.
  • Microsoft Azure Data Factory Services, SSIS, SSAS, SSRS, Power BI, Datastage, Quality Stage, Visual Studio, Team Foundation Services, SQL Server Management Studio, Erwin Data Modeler, Power Designer.
  • Development - 25% :

  • Design, develop, and maintain data pipelines using Azure Data Factory Services for data ingestion, transformation, and integration.
  • Develop ETL processes using SQL Server Integration Services (SSIS) to move and transform data from various sources into Azure data repositories.
  • Azure Data Factory, knowing how to create and manage pipelines, datasets, triggers, and other ADF components effectively.
  • Design and implement interactive and visually appealing reports and dashboards using SQL Server Reporting Services (SSRS) and Power BI.
  • Well-versed in ETL tools and technologies, especially those within Azure Data Factory, such as Data Flow, Mapping Data Flows, and other data transformation components.
  • Design / Architecture - 20% :

  • Ensure data quality and data governance practices are implemented throughout the data integration process.
  • Demonstrated experience with data ingestion from multiple sources, staging and data cleansing.
  • Guide the architecture leveraging Azure cloud services, ensuring effective and standard use of the Microsoft Stack tools and services critical for the integrity, quality, and pace of delivery.
  • Understanding of Azure's security and compliance features is crucial to ensure data privacy and meet regulatory requirements.
  • Design, plan, and implement data integration and analytics solutions on the Microsoft Azure platform, leveraging Azure Data Factory, SSIS, SSAS, SSRS, Power BI, and other relevant services.
  • Create architecture diagrams and technical documentation for Azure-based solutions.
  • Collaborate with cross-functional teams to understand business requirements and translate them into technical solutions.
  • Design and implement data models and cubes using SQL Server Analysis Services (SSAS) for efficient data analysis and reporting.
  • Design and develop interactive and informative dashboards and reports using Power BI to facilitate data-driven decision-making.
  • Data Modelling - 20% :

  • Design experience with star and snowflake schemas, dimensional modeling and data model architecture and design aligned with data standards and analytics needs of various stakeholders, includes creation DW, Views, Cubes, and other data services products, using SQL Server Analysis Services (SSAS)
  • Utilize tools like Erwin Data Modeler and Power Designer to create and maintain data models for efficient data storage and retrieval.
  • Microsoft Azure Data Factory Services, SSIS, SSAS, SSRS, Power BI, DataStage, Quality Stage, Visual Studio, Team Foundation Services, SQL Server Management Studio, Erwin Data Modeler, Power Designer.
  • Public Sector Experience - 5% :

  • Previous public sector experience in an organization of equivalent size or complexity to Government.
  • Demonstrates experience designing and developing applications that comply with GOITS standards and general processes would be an asset.