Orchestration (SSIS) Developer

Full-time

Acestack

Role: Orchestration (SSIS) Developer

Employment: Full Time

Location: Toronto, ON

Work Arrangement: Onsite Job Description

We are seeking a Full Time Orchestration (SSIS) Developer with strong experience in MS SQL Server, SSIS, data development, data pipelines, and banking document processing. The ideal candidate will design, develop, test, integrate, and support complex data solutions while collaborating with onshore and offshore teams

Key Responsibilities

Develop and maintain data solutions using MS SQL Server, SSIS, and related tools
Design stored procedures, functions, data pipelines, and data processing workflows
Develop VB.NET scripts and advanced data processing solutions
Work with XML, CSV, fixed-length, and delimited data formats
Build templates for data file preprocessing, parsing, and transformation
Support GitLab, CI/CD, and artifact management processes
Analyze complex business requirements and create technical specifications
Estimate timelines, resources, and dependencies for SQL projects
Perform code reviews, unit testing, integration testing, and debugging
Support QA and troubleshoot end-to-end application flows
Conduct root cause analysis and resolve production issues
Collaborate with offshore teams and other technology teams
Mentor junior developers and support technical standards and architecture
Support banking document processing, statements, Canadian tax, and cheque processing solutions

Required Skills

5+ years of data development experience
Advanced MS SQL Server, RDBMS, and SQL skills
Strong Stored Procedures and Functions experience
Hands-on DTS/SSIS experience
Strong VB.NET scripting knowledge
Experience with XML, CSV, fixed-length, and delimited data formats
Knowledge of GitLab, CI/CD, and artifact management
Strong data sorting, bundling, aggregation, and transformation skills
Banking and financial domain experience preferred
Strong analytical, problem-solving, and communication skills

Apply

Vacancy posted 2 days ago

Similar jobs that could be interesting for youBased on the Orchestration (SSIS) Developer in Ontario, CA vacancy

