Software Developer - ETL - Senior

• 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

• 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.

LanceSoft