11 jobs found for etl

Our Client in the Ontario Public Sector is looking for a ETL Developer on a 12 month contractMust-haves:5+ years of hands on ETL development experience using Informatica, in a data warehousing environment or large data migrationWorking experience in debugging mappings, transformations, mapplets and source qualifier files and Unit testing the newly developed ETL componentsExperience with data architecture designs and technologies for BI solutionsExperience in debugging mappings, transformations, mapplets, source qualifier files and queriesAdvantagesOur Client in the Ontario Public Sector is looking for a ETL Developer on a 12 month contractMust-haves:5+ years of hands on ETL development experience using Informatica, in a data warehousing environment or large data migrationWorking experience in debugging mappings, transformations, mapplets and source qualifier files and Unit testing the newly developed ETL componentsExperience with data architecture designs and technologies for BI solutionsExperience in debugging mappings, transformations, mapplets, source qualifier files and queriesResponsibilitiesOur Client in the Ontario Public Sector is looking for a ETL Developer on a 12 month contractMust-haves:5+ years of hands on ETL development experience using Informatica, in a data warehousing environment or large data migrationWorking experience in debugging mappings, transformations, mapplets and source qualifier files and Unit testing the newly developed ETL componentsExperience with data architecture designs and technologies for BI solutionsExperience in debugging mappings, transformations, mapplets, source qualifier files and queriesQualificationsOur Client in the Ontario Public Sector is looking for a ETL Developer on a 12 month contractMust-haves:5+ years of hands on ETL development experience using Informatica, in a data warehousing environment or large data migrationWorking experience in debugging mappings, transformations, mapplets and source qualifier files and Unit testing the newly developed ETL componentsExperience with data architecture designs and technologies for BI solutionsExperience in debugging mappings, transformations, mapplets, source qualifier files and queriesSummaryOur Client in the Ontario Public Sector is looking for a ETL Developer on a 12 month contractMust-haves:5+ years of hands on ETL development experience using Informatica, in a data warehousing environment or large data migrationWorking experience in debugging mappings, transformations, mapplets and source qualifier files and Unit testing the newly developed ETL componentsExperience with data architecture designs and technologies for BI solutionsExperience in debugging mappings, transformations, mapplets, source qualifier files and queries

Our Client in the Ontario Public Sector is looking for a Intermediate Leve Cognos and ETL Developer on a 12 month contract Must-haves:3+ years of hands on ETL development experience using Informatica, in a data warehousing environment or large data migrationWorking experience in debugging mappings, transformations, mapplets and source qualifier files and Unit testing the newly developed ETL components3+ years of working experience with Cognos and Power BIDemonstrated experience with developing Cognos reports, dashboards, storyboards, and data visualization techniquesAdvantagesOur Client in the Ontario Public Sector is looking for a Intermediate Leve Cognos and ETL Developer on a 12 month contract Must-haves:3+ years of hands on ETL development experience using Informatica, in a data warehousing environment or large data migrationWorking experience in debugging mappings, transformations, mapplets and source qualifier files and Unit testing the newly developed ETL components3+ years of working experience with Cognos and Power BIDemonstrated experience with developing Cognos reports, dashboards, storyboards, and data visualization techniquesResponsibilitiesOur Client in the Ontario Public Sector is looking for a Intermediate Leve Cognos and ETL Developer on a 12 month contract Must-haves:3+ years of hands on ETL development experience using Informatica, in a data warehousing environment or large data migrationWorking experience in debugging mappings, transformations, mapplets and source qualifier files and Unit testing the newly developed ETL components3+ years of working experience with Cognos and Power BIDemonstrated experience with developing Cognos reports, dashboards, storyboards, and data visualization techniquesQualificationsOur Client in the Ontario Public Sector is looking for a Intermediate Leve Cognos and ETL Developer on a 12 month contract Must-haves:3+ years of hands on ETL development experience using Informatica, in a data warehousing environment or large data migrationWorking experience in debugging mappings, transformations, mapplets and source qualifier files and Unit testing the newly developed ETL components3+ years of working experience with Cognos and Power BIDemonstrated experience with developing Cognos reports, dashboards, storyboards, and data visualization techniquesSummaryOur Client in the Ontario Public Sector is looking for a Intermediate Leve Cognos and ETL Developer on a 12 month contract Must-haves:3+ years of hands on ETL development experience using Informatica, in a data warehousing environment or large data migrationWorking experience in debugging mappings, transformations, mapplets and source qualifier files and Unit testing the newly developed ETL components3+ years of working experience with Cognos and Power BIDemonstrated experience with developing Cognos reports, dashboards, storyboards, and data visualization techniques

