Data warehousing contract job in Ottawa, Ontario

For quick response and complete job description you can reach the job poster at
Desk No: +1 647-560-0127
Email: j o h [email protected] com all the spaces, please)

It’s an Urgent Requirement and job is posted on 11th June 2020

Role: Data Warehousing
Location : Ottawa,ON
Job Type: Contract

Salary: Not known

Job Description:
Strong experience in Python using Excel POI API, XML API, Database programming and design, MS SQL Server, TSQL, Linux, Shell scripting
Experience with development, deployment, and support of large-scale OLTP and OLAP Data Warehousing applications in a production environment
Advanced knowledge of application, data and infrastructure architecture disciplines
Test-infected attitude (strong desire to perform thorough and exhaustive unit, integration and system testing)
Exposure to ETL tools such as Talend, SSIS etc.
Ability to liaise with Business, QA and Dev stakeholders to understand processes, Data and system specs and test data requirements.

Nice to have:
Understanding on BI tools
Ability to understand business process information and associated data flows for business domains such as Finance, Sales, HR, Services and Operations.

Job Responsibilities:
Collaborate with Business Analysts of different functional teams like HR, Finance, Sales, Product, to gather reporting requirements
Design a scalable, secure database model that is highly performant and meets the requirements of the business functions
Implement automation of data ingestion, data processing and data uploads on a pre-defined cadence
Lead the analysis of test data requests, defines test data characteristics, and the design, development, and implementation of test data automation.
Create and validate test data all phases of testing

Note : please have the submissions explicitly list the OLTP/OLAP applications in their experience history because the terms OLTP and OLAP may not necessarily be used directly. They should also explicitly list the depth and breadth of Python experience in use with other tools and APIs. We should only include profiles with strong Python experience and a listing of OLTP/OLAP applications.

Leave a Reply

Your email address will not be published. Required fields are marked *