SQL Developer
...Job: SQL Developer Location: Rancho cucamonga, CA Employment Type: Full-Time Experience At least five (5) years of experience designing... ...complex SQL Server databases and ETL solutions using SSIS (SQL Server Integration Services). Candidates must possess solid...
SSIS
Full time
Work experience placement
Work from home
Flexible hours
TECHOAUTH SOLUTIONS LLC
Rancho Cucamonga, CA
4 days ago
SQL SERVER DATABASE DEVELOPER/ DATA ENGINEER II
...ONSITE IN NORCO, CA Job Summary The SQL Server Database Developer / Data Engineer II independently designs, develops, and maintains... .... ~ Experience with SQL Server Integration Services (SSIS). ~ Experience with ETL/ELT development. ~ Experience designing...
SSIS
Temporary work
Flexible hours
VSolvit
Norco, CA
10 days ago
SENIOR SQL SERVER DATABASE DEVELOPER / DATA ENGINEER
...IN NORCO, CA Job Summary The Senior SQL Server Database Developer / Data Engineer serves as the technical lead for enterprise... ...Extensive experience with Data Warehousing, Data Marts, ETL/ELT, and SSIS. ~ Experience designing enterprise-scale OLTP and analytical...
SSIS
Contract work
Temporary work
Flexible hours
VSolvit
Norco, CA
10 days ago
SQL SERVER DATABASE DEVELOPER / DATA ENGINEER
...ONSITE DAILY IN NORCO, CA Job Summary The SQL Server Database Developer / Data Engineer I supports the design, development,... ...normalization efforts Assist in developing ETL/ELT processes using SSIS or comparable technologies Perform data validation, reconciliation...
SSIS
Temporary work
Flexible hours
VSolvit
Norco, CA
10 days ago
Senior Data Developer - ETL
...Job Title: Senior Data Developer - ETL Location: Mississauga, ON Work Model: Onsite Job Type: Full Time (FTE)... ...Senior Data Developer - ETL with strong expertise in SQL Server, SSIS, database development, and enterprise file processing . The ideal...
SSIS
Full time
Acestack
Ontario, CA
2 days ago
Senior Data Engineer
$114.28k - $140k
...Storage (ADLS Gen2), Azure SQL, Snowflake, Snowflake OpenFlow, SSIS, SSRS, Power BI, Power Automate, and Power Query. Leads conversion... ...Snowflake warehouses for performance and cost efficiency Develops and supports Power BI datasets, data models, and enterprise reporting...
SSIS
LERETA
Pomona, CA
4 days ago
Developer III
$118.6k - $157.14k
...authentic experience!Reporting to IT Department Leadership, the Developer III is responsible for the design, planning, development and... ...C# & JavaWeb UI development (JavaScript, JQuery, CSS, and HTML)SSIS and SSRS developmentApplicable data privacy practices and lawsHealthcare...
SSIS
Temporary work
Remote work
Inland Empire Health Plan
Rancho Cucamonga, CA
5 days ago
Procurement Functional Developer
...We are seeking a Procurement Functional Developer with strong expertise in Procurement, Source-to-Pay (S2P), and Procure-to-Pay (P2P) processes to design, develop, integrate, and support scalable procurement solutions. Required Skills: Procurement, S2...
Contract work
J M Group Inc
Ontario, CA
2 days ago
Hiring:: IIB WMB Developer || Markham, ON (Hybrid)
...Job Title: IIB WMB Developer Location: Markham, ON (Hybrid) Contract: 12 months Required Skills & Qualifications ~ Bachelor's degree in Computer Science, IT, or related field ~3 8+ years of hands-on experience with IIB/WMB development ~...
Full time
Contract work
Key2Source
Ontario, CA
2 days ago
Senior RPA Developer Blue Prism & Power Automate
...Job Title: Senior RPA Developer Blue Prism & Power Automate Location: Toronto, ON Work Model: Hybrid Job Type: Full Time (FTE) Experience: 5 8+ years Job Description We are seeking a highly experienced Senior RPA Developer with strong...
Full time
Acestack
Ontario, CA
2 days ago
Java Backend Lead
...Java, J2EE, Spring, Hibernate, and related web technologies. What you bring ~5+ years of experience as an Angular/UI Developer. ~ Hands-on expertise with Angular, Java, J2EE, JSP/Servlet, JavaScript, Java RMI, HTML, and XML. ~ Strong experience with...
J M Group Inc
Ontario, CA
2 days ago
AI and Business Process Strategic Portfolio Integrator
$136k - $204k
...AI Transformation and the Director of Business Process Excellence on where the team should focus next. This is a business orchestration role, not a technical execution role. The Integrator ensures the portfolio reflects GTM strategy and delivers measurable revenue...
Full time
Work at office
Equinix
Ontario, CA
a month ago
Data Platform Engineer
...clear service boundaries for domain-specific services and ensuring loose coupling through well-defined API contracts. Design and develop Snowflake-native applications including Snowpark (Python), stored procedures, tasks, streams, and dynamic tables to support day-end...
Contract work
Temporary work
Local area
Staffingine LLC
Ontario, CA
2 days ago
Back-end Engineer - Python
...Canada Job Type: Full-Time Job Description: Design, develop, and maintain backend services using Python. Build and... .... Hands-on experience with Docker and container orchestration. Solid understanding of MySQL and relational database design...
Full time
Flexible hours
Staffingine LLC
Ontario, CA
2 days ago
Front End Developer Tableau/Python
$69.6k - $142.7k
Job Title: Front End Developer Tableau/Python Job Category: Information Technology Time Type: Full time Minimum Clearance Required to Start: Secret Employee Type: Regular Percentage of Travel Required: Up to 10% Type of Travel: Continental US * * *...
Full time
Contract work
Work experience placement
Flexible hours
Caci
Norco, CA
15 hours ago
Findur developer, Java and Eclipse IDE, and SQL
...Job Title: Findur developer, Java and Eclipse IDE, and SQL Job Type: Full Time Location: Mississauga, ON (Remote) Job Description We are seeking an experienced Findur Developer with 8+ years of overall IT experience and 1 2 years of hands-on experience...
Full time
Remote work
Acestack
Ontario, CA
2 days ago
Senior Python Developer
...Job Role: Senior Python Developer Location: Mississauga, ON Onsite Experience: 8+ Years Job Type: Full-Time Job Summary: We are seeking an experienced Senior Python Developer to design, develop, and maintain scalable applications and backend...
Full time
Apptad Inc
Ontario, CA
2 days ago
Hiring: Java full stack developer for Markham, ON (Onsite) - Locals only
...Role: Java full stack developer Location: Markham, ON (Onsite) Interview Mode: In-person interview Must have skills: Angular, AWS, Springboot, Java Required Skills ~ Overall of 10+ years' experience Strong hands-on experience with...
Local area
Key2Source
Ontario, CA
2 days ago
Senior Software Developer
Job Summary: The Senior Software Developer will be responsible for designing, coding, unit testing, and supporting enhancements and troubleshooting for a portfolio of correctional system applications. This role involves integrating multiple risk assessment tools into a...
Full time
Contract work
Monday to Friday
vTech Solution
Ontario, CA
2 days ago
Senior Software Developer
Job Summary: The Senior Software Developer role focuses on designing, developing, and maintaining cloud-based modular systems with... ...CSS, XML, and XPath. ~ Proficiency in containerization and orchestration using Docker and Azure Kubernetes Service (AKS). ~ Strong...
vTech Solution
Ontario, CA
2 days ago
Software Developer
...Job Title: Software Developer - Senior Location: Toronto, Ontario Work Model: Onsite Duration: 12 months Extension... ...5+ years' experience in container management and orchestration to automate application deployment, application scaling/clustering...
Innosystech Inc
Ontario, CA
2 days ago
Software Developer - Senior
...Job Title: Software Developer - Senior Location: Toronto ON Work Model: Onsite Duration: 5 months Extension... ...integrating with IBM Business Automation Workflow (BAW) for process orchestration and automation. ~ Experience with JEE application servers...
Innosystech Inc
Ontario, CA
2 days ago
Senior Software Developer
Job Summary: The Senior Software Developer will design, develop, test, and maintain complex software applications primarily using Java... ...with cloud infrastructure automation and container orchestration beyond Docker. Special Considerations: Must work onsite...
Full time
Work at office
Monday to Friday
vTech Solution
Ontario, CA
2 days ago
Sr. Java Developer - TDM
Job Title: Sr. Java Developer TDM Location: Toronto, ON Work Arrangement: Onsite Employment Type: Full-Time Job Description We are seeking a Senior Java Developer with Test Data Management (TDM) experience to design, develop, and automate scalable...
Full time
Acestack
Ontario, CA
2 days ago
Senior Software Engineer / Architect - Search Engine Internals (Full-Text & Hybrid Retrieval)
$135.2k - $306.4k
...ranking, search infrastructure, vector search, or related systems. Document APIs, Compatibility, and Migration Help evolve developer-facing document APIs, including Oracle's MongoDB-compatible API, and improve the experience of moving production document workloads...
Full time
Temporary work
Flexible hours
Oracle
Pomona, CA
15 hours ago
Oracle Analytics Cloud Consultant
1. Develop, configure, and maintain Oracle Analytics Cloud (OAC) dashboards, reports, and data models to support business reporting needs. 2. Perform OAC administration tasks, including environment setup, deployment, and ongoing maintenance. 3. Write and troubleshoot...
J M Group Inc
Ontario, CA
2 days ago
Quadient Developer
...Job Title: Quadient Developer Location: Toronto, ON Work Arrangement: Hybrid 4 Days Onsite Job Type: Full Time Job Summary We are seeking an experienced Quadient Developer with 8 10 years of experience working with the Quadient Inspire platform...
Full time
Acestack
Ontario, CA
2 days ago
AJO Senior Developer
...Job Title: AJO Senior Developer Location: Toronto, ON Work Model: Hybrid Job Type: Full Time (FTE) Experience... ...mobile and web journeys, events, actions, conditions, and journey orchestration. Implement Profile and Audience Management...
Full time
Acestack
Ontario, CA
2 days ago
Java API Developer
Job Summary: The Specialized IT Consultant will design, develop, and deploy secure, scalable RESTful APIs and microservices to support... ...unit and API tests. Familiarity with Kubernetes orchestration tools such as Helm. Experience with Agile methodologies including...
Contract work
Monday to Friday
Weekend work
vTech Solution
Ontario, CA
2 days ago
Sr Mainframe Developer
...IMS DB/DC, XML, Host/Mainframe, Mainframe, Mainframe application design, SAS, SAS apps, VSAM, Automation Testing on Mainframe, TSO, Tibco Designing and developing mainframe systems Programming and coding Testing and debugging Maintaining systems...
J M Group Inc
Ontario, CA
2 days ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Orchestration (SSIS) Developer. Be the first to apply!