Impress employers and recruiters.
Choose from hundreds of resume examples.

Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now

About the Role

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.

Responsibilities

• 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.
• 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).
• 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.
• 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.

Requirements

• 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.
• 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.
• 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.
• 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.

Skills

• ETL/ELT
• Data Integration
• SQL
• PL/SQL
• T-SQL
• Oracle
• SQL Server
• MySQL
• Dimensional Data Modeling
• Relational Data Modeling
• Azure
• AWS
• Google Cloud
• Azure SQL Server
• Azure Data Factory
• Python
• Unix Shell Scripting
• Elasticsearch
• GitHub
• JIRA
• Azure DevOps
• Oracle Enterprise Manager
• Oracle RAC
• Oracle Data Guard
• Oracle Exadata
• Oracle Warehouse Builder
• Database Recovery
• Database Refresh
• Database Failover
• Database Performance Tuning
• Data Migration
• Software Development
• Application Design
• Coding
• Testing
• Debugging
• Deployment
• Web-based Applications
• Microservices Architecture
• Integration Technologies
• Technical Documentation
• System Design
• Agile
• Scrum
• Waterfall
• SDLC
• Usability
• Security
• Privacy
• Public Sector Projects
• Environmental Data
• Enterprise Architecture Frameworks
• Project Delivery Methodologies
• Problem-Solving
• Decision-Making
• Communication
• Stakeholder Engagement
• Relationship Management
• Troubleshooting
• Critical Thinking
• Customer Service
• Consulting
• Collaboration
• Organization

Location

• Toronto, ON

Work Type

• Hybrid
• Onsite (3 days per week)

Experience Level

• Experienced

About the Company

• 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: RecDep@symbioticgroup.com
• View All Jobs online at: https://www.symbioticgroup.com/view-jobs/