Our Public Sector client is looking for a Senior Business Intelligence Specialist on a 12 month contractMust-haves:•Experience with data architecture designs and technologies for BI solutions, for both on-premise and cloud solutions•Experience leading projects that involve technology upgrade/migration to Microsoft BI Suite; determine which part of existing solution needs to be migrated or rebuilt•10+ years of hands on experience ETL development experience using Informatica, SSIS / ADF in a data warehousing environment or large data migration; Working experience in debugging mappings, transformations, mapplets and source qualifier files and Unit testing the newly developed ETL components•Extensive experience with source control and environment management Responsibilities: Undertakes the design of hosting technology solutions based on the client's service specifications, standards, policies, best practices and cost models, in order to meet client application business requirement and project/initiative deliverables.Key deliverables to be performed by the Solution Designer include, but are not limited to, the following:•Complete work and achieve milestones within the assigned deadlines;•Consult with clients and manages business analysis in order to assess clients' businessproblems/opportunities and to identify business and technology solutions suited to client needs;•Develop realistic work breakdown structure and contribute in preparing overall project schedule;•Ensure defined Change Management Process is followed for any change from agreed scope, schedule, or quality;•Liaise with IT specialists and unit leads and work closely with support team members and relevant stakeholders;•Notify the cluster/ministry project manager in writing of any issues or other material concerns related to the assignment deliverables, as soon as the he/she becomes aware of them;•Participate in discussions with Infrastructure Technology Services (ITS), Cyber Security Branch (CSB), Centre of Excellence for Accessibility and Information Privacy and Archives (IPA) Office to ensure the application remains compliant with all applicable GO-ITS Standards;•Participate in discussions with the business regarding any changes required to business and system requirements;•Participate in working groups and client interviews to define and document needs, processes and problem resolution;•Perform daily tracking, reporting and facilitating resolution of issues and risks for all project activities;•Provide analysis covering systems requirements, screen design, workflow design, gap analysis, testing, and change management in support of any application changes;•Provide clarification to designers, developers, and testers at various stages of SDLC to ensure that any changes or enhancements are fully regression tested and validated;•Provide input in creation of change requests;•Provide knowledge and skill transfer to a designated cluster/ministry staff;•Provides expertise and assistance to cluster functional areas and external service providers in delivering effective technology solutions to clients;•Submit deliverables for the cluster/ministry approval;•Support the analysis of existing business processes, design and recommend process improvements to effectively harness the benefits of using the application(s);•Work closely with the director, managers, and staff on issues and business needs;•Work collaboratively with other groups to ensure optimal integration;•Comply with the Ontario government and the cluster/ministry’s guidelines, standards and procedures such as:o architecture/technology standards and best practiceso conflict of interest and confidentiality guidelineso security procedures and practiceso Ontario Government I&IT Directive, operational policy on the I&IT project gateway process; ando other applicable guidelines, standards and procedures.Skills:•A team player with the ability to coordinate multiple projects with competing priorities and strict deadlines;•Excellent analytical, problem-solving, and decision-making skills; verbal and written communication skills; interpersonal and negotiation skills;•Knowledge and experience in working in accordance with policies and procedures of the Ontario Public Service;•Proven ability to lead technical team to the successful completion of an assignment of this nature, magnitude, and complexity, and demonstrated ability to help them achieve the desired business benefits on schedule and within budget;•Proven experience facilitating the resolution of I&IT and Business issues.Experience:•The Programmer/Developer should have 10+ years of experience in the following:•Demonstrate experience in performing gap fit analysis and impact analysis;•Demonstrated advanced experience and skills using Informatica ETL tools (experience with Oracle Data Integrator also an asset)•Demonstrates development and solution design experience in an environment where SQL Server, Oracle, SSIS, SSAS, SSRS, Power View, Power BI and SharePoint are used together•Demonstrates development and solution design experience with SQL Server 2012, 2016, Oracle 10. x and 11.x databases•Experience enhancing performance of ETL code and SQL Queries•Experience developing ETL routines using Infomatica in a data warehousing environment or large data migration•Demonstrates experience designing and developing for WCAB AA compliance in web applications•Demonstrates development and solution design experience with technology, data, databases, statistics, applications, and networking techniques, tools and practices that enables the candidate to lead the design and development of business intelligence projects•Demonstrates experience in working with and analyzing large and diverse data sets, data visualization, KPI development and data profiling to identify relationships and themes•Experience Designing Data warehouse components and ETL Scripts•Working experience in debugging mappings, transformations, mapplets and source qualifier files and Unit testing the newly developed ETL components•Experience in developing the Application Code package using MS Visual Source Safe•Demonstrate experience in the analysis and planning for the modernization of large, complex multi-platform, multi-tier information technology systems;•Demonstrate skills and experience with documenting deliverables outlined in Deliverables section;•Experience in documenting system requirements.;•Experience supporting business users working on projects or programs involving multiple highly inter-dependent applications and/or data sources;•Experience with requirement management, quality assurance, and change management tools.•Experience working with both the business users and IT development teams to ensure business requirements are properly reflected in the system design and technical specifications;•Extensive experience with GO-ITS standards;•Knowledge and experience with OPS corporate gating and enterprise architecture checkpoints processes; and•Experience developing solutions involving technologies such as Informatica, Oracle DBMS, Cognos, Microsoft BI, GO-Secure, PKI, and data encryption.AdvantagesMust-haves:•Experience developing ETL routines using Informatica in a data warehousing environment or large data migration•Experience working with Microsoft SSIS and has experience with migration involving Informatica to Microsoft BI suite Nice to Have:•Public Sector experienceResponsibilitiesMust-haves:•Experience developing ETL routines using Informatica in a data warehousing environment or large data migration•Experience working with Microsoft SSIS and has experience with migration involving Informatica to Microsoft BI suite Nice to Have:•Public Sector experienceQualificationsMust-haves:•Experience developing ETL routines using Informatica in a data warehousing environment or large data migration•Experience working with Microsoft SSIS and has experience with migration involving Informatica to Microsoft BI suite Nice to Have:•Public Sector experienceSummaryMust-haves:•Experience developing ETL routines using Informatica in a data warehousing environment or large data migration•Experience working with Microsoft SSIS and has experience with migration involving Informatica to Microsoft BI suite Nice to Have:•Public Sector experience

