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
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 chance to work with cutting-edge technologies in a cooperative setting, we would love to hear from you.