ETL Developer

Job Description:

Responsibilities:

1. 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.
2. Support the branch in data migration and data integration.
3. Design technical solutions for data collecting and storing into our centralized data repository.
4. Develop detailed application programming specifications, Extract, Transform and Load (ETL) scripts, design data-driven logic and conducting unit tests.
5. Develop, test and implement the required technical solutions as well as ensure that the requirements in terms of data accuracy, quality are met.
6. Produce design artifacts and documentation which will allow future support of the implemented solutions.
7. Support the enhancement to extend the current automatic ETL process for other data source.
8. Develop coding, testing, and debugging to support centralization and standardization of data entry to achieve expedited public health case and contact initiation along with reporting and timely analytics.
9. Provide subject matter expertise to develop, test, support and maintain reports and transform and present data to support analytics.
10. Provide and support Case and Contact Management (CCM) solution to enable self-service reports which is a critical functionality for PHUs and other stakeholders.
11. Provide Business intelligence and data analytics, data warehouse design, dimensional data modeling, relational data modeling development and support.
12. Work to improve data transformation and reporting from the provincial CCM system.
13. Support Cognos administration and package creation.
14. Conduct research and assessment of options for technical design issues.
15. Contribute to design/development project plans, including work breakdown and resources estimates.
16. Provide Cognos report design, development and testing, Framework manager, Query Studio, Reports Studio, creation of dashboards, etc.
17. Conduct technical analysis, preparation of detailed programming specifications, program design, writing and/or generating code, and conduct unit tests.
18. Translate technical specifications for integration/sustainment and upgrade into working, tested application code.
19. Undertake proof of technology with test data to simulate application load and performance tuning related applications.
20. Provide software expertise in various computing platforms, operating systems, database technology, communication protocols, middleware and gateways.
21. Provide impact analysis, effort estimate and solution design/development for the centralization and standardization of data entry across systems.
22. Provide technical expertise and advice for the integration of the provincial Immunization Repository and the CCM solution.
23. Participate in the planning, technical analysis and design of solutions in support of infectious disease public health activities.
24. Conduct technical analysis, troubleshooting, and issue resolutions for production operational support of CCM reports and business models.
25. Provide end users support for their user-defined reports if required.
26. Resolving and implementing critical fixes and changes in CCM tools and utilities as per defects found by business and as per critical changes.
27. Provide application programming support for incident management, application functionality sustainment, performance tuning and technical documentation.
28. Work with Quality Assurance (QA) to code, test, and debug extensions/tools integration services.
29. Perform performance tuning as well as audit and ad hoc reporting per business requests.
30. Maintain Development environments and continue continuous Integration (CI) practice.
31. Improve the quality and accuracy of the data collected for the approximately 34 PHUs and 2282 PHU users.
32. Ensure availability of the Covid-19 tools and CCM solution for use by all Ontarians.

Experience and Skill Set Requirements:

Public Sector Experience – 5 points:

• Experience working with federal/provincial/broader public-sector healthcare providers.
• Knowledge of the provincial immunization system and OPS large complex IT Health related projects or equivalent.
• Experience with integration of Clinical IT Systems such as Client and Provider Registries.
• Knowledge of OPS Enterprise Architecture artifacts (or similar), processes and practices, and ability to produce technical documentation that comply with industry standard practices.
• Knowledge of industry standard such as Project Management Institute (PMI).
• Experience adopting and adhering to OPS Unified I&IT Project Methodology, OPS Enterprise Architecture and OPS Gating process, and OPS Standard Systems Development Methodologies.

Technical Skills – 50 points:

• 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.
• Relational databases (Oracle, MS-SQL), data modelling (relational & dimensional), advanced SQL, query optimization, data replication, administration.
• Scripting languages (Python, Unix shell).
• Cloud technologies (Azure, Google, AWS).
• Big data (Hadoop, Spark, Hive).
• Data analytics/machine learning.
• BI/Reporting (Cognos, SSRS) and Data Visualization tools (Power BI, Tableau).
• Knowledge and experience with NODE.JS and Python.
• Knowledge and experience with AWS technologies.
• Cognos 11.x report design, development and testing.
• Other Reporting tools, particularly Crystal Reports and Business Objects.
• Business intelligence and data analytics, data warehouse design, modeling, development and support.
• Informatica for data extraction, transformation, and loading.
• Oracle RDBMs(19c), SQL, PL/SQL, JSON, XML, Unix/Linux shell scripting.
• Database and Cognos performance tuning.
• Experience with version control system SVN or GitLab.
• Working knowledge of issue tracking system Jira.
• Enhanced CI/CD experience and DevOps methodologies and technologies an asset.
• Develop and support application monitoring using Elastic/Logstash/Kibana or Sematext.
• Knowledge of Java, JSON, XML, API calls, HL7/FHIR.

Core Skills and Experience – 35 points:

• 10+ years of experience with technical analysis, program code, detailed programming and reports specifications.
• Software in various computing platforms, operating systems, database technology, communication protocols, middleware and gateways.
• Developing and maintaining system design models, technical documentation and specifications.
• Conducting technical evaluation and assessment of options for technical design issues.
• Providing Business intelligence and data analytics, data warehouse design, dimensional data modeling, relational data modeling development and support.
• Support Cognos administration and package creation.
• Conduct research and assessment of options for technical design issues.
• Contributing to design/development project plans, including work breakdown and resources estimates.
• Maintaining development environments and continue continuous Integration (CI) practice.
• Working with business analysts to translate the business requirements and functional specifications into an application design.
• Working with technical systems specifications and translating them into working, tested applications.
• Work with Quality Assurance (QA) to code, test, and debug extensions/tools integration services.
• Analysis, design and development work on complex, multi-tier web-based applications.
• Proven technical leadership skills.
• Designing, developing and implementing applications that work across modern browsers and various platforms.
• Providing impact analysis, effort estimate and solution design/development for solution/software upgrades.
• Undertaking proof of technology with test data.
• Providing software expertise in various computing platforms, operating systems, database technology, communication protocols, middleware and gateways.
• Providing application programming support for incident management.
• Developing and maintaining system design models, technical documentation and specifications.
• Developing medical and clinical based systems.
• Web performance optimization.
• Conducting technical analysis, troubleshooting, and issue resolutions for production operational support.
• Knowledge of recognized accessibility laws, regulations, and standards.
• Ensuring compliance with architecture framework and system standards.
• Project management practices.
• Software Development Lifecycle (SDLC) end-to-end Agile/scrum and Waterfall methodologies.
• Continuous Integration (CI) practice.
• Knowledge and experience with leading-edge technologies.

General Skills – 10 points:

• Demonstrated strong leadership and people management skills.
• Exceptional analytical, problem solving and decision-making skills.
• Demonstrated strong interpersonal, verbal and written communication, and presentation skills.
• Proven troubleshooting and critical thinking experience.
• Demonstrated ability to apply strong listening skills to facilitate issue resolution.
• Effective consulting skills to engage with all stakeholders.
• Excellent customer service skills.
• A motivated, flexible, detail-oriented and creative team player.

MUST HAVES:

• 10+ years of experience with data warehousing design and development.
• Design, build, automate and optimize complex data ETL/ELT processes using Informatica.
• Experience with data migration and data integration.
• Experience with Mulesoft, Salesforce bulk load API is an asset.
• Informatica transformations, mappings and workflows.
• Relational databases (Oracle, MS-SQL), data modelling (relational & dimensional), advanced SQL, query optimization.