ETL Developer
Job Description
We are currently seeking an ETL developer to design, develop, and maintain ETL processes for data integration and transformation.
Job Role: 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, architectural/system design documents
Implement solution using Azure Data Factory (ADF) pipeline and stored procedure, and Informatica Power Centre to populate 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 resumes at
How to Apply
Ready to start your career as a ETL Developer at CloudVital?
- Click the "Apply Now" button below.
- Review the safety warning in the modal.
- You will be redirected to the employer's official portal to complete your application.
- Ensure your resume and cover letter are tailored to the job description using our AI tools.
Frequently Asked Questions
Who is hiring?▼
This role is with CloudVital in Toronto.
Is this a remote position?▼
This appears to be an on-site role in Toronto.
What is the hiring process?▼
After you click "Apply Now", you will be redirected to the employer's official site to submit your resume. You can typically expect to hear back within 1-2 weeks if shortlisted.
How can I improve my application?▼
Tailor your resume to the specific job description. You can use our free Resume Analyzer to see how well you match the requirements.
What skills are needed?▼
Refer to the "Job Description" section above for a detailed list of required and preferred qualifications.