Senior ETL ConsultantMaarut Inc • Toronto C6A, ON, Canada
Senior ETL Consultant
Maarut Inc • Toronto C6A, ON, Canada
30+ days ago
Job type
- Full-time
Job descriptionExtensive 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
Create a job alert for this search
Senior Consultant • Toronto C6A, ON, Canada
Similar jobs
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...Show more
While technically we’re an operational consultancy, we don’t like to call ourselves consultants.We’re a collection of engineers, innovators and creators who work with companies ac...Show more
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...Show more
We are looking for senior professionals in Water Resources, Environmental, Civil, Structural, Geotechnical and Ecology areas of practice.
Position can be based out of any of the areas we service acr...Show more
WANT TO WORK for one of Canada’s Best Managed Companies?.Dilawri Group is now actively searching for a.Apply to this position if you : .
Want to work in an ever-changing market.Enjoy working in ...Show more HireKraft is a trusted SAP staffing agency that has been providing exceptional SAP professionals for over 20 years.SAP MM Consultant – Procurement & Inventory.
Greater Toronto Area (On-sit...Show more 
Are you a highly driven, results-orientated individual who is ready to take the first step towards an exciting career in a company committed to your success? Queensway Automotive Group is looking f...Show more
Our client is a leading global financial services company.They are looking for a Senior Manager, Internal Controls to join their team!.
Opportunity to join a high-performing team.Position will lead ...Show more
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...Show more
Consultants to join Bridge Atlantic.The ideal candidate will have extensive experience in data integration, ETL processes, and SAP data migration projects.
You will be responsible for designing, dev...Show more
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...Show more
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...Show more
Welcome to FOSS — Where Values Drive Everything We Do.For over 60 years, the FOSS Auto Group has been a leader in the automotive industry, home to two trusted brands : Roy Foss and Foss Nation...Show more 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...Show more 
WANT TO WORK for one of Canada’s Best Managed Companies?.Dilawri Group is now actively searching for a.Apply to this position if you : .
Want to work in an ever-changing market.Enjoy working in ...Show more
Technitask is a Canadian company and a trusted provider of IT management, systems integration, software delivery, and consulting services.
Our expert team of SAP functional consultants, developers, ...Show more
Senior Consultant- ETL Dev - ( CREQ125383 ).Job Description for ETL Application Developer.Accountable for the design, development, testing and support of applications utilized in Lines of Business ...Show more
Senior Recruitment Consultant / Sales.Something Different than the norm….Six-figure earning potential - $100,000+.We are hiring in Calgary, Edmonton, Toronto, Vancouver and REMOTE locations ...Show more
ETL Consultant 9992-2211 Foilcon_019992
Foilcon • Toronto, Ontario, Canada
Full-time
Quick Apply
Last updated: less than 1 hour ago • New!
Senior Consultant
Isaac Operations • Toronto, ON, Canada
Full-time
Last updated: 30+ days ago • Promoted
SAP SCM Consultant - Contract (Toronto, ON)
HireKraft • Greater Toronto Area, ON, Canada
Full-time
Last updated: 30+ days ago • Promoted
Senior Consultant (Nationwide Position)
GEI Consultants • Markham, ON, Canada
Full-time
Last updated: 30+ days ago • Promoted
Sales Consultant
Markham Honda • Unionville, ON, Canada
Full-time
Last updated: 6 days ago • Promoted
SAP MM Consultant - Procurement & Inventory
HireKraft • Greater Toronto Area, ON, Canada
Full-time
Last updated: 30+ days ago • Promoted
SALES CONSULTANT
Mazda • Richmond Hill, ON, Canada
Full-time
Last updated: 30+ days ago • Promoted
Senior Manager, Internal Controls
Vaco by Highspring • Richmond Hill, Ontario, Canada
Permanent
Last updated: 4 days ago • Promoted
Sales Consultant
NewRoads Toyota Aurora • Aurora, ON, Canada
Full-time
Last updated: 30+ days ago • Promoted
Senior SAP Syniti Consultant
Bridge Atlantic • Toronto, ON, Canada
Full-time
Last updated: 11 days ago • Promoted
ETL Tech Lead
Hays • toronto, on, ca
Full-time
Last updated: 30+ days ago • Promoted
Senior ETL Consultant
Maarut Inc • Toronto, ON, Canada
Full-time
Last updated: 30+ days ago • Promoted
Sales Consultant
Roy Foss Aurora Chrysler • Aurora, ON, Canada
Full-time
Last updated: 30+ days ago • Promoted
ETL Tech Lead - toronto
Hays • toronto, on, ca
Full-time
Last updated: 30+ days ago • Promoted
Sales Consultant
Markham Kia • Unionville, ON, Canada
Full-time
Last updated: 30+ days ago • Promoted
Techno-functional SuccessFactors Consultant
Technitask • Greater Toronto Area, ON, Canada
Full-time
Last updated: 30+ days ago • Promoted
Senior Consultant- ETL Dev
Virtusa • Toronto, ON, Canada
Full-time
Last updated: 8 days ago • Promoted
Senior Recruitment Consultant - 360 Desk - Business Development
TalentSphere • Richmond Hill, ON, Canada
Full-time +1
Last updated: 30+ days ago • Promoted