Our Public Sector client is looking for a ETL Developer with Azure Data Factory experience on a 12 month contract Must Haves:•Demonstrates experience designing, developing, and implementing ETL solutions using Azure Data Factory•Demonstrates development and solution design experience in an environment where Azure Data Factory, and PowerBI are used togetherroject Background InformationThe Community Services I&IT cluster (CSC) of the Ontario Public Service serves the Colleges, and Universities (MCU), Education (EDU), Municipal Affairs and Housing (MMAH),and Heritage, Sport, Tourism, and Culture Industries (MHSTCI) Ministries.. The Data Collection and Decision Support branch (DDSB) within CSC provides data collection and analytic service to all four client ministries. DDSB supports the ministries by providing information management tools that help enable public policy decision making, business and strategic planning, and program support and improvement. Advanced Analytics Unit requires an intermediate Software Developer who can perform the role of ETL Solution Development/Programmer/Developer using Azure Data Factory and Microsoft BI tools on the Strategic Information Management System project, for the Ministry of Colleges and Universities, and other projects.Please note: “This procurement also includes the option to extend the end date of the project, if there are unused effort days and no change to the ceiling amount if the need arises.”The Solution Development/Programmer/Developer will work under the direction of the Project Manager and the Senior Technical Manager and will engage directly with business clients.Responsibilities/Assignment DeliverablesThe consultant will provide services under the direction of the Senior Technical Manager and Project Manager.Key deliverables to be performed by the consultants include, but are not limited to, the following: •Participate in the analysis, design, development, and unit testing of all the project’s ETL components i.e. Mappings, Workflows, Sessions, and resulting Data;•Lead discussions with the business regarding changes required to ETL system requirements;•Develop data pipelines using Azure Data Factory;•Create and/or update data processing overview, technical design, source to target mapping, operation manual and other technical documentation;•Design data warehouses and data marts for databases such as Oracle, SQL Server / Azure SQL Database;•Participating in project design and code walkthroughs;•Participate in Quality Assurance (QA) and System Integration (SIT) testing and supporting the System Acceptance (SAT) and User Acceptance (UAT) Testing;•Develop, test, and deploy code package using Azure DevOps;•Perform day-to-day tracking, reporting and facilitating resolution of issues and risks for all project activities in Azure DevOps•Work closely with the subject matter experts, managers, and staff of the ministries to implement solutions that address business needs and issues;•Propose and develop proof of concept solutions for extending the use of Microsoft BI technologies within DDSB;•Participate in discussions with Infrastructure Technology Services (ITS), Corporate Security Branch (CSB), Centre of Excellence for Accessibility and Information Privacy and Archives (IPA) Office to ensure the application remains compliant with all applicable GO-ITS standards;•Participate in discussions with the business analyst regarding any changes required to business and/or system requirements, as well as requirement gathering sessions•Support the analysis of existing business processes, design and recommending process improvements to effectively harness the benefits of using the application(s);•Provide input into and/or completing required architectural/development artifacts;•Liaise with IT specialists and unit leads and working closely with support team members and relevant stakeholders;•Contribute to work breakdown structures and project schedules; and•Develop deployment plan for the production environment. SkillsExperience and Skill Set RequirementsCore Technical Skills - 45%· Demonstrates experience designing, developing, and implementing ETL solutions using Azure Data Factory.· Demonstrates development and solution design experience in an environment where Azure Data Factory, and PowerBI are used together· Experience in designing data warehouses and data marts for databases such as Oracle, SQL Server / Azure SQL Database as well as having a strong understanding of the architectural implications associated with each platform in regard to ETL· Experience in debugging mappings, transformations, mapplets, source qualifier files and queries· Demonstrates experience with developing ETL solutions to populate data warehouses and create data extracts for the purpose of business intelligence reporting· Demonstrates experience developing star schema multi-dimensional models· Experience with developing, debugging and enhancing the performance of complex SQL queries· Demonstrates experience developing Unix shell scripts· Demonstrates experience using Power Designer to review data models, as well as make changes and generate DDL scripts· Demonstrates experience developing application code package using Azure DevOps· Demonstrates development experience with SQL Server 2016+ / Azure SQL Database, Oracle 12.x· Demonstrates experience with documenting code changes, creating release packages and deployment instructions· Experience with performing unit testing and conducting System Integration Testing and User Acceptance TestingGeneral skills/experience - 30%· Working knowledge of aggregate reporting· Demonstrates experience supporting business users working on projects or programs involving multiple highly inter-dependent applications and/or data sources· Demonstrates experience developing application code package using Azure DevOps· Demonstrates experience implementing star schema multi-dimensional models and documenting detailed design models· Demonstrates development and design experience with SDLC processes, Agile and Waterfall methodologies· Demonstrates experience with documenting code changes and deployment instructions· Experience with performing unit testing and conducting System Integration Testing and User Acceptance Testing•Analytical and problem-solving skills to assess clients’ business priorities and needs; to evaluate business and technical design alternativesCommunications Skills/experience - 20%· Analytical and problem-solving skills to assess clients’ business priorities and needs; to evaluate business and technical design alternatives· Demonstrates the ability to collaboratively work with other groups (both technical and business) to ensure optimal solution integration· Demonstrates ability to communicate day-to-day task and issue tracking, reporting and facilitating resolution of issues and risks for all project activities· Demonstrates ability in providing input to changes required to business and/or system requirements, change requests, project artefacts, well as requirement gathering sessions· Experience with documenting, consulting and presenting for a diverse audience of stakeholders (both technical and non-technical)· Experience with liaising with IT specialists and unit leads and working closely with support team members and relevant stakeholders· Strong analytical, problem-solving, and decision-making skills; verbal and written communication skills; interpersonal and negotiation skills•Demonstrates experience working collaboratively, with the ability to coordinate multiple projects with competing priorities and a track record for meeting strict deadlinesPublic Sector Experience - 5%•Previous public sector experience in an organization of equivalent size and complexity to Ontario Public Service.•Demonstrates experience designing and developing applications that comply with GO-ITS standards would be an asset•REQUISITION TITLEAdvantagesOur Public Sector client is looking for a ETL Developer with Azure Data Factory experience on a 12 month contract Must Haves:•Demonstrates experience designing, developing, and implementing ETL solutions using Azure Data Factory•Demonstrates development and solution design experience in an environment where Azure Data Factory, and PowerBI are used togetherResponsibilitiesOur Public Sector client is looking for a ETL Developer with Azure Data Factory experience on a 12 month contract Must Haves:•Demonstrates experience designing, developing, and implementing ETL solutions using Azure Data Factory•Demonstrates development and solution design experience in an environment where Azure Data Factory, and PowerBI are used togetherQualificationsOur Public Sector client is looking for a ETL Developer with Azure Data Factory experience on a 12 month contract Must Haves:•Demonstrates experience designing, developing, and implementing ETL solutions using Azure Data Factory•Demonstrates development and solution design experience in an environment where Azure Data Factory, and PowerBI are used togetherSummaryOur Public Sector client is looking for a ETL Developer with Azure Data Factory experience on a 12 month contract Must Haves:•Demonstrates experience designing, developing, and implementing ETL solutions using Azure Data Factory•Demonstrates development and solution design experience in an environment where Azure Data Factory, and PowerBI are used together

