Software Developer â Senior

Connvertex Technologies Inc.; Toronto; On-site; CAD 70,000 - 90,000; Full time

Job summary

A leading technology firm in Toronto seeks a skilled BI Developer to perform analysis and development tasks in a data warehousing environment. You will design and test ETL scripts and Informatica mappings, leveraging 3+ years of experience in relevant tools like Oracle PL/SQL and Power BI. Strong communication skills and collaboration with IT professionals are essential in this full-time role.

Qualifications

• 3 years experience in data warehousing and BI environment.
• 3 years experience in SQL and PL/SQL.
• 3 years experience in designing and developing Crystal Reports and Power BI.

Responsibilities

• Perform analysis design and development in a data warehousing and BI environment.
• Design, develop and test Informatica mappings and ETL scripts.
• Translate technical specifications into working applications.

Skills

Oracle PL/SQL

Informatica

Crystal Reports

Power BI

BOE Reporting

Agile Development

C#/Java

Data Structures

Job description

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

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

Must have skills in Crystal reports Power BI and BOE reporting

Communicate your progress clearly and timely to the management team

Required to translate technical systems specifications into working tested applications. This includes :

developing detailed programming specifications

writing and / or generating code

Compiling data-driven programs maintaining and conducting unit tests

Resolves and troubleshoots technical problems which arise during the use and operation of software packages including technical assistance in implementation conversion and migrations.

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

Excellent analytical problem-solving and decision-making skills; verbal and written communication skills; interpersonal and negotiation skills

A team player with a track record for meeting deadlines

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.

Skills

Experience and Skill Set Requirements

Technical Skills - 70%

Must have :

3 years Experience with analysis design developing unit testing defect fixing and other necessary tasks in data warehousing BI environment.

3 years experience in designing and developing Crystal reports Power BI and BOE reports

3 years Experience in Designing developing and testing SQL and PL / SQL.

3 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.

Communication & other Skills - 30%

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 a technical and non-technical audience.

Key Skills

Spring,.NET,C / C++,Go,React,OOP,C#,AWS,Data Structures,Software Development,Java,Distributed Systems

Employment Type : Full-time

Experience : years

Vacancy : 1