Data Warehousing Specialist

4 weeks ago


Old Toronto, Ontario, Canada ALLTECH CONSULTING SVC INC Full time
Job Description:

As a Data Warehousing Specialist at ALLTECH CONSULTING SVC INC, you will play a crucial role in designing and developing complex data ETL/ELT processes using Informatica. Your expertise in data migration and data integration will enable us to optimize our data warehouse and improve our business intelligence capabilities.

Key Responsibilities:

  • Design, build, automate, and optimize complex data ETL/ELT processes using Informatica.
  • Develop and maintain system design models, technical documentation, and specifications.
  • Conduct technical analysis, troubleshooting, and issue resolutions for production operational support.
  • Work with Quality Assurance (QA) to code, test, and debug extensions/tools integration services.
  • Develop and support application monitoring using Elastic/Logstash/Kibana or Sematext.

Requirements:

  • 10+ years of experience with data warehousing design and development.
  • Experience with data migration and data integration.
  • Experience with Mulesoft, Salesforce bulk load API is an asset.
  • Informatica transformations, mappings, and workflows.
  • Relational databases (Oracle, MS-SQL), data modeling (relational & dimensional), advanced SQL, query optimization.

About Us:

ALLTECH CONSULTING SVC INC is a leading consulting firm that provides expert services in data warehousing, business intelligence, and data analytics. We are committed to delivering high-quality solutions that meet our clients' needs and exceed their expectations.


  • Senior Scrum Master

    3 weeks ago


    Toronto, Ontario, Canada GTT, LLC Full time

    About the Role:We are seeking a highly skilled Scrum Master to lead a dynamic team in delivering a cutting-edge data warehousing solution on Azure. As a seasoned professional, you will drive the successful implementation of our new Dynamics CE-based solution.Responsibilities:Agile Leadership: Lead a team of IT professionals in following agile delivery...


  • Toronto, Ontario, Canada Paralucent Full time

    Data Engineer Role at ParalucentThis position is responsible for developing, maintaining, and optimizing ETL processes within Databricks to support data warehousing, data lakes, and analytics initiatives.The ideal candidate will have strong knowledge of Delta Lake for data management and optimization, hands-on experience with CDC tools like GoldenGate for...


  • Toronto, Ontario, Canada NearSource Full time

    Senior Data Insights SpecialistAt NearSource Technologies, we're seeking a Senior Data Insights Specialist to drive technological excellence forward. As a key member of our team, you'll shape pioneering solutions and leverage your expertise in JavaScript, HTML, weblogs, and data warehousing to deliver cutting-edge analytics.Key Responsibilities:Extensive...

  • Data Specialist

    3 weeks ago


    Toronto, Ontario, Canada City of Toronto Full time

    Data Specialist Job DescriptionThe City of Toronto is seeking a highly skilled Data Specialist to join the Fleet Services Division. As a Data Specialist, you will be responsible for leading tasks and projects related to data modeling, analysis, and interpretation, including spatial data.Key Responsibilities:Design, test, and build complex models to solve...


  • Toronto, Ontario, Canada Foilcon Full time

    About FoilconWe are a leading technology firm, and we're looking for a talented Chief Data Architecture Specialist to join our team. This role is responsible for designing and implementing the technical architecture of our data infrastructure.Job DescriptionThe Chief Data Architecture Specialist will be responsible for: Designing and implementing data...


  • Toronto, Ontario, Canada The Toronto-Dominion Bank (Canada) Full time

    Data Management SpecialistWe are seeking a highly skilled Data Management Specialist to join our team at The Toronto-Dominion Bank (Canada). As a key member of our data management team, you will be responsible for providing technical leadership across a broad range of data analysis functions.Key ResponsibilitiesElicit, analyze, and understand business and...


  • Toronto, Ontario, Canada Maarut Inc Full time

    Company Overview:We are Maarut Inc, a dynamic organization dedicated to delivering innovative solutions in the realm of Business Intelligence (BI). Our team is passionate about leveraging technology to unlock valuable insights from raw data.Salary:$120,000 - $180,000 per yearJob Description:The role of Data Insights Specialist at Maarut Inc involves working...


  • Toronto, Ontario, Canada ESTÉE LAUDER Companies Full time

    About the CompanyThe ESTÉE LAUDER Companies is a leading manufacturer and marketer of quality skin care, makeup, fragrance and hair care products. Our company has grown virtually every year on key principles: creativity, innovation and entrepreneurship.Job Description:The primary purpose of this role is to lead all warehousing, inventory management and...


  • Toronto, Ontario, Canada Burnac Produce Limited Full time

    Data Entry Specialist PositionBurnac Produce Limited is seeking a Data Entry Specialist to join its team. As a key member of our operations team, you will be responsible for providing customer support at Rite-Pak and Provincial Fruit cashier kiosks and ensuring accurate and timely processing of sales orders and inquiries.Key Responsibilities:Inputting...


  • Toronto, Ontario, Canada Purple Drive Full time

    Purple Drive is seeking a highly skilled Data Transformation Specialist to join our team. As a key member of our data management team, you will be responsible for building and maintaining data transformations using SSIS, including importing data from files and moving data from one database platform to another.Key Responsibilities:Design and implement data...


  • Toronto, Ontario, Canada Purple Drive Full time

    Purple Drive is seeking a skilled SSIS Data Specialist to join our team.We are looking for a highly motivated individual with experience in data transformation using SSIS, ETL, and data warehousing. If you have a strong background in SQL queries and batch job processing, we want to hear from you.Key responsibilities will include:Building and maintaining...

  • Data Specialist

    4 weeks ago


    Toronto, Ontario, Canada City of Toronto Full time

    Data Specialist RoleThe City of Toronto is seeking a highly skilled Data Specialist to join the Fleet Services Division. As a Data Specialist, you will play a key role in leading tasks and projects related to data analytics and research, including designing, testing, and building complex models to solve divisional analytics problems.Key Responsibilities:Lead...


  • Old Toronto, Ontario, Canada https:www.pcrecruiter.netsitemap Full time

    Our client is a leading provider of business intelligence and analytics solutions.This is a permanent position that involves architecting, designing, and developing business intelligence applications for our client's customers.Key Responsibilities:Collaborate with senior technical staff to create work products.Translate client business requirements into...


  • Toronto, Ontario, Canada Mevotech Full time

    Unlock Your Career Potential with MevotechMevotech is a leading North American aftermarket auto parts company that specializes in engineering, design, and distribution of driveline, steering, and suspension parts. With a strong focus on innovation and employee growth, we're seeking a skilled Data Warehouse Specialist CoPilot to join our team.Job SummaryThe...


  • Toronto, Ontario, Canada Achievers Full time

    Data Infrastructure SpecialistWe are seeking a talented Data Infrastructure Specialist to join our growing Data Infrastructure team at Achievers. In this role, you will leverage your expertise in designing and developing large-scale data pipelines on Google Cloud Platform (GCP).Responsibilities:Design, develop, and implement scalable and reliable data...

  • Data Engineer

    2 days ago


    Toronto, Ontario, Canada Guidepoint Full time

    About the Role:Guidepoint is a leading research enablement platform that empowers our clients' decision-making process with innovative technology, real-time data, and hard-to-source expertise.We are seeking an experienced Data Engineer - Advanced Analytics Specialist to join our Engineering team in Toronto, Canada. As a key member of our team, you will play...

  • Senior Data Architect

    4 weeks ago


    Toronto, Ontario, Canada Maarut Inc Full time

    About the RoleWe are seeking a highly skilled Data Insights Specialist to join our team at Maarut Inc. As a key member of our Business Intelligence team, you will be responsible for designing and implementing data models to transform raw data into meaningful insights.Key ResponsibilitiesDevelop and maintain data models to support business intelligence...

  • Data Analyst

    1 month ago


    Toronto, Ontario, Canada City of Toronto Full time

    Data SpecialistJoin the City of Toronto's Fleet Services Division as a Data Specialist and play a key role in driving data-driven decision making. As a Data Specialist, you will be responsible for leading tasks and projects related to data analysis, interpretation, and visualization. Your expertise will help us make informed decisions and drive business...

  • Scrum Master

    4 weeks ago


    Toronto, Ontario, Canada Foilcon Full time

    Job Title: Scrum Master - Data Warehouse SpecialistJob Summary: Foilcon is seeking a skilled Scrum Master to lead our data warehouse team in delivering high-quality software development projects.Key Responsibilities:* Lead technical teams in a Scrum Master or related role* Experience in leading software development teams in largescale data warehousing...

  • Data Engineer

    4 weeks ago


    Toronto, Ontario, Canada Capgemini Full time

    Job Title: Data Engineer - Cloud Data Warehouse SpecialistJob Summary:We are seeking a highly skilled Data Engineer to join our team at Capgemini. As a Data Engineer, you will be responsible for designing, building, and maintaining large-scale data pipelines using cloud-based technologies. Your expertise in data engineering will enable us to process and...