ETL Consultant

3 weeks ago

Toronto ON, Canada Infotek Consulting Inc. Full time

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 high-quality, 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 / Salesforce.com 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.

  • ETL Consultant

    7 days ago

    Toronto, ON, Canada LanceSoft, Inc. Full time

    Job Description: Responsibilities: Works in partnership with clients, advising them how to use information management (IM) and/or information technology in order to meet their business objectives or overcome problems, work to improve the structure and efficiency of an organization's I&IT Systems including the use of Oracle Data Integrator and...

  • Hiring for Etl Consultant!!

    4 weeks ago

    Toronto, Canada Kumaran Systems Pvt Ltd Full time

    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 Interested means reply with your updated resume. Regards, Sasirega TAG - Kumaran...

  • ETL Consultant

    7 days ago

    Old Toronto, Canada LanceSoft, Inc. Full time

    Job Description:Responsibilities:Works in partnership with clients, advising them how to use information management (IM) and/or information technology in order to meet their business objectives or overcome problems, work to improve the structure and efficiency of an organization's I&IT Systems including the use of Oracle Data Integrator and Informatica ETL...

  • ETL Consultant

    1 week ago

    Toronto, Canada Infotek Consulting Inc. Full time

    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 g

  • ETL Migration Specialist

    1 week ago

    Toronto, ON, Canada Infinity Financial Solutions Full time

    Position - ETL Migration Specialist Location - Toronto, ON Full Time Role 7+ years of IT experience with Informatica Power Center 9.x or higher In depth knowledge of Informatica 9. Power Center as a Developer to develop solutions to meet or exceed requirements on migration projects on cross platformExperience writing efficient, robust code, follow...

  • ETL Developer

    1 month ago

    Toronto, Canada Tata Consultancy Services Full time

    About TCSTCS operates on a global scale, with a diverse talent base of more than 600,000 associates representing 153 nationalities across 55 countries. TCS has been recognized as a Global Top Employer by the Top Employers Institute - one of only eight companies worldwide to have achieved this status. Our organizational structure is domain-led and designed to...

  • ETL Migration Specialist

    1 week ago

    Old Toronto, Canada Infinity Financial Solutions Full time

    Position - ETL Migration Specialist Location - Toronto, ON Full Time Role 7+ years of IT experience with Informatica Power Center 9.x or higher In depth knowledge of Informatica 9. Power Center as a Developer to develop solutions to meet or exceed requirements on migration projects on cross platformExperience writing efficient, robust code, follow coding...

  • ETL Migration Specialist

    1 week ago

    Old Toronto, Canada Infinity Financial Solutions Full time

    Position - ETL Migration Specialist Location - Toronto, ON Full Time Role 7+ years of IT experience with Informatica Power Center 9.x or higher In depth knowledge of Informatica 9. Power Center as a Developer to develop solutions to meet or exceed requirements on migration projects on cross platformExperience writing efficient, robust code, follow coding...

  • ETL Migration Specialist

    1 week ago

    Old Toronto, Canada Infinity Financial Solutions Full time

    Position - ETL Migration Specialist Location - Toronto, ON Full Time Role 7+ years of IT experience with Informatica Power Center 9.x or higher In depth knowledge of Informatica 9. Power Center as a Developer to develop solutions to meet or exceed requirements on migration projects on cross platformExperience writing efficient, robust code, follow coding...

  • ETL Consultant

    3 weeks ago

    Toronto, ON, Canada Infotek Consulting Inc. Full time

    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...

  • Sr. Consultant/Developer – ETL

    2 weeks ago

    Toronto, Canada Randstad Canada Full time

    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 support the related portfolio of products: Informatica DEI and shell scripting,...

  • Consultant, Application Development

    1 month ago

    Toronto, Canada CIBC Full time

    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. At CIBC, we embrace your strengths and your ambitions, so you are empowered at work. Our team members have what they need to make a meaningful impact and are truly valued for who they are...

  • Business Intelligence Consultant

    1 week ago

    Toronto, ON, Canada Infotek Consulting Services Inc. Full time

    Infotek Consulting is searching for an Oracle Analytics Server Consultant - this is a hybrid assignment based in TorontoMust Haves:Computer Scienceyears experience with Oracle Analytics Server (OAS) ( significant Oracle BI / OAS Experience)years experience with SQL and Knowledge of Relational Database concepts and design.years experience in...

  • Business Intelligence Consultant

    1 week ago

    Toronto, ON, Canada Infotek Consulting Services Inc. Full time

    Infotek Consulting is searching for an Oracle Analytics Server Consultant - this is a hybrid assignment based in TorontoMust Haves:Computer Scienceyears experience with Oracle Analytics Server (OAS) ( significant Oracle BI / OAS Experience)years experience with SQL and Knowledge of Relational Database concepts and design.years experience in...

  • Business Intelligence ETL 5781

    1 month ago

    Toronto, Canada Foilcon Full time

    General ResponsibilitiesDesign, develop and implement ingestion framework from Oracle source to Azure Data Lake - initial load and incremental ETL. Used tools are:-Oracle Golden Gate (knowledge and experience are an asset but not required) for data ingestion and change data capture (currently in final stages of proof of concept)-Azure Data Factory (expert...

  • ETL Consultant

    2 weeks ago

    Toronto, Canada Infotek Consulting Inc. Full time

    We are seeking an ETL consultant on a contract opportunity located in Toronto OntarioMust 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...

  • ETL Consultant

    3 weeks ago

    Toronto, Canada Infotek Consulting Inc. Full time

    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...

  • ETL Consultant

    3 weeks ago

    Toronto, Canada Infotek Consulting Inc. Full time

    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...

  • ETL Consultant

    3 weeks ago

    Toronto, Canada Infotek Consulting Inc. Full time

    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...

  • ETL Consultant

    3 weeks ago

    Toronto, Canada Infotek Consulting Inc. Full time

    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...