Our client is looking for a technical business analyst to join them on a full time - permanent basis. • Provide technical consulting to client teams and clients.• Work with internal and external clients to document and develop new solutions.• Manage and develop Functional specs and user stories.• Work with the developers on architecting solutions.• Work in an agile environment with other professional skilled technologies workers.• Work very closely with the digital manager to create solution overviews and cost estimates for enhancements and new builds.• Provide on-going support for implemented systemsAdvantagesworking for a large organization with great technology expertise located in Mississauga OntarioResponsibilitiesAs our Technical Business Analyst, you have:• Proficient knowledge of SQL, .NET technologies, C#, XML data structures and different operating system/browser environments.• 3-5 years of experience in .NET & other MS technologies• 3-5 years of experience in other languages like react/Angular• 3-5 years of experience in Visio• 3-5 years of experience in MS Project• 5-7 years of experience in software development lifecycle using agile and waterfall methodologies.• 5-7 years of experience working with development teams building and architecting solutions.• 5-7 years of experience in designing and developing multi-tier web and windows-based applications.• 5-7 years conducting workshops/stakeholder interviews to gather business requirements.• 5-7 years of experience working with big data sets and ETL methodologies.• 3+ years of experience in a technical leadership role• Extensive knowledge of web development including API and web services.• Experience factoring in security, data privacy and compliance into proposed solutions.• Strong understanding of Data Analytics.• Strong understanding of data flow diagrams and technical specificationsQualifications• Proficient knowledge of SQL, .NET technologies, C#, XML data structures and different operating system/browser environments.• 3-5 years of experience in .NET & other MS technologies• 3-5 years of experience in other languages like react/Angular• 3-5 years of experience in Visio• 3-5 years of experience in MS Project• 5-7 years of experience in software development lifecycle using agile and waterfall methodologies.• 5-7 years of experience working with development teams building and architecting solutions.• 5-7 years of experience in designing and developing multi-tier web and windows-based applications.• 5-7 years conducting workshops/stakeholder interviews to gather business requirements.• 5-7 years of experience working with big data sets and ETL methodologies.• 3+ years of experience in a technical leadership role• Extensive knowledge of web development including API and web services.• Experience factoring in security, data privacy and compliance into proposed solutions.• Strong understanding of Data Analytics.• Strong understanding of data flow diagrams and technical specificationsSummaryIf you are a strong technical BA with development background we would love to hear from you!

