ETL Developer
- Toronto, ON, Canada
Full-time
Applications open in a new tab.
Job details
- Job type
- Full-time
- Apply by
- Posting language
- English
- Posted
Original job description
We are currently seeking a Senior ETL developer to design, develop, and maintain ETL processes for data integration and transformation.
Job Role: Senior ETL Developer
Job Type: Full -Time/Contract
Location: Toronto (Onsite)
This is an onsite role located in Toronto, requiring you to work in the office 4 to 5 days a week.
Responsibilities:
· Collaborate with cross-functional teams to gather and analyze requirements for data integration projects.
· Analyze requirements/specifications and architectural/system design documents
· Implement solutions using Azure Data Factory (ADF) pipelines and stored procedures, and Informatica Power Centre to populate the enterprise data warehouse
· Develop Azure CI/CD pipeline to automate ADF release
· Implement complex data conversion, e.g., binary to character, EBCDIC to UTF
· Implement complex data transformation(s) for derived and calculated values
· Integrate data sets from diverse source systems
· Implement ADF for initial data load and incremental load
· Promote ADF and Informatica ETL/ELT including: Development, Integration Testing, QA, UAT, Production
· Debug ADF pipeline and stored procedure and Informatica workflow to investigate and fix defects
· Optimize performance of ADF pipeline, Azure SQL and Synapse databases, and Informatica workflow
Skills Required:
· SQL competence (query performance tuning, index management, etc.) and a grasp of database structure are required.
· Understanding of data modelling concepts.
· Extensive experience with ETL tools: Informatica Power Centre and Microsoft SSIS
· Extensive experience with Azure Data Factory
· High attention to detail
· Passionate about complex data structures and problem-solving
If you are a skilled ETL Developer looking for an exciting opportunity to work with cutting-edge technologies in a collaborative environment, we would love to hear from you.
Please apply via LinkedIn or send us your resume at hr@cloudvital.ca
More about this job
Responsibilities
Design, develop, and maintain ETL processes that integrate and transform data from diverse source systems into the enterprise data warehouse using Azure Data Factory, Informatica PowerCenter, and stored procedures. Automate deployments, manage data loads and environment promotions, troubleshoot defects, and optimize pipeline and database performance.
Requirements
Requires extensive experience with Azure Data Factory, Informatica PowerCenter, and Microsoft SSIS, along with strong SQL skills including query tuning and index management. Candidates should understand database structures and data modeling, and demonstrate attention to detail and problem-solving ability with complex data structures.
Skills
- SQL
- Query Performance Tuning
- Index Management
- Database Structure
- Data Modeling
- Informatica PowerCenter
- Microsoft SSIS
- Azure Data Factory
- ETL/ELT
- Azure CI/CD Pipelines
- Stored Procedures
- Data Integration
- Data Transformation
- Performance Optimization
- Data Conversion
Visa sponsorship
Not detected in the job text
Categories
- Technology
- Data & Analytics
- Software
Keywords
- ETL
- ELT
- Azure Data Factory
- ADF Pipelines
- Informatica PowerCenter
- Microsoft SSIS
- SQL
- Stored Procedures
- Azure CI/CD
- Enterprise Data Warehouse
- Data Integration
- Data Transformation
- Data Modeling
- Query Performance Tuning
- Index Management
- Azure SQL
- Azure Synapse
- Initial Data Load
- Incremental Load
- Data Conversion
- EBCDIC
- UTF
- Binary-to-Character Conversion
- Integration Testing
- Quality Assurance
- User Acceptance Testing
- Production Deployment
- Pipeline Debugging
- Performance Optimization