Robotic Power Automate Developer (34090)
About the role
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
- 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
Required Skills & Qualifications
- 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
Nice-to-Have
- 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
, : Runa Parmar
About Myticas Consulting
Myticas Consulting is a proven industry-leading IT Staffing and Recruitment organization, with active locations in major North American cities such as Ottawa Ontario, Chicago Illinois, and Atlanta Georgia.
Our large team of IT recruitment and sales professionals have over 50+ years of combined experience providing the highest quality of Telecommunication Engineering, ERP and IT Software Development resources, to both Public and Private sector enterprise level environments.
Here at Myticas, we strive to continually provide unmatched quality of IT resources, that prove to stand the test of time, and go above and beyond all project expectations and deliverables.
The "motto" at Myticas is not only to work with you, but to understand what success really looks like for your organization, and to deliver the IT staffing needs that matter most to increasing both the functionality and efficiency of your environment.
With our evolving expertise in Telecom, ERP, DW/BI and EAI resources, and a guaranteed replacement program for all our partners, the defined win-win scenario has never been presented in a more simple manner.
Robotic Power Automate Developer (34090)
About the role
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
- 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
Required Skills & Qualifications
- 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
Nice-to-Have
- 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
, : Runa Parmar
About Myticas Consulting
Myticas Consulting is a proven industry-leading IT Staffing and Recruitment organization, with active locations in major North American cities such as Ottawa Ontario, Chicago Illinois, and Atlanta Georgia.
Our large team of IT recruitment and sales professionals have over 50+ years of combined experience providing the highest quality of Telecommunication Engineering, ERP and IT Software Development resources, to both Public and Private sector enterprise level environments.
Here at Myticas, we strive to continually provide unmatched quality of IT resources, that prove to stand the test of time, and go above and beyond all project expectations and deliverables.
The "motto" at Myticas is not only to work with you, but to understand what success really looks like for your organization, and to deliver the IT staffing needs that matter most to increasing both the functionality and efficiency of your environment.
With our evolving expertise in Telecom, ERP, DW/BI and EAI resources, and a guaranteed replacement program for all our partners, the defined win-win scenario has never been presented in a more simple manner.