Title: Intermediate Database AdministratorJob SummaryResponsible for maintaining, monitoring and securing our clients SQL server infrastructure. Handling user report requests and ad-hoc extracts. Ensuring replicated databases are operating correctly and responding to user requests. Ensuring backups are operating correctly and reviewing system logs.Primary responsibilities•Support & Monitor SQL Server 2005-2016•Monitor backups and SQL jobs•Ensuring databases are running optimal•Troubleshoot problems reported by users.•Make recommendations for future upgrades and tablespace design•Maintain database and system performance•Analyze and isolate issues.•Monitor servers to ensure security and availability to specific users.•Evaluate and modify system's performance.•Identify user needs.•Maintain integrity of the network and security.•Design and deploy reports using SQL/Crystal Reports/SSRS/SSIS.•Proficient in generating reports using SQL Server Reporting Services (SSRS), POWER BI, EXCEL Services.•Experience in creating and working on ETL•Knowledge of using SQL profiler for troubleshooting DMVs and performance issues.•Experience with version control using Team foundation server•Deploy custom applications and databases•Maintain and audit user database access.Must have skills•Windows administrator skills•VMWare experience •MS SQL Server 2005 and greater•Database replication technologyNice to have•PostgreSQL •Oracle 10g and greater•Pervasive and MySQL•Informix 10 and greater•SAN experience•WAN connectivity and design principals•Active Directory management experience•AWS & Azure cloud experienceAdvantages100% work from home if preferred. Home office Aurora Ontario. Great team!!ResponsibilitiesPrimary responsibilities•Support & Monitor SQL Server 2005-2016•Monitor backups and SQL jobs•Ensuring databases are running optimal•Troubleshoot problems reported by users.•Make recommendations for future upgrades and tablespace design•Maintain database and system performance•Analyze and isolate issues.•Monitor servers to ensure security and availability to specific users.•Evaluate and modify system's performance.•Identify user needs.•Maintain integrity of the network and security.•Design and deploy reports using SQL/Crystal Reports/SSRS/SSIS.•Proficient in generating reports using SQL Server Reporting Services (SSRS), POWER BI, EXCEL Services.•Experience in creating and working on ETL•Knowledge of using SQL profiler for troubleshooting DMVs and performance issues.•Experience with version control using Team foundation server•Deploy custom applications and databases•Maintain and audit user database access.QualificationsMust have skills•Windows administrator skills•VMWare experience •MS SQL Server 2005 and greater•Database replication technologyNice to have•PostgreSQL •Oracle 10g and greater•Pervasive and MySQL•Informix 10 and greater•SAN experience•WAN connectivity and design principals•Active Directory management experience•AWS & Azure cloud experienceSummaryResponsible for maintaining, monitoring and securing our clients SQL server infrastructure. Handling user report requests and ad-hoc extracts. Ensuring replicated databases are operating correctly and responding to user requests. Ensuring backups are operating correctly and reviewing system logs.Primary responsibilities•Support & Monitor SQL Server 2005-2016•Monitor backups and SQL jobs•Ensuring databases are running optimal•Troubleshoot problems reported by users.•Make recommendations for future upgrades and tablespace design•Maintain database and system performance•Analyze and isolate issues.•Monitor servers to ensure security and availability to specific users.•Evaluate and modify system's performance.•Identify user needs.•Maintain integrity of the network and security.•Design and deploy reports using SQL/Crystal Reports/SSRS/SSIS.•Proficient in generating reports using SQL Server Reporting Services (SSRS), POWER BI, EXCEL Services.•Experience in creating and working on ETL•Knowledge of using SQL profiler for troubleshooting DMVs and performance issues.•Experience with version control using Team foundation server•Deploy custom applications and databases•Maintain and audit user database access.Must have skills•Windows administrator skills•VMWare experience •MS SQL Server 2005 and greater•Database replication technologyNice to have•PostgreSQL •Oracle 10g and greater•Pervasive and MySQL•Informix 10 and greater•SAN experience•WAN connectivity and design principals•Active Directory management experience•AWS & Azure cloud experience

