RQ07129 Software Developer - ETL

This is a contract position for a Software Developer - ETL for our public sector client.

Work location : North York

Duration : Twelve Months

7.25 hours / day

This is a Hybrid role that requires the candidate to be onsite 3 days of the week (This is a mandatory requirement of the role and is non-negotiable outside of exceptional circumstances.)

Advantages

Good compensation working on projects that will make a difference to the people of Ontario.

Responsibilities

• Support the branch in developing and implementing the technical solutions needed as well as providing operational support ensuring that any technical glitch can be quickly addressed
• Support the branch in data migration and data integration
• Design technical solutions for data collecting and storing into our centralized data repository
• Develop detailed application programming specifications, Extract, Transform and Load (ETL) scripts, design data-driven logic and conducting unit tests
• Develop, test and implement the required technical solutions as well as ensure that the requirements in terms of data accuracy, quality are met
• Produce design artifacts and documentation which will allow future support of the implemented solutions
• Support the enhancement to extend the current automatic ETL process for other data source from Contact+ (online tool for citizens to provide contact details), the Ontario Laboratory Information System (OLIS), Integrated Public Health Information System (iPHIS), iPHIS Cognos Reporting Network (CRN), the Provincial Client Registry (PCR) and Enterprise Master Patient Index (EMPI) service
• Develop coding, testing, and debugging to support centralization and standardization of data entry to achieve expediated public health case and contact initiation along with reporting and timely analytics
• Provide subject matter expertise to develop, test, support and maintain reports and transform and present data to support analytics
• Provide and support Case and Contact Management (CCM) solution to enable self-service reports which is a critical functionality for PHUs and other stakeholders
• Provide Business intelligence and data analytics, data warehouse design, dimensional data modeling, relational data modeling development and support
• Work to improve data transformation and reporting from the provincial CCM system
• Support Cognos administration and package creation
• Conduct research and assessment of options for technical design issues
• Contribute to design / development project plans, including work breakdown and resources estimates
• Provide Cognos report design, development and testing, Framework manager, Query Studio, Reports Studio, creation of dashboards, etc.
• Conduct technical analysis, preparation of detailed programming specifications, program design, writing and / or generating code, and conduct unit tests
• Translate technical specifications for integration / sustainment and upgrade into working, tested application code
• Undertake proof of technology with test data to simulate application load and performance tuning related applications
• Provide software expertise in various computing platforms, operating systems, database technology, communication protocols, middleware and gateways
• Provide impact analysis, effort estimate and solution design / development for the centralization and standardization of data entry across systems
• Provide technical expertise and advice for the integration of the provincial Immunization Repository and the CCM solution
• Participate in the planning, technical analysis and design of solutions in support of infectious disease public health activities, including infectious disease case, contact, and outbreak investigation and management, immunization administration, and vaccine distribution and delivery (inventory)
• Conduct technical analysis, troubleshooting, and issue resolutions for production operational support of CCM reports and business models and other components and utilities
• Provide end users support for their user-defined reports if required
• Resolving and implementing critical fixes and changes in CCM tools and utilities as per defects found by business and as per critical changes
• Provide application programming support for incident management, application functionality sustainment, performance tuning and technical documentation
• Work with Quality Assurance (QA) to code, test, and debug extensions / tools integration services
• Perform performance tuning as well as audit and ad hoc reporting per business requests
• Call Provide software expertise in various computing platforms, operating systems, database technology, communication protocols, middleware and gateways
• Maintain Development environments and continue continuous Integration (CI) practice
• Improve the quality and accuracy of the data collected for the approximately 34 PHUs and 2282 PHU users
• Ensure availability of the Covid-19 tools and CCM solution for use by all Ontarians.

Qualifications

10+ years of experience with :

• Data warehousing design and development with focus on extracting, transforming data coming from various data sources and loading into star / snowflake schemas
• Design, build, automate and optimize complex data ETL / ELT processes using Informatica and equivalent
• Experience with data migration and data integration
• Experience with Mulesoft, Salesforce bulk load API is an asset
• Informatica transformations, mappings and workflows (experience with other ETL tools such as DataStage, ODI or Microsoft SSIS could also be considered)
• Relational databases (Oracle, MS-SQL), data modelling (relational & dimensional), advanced SQL, query optimization, data replication, administration

Summary

If interested and qualified for this role, please apply today for immediate consideration!

Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees.

In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary / gender non-conforming;

Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.

Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle.

We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.

ca to ensure their ability to fully participate in the interview process.