Overview
Remote
On Site
Contract - W2
Skills
Data Migration
Financial Services
Project Scoping
Collaboration
Extract
Transform
Load
Regulatory Compliance
Documentation
Auditing
Migration
SQL
Stored Procedures
Performance Tuning
Mainframe
Data Integration
Robotic Process Automation
Workflow
Orchestration
Agile
Communication
Cloud Computing
Microsoft SSIS
ADF
Informatica
Middleware
COBOL
Batch Processing
Data Mapping
Job Details
Myticas Consulting is currently seeking 2-3 Robotic Power Automate Developers to support a large-scale data migration project for a confidential financial services client. This is a hybrid role based in Montreal or Toronto, with a preference for Montreal-based candidates. Candidates must be open to periodic travel to Montreal (1-2 times/month, 3-4 days at a time) and working shifts during production events, including some evenings/weekends.
Project Scope:
The successful candidates will develop, optimize, and deploy automation workflows using Power Automate Desktop (RPA) and SQL. The role focuses on data transformation and integration into legacy mainframe systems, supporting business-critical migration activities with high compliance and quality standards.
Key Responsibilities:
Project Scope:
The successful candidates will develop, optimize, and deploy automation workflows using Power Automate Desktop (RPA) and SQL. The role focuses on data transformation and integration into legacy mainframe systems, supporting business-critical migration activities with high compliance and quality standards.
Key Responsibilities:
- Design and deploy automation workflows using Power Automate Desktop (RPA)
- Collaborate with business and data teams to translate migration requirements into automated processes
- Write and optimize complex SQL queries, stored procedures, and data validations
- Automate ETL processes for integration with mainframe environments
- Monitor, troubleshoot, and resolve workflow issues
- Ensure security, compliance, and maintain clear documentation and audit trails
- Participate in key migration events and be available for shift-based support when needed
- 4+ years of experience in Power Automate Desktop (RPA) development
- Experience with Power Platform (solution creation and deployments)
- Strong SQL development skills, including stored procedures and performance tuning
- Previous experience with mainframe data integration or loading
- Understanding of RPA architecture, workflow orchestration, and automation lifecycle
- Experience working in Agile or hybrid project settings
- Strong communication and troubleshooting skills
- Familiarity with Power Automate Cloud flows or Power Platform integrations
- Knowledge of SSIS, ADF, Informatica, or middleware tools
- Exposure to COBOL datasets or legacy batch processing
- Experience with data mapping and transformation logic
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.