Our Candidate in the Public Sector is looking for a Senior Data Developer with AS400 experience - With the Ontario Public/Broader Public Sector Must Haves:•Experience in the use of data and process modelling technologies, data integration, data cleansing, techniques and tools, including knowledge of metadata structures, repository functions, and data dictionaries.•Experience with complex application and data migration from legacy systems like AS400, experience in troubleshooting and performance tuning of complex database queries•Experience with Business Intelligence environment showing familiarity with ETL tools like Talend, Business Intelligence software and leading industry practices Nice to Have:•Public Sector ExperienceNOTE: Due to COVID-19 restrictions, consultants will temporarily be working remotely until restrictions are lifted and it is safe to return to the office.Note: This procurement also includes the option to extend the end date of the project, if there are unused effort days and no change to the ceiling amount if the need arises.Responsibilities:Works in partnership with clients, advising them on information technology in order to meet their business objectives or overcome problems, work 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.General Skills:Acts as the technical advisor/expert on all aspects of a specific deliverableProvide the quality assurance/quality control of specific deliverablesAnticipates and resolves problems to ensure that the deliverables are completed within budget, to the highest quality, meeting or exceeding expectationsDevelops processes and procedures for implementing deliverablesPrepares reports and presentations including options, recommendations, implementation plans, etc.Works with clients to define the scope of a project and to determine requirementsDefines software, hardware and network requirementsAnalyzes I&IT requirements giving independent and objective advice on the use of I&ITDesigns, tests, installs and monitors new systems and develops solutions and implementation of new systemsFamiliar with change-management principles and methodologyKnowledge and understanding of Information Management principles, concepts, policies and practicesSkillsExperience and Skill Set RequirementsEvaluation Criteria:Knowledge and Skills: 60 %•Experience in systems design, configuration, integration and development, IT security, programming concepts, languages and related methods, techniques, practices and standards used in development of n-tier JEE web applications•Knowledge of enterprise architecture deliverables (e.g. Business, logical and physical models) based on Enterprise Application Processes and Modeling methodology and guidelines.•Experience in the use of data and process modelling technologies, data integration, data cleansing, techniques and tools, including knowledge of metadata structures, repository functions, and data dictionaries.•Experience with complex application and data migration from legacy systems like AS400, experience in troubleshooting and performance tuning of complex database queries•Experience with Fieldworker platform, development and design experience using Fieldworker and providing support to business clients•Experience with Business Intelligence environment showing familiarity with ETL tools like Talend, Business Intelligence software and leading industry practices•Demonstrated experience in presenting solutions in written or oral reports to relevant stakeholders and presents progress reports to clients•Familiar with change-management principles and methodology General Skills 25%•Excellent communication skills with both technical and business audience, builds positive relationships by developing an understanding of business and deliverable needs.•Experience in providing advice in developing and integrating process and information. Experience in providing technical guidance to business analysts, architects and system development teams•Anticipates and resolves problems to ensure that the deliverables are completed to the highest quality, meeting or exceeding expectations•Identifies conflicts and communicates deliverable conflicts or issues to the engagement lead or client manager – directly engaging with clientsOther Skills: 15%•Knowledge of Public Sector gating and architectural checkpoint approvals process and familiarity with Risk Assessment techniques and Privacy Assessment processes•Knowledge and experience on platform as a service (PaaS) in enterprise data center or on-premise cloud environment•Experience with Freedom of Information and Privacy Protection Act and GO–ITS standards would be an assetRequisition TitleRFS-RAU-4371-4372-Specialized IT Consultant - Senior (PARIS)DescriptionNote: Due to COVID-19 restrictions, consultants will temporarily be working remotely until restrictions are lifted and it is safe to return to the office.Responsibilities:· Works in partnership with clients, advising them on information technology in order to meet their business objectives or overcome problems, work 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.General Skills:· Acts as the technical advisor/expert on all aspects of a specific deliverable· Provide 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, AdvantagesMust Haves:•Experience in the use of data and process modelling technologies, data integration, data cleansing, techniques and tools, including knowledge of metadata structures, repository functions, and data dictionaries.•Experience with complex application and data migration from legacy systems like AS400, experience in troubleshooting and performance tuning of complex database queries•Experience with Business Intelligence environment showing familiarity with ETL tools like Talend, Business Intelligence software and leading industry practicesResponsibilitiesMust Haves:•Experience in the use of data and process modelling technologies, data integration, data cleansing, techniques and tools, including knowledge of metadata structures, repository functions, and data dictionaries.•Experience with complex application and data migration from legacy systems like AS400, experience in troubleshooting and performance tuning of complex database queries•Experience with Business Intelligence environment showing familiarity with ETL tools like Talend, Business Intelligence software and leading industry practicesQualificationsMust Haves:•Experience in the use of data and process modelling technologies, data integration, data cleansing, techniques and tools, including knowledge of metadata structures, repository functions, and data dictionaries.•Experience with complex application and data migration from legacy systems like AS400, experience in troubleshooting and performance tuning of complex database queries•Experience with Business Intelligence environment showing familiarity with ETL tools like Talend, Business Intelligence software and leading industry practicesSummaryMust Haves:•Experience in the use of data and process modelling technologies, data integration, data cleansing, techniques and tools, including knowledge of metadata structures, repository functions, and data dictionaries.•Experience with complex application and data migration from legacy systems like AS400, experience in troubleshooting and performance tuning of complex database queries•Experience with Business Intelligence environment showing familiarity with ETL tools like Talend, Business Intelligence software and leading industry practices

