developer (power b.i. - informatica) rfs number: it19-csc-0081-1, Toronto

posted
contact
randstad canada
job type
temporary
apply now

job details

posted
location
toronto, ontario
sector
technologies
job type
temporary
reference number
2201100PROEN
contact
randstad canada
apply now

job description

Our public sector client is looking for 2 programmer /developers who have experience with Data Warehousing and B.I. solutions for an initial 3 month contract starting in early January.



The operating Environment includes J2EE, Crystal Reports, Oracle SQL/PL SQL, Power BI, Oracle Database, Business Objects Universe and Dashboarding, WebI, and Bursting technologies. The source system is based on IBM CURAM.

The resource will be responsible for performing the following activities and producing deliverable:

• Perform analysis, design, developing, unit testing, defect fixing and other necessary tasks in order to successfully develop and maintain the Oracle PL/SQL, Informatica Crystal Reports, BOE based reports, Power BI based reports.

• Design, develop and test database, Informatica mappings ETL scripts to transfer and transform data from OLTP database to Data Warehouse and Datamarts based on Curam data model.

• Design, develop and test Power BI reports / analytical requirements. • Build Dashboards and visualizations using Power BI

• Communicate your progress clearly and timely to the management team

Rated Criterion Criterion Details
Technical Skills

• Experience with analysis, design, developing, unit testing, defect fixing and other necessary tasks in order to successfully develop and maintain the
Oracle PL/SQL, Crystal Reports

• Experience with Design, develop and test database ETL scripts to transfer and transform data from OLTP database to Data Warehouse and
Datamarts based on the requirements.

• Experience with Design, develop and test Power BI reports.

• Experience with Creating Interactive Dashboards using Power BI

• Experience with Data Warehouse design, Reporting and ETL concepts

• Knowledge and experience working with Curam Software is a plus

• Experience with ETL Informatica design and development of highly scalable ETL processes and Data Warehouse with experience in real-time
replication using CDC tools.

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

General Skills

• Experience with technology solutions and solutioning methodologies

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

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

• Experience in RDBMS design concepts

Communication Skills

• Excellent communication skills, both written and verbal: clear and concise. Able to communicate concepts and details to clients, development team
and testing team

• Excellent analytical, problem-solving, decision-making and interpersonal skills


Randstad Professionals Canada
Randstad Canada is committed to building a diverse workforce reflective of the diversity of Canada. As a result, we promote employment equity and encourage candidates, especially those who identify as a woman, an Aboriginal person, a person with a disability or a member of a visible minority group, and any others who may contribute to the diversification of our workforce, to apply.

Randstad Canada is also committed to developing an inclusive, barrier-free selection processes and work environments.If contacted in relation to a job opportunity, you should advise your Randstad Representative or your local Randstad branch in a timely fashion of the accommodation measures which must be taken to enable you to be assessed in a fair and equitable manner.Information received relating to accommodation measures will be addressed confidentially.

For all feedback on equity and accommodation needs, please contact your local Randstad Canada Branch.