$4 - $5 Posted: 3 hours ago
Job Description
<p><strong>We are currently seeking an ETL developer to design, develop, and maintain ETL processes for data integration and transformation.</strong></p><p><br></p><p><strong>Job Role:</strong> ETL Developer</p><p><strong>Job Type:</strong> Full -Time/Contract</p><p><strong>Location:</strong> Toronto (Onsite) </p><p><br></p><p><strong>This is an onsite role located in Toronto, requiring you to work in the office 4 to 5 days a week.</strong></p><p><br></p><p><strong>Responsibilities:</strong></p><p> Collaborate with cross-functional teams to gather and analyze requirements for data integration projects.</p><p> Analyze requirements/specifications, architectural/system design documents</p><p> Implement solution using Azure Data Factory (ADF) pipeline and stored procedure, and Informatica Power Centre to populate enterprise data warehouse</p><p> Develop Azure CI/CD pipeline to automate ADF release</p><p> Implement complex data conversion, e.g., binary to character, EBCDIC to UTF</p><p> Implement complex data transformation(s) for derived and calculated values</p><p> Integrate data sets from diverse source systems</p><p> Implement ADF for initial data load and incremental load</p><p> Promote ADF and Informatica ETL/ELT including: Development, Integration Testing, QA, UAT, Production</p><p> Debug ADF pipeline and stored procedure and Informatica workflow to investigate and fix defects</p><p> Optimize performance of ADF pipeline, Azure SQL and Synapse databases, and Informatica workflow</p><p><br></p><p><strong>Skills Required:</strong></p><p> SQL competence (query performance tuning, index management, etc.) and a grasp of database structure are required.</p><p> Understanding of data modelling concepts.</p><p> Extensive experience with ETL tools Informatica Power Centre and Microsoft SSIS</p><p> Extensive experience with Azure Data Factory</p><p> High attention to detail</p><p> Passionate about complex data structures and problem solving</p><p><br></p><p>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.</p><p>Please apply via LinkedIn or send us your resumes at </p>Create Your Resume First
Give yourself the best chance of success. Create a professional, job-winning resume with AI before you apply.
It's fast, easy, and increases your chances of getting an interview!
Application Disclaimer
You are now leaving Thisjob.ca and being redirected to a third-party website to complete your application. We are not responsible for the content or privacy practices of this external site.
Important: Beware of job scams. Never provide your bank account details, credit card information, or any form of payment to a potential employer.