The resource sought has a technical test specialist profile and should be able to develop detailed test strategies as well as ensure the execution of strategy, plans and test cases.General roles and responsibilities:Analyze and receive functional and technical specificationsContribute to the development of the test strategyWrite test plans· Execute / create different test cases (manual, automated, etc.) via the different toolsWrite and run testsGeneral skills:- Knowledge of the testing process, test levels, types of tests and test methods- Knowledge of the Agile development environment- Experience with test management tools such as HP ALM, XRAY.- Experience with different types of tests (eg front-end, back-end, security, UI, process, ETL)- Strong technique for the diagnosis of anomalies- Assets: Training in Quality Assurance (AEC, ISTBQ or others)Specific knowledge for this mandate: - Expertise in quality assurance processes and quality assurance tools- Writing and execution of strategies and test scenarios- Mastery of data management and validation practices- Strong technical skillsRequired profile:- Demonstrate thoroughness and rigor- Demonstrate analytical skills- Master written and verbal communications- Be results oriented- Able to work with minimal supervision- Ease of working with offshore teams- Be a team personAdvantages__________________________________________________________________________________________Responsibilities__________________________________________________________________________________________Qualifications__________________________________________________________________________________________Summary__________________________________________________________________________________________

Our retail industry client is looking for 2 Data Engineers to join their team on a permanent hire basis.You will be part of our innovation hub located in downtown Toronto where your desire for impact will only be matched by your innate ability to collaborate with other like minded individuals to come up with creative solutions to our retail data science problemsJob Description•Maintaining, streamlining and hardening existing data pipelines, from ingestion, through ETL and batch processing in order to reliably process billions of records per day.•Build data support for our personalization and experimentation efforts, solving problems from statistical test automation to building real-time M/L applications.•Working with Analytics and Product Management to ensure optimal data design and efficiency.•Assisting Data Analysts and Data Scientists with pipeline and model deployment•Use an analytical, data-driven approach to drive a deep understanding of our fast changing business.•Building data models to deliver insightful analytics while ensuring the highest standard in data integrity..Advantages- work from home initially until quarantine is lifted- be part of a new department working on high profile projects ResponsibilitiesJob Description•Maintaining, streamlining and hardening existing data pipelines, from ingestion, through ETL and batch processing in order to reliably process billions of records per day.•Build data support for our personalization and experimentation efforts, solving problems from statistical test automation to building real-time M/L applications.•Working with Analytics and Product Management to ensure optimal data design and efficiency.•Assisting Data Analysts and Data Scientists with pipeline and model deployment•Use an analytical, data-driven approach to drive a deep understanding of our fast changing business.•Building data models to deliver insightful analytics while ensuring the highest standard in data integrity.QualificationsJob Requirements•Bachelor’s degree in Engineering, Computer Science, Statistics, Economics, Mathematics, Finance or related quantitative field, or equivalent practical experience.•Experience and proficiency with SQL and SQL-like languages•More than 3 years of software engineering experience, especially working on back-end data infrastructure.•Proficiency with at least one of the following languages: Java, Python, Scala.•Proficiency with Spark and/or similar tools in Hadoop/YARN environment and comfortable with Linux operating system.•Ability to creatively solve problems in a fast paced, rapidly changing environment•Ability to navigate ambiguity, drive solutions forward and bring stakeholders along.•Strong problem solving, analytical skills and capability of managing multiple projects and reporting simultaneously across different stakeholders.•Strong structured thinking and the ability to easily break down complex ambiguous problems and propose impactful data modeling designs.Summary- minimum 3 years software engineering especially working with back-end data infrastructure•Proficiency with at least one of the following languages: Java, Python, Scala •Experience and proficiency with SQL and SQL-like languages•Proficiency with Spark and/or similar tools in Hadoop/YARN environment and comfortable with Linux operating system.

