Current jobs related to ETL Consultant - Toronto - Infotek Consulting Inc.
-
ETL Developer
2 months ago
Toronto, Canada Tata Consultancy Services Full timeAbout TCS: Tata Consultancy Services is an IT services, consulting, and business solutions organization that has been partnering with many of the world’s largest businesses in their transformation journeys for over 55 years. Its consulting-led, cognitive powered portfolio of business, technology, and engineering services and solutions is delivered through...
-
ETL Developer
2 months ago
Toronto, Canada Tata Consultancy Services Full timeAbout TCS: Tata Consultancy Services is an IT services, consulting, and business solutions organization that has been partnering with many of the world’s largest businesses in their transformation journeys for over 55 years. Its consulting-led, cognitive powered portfolio of business, technology, and engineering services and solutions is delivered through...
-
ETL Developer
2 months ago
Toronto, Canada Tata Consultancy Services Full timeAbout TCS: Tata Consultancy Services is an IT services, consulting, and business solutions organization that has been partnering with many of the world’s largest businesses in their transformation journeys for over 55 years. Its consulting-led, cognitive powered portfolio of business, technology, and engineering services and solutions is delivered...
-
ETL Developer
2 weeks ago
Toronto, Canada Tata Consultancy Services Full timeAbout TCS: Tata Consultancy Services is an IT services, consulting, and business solutions organization that has been partnering with many of the world’s largest businesses in their transformation journeys for over 55 years. Its consulting-led, cognitive powered portfolio of business, technology, and engineering services and solutions is delivered through...
-
ETL Developer
3 weeks ago
Toronto, Canada Tata Consultancy Services Full timeAbout TCS: Tata Consultancy Services is an IT services, consulting, and business solutions organization that has been partnering with many of the world’s largest businesses in their transformation journeys for over 55 years. Its consulting-led, cognitive powered portfolio of business, technology, and engineering services and solutions is delivered through...
-
ETL Developer
3 weeks ago
Toronto, Canada Tata Consultancy Services Full timeAbout TCS: Tata Consultancy Services is an IT services, consulting, and business solutions organization that has been partnering with many of the world’s largest businesses in their transformation journeys for over 55 years. Its consulting-led, cognitive powered portfolio of business, technology, and engineering services and solutions is delivered through...
-
ETL Developer
3 weeks ago
Toronto, Canada Tata Consultancy Services Full timeAbout TCS: Tata Consultancy Services is an IT services, consulting, and business solutions organization that has been partnering with many of the world’s largest businesses in their transformation journeys for over 55 years. Its consulting-led, cognitive powered portfolio of business, technology, and engineering services and solutions is delivered...
-
ETL Developer
1 week ago
Toronto, ON, Canada Tata Consultancy Services Full timeAbout TCS: Tata Consultancy Services is an IT services, consulting, and business solutions organization that has been partnering with many of the world’s largest businesses in their transformation journeys for over 55 years. Its consulting-led, cognitive powered portfolio of business, technology, and engineering services and solutions is delivered through...
-
ETL Developer
1 week ago
Toronto, ON, Canada Tata Consultancy Services Full timeAbout TCS: Tata Consultancy Services is an IT services, consulting, and business solutions organization that has been partnering with many of the world’s largest businesses in their transformation journeys for over 55 years. Its consulting-led, cognitive powered portfolio of business, technology, and engineering services and solutions is delivered through...
-
ETL Developer
3 weeks ago
Toronto, Ontario, Ontario, Canada Tata Consultancy Services Full timeAbout TCS: Tata Consultancy Services is an IT services, consulting, and business solutions organization that has been partnering with many of the world’s largest businesses in their transformation journeys for over 55 years. Its consulting-led, cognitive powered portfolio of business, technology, and engineering services and solutions is delivered through...
-
Datastage Developer
2 weeks ago
Toronto, Ontario, Canada Tata Consultancy Services Full timeAbout Tata Consultancy ServicesTata Consultancy Services is a leading IT services, consulting, and business solutions organization that has been partnering with many of the world's largest businesses in their transformation journeys for over 55 years.Our consulting-led, cognitive powered portfolio of business, technology, and engineering services and...
-
Datastage Developer
2 weeks ago
Toronto, Ontario, Canada Tata Consultancy Services Full timeAbout Tata Consultancy ServicesTata Consultancy Services is a leading IT services, consulting, and business solutions organization that has been partnering with many of the world's largest businesses in their transformation journeys for over 55 years.Our consulting-led, cognitive powered portfolio of business, technology, and engineering services and...
-
ETL/Datastage Developer
1 month ago
Old Toronto, Canada ROSS Full timeOur client is a boutique consulting firm that is currently working on a project with a large Telco company. They are looking for an ETL Developer with 5-7 years of experience. This is a 10-week engagement that has a great possibility of being extended.Opportunity Details:Work with the project team to build an ETL (DataStage) process:Extract data from an...
-
ETL/Datastage Developer
1 month ago
Old Toronto, Canada ROSS Full timeOur client is a boutique consulting firm that is currently working on a project with a large Telco company. They are looking for an ETL Developer with 5-7 years of experience. This is a 10-week engagement that has a great possibility of being extended.Opportunity Details:Work with the project team to build an ETL (DataStage) process:Extract data from an...
-
ETL Tester
2 months ago
Toronto, Canada Tata Consultancy Services Full timeAbout TCS: Tata Consultancy Services is an IT services, consulting, and business solutions organization that has been partnering with many of the world’s largest businesses in their transformation journeys for over 55 years. Its consulting-led, cognitive powered portfolio of business, technology, and engineering services and solutions is delivered through...
-
ETL Tester
2 months ago
Toronto, Canada Tata Consultancy Services Full timeAbout TCS: Tata Consultancy Services is an IT services, consulting, and business solutions organization that has been partnering with many of the world’s largest businesses in their transformation journeys for over 55 years. Its consulting-led, cognitive powered portfolio of business, technology, and engineering services and solutions is delivered through...
-
ETL Tester
2 months ago
Toronto, Canada Tata Consultancy Services Full timeAbout TCS: Tata Consultancy Services is an IT services, consulting, and business solutions organization that has been partnering with many of the world’s largest businesses in their transformation journeys for over 55 years. Its consulting-led, cognitive powered portfolio of business, technology, and engineering services and solutions is delivered...
-
Data Modeling and ETL Specialist
2 weeks ago
Toronto, Ontario, Canada Tata Consultancy Services Full timeAbout Tata Consultancy ServicesTata Consultancy Services is a leading IT services, consulting, and business solutions organization that has been partnering with numerous global businesses in their transformation journeys for over five decades. Its consulting-led, cognitive-powered portfolio of business, technology, and engineering services and solutions is...
-
Data Modeling and ETL Specialist
2 weeks ago
Toronto, Ontario, Canada Tata Consultancy Services Full timeAbout Tata Consultancy ServicesTata Consultancy Services is a leading IT services, consulting, and business solutions organization that has been partnering with numerous global businesses in their transformation journeys for over five decades. Its consulting-led, cognitive-powered portfolio of business, technology, and engineering services and solutions is...
-
ETL/Datastage Developer
1 month ago
Old Toronto, Ontario, CA ROSS Full timeOur client is a boutique consulting firm that is currently working on a project with a large Telco company. They are looking for an ETL Developer with 5-7 years of experience. This is a 10-week engagement that has a great possibility of being extended.Opportunity Details:Work with the project team to build an ETL (DataStage) process:Extract data from an...
ETL Consultant
4 months ago
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.
