SQL Developer no Admin

Job Title: SQL Developer (no Admin)

Location: Montreal QC Hybrid

Exp: 48 years

No. of positions: 1

Note: Local candidates only Candidates from Ottawa acceptable if they are willing to appear for L2/client interviews in person at Montreal office and relocate post selection.

Description:

SQL Developer role available in Montreal supporting an insurance client needing proficiency in SQL programming and database design principles.

The ideal candidate will have a deep understanding of ETL and SQL and compatible coding languages (SQL Python VBA etc).

Design develop and maintain complex SQL databases and data warehouses
Optimize database performance through efficient query tuning indexing and partitioning strategies.

Develop implement and optimize ETL processes executing related tasks such as extraction transformation loading integration and error handling.

Gather interpret and document complex business line information to support decisionmaking as well as target state employee training adapting as needed.

Collaborate closely with crossfunctional stakeholders to ensure developed solutions are duly tested and fulfill specified business requirements.

Contribute to the design development and implementation of data warehouse and data integration solutions.

Desired skills:

• Good understanding of Microsoft SSIS SSRS development and deployment
• Capability to deploy the SSIS pkgs using catalog scripts and monitor jobs scheduled job
• Knowing how to send alert and failure notifications for scheduled SSIS and Jobs
• Experience working with and configuring datadriven applications.
• Understanding of translation between multiple file formats
• Ability to use scripting languages ETL tools and methodologies to map data between various formats.
• Experience with Reporting tools (ex. Crystal Reports and SQL Reporting Services)
• Strong technical skills with PL SQL Stored procedures Functions
• TSQL / Stored Procedure development on MS SQL database