Senior BI Developer

Zohorecruit; Toronto; Hybrid; CAD 90,000 - 130,000; Full time

Job summary

Symbiotic Digital is seeking a strong Software Developer – ETL to support data warehousing, BI reporting, and analytics. Onsite work in Canada’s Toronto area with a focus on Oracle SQL/PLSQL, Informatica, Crystal Reports, and Power BI.

You will design, develop, and test ETL mappings and dashboards, collaborate with IT across the SDLC, and deliver robust data solutions. The role requires 5+ years in DW/BI environments, expertise in Informatica and BOE reporting, and strong analytical and

Qualifications

• 5+ years in data warehousing and BI development tasks.
• Proven experience with Crystal Reports, Power BI, and BOE reporting.
• Strong Oracle SQL/PLSQL design, development, and testing skills.
• Extensive Informatica ETL design, development, and testing.
• Knowledge of SDLC, Agile, and RDBMS design concepts.
• Experience with data warehouse architecture and dimensional modeling.

Responsibilities

• Analyze, design, develop, test, and fix defects in DW/BI projects.
• Design, develop, and test Informatica mappings.
• Develop ETL scripts to move data from OLTP to DW/Data Marts.
• Develop and maintain BOE reports.
• Communicate progress clearly to management.
• Must have skills in Crystal Reports, Informatica, Power BI, and BOE reporting.

Skills

Informatica

Power BI

Crystal Reports

BOE reporting

Oracle SQL/PLSQL

Data warehousing

BI reporting

SDLC & Agile

RDBMS design

Dimensional modeling

Tools

Informatica

Power BI

Crystal Reports

BOE

Oracle SQL/PLSQL

Job description

We are seeking a strong Software Developer – ETL to support the design and development of data warehousing, Business Intelligence, reporting, and analytics solutions.

The operating environment includes JEE, CURAM, Crystal Reports, Oracle SQL/PL SQL, Power BI, Oracle Database, Business Objects Universe and Dashboarding, WebI, Bursting technologies, and Informatica ETL.

Work Arrangement: Onsite

Key Responsibilities

• Perform analysis, design, development, unit testing, defect fixing, and other necessary tasks in a data warehousing and BI environment using Oracle PL/SQL.
  
• Design, develop, and test Informatica mappings.
  
• Develop ETL scripts to transfer and transform data from OLTP databases to the Data Warehouse and Data Marts.
  
• Develop and maintain BOE reports.
  
• Communicate progress clearly and in a timely manner to the management team.
  
• Must have skills in Crystal Reports, Informatica, Power BI, and BOE reporting.
  

General Skills

• Experience in programming and analysis and 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 designing, coding, testing, debugging, and documenting 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 patterns, 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.
  
• Excellent analytical, problem-solving, and decision-making skills.
  
• Strong verbal and written communication, interpersonal, and negotiation skills.
  
• Team player with a track record of meeting deadlines.
  
• 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, and debugging.
  
• Ability to provide post-implementation support and resolve post-implementation technical issues.
  
• Experience conducting design walkthrough sessions with project teams.
  
• Knowledge and understanding of the Accessibility for Ontarians with Disabilities Act (AODA) and related regulations and standards.
  
• Ability to provide user and system documentation as required.
  

Experience and Skill Set Requirements

Technical Skills – 70%

Must Have:

• 5+ years of experience with analysis, design, development, unit testing, defect fixing, and other necessary tasks in data warehousing and BI environments.
  
• 5+ years of experience designing and developing Crystal Reports, Power BI, and BOE reports.
  
• 5+ years of experience designing, developing, and testing Oracle SQL and PL/SQL.
  
• 5+ years of experience designing, developing, and testing in Informatica.
  
• Experience with technology solutions and development methodologies.
  
• Experience analyzing and designing changes to existing web-based software solutions.
  
• Complete knowledge of SDLC methodologies, including Agile development.
  
• Experience with 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.
  

Communication & Other Skills – 20%

• Ability to build good working relationships.
  
• Positive team player.
  
• Good verbal and written communication skills.
  
• Good analytical and problem-solving skills.
  
• Excellent ability to present to technical and non-technical audiences.
  

Knowledge of Methodologies – 10%

• Working knowledge of SDLC and Agile development methodology.
  
• Demonstrated knowledge and experience with RDBMS design concepts.
  
• Demonstrated experience identifying risks and providing solutions.
  
• Strong analytical and problem-solving skills.
  
• Ability to mentor junior developers and lead technical discussions.
  

About Symbiotic Digital.

Symbiotic Digital provides the IT Experts you need that solve problems and get things done. See what the top 2% in their field can do for you. (Symbiotic Digital is a division of Symbiotic Group Inc.) We serve customers in two ways, we provide:

• Digital Experts: IT Consulting expertise. Bright Minds That Produce Proven Results
• Recruitment: Find The Right People You Need

Serving IT & Business leaders, Symbiotic Digital provides a business system that enable us to provide the Expert Technical staff needed to solve challenging business and IT problems. IT leaders in the most reputable organizations in Canada have relied on Symbiotic Digital to help them staff difficult assignments with proven Experts uniquely evaluated by our proven QMS- Quality Management System Staff Development Model. We are a 100% Indigenous owned company.