We are responsible for the systems allowing the disclosure of regulatory capital to the AMF as well as the calculations of economic capital. Behavioral rating systems, issuance of risk ratings on granting or revising credit, as well as systems for calculating provisions are also part of the management portfolio.We are currently looking for a Test Automation Analyst to collaborate on management projects.The main tasks of the test automation analyst are:Set up a test automation strategyInstall and maintain automated test environmentsScript automated testsResolve anomalies related to test automationRequired profile- A minimum of five (5) years of experience in a functional analyst role with applications intended for medium and large companies- Knowledge of artificial intelligence, risk strategies, models (an asset)- Knowledge of the field of banking risk (credit report, customer profile, loan, mortgage, card applications) (an asset)- Practical knowledge of Agile methodology (Scrum / Kanban / Safe)- Knowledge of the software life cycle, the QA process- Demonstrated ability to understand the business needs of the organization and define the digital services to develop- Intermediate level knowledge of English- Have a keen analytical mind and have excellent problem-solving skills- Experience with automation using Postman tool, Xunit- Experience with test automation in a PAAS environment- Experience with the XRAY test case management tool (asset)- Knowledge of HP ALM, HP UFT, HP LEANFT, Selenium, and other testing tools- Experience in the implementation of test automation strategy- Hands-on experience automating back-end systems, user interface applications, web services, ETL, etc.- Experience with scripting languages ​​for test automation: Java script, ANT, Script Shell, Powershell, etc.- Knowledge of continuous integration for test automation: be familiar with continuous integration tools (Jenkins, Hudson, CruiseControl, etc.)- Ability to learn and adapt quickly in a multitasking environment despite constraints and pressures- Be oriented towards business teammates, teamwork and action- Make quality decisions- Be good at interpersonal communication- Be results oriented- Knowing how to define priorities, inform and manage your time- Demonstrate professional rigor and thoroughnessAdvantages____________________________________________________________________________________Responsibilities____________________________________________________________________________________Qualifications____________________________________________________________________________________Summary____________________________________________________________________________________

Are you a Data Architect looking to work on exciting Big Data intiatives comprising of the management of over 1600 databases? Our Downtown Vancouver client is looking for a Data Architect to join their amazing team on a permanent full-time basis! The Data Architect will be responsible for all data driven initiatives and strategies focusing on database schema design and maintenance, data transformation and batch processing, data analytics and data management. The Data Architect will act as a lead for a growing DBA team, setting priorities and organizing work in collaboration with the Head of CloudOps. Apply for this awesome Data Architect opportunity today!AdvantagesWhat’s in it for you!As a Data Architect with our Downtown Vancouver client, you’ll receive:• Highly competitive market annual rates.• Remote work environment.• Group RRSP matching.• Extended health and dental benefits.• Quarterly extra-curricular activities.ResponsibilitiesWhat will you do?As a Data Architect with our Downtown Vancouver client, you will:• Take ownership of all data sources, repositories and artifacts including documentation, diagrams, polices, procedures and the actual data and schema itself.• Develop Big Data storage using cloud data platforms (such as GCP, AWS etc.) to consume vast amounts of data and consolidate them to be consumable by technical and non-technical users alike (both internal and external).• Architect scalable and sustainable data management, analytics, and storage solutions on hybrid cloud (modern cloud platforms integrating with legacy systems).• Lead and report on progress on the small but growing DBA team.• Oversight into data monitoring, performance and other data devops tasks.QualificationsHow do you qualify?To qualify for the Data Architect role with our Downtown Vancouver client, you must have:• 8+ years of experience with a deep understanding of databases and analytics, specifically in MySQL, data warehousing, and business analytics (Power BI, Tableau, Data studio etc.).• Reporting Authoring, ETL.• Building/Maintaining efficient database schemas.• Database performance management and tuning.• Backup and recovery processes that can be executed by non-DBA technical support staff.• Data security (encryption, role based access control, auditing, best practices).• 5+ years of experience leading DBA resources and managing complex projects requiring interfacing with multiple stakeholders with a demonstrated ability to obtain consensus.SummaryIf the prospect of working within a high-functioning collaborative environment on an exciting Data initiatives intrigues you, then the Data Architect role with our Downtown Vancouver client could be the perfect opportunity for you!Please contact Corey Newson with your resume at:corey.newson@randstad.ca