11669

Zohorecruit; Toronto; On-site; CAD 100,000 - 130,000; Full time

Job summary

Zohorecruit is seeking a Senior Software Developer - ETL to join our Toronto team. You will design, develop, and optimize data warehousing, BI reporting, and analytics initiatives that support Employment Ontario programs.

You will work with Oracle SQL/PL SQL and Informatica to move data from OLTP to Data Warehouse and data marts, create Crystal Reports and Power BI dashboards, and deliver robust BI solutions across teams.

Qualifications

• 5+ years of experience in data warehousing, BI environment.
• 5+ years designing and developing Crystal Reports, Power BI, and BOE reports.
• 5+ years designing, developing, and testing Oracle SQL/PL SQL.
• 5+ years designing, developing and testing in Informatica.

Responsibilities

• Perform analysis, design, development, unit testing, and defect fixing in a data warehousing/BI environment.
• Design, develop and test Informatica mappings.
• Develop ETL scripts to transform data from OLTP to Data Warehouse and Data Marts.
• Develop and maintain BOE reports.
• Communicate progress clearly to management.
• Must have skills in Crystal Reports, Informatica, PowerBI and BOE reporting.

Skills

Data warehousing

ETL design

SDLC/Agile

SQL proficiency

Analytical thinking

Communication

Team collaboration

Tools

Crystal Reports

Power BI

BOE reports

Oracle SQL/PL SQL

Informatica

Job description

RQ11635 - Software Developer - ETL - Senior

• ‘Employment Ontario’ is one of the major programs deliveredby the Employment and Training Division of the Ontario Ministry of Training,Colleges and Universities. Employment Ontario helps the citizens of Ontariogain the training, skills and experience to achieve their goals.
  
• The Employment Ontario Information Systems (EOIS) is themajor IT system that supports the administration of these programs. Applicationsubsystems under EOIS include CaMS (Case Management System), Service ProviderlifeCycle (SPL), EO Self Service (EOSS), APPR (Apprenticeship), OJG (OntarioJob Grant), and APPR AOL (Apply OnLine).
  
• The operating Environment includes JEE, CURAM, CrystalReports, Oracle SQL/PL SQL, Power BI, Oracle Database, Business ObjectsUniverse and Dashboarding, WebI, Bursting technologies, and Informatica ETL.
  

Responsibilities:

This request is for strong developers to help in designingand developing data warehousing, BI, reporting and analytics.

• Perform analysis, design, developing, unit testing, defectfixing and other necessary tasks in a data warehousing and BI environment inOracle PL/SQL
  
• Design, develop and test Informatica mappings
  
• Develop ETL scripts to transfer and transform data from OLTPdatabase to Data Warehouse and Data marts
  
• Develop and maintain BOE reports
  
• Communicate your progress clearly and timely to themanagement team
  
• Must have skills in Crystal reports, Informatica, PowerBI and BOE reporting
  

General Skills:

• Experience in programming and analysis; specialized softwarepackage support at the specified experience level
  
• Ability to collaborate with IT Professionals throughout theSoftware Development Life Cycle
  
• Experience in structured methodologies for the development,design, implementation and maintenance of applications
  
• Experience in design, code, test, debug and documentapplications
  
• Experience in the use of object and/or third generationlanguage development tools
  
• Experience in one or more programming languages
  
• Experience in application design, latest design patters,deployment and troubleshooting
  
• Experience with relational and hierarchical databasetechnologies
  
• Experience in the use of information retrieval packagesusing query languages
  
• Experience with one or more communications protocols
  
• Experience in structured methodologies for the design,development, implementation and maintenance of applications
  
• Experience eliciting and documenting information fromdiverse business area stakeholders and subject matter experts
  
• Excellent analytical, problem-solving and decision-makingskills; verbal and written communication skills; interpersonal and negotiationskills
  
• A team player with a track record for meeting deadlines
  
• Knowledge and experience with programming Internet-readyapplications
  
• Knowledge and experience in rapid application development(RAD) methodologies
  
• Knowledge and understanding of Information Managementprinciples, concepts, policies and practices.
  
• Experience with middleware and gateways
  
• Experience reviewing, analyzing, and modifying productinstallation scripts including encoding, testing, debugging
  
• Ability to provide post-implementation support and resolveany post-implementation technical issues
  
• Experience conducting design walkthrough sessions withproject team
  
• Knowledge and understanding of Accessibility for Ontarianswith Disability Act (AODA) and related regulations and standards
  
• Ability to provide user and system documentation asrequired.
  

Requirements

Experience and Skill Set Requirements:

Must Haves:

• 5+years’ Experience with analysis, design, developing, unit testing, defectfixing and other necessary tasks in data warehousing, BI environment.
  
• 5+years’ experience in designing and developing Crystal reports, Power BI,and BOE reports
  
• 5+years’ experience in Designing, developing and testing Oracle SQL andPL/SQL.
  
• 5+years’ experience in Designing, developing and testing in Informatica.
  
• Experiencewith technology solutions and development methodologies
  
• Experiencein analyzing and designing changes to existing web-based softwaresolutions
  
• Completeknowledge of SDLC methodologies, e.g. Agile development.
  
• Experiencewith Data Warehouse design, Reporting and ETL concepts.
  
• Experiencewith Data Warehouse architecture, design, dimensional modeling,development and deployment of business intelligence systems.
  

Skill Set Requirements:

Technical Skills:

• 5+years’ Experience with analysis, design, developing, unit testing, defectfixing and other necessary tasks in data warehousing, BI environment.
  
• 5+years’ experience in designing and developing Crystal reports, Power BI,and BOE reports
  
• 5+years’ experience in Designing, developing and testing Oracle SQL andPL/SQL.
  
• 5+years’ experience in Designing, developing and testing in Informatica.
  
• Experiencewith technology solutions and development methodologies
  
• Experiencein analyzing and designing changes to existing web-based softwaresolutions
  
• Completeknowledge of SDLC methodologies, e.g. Agile development.
  
• Experiencewith Data Warehouse design, Reporting and ETL concepts.
  
• Experiencewith Data Warehouse architecture, design, dimensional modeling,development and deployment of business intelligence systems.
  

Communication & other Skills:

• Abilityto build good working relationships.
  
• Positiveteam player.
  
• Goodverbal and written communication skills.
  
• Goodanalytical and problem-solving skills.
  
• Excellentability to present to a technical and non-technical audience.
  

Knowledge of Methodologies:

• Workingknowledge of SDLC and the Agile development methodology.
  
• Demonstratedknowledge and experience with RDBMS design concepts.
  
• Demonstratedexperience in identifying risk and providing solutions.
  
• Stronganalytical and problem-solving skills.
  
• Abilityto mentor junior developers and lead technical discussions.