Senior ETL & BI Data Warehouse Engineer

S M Software Solutions Inc; Toronto; On-site; CAD 90,000 - 130,000; Full time

Job summary

S M Software Solutions Inc. seeks a Senior Software Developer – ETL to support data warehousing, BI reporting and analytics for the EOIS environment in Toronto.

The role emphasizes Oracle SQL/PL/SQL, Informatica, Crystal Reports, Power BI and BOE reporting in an Agile SDLC context. Responsibilities include designing, developing and testing ETL mappings, dashboards, and BI reports, with a focus on data quality and timely delivery.

Qualifications

• 5+ years’ experience in data warehousing, BI environment.
• 5+ years’ experience in Crystal Reports, Power BI, and BOE reporting.
• 5+ years’ experience in Oracle SQL/PLSQL development and testing.
• 5+ years’ experience in Informatica.
• Knowledge of SDLC methodologies, e.g. Agile.

Responsibilities

• Design and develop data warehousing, BI, reporting and analytics solutions.
• Perform analysis, design, development, testing, and defect fixing in Oracle PL/SQL.
• Design, develop and test Informatica mappings.
• Develop ETL scripts to move data to Data Warehouse and marts.
• Develop and maintain BOE reports.
• Communicate progress to management.
• Must have skills in Crystal Reports, Informatica, Power BI and BOE reporting.

Skills

Data warehousing

BI reporting

ETL development

Oracle SQL/PLSQL

Analytical skills

Agile development

SDLC

Tools

Informatica

Crystal Reports

Power BI

BOE (Business Objects Enterprise)

Oracle SQL/PLSQL

Job description

S M Software Solutions Inc. seeks a Senior Software Developer – ETL to support data warehousing, BI reporting and analytics for the EOIS environment in Toronto.

The role emphasizes Oracle SQL/PL/SQL, Informatica, Crystal Reports, Power BI and BOE reporting in an Agile SDLC context. Responsibilities include designing, developing and testing ETL mappings, dashboards, and BI reports, with a focus on data quality and timely delivery.