We are currently seeking a Senior ETL developer to design, develop, and maintain ETL processes for data integration and transformation.Job Role: Senior ETL DeveloperJob Type: Full -Time/ContractThis 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 documentsImplement solutions using Azure Data Factory (ADF) pipelines and stored procedures, and Informatica Power Centre to populate the enterprise data warehouseDevelop Azure CI/CD pipeline to automate ADF releaseImplement complex data conversion, e.G., binary to character, EBCDIC to UTFImplement complex data transformation(s) for derived and calculated valuesIntegrate data sets from diverse source systemsImplement ADF for initial data load and incremental loadPromote ADF and Informatica ETL/ELT including: Development,



Integration Testing, QA, UAT, ProductionDebug ADF pipeline and stored procedure and Informatica workflow to investigate and fix defectsOptimize performance of ADF pipeline, Azure SQL and Synapse databases, and Informatica workflowSkills 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 SSISExtensive experience with Azure Data FactoryHigh attention to detailPassionate about complex data structures and problem-solvingIf you are a skilled ETL Developer looking for an exciting prospect to work with cutting-edge technologies in a collaborative environment, we would love to hear from you.#J-18808-Ljbffr

📌 Etl Developer With Azure Expertise (Toronto)
🏢 CIBC
📍 Toronto