11951

Maarut; Toronto; In loco; CAD 110.000 - 150.000; Tempo pieno

Descrizione del lavoro

Maarut is seeking a senior data/ETL engineer to design OLAP/OLTP solutions using Oracle 12c, PL/SQL and data warehousing concepts. You will translate business requirements into scalable technical designs and deliver tested applications.

You will work with Informatica, Cognos, and other BI tools, implement CI practices, tune performance, and produce technical documentation for a large healthcare-related data platform used by Ontario PHUs.

Competenze

• Experience designing OLAP/OLTP with Oracle 12c.
• Advanced SQL and data warehousing.
• Experience with data integration tools like Informatica.
• Strong knowledge of Cognos reporting.
• Public sector healthcare experience is a plus.
• Experience with UI accessibility standards is a plus.

Mansioni

• Develop extensions/tools for DHIR; support upgrades and new requirements.
• Translate technical specifications into working applications; design and coding.
• Code, test, debug; perform unit tests; support CI practices.
• Work with QA to code, test, and debug extensions/tools integration services.
• Maintain development environments and CI pipelines; performance tuning.
• Improve data quality for 34 PHUs and 2282 PHU users; ensure availability for Ontarians.
• Provide technical documentation and impact analysis for upgrades and new features.
• Collaborate with stakeholders to ensure alignment with OPS methodologies and standards.

Conoscenze

Oracle PL/SQL

Data modeling

SQL optimization

DW/ETL design

Cognos reporting

Informatica

Java

JSON/XML/REST

HL7/FHIR

CI/DevOps

UI design principles

Leadership

Strumenti

Informatica

Cognos

Crystal Reports

Business Objects

Descrizione del lavoro

• Develop coding, testing, and debugging to support existingextensions/tools such as IRT, De-Dup, OIA, Immunization Forecaster and PRUpload
  
• Conduct technical analysis, preparation of detailedprogramming specifications, program design, writing and/or generating code, andconduct unit tests
  
• Translate technical specifications for sustainment andupgrade into working, tested applications
  
• Undertake proof of technology with test data to simulateapplication load and performance tuning related applications
  
• Provide software expertise in various computing platforms,operating systems, database technology, communication protocols, middleware andgateways
  
• Provide impact analysis, effort estimate and solutiondesign/development for supported solutions due to DHIR solution upgrades,software upgrades or any new requirements (e.g. Panorama 4.4 upgrades, PHUmerge and more)
  
• Provide application programming support for incidentmanagement, application functionality sustainment, performance tuning andtechnical documentation
  
• Work with Quality Assurance (QA) to code, test, and debugextensions/tools integration services
  
• Maintain Development environments and continue continuousIntegration (CI) practice
  
• Improve the quality and accuracy of the data collected forthe approximately 34 PHUs and 2282 PHU users
  
• Ensure availability of the DHIR extensions/tools for use byall Ontarians.
  

Requirements

Experience and Skill Set Requirements:

Must Have:

• Design and development of Oracle(12c) for OLAP and OLTPapplications, including PL/SQL, Oracle stored procedure, packages, functions,triggers, ref cursors, dynamic SQLs, DBMS packages, etc.
  
• Advanced SQL skills, optimized database queries, and dataarchitecture, database design, database modeling
  
• Data Warehouse design and development, Database performancetuning, Automation
  
• Working with business analysts to translate the businessrequirements and functional specifications into an application designappropriate to meet the business and operational/IT needs
  

Skill Set Requirements:

Public Sector Experience:

• Experience working with federal/provincial/broaderpublic-sector healthcare providers
  
• Knowledge of the provincial immunization system and OPSlarge complex IT Health related projects or equivalent
  
• Experience with integration of Clinical IT Systems such asClient and Provider Registries
  
• Knowledge of OPS Enterprise Architecture artifacts (orsimilar), processes and practices, and ability to produce technicaldocumentation that comply with industry standard practices
  
