Senior ETL Developer

Position: Software Developer – ETL (Senior) Location: Toronto, ON (Hybrid) Job ID#: RQ11272 Duration: 2 Months Role Overview We are seeking a highly skilled and experienced Senior ETL Developer to design, develop, and maintain robust data integration solutions. The successful candidate will bring strong expertise in Informatica, PL/SQL, cloud technologies, data warehousing, performance optimization, troubleshooting, and migration initiatives. This role involves collaborating with business analysts, developers, and stakeholders to deliver high-quality data solutions and system integrations in an Agile environment. Key Responsibilities Design, develop, support, and maintain ETL processes using Informatica Cloud (IDMC). Migrate Informatica PowerCenter ETL code, including embedded SQL and PL/SQL developed on Oracle platforms. Test migrated SQL and PL/SQL stored procedures. Perform SQL and PL/SQL performance tuning and optimization. Conduct root cause analysis and resolve ETL-related issues. Execute data extraction, transformation, and loading from multiple data sources into enterprise data warehouses. Develop and validate data pipelines based on technical specifications. Collaborate with project teams during testing, debugging, and validation activities. Produce technical documentation, deployment guides, and support materials. Participate in Agile/Scrum delivery cycles. Ensure compliance with data governance, security, and access control requirements. Provide post-implementation support and knowledge transfer. Required Qualifications Technical Skills 5+ years of ETL and data warehousing experience. Strong experience with Informatica PowerCenter and Informatica Cloud (IDMC). Advanced PL/SQL and SQL development skills. Experience with relational databases including Oracle, SQL Server, and MySQL. Experience designing and supporting dimensional data models and star/snowflake schemas. Experience with Azure SQL, Azure Data Factory, and cloud platforms such as Azure, AWS, or Google Cloud. Experience with Python and Unix shell scripting. Version control and DevOps experience using GitHub, Azure DevOps, and Jira. Experience with ETL performance tuning, troubleshooting, recovery, and optimization. Core Competencies Software development lifecycle experience using Agile/Scrum and Waterfall methodologies. Technical analysis, design, coding, testing, and documentation experience. Strong experience translating business requirements into technical solutions. Experience supporting large-scale enterprise applications and integrations. Proven technical leadership and problem-solving skills. Preferred Experience Experience working within public sector environments. Experience with inter-jurisdictional government projects and enterprise architecture practices. Knowledge of accessibility standards and related regulations. Work Arrangement Hybrid work model. Candidate must work onsite three days per week in Toronto. About Symbiotic Digital. Symbiotic Digital provides the IT Experts you need that solve problems and get things done. See what the top 2% in their field can do for you. (Symbiotic Digital is a division of Symbiotic Group Inc.) We serve customers in two ways, we provide: Digital Experts: IT Consulting expertise. Bright Minds That Produce Proven Results Recruitment: Find The Right People You Need Serving IT & Business leaders, Symbiotic Digital provides a business system that enable us to provide the Expert Technical staff needed to solve challenging business and IT problems. IT leaders in the most reputable organizations in Canada have relied on Symbiotic Digital to help them staff difficult assignments with proven Experts uniquely evaluated by our proven QMS- Quality Management System Staff Development Model. We are a 100% Indigenous owned company. Learn more online at https://www.symbioticgroup.com/home-sd/. Please submit your most recent resume to: [email protected] View All Jobs online at: https://www.symbioticgroup.com/view-jobs/

The Senior ETL Developer will design, develop, and maintain robust data integration solutions using Informatica Cloud and migrate existing PowerCenter code. They will also perform performance tuning, troubleshoot ETL issues, and collaborate with stakeholders to deliver high-quality data pipelines.

Candidates must have at least 5 years of experience in ETL and data warehousing, with advanced proficiency in SQL and PL/SQL. Strong technical expertise in Informatica, cloud platforms, and Agile methodologies is required for this role.

• SQLSouhaitée
• GitHubSouhaitée
• JiraSouhaitée
• ScrumSouhaitée
• AgileSouhaitée
• PythonSouhaitée

Relevées dans la description du poste. Confirmez les exigences importantes ci-dessus.

• Informatica PowerCenter
• Informatica Cloud
• PL/SQL
• SQL
• Data Warehousing
• Azure SQL
• Azure Data Factory
• Python
• Unix Shell Scripting
• Performance Tuning
• Agile
• Scrum
• Data Modeling
• GitHub
• Azure DevOps
• Jira
• Informatica
• Waterfall Methodology
• Snowflake Schema
• Google Cloud Platform (GCP)
• Technical Leadership
• Knowledge Transfer
• Quality Management Systems
• Access Controls
• Agile Methodology
• Amazon Web Services
• JIRA
• Microsoft Azure
• Business Requirements
• Business Systems
• Technical Analysis
• Version Control
• Consulting
• Training And Development
• Data Extraction
• Data Governance
• Data Integration
• Extract Transform Load (ETL)
• Relational Databases
• Debugging
• Software Development Life Cycle
• DevOps
• Embedded SQL
• Github
• Enterprise Architecture
• Problem Solving
• Python (Programming Language)
• Unix Shell
• SQL Azure
• MySQL

• Technology
• Data & Analytics
• Software
• Government & Public Sector
• Consulting
• ETL Developer
• Database Designers and Administrators
• Database Administrators

Expérience minimale

5+ ans

Langue de l’offre

anglais

Heures de travail

40 heures par semaine

Présence au bureau

3 jours par semaine