Job Title

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