Sr. Software Developer

Overview

Job Description: RQ09622 - Sr. Software Developer - ETL. Downtown, Toronto (St. Clair W). Hybrid - Candidate MUST work 3 days onsite and 2 days remote. Starting October 20, resources are expected to come into the office 4 days per week. Starting January 5, resources are expected to come into the office 5 days per week. This is subject to change based on manager discretion. Contract 6 months, possible extension.

Responsibilities

- Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities.

- Translate technical systems specifications into working, tested applications, including developing detailed programming specifications, writing and/or generating code, compiling data-driven programs, maintaining, and conducting unit tests.

- Resolve and troubleshoot technical problems during the use and operation of software packages, including technical assistance in implementation, conversion and migrations.

Must-Haves

- Design, build, automate and optimize complex data ETL/ELT processes using PL/SQL and equivalent.

- Cloud technologies (Azure, Google, AWS).

- Advanced skills and hands-on experience with Azure SQL Server and Azure Data Factory.

- PL/SQL for data extraction, transformation, and loading; initial setup and other ETL experience management and support (troubleshooting, performance tuning, failover and recovery).

- Working knowledge of issue tracking system JIRA, Azure DevOps.

Nice-To-Have

- Public Sector experience.

FULL RESUME EVALUATION CRITERIA

- Technical Skills – 40%

- 5+ years of experience with data warehousing design and development (extraction, transformation, loading) into star/snowflake schemas.

- Design, build, automate and optimize complex data ETL/ELT processes using PL/SQL and equivalent.

- Writing complex procedures/pkg/views/scripts for data denormalization, extraction, cleansing, transformation, and loading.

- Creating data assets (denormalized) from highly normalized Oracle databases and loading into other DBMS (Microsoft SQL Server, PostgreSQL, etc.).

- Relational databases, data modelling (relational & dimensional), advanced SQL, query optimization, data replication, administration.

- Advanced SQL skills (PL/SQL, T-SQL), scripting languages (Python, Unix shell).

- Cloud technologies (Azure, Google, AWS); Azure SQL Server and Azure Data Factory; creating Data Factory pipelines for copy activity and custom Azure development.

- PL/SQL for data extraction, transformation, loading; initial setup and other ETL experience management and support (troubleshooting, performance tuning, failover and recovery).

- ElasticSearch for search/reporting, performance tuning and optimization.

- JIRA, Azure DevOps; GitHub for version control and data model changes.

- Oracle tools and data warehousing topics (OEM, Data Guard, Exadata, etc.).

- Data migration and integration across different platforms; recovery and refresh production and Dev/UAT/Test using RMAN to SAN storage.

Core Skills – 30%

- Technical analysis, program code, detailed programming and reports specifications, program design, writing and unit tests.

- Software in various computing platforms, operating systems, database technology, communication protocols, middleware and gateways.

- Developing and maintaining system design models, technical documentation and specifications.

- Technical evaluation and assessment of options for technical design issues, application configuration, and integration capabilities.

- Business intelligence and data analytics, data warehouse design, relational data modeling development and support.

- Contributing to design/development project plans, work breakdown, and resource estimates.

- Translating business requirements into application design with IT needs.

- Working with technical systems specifications and translating them into working, tested applications for large, complex, mission-critical apps.

General Skills – 25%

- Exceptional analytical, problem solving and decision-making skills; strong interpersonal, verbal and written communication.

- Proven troubleshooting and critical thinking experience; strong listening skills to facilitate issue resolution.

- Effective consulting skills to engage with stakeholders and build strong working relationships.

- Excellent customer service skills, tact and diplomacy to manage client needs effectively.

- Motivated, flexible, detail-oriented and creative team player with perseverance, organization and multi-tasking abilities; proven track record for meeting deadlines.

#J-18808-Ljbffr