• Knowledge of industry standard such as Project ManagementInstitute (PMI)
  
• Experience adopting and adhering to OPS Unified I&ITProject Methodology, OPS Enterprise Architecture and OPS Gating process, andOPS Standard Systems Development Methodologies.
  

Technical Skills:

10+ years of experience with:

• Design and development of Oracle(12c) for OLAP and OLTPapplications, including PL/SQL, Oracle stored procedure, packages, functions,triggers, ref cursors, dynamic SQLs, DBMS packages, etc.
  
• Demonstrated ability to create normalized database schemasutilizing data modeling discipline. Understanding of normalization,de-normalization, and the difference between the two. Ability to create schemasfor both OLTP and OLAP databases.
  
• Advanced SQL skills, optimized database queries, and dataarchitecture, database design, database modeling
  
• Data Warehouse design and development, Database performancetuning, Automation
  
• Informatica for data extraction, transformation, andloading, initial setup and other data management purposes
  
• Cognos report design and development, Framework manager,Query Studio, Reports Studio, creation of dashboards, etc. Other reportingtools would also be an asset, particularly Crystal Reports and Business Objects
  
• Knowledge of Java, JSON, XML, API calls, HL7/FHIR, Restfulweb services
  
• Knowledge of the provincial immunization system.
  

Core Skills and Experience:

10+ years of experience with:

• Working with business analysts to translate the businessrequirements and functional specifications into an application designappropriate to meet the business and operational/IT needs
  
• Working with technical systems specifications andtranslating them into working, tested applications for large, complex, missioncritical applications
  
• Analysis, design and development work on complex, multi-tierweb-based applications, micro-services architecture, mobile, and off-the-shelfsolutions
  
• Proven technical leadership skills with ability to identifyareas for improvement, and recommend solutions
  
• Using and applying extensive knowledge of User Interface(UI) design principles across a variety of applications, platforms and devices
  
• Technical analysis, program code, detailed programming andreports specifications, program design, writing and/or generating code, andconducting tests
  
• Developing and maintaining system design models, technicaldocumentation and specifications
  
• Conducting technical evaluation and assessment of optionsfor technical design issues, application figuration aspects and integrationcapabilities, related tools and utilities, gap analysis of integrationcomponents to technical requirements/specifications/documentation
  
• Developing medical and clinical based systems
  
• Web performance optimization
  
• Various computing platforms, operating systems, databasetechnology, communication protocols, middleware and gateways
  
• Conducting technical analysis, trouble-shooting, and issueresolutions for production operational support of reports, and other componentsand utilities
  
• Knowledge of recognized accessibility laws, regulations, andstandards (e.g., W3C, WCAG) or other specific accessibility standards, andexperience in usability, accessibility and compliance testing
  
• Ensuring compliance with architecture framework and systemstandards, and Agile Development Methodology
  
• Project management practices, and ability to contribute todesign/development project plans, including work breakdown, resource estimates,and status reports
  
• Experience with Software Development Lifecycle (SDLC)
  
• Continuous Integration (CI) practice and DEVOPSmethodologies and technologies
  
• Knowledge and experience with leading-edge technologies,design criteria including usability, security, and privacy for web and mobileapplications.
  

General Skills:

• Demonstrated strong leadership and people management skills
  
• Exceptional analytical, problem solving and decision-makingskills
  
• Demonstrated strong interpersonal, verbal and writtencommunication, and presentation skills
  
• Proven troubleshooting and critical thinking experience
  
• Demonstrated ability to apply strong listening skills tofacilitate issue resolution
  
• Effective consulting skills to engage with all stakeholderswith proven track record for building strong working relationships
  
• Excellent customer service skills, including tact anddiplomacy to ensure client needs are managed effectively
  
• A motivated, flexible, detail-oriented and creative teamplayer with perseverance, excellent organization and multi-tasking abilities,and a proven track record for meeting strict deadlines.