Senior ETL Developer
2 weeks ago
Job Title: Senior Software Developer – ETL
Location: Toronto, ON (Hybrid: Onsite 3 days/week)
Duration: Long-Term
Position Overview:
We are seeking an experienced ETL Software Developer to support a variety of data integration and transformation initiatives using Azure Data Factory (ADF), Informatica PowerCenter, and Oracle PL/SQL. The successful candidate will design, build, and optimize scalable data pipelines, support DevOps automation, and collaborate closely with technical and business teams to deliver high-quality data solutions.
Key Responsibilities:
- Analyze project documentation such as Use Cases and System Requirements Specifications.
- Design and document detailed system architecture and technical solutions aligned with Ministry standards.
- Built logical and physical data models using Sybase PowerDesigner.
- Create transformation mapping documents for complex data workflows.
- Develop end-to-end ETL pipelines using:
- Azure Data Factory (ADF)
- Informatica PowerCenter
- Oracle PL/SQL
- Stored Procedures and Logic Apps
- Integrate diverse datasets and support both initial and incremental data loads.
- Generate structured JSON files using ADF and SQL queries.
- Develop and maintain CI/CD pipelines for ADF using Azure DevOps.
- Perform data conversions (e.g., binary to character, EBCDIC to UTF) and complex data transformations (e.g., derived/calculated values).
- Promote ETL components through various environments: Dev, Integration, QA, UAT, and Production.
- Troubleshoot ADF pipelines, Informatica workflows, and stored procedures to resolve technical issues.
- Monitor system performance, perform tuning, and analyzing incidents for resolution.
- Collaborate with IT teams throughout the Software Development Lifecycle (SDLC).
- Capture and document insights from stakeholders and subject matter experts.
- Conduct knowledge transfer sessions with Ministry staff to ensure long-term sustainability.
Required Skills & Experience:
ETL & Data Integration (40%)
- Proven experience gathering business requirements and translating them into high-quality data transformation logic.
- Hands-on expertise with ADF, including:
- Self-Hosted Integration Runtime
- Complex ETL workflows and transformations
- Large volume performance optimization
- Debugging with ADF tools
- Strong experience with Informatica PowerCenter, including Workflow Manager, Repository Manager, Designer, and Monitor.
- Experience with Azure Logic Apps and Azure Function Apps.
- Experience supporting and optimizing existing ETL pipelines.
- Familiarity with BI tools such as IBM Cognos and Microsoft Power BI.
Azure DevOps & CI/CD (40%)
- Strong experience building CI/CD pipelines and managing DevOps processes, including:
- Azure Resource Management
- GitHub Repositories
- Source control (branching, pull requests, and mergers)
- Azure Boards, Test Plans, Pipelines, Repos, and Artifacts
PL/SQL Development (10%)
- Expert-level experience developing Oracle PL/SQL and SQL Server Stored Procedures for data integration and transformation.
Database Technologies (10%)
- Experience working with Oracle, SQL Server, and Azure SQL/Synapse.
- Deep understanding of both relational and hierarchical databases.
- Ability to perform database performance tuning for large datasets.
-
Senior ETL Developer
2 weeks ago
Canada Emids Full timeAbout the RoleWe are seeking a highly skilled and experienced Senior ETL Developer to join our team at Emids. The ideal candidate will have a deep understanding of ETL processes, data integration, and database management within an Azure cloud environment.You will be responsible for designing, developing, and optimizing ETL pipelines and ensuring the seamless...
-
Senior ETL Developer
2 weeks ago
Canada Emids Full timeJob Overview:We are seeking a highly skilled and experienced Senior ETL Developer to join our team. The ideal candidate will have a deep understanding of ETL processes, data integration, and database management within an Azure cloud environment and central SQL database. You will be responsible for designing, developing, and optimizing ETL pipelines and...
-
Senior ETL Developer Position
1 week ago
Canada Wirehead Full time**Job Title:** Senior ETL Developer**Job Type:** Contract, Full-time**Company Overview**Wirehead Talent is a leading provider of top talent in the IT industry. We specialize in finding exceptional professionals like you to join our clients' teams.**Salary and Benefits**The salary for this position is $90.00 per hour. This includes benefits such as access to...
-
Senior ETL Developer
1 week ago
Canada Wirehead Full timeJob SummaryWe are seeking an experienced Senior ETL Developer to join our team at Wirehead. The successful candidate will have extensive experience in designing and developing SQL Server Stored Procedures, Oracle PL/SQL programs, and database technologies. They will also have expertise in leveraging Azure Data Factory, Databricks, and CI/CD pipelines to...
-
Informatica ETL Developer
1 week ago
canada | ca VDart Inc Full timeRole: Informatica ETL Developer Location: Remote Type: Contract Summary Description: Join an enterprise data warehouse team environment with focus on customer-centricity, quality, forever learning and teamwork. If you enjoy all of these values and can work completely remote, this could be a position for you. ETL / Data Movement Developer will need at...
-
Senior ETL Developer
2 weeks ago
Canada Wirehead Full timeClient: Government Type: Contract Role: Senior Software Developer ETL Term: 1 Year + extension option Pay Rate: $90.00 Start date: 2-3 weeks Location: Toronto / Hybrid Req ID: RQ09067 Requirements: What you'll need Skills, Knowledge, Experience, and Qualifications: ETL Development-Data Integration Extensive experience in gathering requirements and...
-
Senior ETL Developer
1 week ago
Canada Wirehead Full timeClient: Government Type: Contract Role: Senior Software Developer ETL Term: 1 Year + extension option Pay Rate: $90.00 Start date: 2-3 weeks Location: Toronto / Hybrid Req ID: RQ09067 Requirements: What you'll need Skills, Knowledge, Experience, and Qualifications: ETL Development-Data Integration Extensive experience in gathering...
-
Senior ETL Developer
1 week ago
Canada Russell Tobin Full timeResponsibilities:- Analyze project documentation to identify business requirements and translate them into high-quality data transformation logic.- Design and document detailed system architecture and technical solutions aligned with Ministry standards.- Build logical and physical data models using Sybase PowerDesigner and create transformation mapping...
-
ETL Development Expert
2 weeks ago
Canada Wirehead Full timeWe are seeking a highly skilled ETL Developer to join our team at Wirehead. As a Senior ETL Developer, you will be responsible for designing, developing, and implementing high-quality data transformation solutions using Azure Data Factory, Databricks, and other relevant technologies.Key Responsibilities:Gather requirements and business process knowledge to...
-
Senior ETL Consultant
2 weeks ago
Canada Kumaran Systems Full timeWe are seeking a highly skilled Senior ETL Developer to analyze, understand, and transform our existing Informatica/Oracle-based ETL processes into comprehensive documentation. The current MST ETL process, initially developed with BRD/SRD documentation, has undergone significant enhancements and business logic changes over time. The ideal candidate will...
-
Senior ETL Consultant
2 weeks ago
Canada Kumaran Systems Full timeWe are seeking a highly skilled Senior ETL Developer to analyze, understand, and transform our existing Informatica/Oracle-based ETL processes into comprehensive documentation. The current MST ETL process, initially developed with BRD/SRD documentation, has undergone significant enhancements and business logic changes over time. The ideal candidate will...
-
ETL Development Lead
2 weeks ago
Canada Kumaran Systems Full timeWe are seeking a highly skilled Senior ETL Developer to lead our data transformation efforts and ensure seamless knowledge transfer. The ideal candidate will possess a strong ability to interpret complex code, leveraging tools like AI-powered Co-pilots to streamline the documentation process.Key Responsibilities:Analyze and document existing on-premises...
-
Senior Enterprise ETL Developer
2 weeks ago
Canada HCLTech Full timeAbout the RoleWe are seeking a highly skilled Ab Initio developer to join our team. The ideal candidate will have 6+ years of experience in designing and developing complex data integration solutions using Ab Initio.Key ResponsibilitiesDesign and develop highly scalable enterprise-grade ETL processes in Ab Initio.Develop complex code to build business rules...
-
Senior ETL Specialist
5 days ago
Canada HCLTech Full timeCompany OverviewHCLTech is a leading global technology company with a rich history dating back to 1976. We have grown to become a major player in the IT services industry, offering a wide range of services including digital, engineering, and cloud solutions.Job SummaryWe are seeking an experienced Ab Initio Developer to join our team as a Senior ETL...
-
ETL Developer(QA)
3 weeks ago
Canada Quantum World Technologies Inc. Full timeRole: ETL QALocation: Toronto,ON(Hybrid)Job Type: Contract Hands on expereince in ETL testingWorking knowledge in SSIS ETL tools at a QA levelDevelop comprehensive test plans, test cases, and test scripts specifically for SSIS (SQL Server Integration Services) ETL processes.Define testing strategies and methodologies for data integration and data migration...
-
Senior Ab Initio ETL Developer
5 days ago
Canada HCLTech Full timeWe are seeking an experienced Ab Initio developer to join our team.About the RoleThis is a high-profile project requiring strong coding, design, and communication skills. The main responsibilities will be to develop solutions, design frameworks, lead and guide development teams.Key Responsibilities:Designing highly scalable enterprise-grade ETL processes in...
-
Informatica ETL Developer
1 week ago
Canada United Software Group Inc Full timeJob Title: Informatica ETL DeveloperLocation: Remote RoleInterview: Video Interview Description:Required Skills:8-10 years of Enterprise Data Warehouse ETL development.8-10 years of experience ETL development using various versions of Informatica Powercenter.8-10 years of experience with proficiency in SQL with Oracle and/or Teradata Databases.Expert at...
-
High-Performance ETL Developer
5 days ago
Canada HCLTech Full timeEnterprise Data Transformation ExpertWe are seeking an experienced Ab Initio Developer to join our team. As an Ab Initio Developer, you will be responsible for designing highly scalable enterprise-grade ETL processes in Ab Initio. You will work closely with our development team to deliver high-quality ETL solutions and provide ETL solutions for new business...
-
ETL Solutions Architect
1 week ago
Canada Wirehead Full timeSenior ETL Solutions ArchitectWe are seeking an experienced ETL Solutions Architect to join our team at Wirehead. The successful candidate will have extensive experience in designing and developing high-quality ETL pipelines using Azure Data Factory and Databricks. They will also have expertise in leveraging Business Intelligence tools such as IBM Cognos and...
-
Senior Informatica Developer
2 weeks ago
Canada Kumaran Systems Full timeWe are seeking a Senior Informatica Developer to join our team and take the lead in developing and implementing our ETL solutions. As a senior member of our development team, you will be responsible for designing, developing, and deploying ETL processes using Informatica and Oracle technologies.Key Responsibilities:Design and develop ETL processes using...