Sr. Software Developer - ETLmicro1 • Toronto, ON, CA
Sr. Software Developer - ETL
micro1 • Toronto, ON, CA
30+ days ago
Job type
- Full-time
Job descriptionDesign, 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. Public Sector experience. 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. 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. 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.
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
Nice-To-Have
FULL RESUME EVALUATION CRITERIA
Core Skills – 30%
General Skills – 25%
#J-18808-Ljbffr
Create a job alert for this search
Sr Software Developer • Toronto, ON, CA
Similar jobs
We are seeking a skilled ETL Tester with substantial hands-on experience in advanced SQL and Python.This role is open to candidates with either a Quality Assurance (QA) or Developer background, pro...Show more
HireKraft | SAP SCM Consultant – Contract (Toronto, ON).SAP staffing agency with over 20 years of experience connecting exceptional SAP professionals with leading organizations across North A...Show more
CAROBOT Learning and Research Organization is an Ontario-based not-for-profit corporation focusing on promoting and teaching technology-related topics.
We have multiple openings available.We are loo...Show more
The SAP PO / CPI Developer is responsible for designing, developing, testing, deploying, and supporting integration scenarios using SAP Process Orchestration (PI / PO) and Cloud Platform Integration.Th...Show more
Overview Veeva Systems is a mission-driven organization and pioneer in industry cloud, helping life sciences companies bring therapies to patients faster.
As one of the fastest-growing SaaS companie...Show more
A leading banking institution in Toronto is seeking a Software Engineer (SRE) to enhance capital markets products and analytics platforms.
This role involves ensuring system reliability, optimizing ...Show more
A leading Ontario government enterprise seeks a Director, Release Management to enhance testing and release management processes.
You will lead the Testing Centre of Excellence, manage release plann...Show more
Our client is a leading provider of innovative healthcare technology solutions focused on organ transplantation and allocation.
They deliver powerful, scalable platforms that support national-level ...Show more
Senior Software Engineer II, Smart Trailer & Connected Equipment Base pay range : CA$142,800.Schedule : Remote, Canada only.
relocation assistance not provided.This range is provided by Samsara.Your ...Show more
A premier recruitment agency is looking for a Senior Recruiter for advanced manufacturing in downtown Toronto.This role involves system design and integration, project management, and working with ...Show more
Get AI-powered advice on this job and more exclusive features.We Are Cognizant Artificial Intelligence.Digital technologies, including analytics and AI, give companies a once-in-a-generation opport...Show more
We’re looking for a software engineer to join us in building the future of business banking and cash management.You’ll work closely with other engineers, product, and design to design, ...Show more
Join us to build a more rewarding financial future for all Canadians At Neo, we’re on a mission to build a more rewarding financial future for all Canadians.
Life at a rapidly scaling tech startup i...Show more
Our employees rank us highly in terms of commitment to work / life balance.We realize that for our people to be innovative, creative and passionate they need to feel valued and supported.We believe i...Show more
Salary : $80-$120 K Yearly CAD DOE.AnswerNet is the brand name for the AnswerNet family of companies, including AnswerNet, Inc.
TPV, and Ansercomm to name a few.Together with our affiliates, AnswerNe...Show more
Drive the product vision, strategy, and roadmap for satellite systems and space-related hardware / software, aligning business goals with commercial & government / defence customer ne...Show more
Be among the first 25 applicants.Good knowledge of Testing Life Cycle, SDLC and Defect Management processes for application support and development.
Good knowledge with QE Processes, Methodologies a...Show more
Our client is sourcing a Senior Analyst for a 6-month contract.Responsible for month-end, quarter-end, and annual close process in accordance with company requirements.
Responsible for expense reimb...Show more
ETL TESTER
Pyxidia Techlab LLP • Toronto, ON, Canada
Full-time
Last updated: 22 days ago • Promoted
SAP SCM Consultant - Contract (Toronto, ON)
HireKraft • Greater Toronto Area, ON, Canada
Full-time
Last updated: 30+ days ago • Promoted
STEM Insturctor (Arduino) (Canada Summer Job - 8 Weeks)
CAROBOT Learning and Research • Markham, ON, Canada
Permanent
Last updated: 30+ days ago • Promoted
SAP PI / PO
Hays • newmarket, on, ca
Full-time
Last updated: 5 days ago • Promoted
Senior Software Engineer - SRE
Veeva Systems • Toronto, Canada
Full-time
Last updated: 30+ days ago • Promoted
SRE Software Engineer - Hybrid; Reliability & Observability
Scotiabank • Toronto, Canada
Full-time
Last updated: 6 days ago • Promoted
Director, Release & Testing Coe - $104,558 - $200,697 A Year
LCBO • Toronto, Canada, CA
Full-time
Last updated: 8 days ago • Promoted
ETL & Functional Tester ( Canada Only)
Divine Match Talent • Toronto, ON, Canada
Full-time
Last updated: 30+ days ago • Promoted
Senior Software Engineer II, Smart Trailer & Connected Equipment
Samsara • Toronto, Canada
Full-time
Last updated: 30+ days ago • Promoted
Sr. System Integration Engineer - Lead Complex Projects
iRiS Recruiting Solutions • Toronto
Full-time
Last updated: 16 days ago • Promoted
ETL Informatica Developer
Cognizant • Toronto
Full-time
Last updated: 13 days ago • Promoted
Sr Software Engineer
hireVouch • Toronto, ON, Canada
Full-time
Last updated: 30+ days ago • Promoted
Director, Software Development
Neo Financial • Toronto, Canada
Full-time
Last updated: 30+ days ago • Promoted
Software Engineer III - Store Browse
Rakuten Kobo Inc. • Toronto
Full-time
Last updated: 14 days ago • Promoted
Manager of Software Development-REMOTE
Contact Centre Growth Corp Inc • Toronto, ON, Canada
Remote
Full-time
Last updated: 30+ days ago • Promoted
Space Systems Program Director
The Wohl Group - Recruitment Made Easy! • Markham, ON, Canada
Full-time
Last updated: 22 days ago • Promoted
Senior ETL SDET
J&M Group • Toronto
Full-time
Last updated: 16 days ago • Promoted
Senior Analyst
Vaco by Highspring • Stouffville, ON, CA
Temporary
Last updated: 9 days ago • Promoted