Jobs
>
Toronto

    ETL Consultant - Toronto, Canada - Infotek Consulting Inc.

    Infotek Consulting Inc.
    Infotek Consulting Inc. Toronto, Canada

    4 weeks ago

    Default job background
    Pharmaceutical / Bio-tech
    Description
    We are seeking an ETL consultant on a contract opportunity located in Toronto Ontario


    Must Haves:

    • An Informatica MDM, IICS, Mulesoft expert with 15+ years of experience
    • Extensive knowledge in using these three technologies to design, develop, and implement data integration, data quality, data governance, and data management solutions.
    • The expert is responsible for understanding the business requirements, data sources, data models, data flows, data transformations, data validations, data mappings, and delivering highquality, scalable, and robust Informatica MDM solution to support various NNCI downstream systems using the best practices and methodologies of Informatica MDM, IICS, and Mulesoft.
    Roles and Responsibilities


    • Understand the business requirements and various master data sources to support & enhance existing MDM development work on the Informatica MDM, IICS, and Mulesoft platforms.
    • Develop and enhance data integration, data quality, data governance, and data management solutions using Informatica MDM, IICS, and Mulesoft tools and frameworks, such as Informatica Data Quality, Informatica Cloud Data Integration, Informatica Cloud Application Integration, Mulesoft Anypoint Platform, Mulesoft API Manager, Mulesoft Runtime Manager, Mulesoft DataWeave, Mulesoft Connectors, and Mulesoft Flows.
    • Develop and enhance T-SQL scripts for transformation of Informatica MDM data model into NNCI's data model to support various NNCI downstream systems.
    • Implement data transformations, data validations, data mappings, data standards, data lineage, data profiling, data cleansing, data enrichment, data matching, data merging, data survivorship, data synchronization, data security, data monitoring, and data auditing using Informatica MDM, IICS, Mulesoft, and MS SQL Server tools and techniques.
    • Test, debug, troubleshoot, and optimize the performance, scalability, reliability, and availability of the data integration, data quality, data governance, and data management solutions using Informatica MDM, IICS, and Mulesoft tools and best practices.
    • Enhance the existing and create new documentations that cover architecture, design, development, implementation, testing, and maintenance of the data integration, data quality, data governance, and data management solutions using Informatica MDM, IICS, and Mulesoft tools and standards.
    • Prepare deployment guidelines for Informatica MDM platform, go-live in the Production environment, and provide hypercare support after the MDM go-live.
    • Provide technical support and training to team members and stakeholders on how to use Informatica MDM, IICS, and Mulesoft tools and solutions.
    • Collaborate with external vendors, other developers, and business users to ensure the alignment, integration, and quality of the data integration, data quality, data governance, and data management solutions with the business objectives, data strategies, data policies, data rules, and data regulations of the organization.
    Skills


    • Expert in Informatica MDM platform, architecture, data model, match and merge processes, creating Mappings, Trust and Validation rules, Match Path, Match Column, Match rules.
    • Expert in creation and maintenance of entity objects, hierarchies, entity types, relationship objects. Relationship types using Hierarchy tool to enable Hierarchy Manager (HM) in MDM HUB implementation. Hands on experience in design and configuration of landing tables, staging tables, base objects, hierarchies, foreign - key relationships, lookups, query groups, queries/custom queries and packages.
    • Expert in core Informatica MDM Hub components such as Informatica MDM Hub Console, Hub Store, Hub Server, Cleanse Match Server, Cleanse Adapter, Data Modeling, Merge properties and Batch Group creation, Provisioning tool, and Customer 360 UI.
    • Expert in IICS application and data integration layers, IICS secure agent, and IICS cloud.
    • Expert in IDQ Developer and Informatica Administrator.
    • Expert in Mulesoft Anypoint Studio, Mulesoft Experience API, Mulesoft System API, Mulesoft Process API, Mulesoft Reference Translation API, Mulesoft API Manager, Mulesoft Runtime Manager, Mulesoft DataWeave, Mulesoft Connectors, and Mulesoft Flows.
    • Expert knowledge of MS SQL Server connectivity from Informatica environments, MS SQL Server relational databases, data modeling, and T-SQL.
    • Expert in data integration to/from Informatica MDM to Cloud CRM platform.
    • Experience in assembling large, complex structured/unstructured data sets that meet functional / non-functional business requirements.
    • Quick learner, Expert in analytics and problem-solving, Expert in recommending sound solutions with best practices, Excellent communication skills, Works independently.
    • Expert knowledge of systems analysis and design techniques.
    • Knowledge of all phases of the project and system development methodologies.

    Education Level:
    Bachelor's degree in business, information systems, computer science, or related field preferred.
    Preferred


    • Knowledge of Veeva / CRM platform & data integration to/from Veeva with Informatica MDM.
    • Pharmaceutical data experience especially HCP/HCO master data, IQVIA OneKey data and its API connector, IQVIA data.
  • Infotek Consulting Inc.

    ETL Consultant

    3 weeks ago

    Infotek Consulting Inc. Toronto, Canada

    We are seeking an ETL consultant on a contract opportunity located in Toronto Ontario Must Haves: - An Informatica MDM, IICS, Mulesoft expert with 15+ years of experience - Extensive knowledge in using these three technologies to design, develop, and implement data integration, d ...

  • Randstad Canada

    Sr. Consultant/Developer – ETL

    3 days ago

    Randstad Canada Toronto, Canada Temporary

    Our client, a leader in the Healthcare industry, is looking for a Senior ETL developer for doing product updates, operations and maintenance on a series of ETL products. · This Senior Developer must be knowledgeable and experienced in the following technologies to be able to sup ...

  • Kumaran Systems Pvt Ltd

    Hiring for Etl Consultant

    2 weeks ago

    Kumaran Systems Pvt Ltd Toronto, Canada

    Currently we are hiring "ETL consultant" with one of our Banking Customer - Toronto · Mode : To start with 6 months of contract with possible extension · JD: · Must Have: · People with database knowledge (ETL process), SQL, SAS as well as BI Tools such as Tableau or thoughspot · ...

  • Kumaran Systems Pvt Ltd

    Hiring for Etl Consultant

    2 weeks ago

    Kumaran Systems Pvt Ltd Toronto, Canada

    Currently we are hiring "ETL consultant" with one of our Banking Customer - Toronto · Mode : To start with 6 months of contract with possible extension · JD: · **Must Have**: · - **Strong knowledge in working with relational databases like Microsoft SQL Server, **Oracle. · - **Wr ...

  • opentext

    Etl Consultant

    3 weeks ago

    opentext Mississauga, Canada

    **OPENTEXT - THE INFORMATION COMPANY** · As the Information Company, our mission at OpenText is to create software solutions and deliver services that redefine the future of digital. Be part of a winning team that leads the way in Enterprise Information Management. · LI-Remote #I ...

  • NR Consulting

    Intermediate Data Analytical Specialist/Scientist

    2 weeks ago

    NR Consulting Toronto, Canada

    Position Title: Intermediate Data Analytical Specialist/Scientist · Work Location: Toronto, ON · Position Type: Contract · Duration: + Month · Job Description: · Responsibilities: Lead the development and delivery of functional and ministry-specific analytics to support ev ...

  • AMANST Inc

    Solutions Designer

    1 week ago

    AMANST Inc Toronto, Canada Full time / Contract

    MUST · Microsoft BI stack including Power BI for analytic reporting solution experience including ETL experience and experience migrating solutions from Oracle/Cognos/Informatica BI · Leading technical team including BI dashboard developers, and assisting architects with document ...

  • Tata Consultancy Services

    ETL Tester

    4 days ago

    Tata Consultancy Services Toronto, Canada

    TCS is an equal opportunity employer, and embraces diversity in race, nationality, ethnicity, gender, age, physical ability, neurodiversity, and sexual orientation, to create a workforce that reflects the societies we operate in. Our continued commitment to Culture and Diversity ...

  • Computer Consultants International, Inc.

    Data Analytical Specialist/Scientist

    2 weeks ago

    Computer Consultants International, Inc. Toronto, Canada

    HYBRID position at Toronto, Ontario · Tools and techniques · Experience with a range of analytical methods, techniques and tools such as statistical analysis and modelling, data mining, machine learning and algorithms, natural language processing, and other related disciplines · ...

  • CAPCO

    Senior Data and Cloud Consultant

    3 days ago

    CAPCO Toronto, Canada

    Senior Data and Cloud Consultant · at Capco Canada - Toronto Capco – The Future. Now. · Capco is a distinctly and positively different place to work. Much more than consultants, we are active participants in the global financial services industry. Our passionate business and ...

  • Tiger Analytics

    Data Engineer

    3 days ago

    Tiger Analytics Toronto, Canada Full time

    Tiger Analytics is a fast-growing advanced analytics consulting firm. Our consultants bring deep expertise in Data Science, Machine Learning and AI. We are the trusted analytics partner for several Fortune 100 companies, enabling them to generate business value from data. Our bus ...

  • Scotiabank

    Data Developer

    1 week ago

    Scotiabank Toronto, Canada

    Is this role right for you? · In this role you will: Developing SQL queries / ETL packages using T-SQL and SSIS to ingest data from source systems to integrate with SQL Server data warehouse. · Design and develop physical data model structures in SQL Server · Design and develo ...

  • High Cliff Partners Inc.

    Senior Data Migration Specialist

    2 days ago

    High Cliff Partners Inc. Toronto, Canada

    Our client is currently looking for a Senior Data Migration Specialist to join their team for a 1-year contract, with the potential for extension. This role offers a dynamic hybrid work setting, combining remote work with the occasional need for on-site workshops. · Responsible ...

  • Tiger Analytics

    Data Engineer

    3 weeks ago

    Tiger Analytics Toronto, Canada Full time

    Tiger Analytics is a fast-growing advanced analytics consulting firm. Our consultants bring deep expertise in Data Science, Machine Learning and AI. We are the trusted analytics partner for several Fortune 100 companies, enabling them to generate business value from data. Our bus ...

  • CGI

    Pre-sales Specialist

    2 days ago

    CGI Toronto, Canada Full time

    Position Description: · Your mission as a Presales Specialist (Architecture) - Data & Analytics within CGI, involves leading initiatives to architect, model, and design robust Analytics, Big Data, and AI solutions that align with the organization's strategic goals. · Reporting t ...

  • GTT, LLC

    Data Analytical Specialist/Scientist

    2 weeks ago

    GTT, LLC Toronto, Canada Contract

    Data Analytical Specialist/Scientist · Contract Duration 6+ Months · Must Haves; · The Data Analytical Specialist/Scientist must provide a contact email address and be available to work on this assignment. · Experience with a range of analytical methods, techniques, and tools suc ...

  • Capleo Global

    Senior Solutions Designer

    1 week ago

    Capleo Global Toronto, Canada Contract

    Position: Senior Solutions Designer · Location: Toronto, ON Hybrid · Duration: 12 Months Contract + possible extension · Description: · Undertakes the design of hosting technology solutions based on the client s service specifications, standards, policies, best practices, and co ...

  • Capleo Global

    Specialized I&IT Consultant

    1 week ago

    Capleo Global Toronto, Canada Contract

    Title Specialized IT Consultant - Intermediate · Location: Toronto, ON (Hybrid) · Duration: 251 Business Days + Possible extension · Job Description: Design, develop, and maintain data pipelines using Azure Data Factory Services for data ingestion, transformation, and i ...

  • NTT DATA Services

    Data Engineer

    1 week ago

    NTT DATA Services Toronto, Canada

    Req ID: · NTT DATA Services strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. · We are currently seeking a Data Engineer to join our team i ...

  • AMISEQ

    Database Developer

    2 weeks ago

    AMISEQ Toronto, Canada

    Description: · Lead the development and delivery of functional and ministry-specific analytics to support evidence-based decision-making and produce actionable insights. Work closely with client groups to assess current data analytics and reporting capabilities, gather future-sta ...