Data Warehouse Engineer Jobs

Job Title: Data warehouse / Database Developer

Location: Montreal, QC (Onsite)

Duration: 12 Months

Pay rate: $70+/hr on T4

Direct Responsibilities

Principal Duties: -

The scope of the engagement will include but not be limited to:

• Apply strong performance tuning knowledge in SQL to interpret plans, identify bottlenecks in queries and remediate them.
• Provide weekly progress reports of work performed.
• Work with the project team to assist in other aspects of the project.
• Apply strong knowledge in Python and Shell Scripting required for file processing and database connections.
• Use Data Modeling, Database Query Optimization and Data Access techniques and concepts.
• Document, effectively track and resolve issues in a timely manner during the development and testing phases (work with the team and end users as appropriate)
• Code, maintain, test, and provide code reviews for developed processes and procedures (e.g., queries, scripts, stored procedures, database objects, indices, triggers, etc.)
• Closely interact with onshore stakeholders and onshore teams on a regular basis.
• Review, understand, interpret, and transform clearly defined technical specifications into data warehouse, database and/or business intelligence solutions.
• Follow and adhere to client development standards, the software development lifecycle, vendor application / project standards and guidelines.
• Create use cases and assist in UAT testing efforts for the developed solutions.
• Work proactively to solve issues and problems.
• Perform detailed data analysis (i.e., determine the structure, content, and quality of the data through examination of source systems and data samples)
• Use Database knowledge in areas of import and export, users, roles, privileges, schema and object management, session monitoring, etc.
• Perform problem analysis, structured analysis, design, and programming techniques.
• Embrace the opportunity to take on special projects outside of specific roles and responsibilities.

Contributing Responsibilities

• Contribute towards knowledge sharing initiatives across the team.
• Contribute towards Innovation and Creativity initiatives across the team and the organization.

Technical & Behavioural Competencies

• Java/JavaScript
• Good understanding of SDLC processes.
• Good understanding of concepts and techniques for design, development, and implementation of ETL and data quality
• Python Scripting
• Good working knowledge of data warehouse, database and business intelligence environments, concepts, and techniques
• Oracle: Warehouse Builder, Data Integrator
• Oracle: SQL, PL/SQL (Mandatory)
• Unix Scripting
• T-SQL, MS SQL