Senior ETL ConsultantMaarut Inc • Toronto C6A, ON, Canada
Senior ETL Consultant
Maarut Inc • Toronto C6A, ON, Canada
Il y a plus de 30 jours
Type de contrat
- Temps plein
Description de posteExtensive experience in gathering requirements and business process knowledge in order to design correct and high-quality data transformation. Extensive experience in design, development, and implementation with Azure Data Factory, Databricks, including : Self-Hosted Integration Runtime Performance tuning on large data volumes Complex data transformations ADF Debugger to validate data transformation. Experience with Informatica, including : Workflow Manager Repository Manager Designer Workflow Monitor Experience with developing solutions using Logic App and Function App. Experience in rapid application development (RAD) methodologies. Experience in maintaining and improving existing ETL processes. Experience in investigating data to identify potential issues within ETL pipelines. Experience with Business Intelligence tools IBM Cognos and Microsoft PowerBI. Experience with CI / CD (DevOps) pipelines and concepts, including : Branching, pull requests, build, release, multiple parallel development repositories merge. Experience with Azure DevOps. Extensive experience in designing and developing SQL Server Stored Procedure, Oracle PL / SQL programs. Experience with Oracle, Microsoft SQL Server database and tools. Experience with relational and hierarchical database technologies. Extensive knowledge of Azure SQL DB and Synapse platforms, including : Performance tuning on large data volume. Extensive experience in gathering requirements and business process knowledge in order to design correct and high-quality data transformation.
4 days ago Be among the first 25 applicants
Get AI-powered advice on this job and more exclusive features.
Direct message the job poster from Maarut Inc
Responsibilities
- Participate in the review of project, work request and maintenance release artefacts - Use Case, System Requirement Specification, etc.
- Deliver detailed system design documents and any other supporting documentation conforming to Ministry standards.
- Design logical and physical data models using Sybase Power Designer.
- Implement data pipelines using Azure Data Factory (ADF), stored procedure, and Informatica PowerCenter performing extraction, transformation, and loading activities.
- Implement solutions using Logic App and Function App.
- Generate structured JSON file using ADF / SQL.
- Develop Azure CI / CD pipeline to automate ADF release.
- Develop complex Oracle PL / SQL program to fulfill project requirements.
- 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 through all Ministry environments including Development, Integration Testing, QA, UAT, Production.
- Resolve and troubleshoot ADF pipeline, stored procedure, and Informatica workflow technical problems.
- Monitor and analyze incident, provide timely resolution.
- Collaborate with IT Professionals throughout the Software Development Life Cycle.
- Document information from diverse business area stakeholders and subject matter experts.
- Optimize performance of ADF pipeline, Azure SQL and Synapse databases, and Informatica workflow.
- Monitor application functionality and performance on daily basis.
- Provide effective knowledge transfer to Ministry staff at all stages of this assignment.
Requirements
ETL Development-Data Integration
Oracle PL / SQL Development
Database Technologies
Must haves :
Seniority level
Mid-Senior level
Employment type
Contract
Job function
Information Technology
Industries
IT Services and IT Consulting
#J-18808-Ljbffr
Créer une alerte emploi pour cette recherche
Senior Consultant • Toronto C6A, ON, Canada
Offres similaires
A leading technology consulting firm is seeking a Senior Consultant specializing in ETL development.The role involves designing and supporting applications in Line of Business strategies, with a fo...Voir plus
HM Note : This onsite contract role is in office every day at the manager's discretion.Candidate resumes must include first and last name, email and telephone contact information.This role commences...Voir plus
Our client is a leading Canadian energy organization with a strong presence across Ontario.They operate critical infrastructure that supports millions of customers and drives economic growth.Our cl...Voir plus
We are seeking a talented and motivated Senior Consultant to join our growing Restoration team.Edison specializes in the repair and restoration of existing buildings, providing communication-focuse...Voir plus
We are seeking a Senior Integration Engineerfor a 3-6 months contract engagement with a client based in Toronto.This role will focus on enhancing and integrating enterprise architecture and certifi...Voir plus
HireKraft | SAP SCM Consultant – Contract (Toronto, ON).SAP staffing agency with over 20 years of experience connecting exceptional SAP professionals with leading organizations across North A...Voir plus
Senior ETL EngineerScotiabankTorontoRequisition ID : 238183 Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.
The Team • • • We are the CRM, Sales...Voir plus
Senior ETL EngineerScotiabankTorontoRequisition ID : 238183 Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.
The Team • • • We are the CRM, Sales...Voir plus
We are a trailblazing health tech company on a mission to revolutionize the nursing home & post acute space.Our innovative AI software is transforming the admissions process and care delivery in th...Voir plus
Solutions Director - Toronto, Ontario page is loaded## Sr.Solutions Director - Toronto, Ontariolocations : Toronto, Ontariotime type : Full timeposted on : Posted Yesterdayjob requisition id : ...Voir plus
Achievers offers more than just a thank you program.Our employee recognition and rewards software inspires employees to recognize everyone, every day, everywhere.
Join our team of A-players who brin...Voir plus
Workato transforms technology complexity into business opportunity.As the leader in enterprise orchestration, Workato helps businesses globally streamline operations by connecting data, processes, ...Voir plus
Aurora Toyota a multiple President's Award Winning Dealer.This is an outstanding opportunity to join a busy and dynamic sales team with an income-earning potential of $40,000 to $150,000.We are...Voir plus
US Director, Business Development & Sales (Remote).US Director, Business Development & Sales (Remote).Get AI-powered advice on this job and more exclusive features.
Util-Assist is a leading consulti...Voir plus
Be among the first 25 applicants.We’re building a relationship‑oriented bank for the modern world.We need talented, passionate professionals who are dedicated to doing what’s right for our clients....Voir plus
Be among the first 25 applicants.Get AI-powered advice on this job and more exclusive features.Direct message the job poster from Maarut Inc.
Participate in the review of project, work request and m...Voir plus
New Value Solutions, a national IT consulting company, is seeking a Change Management Lead.The successful candidate will design and implement a scalable, repeatable change management structure to s...Voir plus
You’ll be joining a leading organization committed to delivering innovative solutions that support strategic initiatives across the health information sector.
The company values collaboration, excel...Voir plus
Senior ETL & Data Warehouse Consultant
Virtusa • Toronto C6A, ON, Canada
Temps plein
Dernière mise à jour : il y a 8 jours • Offre sponsorisée
ETL Consultant 9992-2211 Foilcon_019992
Foilcon • Toronto, Ontario, Canada
Temps plein
Quick Apply
Dernière mise à jour : il y a 12 heures • Nouvelle offre
ERP Program Data Migration Lead x2 (ID : 52809)
Vaco by Highspring • Unionville, Ontario, Canada
Temps plein
Dernière mise à jour : il y a 11 jours • Offre sponsorisée
Senior Consultant - Building Restoration
Edison Engineers • Markham, ON, Canada
Temps plein
Dernière mise à jour : il y a 1 jour • Offre sponsorisée
Senior Integration Engineer
Veriday Inc. • Toronto, ON, Canada
Temporaire
Dernière mise à jour : il y a 4 jours • Offre sponsorisée
SAP SCM Consultant - Contract (Toronto, ON)
HireKraft • Greater Toronto Area, ON, Canada
Temps plein
Dernière mise à jour : il y a plus de 30 jours • Offre sponsorisée
Senior ETL Engineer
Women Thrive Magazine • Toronto C6A, ON, Canada
Temps plein
Dernière mise à jour : il y a 4 jours • Offre sponsorisée
Senior ETL Engineer
Thebusinessyear • Toronto C6A, ON, Canada
Temps plein
Dernière mise à jour : il y a 9 jours • Offre sponsorisée
Senior Solutions Consultant
ExaCare AI • Toronto, ON, Canada
Temps plein
Dernière mise à jour : il y a 23 jours • Offre sponsorisée
Sr. Solutions Director - Toronto, Ontario
Optiv Security • Toronto C6A, ON, Canada
Temps plein
Dernière mise à jour : il y a 16 jours • Offre sponsorisée
Senior Solutions Consultant
Achievers Corp. • Toronto C6A, ON, Canada
Télétravail
Temps plein
Dernière mise à jour : il y a plus de 30 jours • Offre sponsorisée
Senior Technical Consultant
Workato • Toronto C6A, ON, Canada
Télétravail
Temps plein
Dernière mise à jour : il y a 2 jours • Offre sponsorisée
Sales Consultant
NewRoads Toyota Aurora • Aurora, ON, Canada
Temps plein
Dernière mise à jour : il y a plus de 30 jours • Offre sponsorisée
US Director, Business Development & Sales (Remote)
Util-Assist Inc. • Newmarket L0G, ON, Canada
Télétravail
Temps plein +1
Dernière mise à jour : il y a 9 jours • Offre sponsorisée
Senior Consultant, Business Controls - Simplii Financial
Simplii Financial • Toronto C6A, ON, Canada
Temps plein
Dernière mise à jour : il y a 19 jours • Offre sponsorisée
Senior ETL Consultant
Maarut Inc • Toronto, ON, Canada
Temps plein
Dernière mise à jour : il y a plus de 30 jours • Offre sponsorisée
Change Management Lead
freelance.ca • Richmond Hill, Canada
Temps plein
Dernière mise à jour : il y a plus de 30 jours • Offre sponsorisée
ETL Tech Lead
Hays • Toronto, ON, Canada
Temps plein
Dernière mise à jour : il y a 9 jours • Offre sponsorisée