Software Developer - ETL - Senior

ISG Search Inc; Toronto; On-site; CAD 95,000 - 130,000; Full time

Job summary

ISG Search Inc. seeks a senior Software Developer - ETL to design and build data warehousing, BI, reporting, and analytics capabilities in Toronto. The role emphasizes Oracle SQL/PL/SQL, Informatica mappings, and data movement from OLTP to DW and data marts.

You will develop and maintain BOE and Crystal Reports, and collaborate with the team to ensure timely delivery of analytics solutions, with adherence to SDLC practices.

Qualifications

• 5+ years’ experience in data warehousing, BI environment.
• 5+ years’ experience in Crystal reports, Power BI, and BOE reports.
• 5+ years’ experience in Oracle SQL and PL/SQL.
• 5+ years’ experience in Informatica.

Responsibilities

• Design, develop, test Oracle SQL/PL/SQL in data warehousing/BI.
• Develop and test Informatica mappings.
• Create ETL scripts to move data from OLTP to DW/data marts.
• Develop and maintain BOE reports; collaborate with management.

Skills

ETL development

Oracle PL/SQL

Informatica

Power BI

BOE reports

Crystal Reports

Data warehousing

SQL

Data modeling

Tools

Informatica

Crystal Reports

Power BI

BOE

Job description

Software Developer - ETL - Senior (BBBH12231) Toronto, Canada

Apply with Indeed

Software Developer - ETL

Responsibilities:

We are looking for strong developers to help in designing and developing data warehousing, BI, reporting and analytics.

• Perform analysis, design, developing, unit testing, defect fixing and other necessary tasks in a data warehousing and BI environment in Oracle PL/SQL


• Design, develop and test Informatica mappings


• Develop ETL scripts to transfer and transform data from OLTP database to Data Warehouse and Data marts


• Develop and maintain BOE reports


• Communicate your progress clearly and timely to the management team


• Must have skills in Crystal reports, Informatica, Power BI and BOE reporting.

Must have:

• 5+ years’ Experience with analysis, design, developing, unit testing, defect fixing 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 and PL/SQL.


• 5+ years’ experience in Designing, developing and testing in Informatica.


• Experience with technology solutions and development methodologies


• Experience in analyzing and designing changes to existing web-based software solutions


• Complete knowledge of SDLC methodologies, e.g. Agile development.


• Experience in RDBMS design concepts.


• Experience with Data Warehouse design, Reporting and ETL concepts.


• Experience with Data Warehouse architecture, design, dimensional modeling, development and deployment of business intelligence systems.

General Skills

• Experience in programming and analysis; specialized software package support at the specified experience level


• Ability to collaborate with IT Professionals throughout the Software Development Life Cycle


• Experience in structured methodologies for the development, design, implementation and maintenance of applications


• Experience in design, code, test, debug and document applications


• Experience in the use of object and/or third generation language development tools


• Experience in one or more programming languages


• Experience in application design, latest design patters, deployment and troubleshooting


• Experience with relational and hierarchical database technologies


• Experience in the use of information retrieval packages using 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 from diverse business area stakeholders and subject matter experts

Desirable Skills

• Knowledge and experience with programming Internet-ready applications


• Knowledge and experience in rapid application development (RAD) methodologies


• Knowledge and understanding of Information Management principles, concepts, policies and practices.


• Experience with middleware and gateways


• Experience reviewing, analyzing, and modifying product installation scripts including encoding, testing, debugging


• Ability to provide post-implementation support and resolve any post-implementation technical issues


• Experience conducting design walkthrough sessions with project team


• Knowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards


• Ability to provide user and system documentation as required.