Software Developer – ETL

Position: Software Developer – ETL Location: Toronto, ON (Hybrid) Job ID#: RQ10840 Duration: 7 Months Role Overview We are seeking an experienced Software Developer – ETL to design, develop, optimize, and support enterprise-scale data integration solutions. The successful candidate will be responsible for building and maintaining ETL/ELT pipelines, data warehousing solutions, database integrations, and cloud-based data platforms while ensuring high-quality, scalable, and maintainable data architecture. Key Responsibilities ETL & Data Integration Design, implement, and continuously expand data pipelines through extraction, transformation, and loading activities. Build, automate, and optimize complex ETL/ELT processes. Develop data transformation, cleansing, loading, and migration solutions across multiple platforms. Investigate data issues within ETL pipelines and recommend corrective actions. Ensure data architecture remains scalable, maintainable, and aligned with business requirements. Create and maintain detailed ETL process documentation. Software Development Translate technical system specifications into tested, working applications. Develop detailed programming specifications and generate production-ready code. Conduct unit testing, troubleshooting, debugging, and code optimization. Support implementation, conversion, migration, and post-deployment activities. Participate in all phases of the Software Development Life Cycle (SDLC). Data Warehouse & Database Development Design and develop data warehouse solutions including star and snowflake schemas. Create denormalized data assets from highly normalized databases. Develop complex SQL procedures, packages, scripts, and database components. Perform database performance tuning, optimization, and data replication activities. Support data migration and integration initiatives across heterogeneous environments. Technical Leadership & Collaboration Collaborate with business analysts, stakeholders, subject matter experts, QA teams, and developers. Conduct technical evaluations and recommend solution approaches. Support architecture alignment, technical documentation, and integration planning. Contribute to project planning, estimation, and technical design discussions. Required Qualifications Technical Skills 5+ years of experience with data warehousing design and development. Strong expertise in ETL/ELT development and data integration. Advanced SQL skills including PL/SQL and T-SQL. Experience with relational databases including Oracle, SQL Server, and MySQL. Knowledge of dimensional and relational data modeling. Experience with cloud technologies such as Azure, AWS, or Google Cloud. Hands-on experience with Azure SQL Server and Azure Data Factory. Experience creating Azure Data Factory pipelines and custom data integration solutions. Proficiency with Python and Unix Shell scripting. Experience with Elasticsearch performance tuning and reporting solutions. Experience using GitHub for version control. Experience working with JIRA and Azure DevOps. Knowledge of Oracle technologies including Oracle Enterprise Manager, RAC, Data Guard, Exadata, and Oracle Warehouse Builder. Experience with database recovery, refresh, failover, and performance tuning activities. Experience with data migration and integration across different operating environments. Core Skills Technical analysis and software development expertise. Application design, coding, testing, debugging, and deployment experience. Experience with large-scale, mission-critical applications. Knowledge of web-based applications, microservices architecture, and integration technologies. Experience producing technical documentation and system design artifacts. Familiarity with Agile, Scrum, Waterfall, and SDLC methodologies. Understanding of usability, security, and privacy considerations in application development. Public Sector Experience Experience working on projects involving federal, provincial, or municipal government organizations. Experience with environmental data migration and integration initiatives. Knowledge of enterprise architecture frameworks, methodologies, and governance processes commonly used in public sector environments. Experience following structured project delivery and system development methodologies. General Skills Strong analytical, problem-solving, and decision-making abilities. Excellent verbal and written communication skills. Strong stakeholder engagement and relationship management skills. Proven troubleshooting and critical thinking capabilities. Strong customer service orientation and consulting skills. Ability to work independently and collaboratively in fast-paced environments. Excellent organizational skills with the ability to meet tight deadlines. Work Arrangement Hybrid work model. Three (3) days per week in office. 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 developer will design, build, and optimize enterprise-scale ETL/ELT pipelines and data warehousing solutions. They will also collaborate with stakeholders to ensure scalable data architecture and provide technical support throughout the software development lifecycle.

Candidates must have at least 5 years of experience in data warehousing and ETL development with advanced SQL proficiency. Expertise in cloud platforms like Azure, Python scripting, and experience within public sector environments is highly preferred.

• SQLSouhaitée
• GitHubSouhaitée
• JiraSouhaitée
• PythonSouhaitée

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

• ETL/ELT Development
• Data Warehousing
• SQL
• PL/SQL
• T-SQL
• Azure Data Factory
• Python
• Unix Shell Scripting
• Data Modeling
• Oracle
• SQL Server
• Elasticsearch
• GitHub
• JIRA
• Azure DevOps
• Data Integration
• Pipelines
• Relationship Management
• Organizational Skills
• Reporting Solutions
• Waterfall Methodology
• Snowflake Schema
• Google Cloud Platform (GCP)
• Technical Leadership
• Technical Design
• Project Delivery
• Planning
• Quality Management Systems
• Agile Methodology
• Amazon Web Services
• Application Development
• Software Development
• Unit Testing
• Microsoft Azure
• Business Requirements
• Business Systems
• Technical Analysis
• Decision Making
• Customer Service
• Version Control
• Program Optimization
• Communication
• Consulting
• Training And Development
• Critical Thinking
• Data Architecture
• Extract Transform Load (ETL)
• Data Transformation
• Data Migration
• Relational Databases

• Technology
• Data & Analytics
• Software
• Government & Public Sector
• Consulting
• Software Developer
• 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