Senior Data Consultant (Talend DI)

Job Description:

Skill Set

Informatica, IDMC, Informatica MDM

Experience

4-6 Years

Location

Faridabad, Haryana, India

Work Mode- Hybrid

Job Description

Roles & Responsibilities

• Lead project team members through all activities required to successfully deliver Informatica.
• Define technical specifications for workflows and business rules.
• Prepare detailed design documents for data migration.
• Configure, build and unit test Informatica components, including data structures, roles, workflows, and portals.
• Train and mentor colleagues in Informatica implementation activities and best practices.
• Support integration, system, and user acceptance testing.
• Accountable for the Master Data Management, Technical Architecture, providing data modeling solutions and recommendations.
• Profile & Analyze Source Data usage using ETL tool.
• Automation, job scheduling, dependencies, monitoring.
• Configure/Script Business rules and transformation rules in ETL
• Data pipeline using IICS
• Hands on experience in Informatica MFT, Data Exchange (DX),and Data Transform (DT) modules
• Integration experience using various adapters (MLLP, SOAP, REST, SFTP, ODBC) will be essential.
• Strong knowledge and experience with developing complex SQL Queries, stored procedures, and triggers for RDBMS systems.
• Experience in administering, supporting, and performance tuning using Informatica.

Job Summary

We are seeking an experienced Informatica MDM Developer to design, develop, and implement Master Data Management (MDM) solutions using Informatica IDMC (SaaS). The role focuses on establishing a Single Source of Truth by integrating multiple data sources, enforcing data quality standards, and managing master data domains such as Customer, Product, Supplier, and Employee.

The engineer will collaborate closely with data stewards, data architects, and business stakeholders to deliver high-quality, governed enterprise data. The role requires willingness to support production MDM SaaS platforms and the data warehouse feeding MDM. When capacity permits, the candidate will also support GCP Data Engineering activities

Key Roles & Responsibilities

• Design and build Master Data Management (MDM) solutions using Informatica IDMC (SaaS).
• Create and manage data models for domains like Customer, Product, Supplier, and Employee.
• Configure Business 360 including UI, entities, and business rules.
• Develop and maintain match, merge, and survivorship rules to create accurate golden records.
• Build data integrations using Cloud Data Integration (CDI) and Cloud Application Integration (CAI).
• Develop and support REST APIs for real-time data exchange.
• Implement data quality, cleansing, and standardization rules using Cloud Data Quality (CDQ).
• Support data stewards in resolving data issues, merges, and exceptions.
• Monitor, troubleshoot, and optimize MDM SaaS platform performance.
• Support production MDM systems and the data warehouse feeding MDM.
• Collaborate with business and technical teams to deliver high-quality governed data.
• Willing to support GCP Data Engineering tasks when required (training provided).

Required Skills & Qualifications:

• Hands-on experience with Informatica IDMC (SaaS) including Business 360, Customer 360, or Product 360.
• Strong expertise in CDI, CAI, and CDQ.
• Solid understanding of relational and dimensional data modeling.
• Advanced SQL skills.
• Experience with REST/SOAP APIs, JSON, and XML.
• Familiarity with cloud data platforms such as Snowflake, Databricks, AWS Redshift, or Azure Synapse.

Experience & Education

• Education: Bachelor’s degree in Computer Science, Information Technology, or a related field.
• Experience:
• 3+ years of experience in Master Data Management (MDM).
• 1–2 years of hands-on experience with Informatica MDM SaaS / IDMC.
• Prior experience with Informatica On-Prem Multidomain MDM is a plus (with SaaS migration exposure).

.

Job Types: Full-time, Permanent

Hiring: Informatica IDMC / IICS Developer

Location: Faridabad, Haryana

Experience: 4–7 Years

Must-Have:

• Informatica IDMC / IICS

• Data Integration & Application Integration (CAI)

• ETL / Data Pipelines / Data Migration

• REST, SOAP, SFTP & API Integration

• Strong SQL, Stored Procedures & RDBMS

• Job Scheduling, Monitoring & Performance Tuning

Good to Have: Informatica MFT, DX, DT, MDM & Data Quality

Position title: Business Intelligence and Data Analyst

Summary -

• Operate and continuously improve the CARS/BI backend within the global Enterprise Data and Business Intelligence platform, ensuring system stability, continuous data loading, and Warehouse the timely delivery of business-critical reports.

• Own the underlying data foundation — SQL pipelines, relational data models, and data warehouse structures — that internal reporting teams and global Data Management initiatives depend on, and act as 1st and 2nd level support for internal customers such as SCM and Sales.

• The role is needed to secure daily BI availability in the Asian time zone, reduce the risk of late or incorrect reporting, and add dedicated database and ETL capacity to the global BI team, including support to the Data Centre team on infrastructure-related issues.

Responsibilities:

• Operate, monitor, and maintain the CARS/BI data integration and data processing workflows, ensuring continuous data loading and stable daily business operations.

• Provide 1st and 2nd level support for CARS/BI, including user support, incident handling, and root-cause analysis of data issues.

• Develop, maintain, and optimise SQL-based data pipelines and transformations within the Enterprise Data Warehouse.

• Design and maintain relational data models and data warehouse structures for CARS BI.

• Integrate data from ERP and other enterprise systems into the BI backend.

• Ensure data consistency, integrity, and performance at the database level, including query tuning and database efficiency improvements.

• Administer the BI technical environment and contribute to its continuous enhancement as part of a global team.

• Support reporting teams by providing structured, reliable datasets and safeguarding the timely delivery of business-critical reports.

• Contribute to global Data Management initiatives, with a focus on Master Data Management and the development of a Common Data Model within the Business Integration Platform.

• Collaborate with the Data Centre team to resolve infrastructure-related issues affecting BI availability.

Education and Experience:

Bachelor's degree in Engineering (BE/B.Tech) or equivalent in Computer Science, Information Technology, or a comparable technical field.

Minimum 3 years of relevant professional experience in Business Intelligence, data warehousing, or database development, including hands-on SQL and ETL work in an enterprise environment.

Experience supporting business users in a global or multi-time-zone IT organisation is an advantage.

Competencies:

• Knowledge about either BI platforms (e.g. IBM Cognos BI suite) or ETL tools (e.g. Informatica PowerCenter)

• Database, data modeling and SQL (preferred Oracle PLSQL)

• Good analytical and communication skills

• Teamplayer

• English

• Strong hands-on experience with SQL (advanced level)

• Solid understanding of relational databases and data warehouse concepts

• Experience with ETL tools and database technologies (e.g., Oracle, SQL Server, SAP BW,Informatica or similar)

• Performance tuning and query optimization skills

• Structured, detail-oriented, and quality-focused working style

• Good understanding of enterprise data flows (SAP/CARS is a plus)

Key Interfaces and Stakeholders:

Only internal customers with different topics: e.g. SCM, Sales etc.

Geography to cover and Travel requirements:

Asian Time Zone, Sometimes travel is required

Behavioral Characteristics

Reliability and accountability — the role safeguards daily reporting availability, so dependable ownership of monitoring and issue follow-up is expected. Structured, analytical problem solving with the patience for thorough root-cause analysis. Service orientation and clear communication towards internal customers such as SCM and Sales. Initiative taking and self-reliance, given largely independent work in the Asian time zone. Cooperation and team spirit within a globally distributed BI team across cultures and time zones. Flexibility and resilience under time pressure, including occasional off-hours support during critical data loads. Integrity and discretion when handling confidential business data. Quality focus and attention to detail, with a continuous improvement mindset.

Interview process

2 rounds - Virtual interview and 1 round Face to Face

Any other Criteria

• Notice Period: Below 60 or 90 Days . No Negotiation on Notice Period
• Gender: Female and Male; Female preferred
• Qualification:Bachelor's degree in Engineering (BE/B.Tech) or equivalent in Computer Science, Information Technology, 

Role & Responsibilities

Key Responsibilities

• Manage and improve master data across customer, product, entitlement, account hierarchy, product catalog, subscription, contract, billing, and revenue domains.
• Configure and support MDM platform capabilities, including data models, match and merge rules, survivorship rules, hierarchy management, validation rules, workflows, reference data, and data quality rules.
• Support integration of master data between MDM platforms and operational systems such as Salesforce CRM, Salesforce CPQ, Salesforce Revenue Cloud, billing, ERP, data lake, and reporting platforms.
• Assist with customer golden record creation, account hierarchy management, deduplication, data standardization, and Customer 360 enablement.
• Support product taxonomy and product catalog data needed for CPQ bundles, pricing rules, eligibility rules, commercial BOMs, and quote-to-cash automation.
• Maintain entitlement and subscription data, including customer-to-product mappings, lifecycle status, renewals, amendments, upsells, and install base visibility.
• Perform data profiling, cleansing, reconciliation, validation, issue resolution, and root-cause analysis across multiple systems.
• Document data definitions, business rules, source-to-target mappings, lineage, stewardship processes, and remediation actions.
• Partner with Sales Operations, Revenue Operations, Finance, Product Operations, Customer Success, IT, Data Governance, and Enterprise Architecture teams.

Ideal Candidate

• Strong Master Data Management (MDM) Specialist Profile.
• Mandatory (Experience 1) – Must have 3+ years of experience in Master Data Management (MDM), Data Governance, Data Quality, Data Operations, Revenue Operations, Sales Operations, Product Operations, or Enterprise Data Management roles.
• Mandatory (Experience 2) – Must have hands-on experience working with an enterprise MDM platform such as Informatica MDM, Informatica IDMC, Reltio, or any comparable Master Data Management solution.
• Mandatory (Experience 3) – Must have strong experience managing one or more master data domains including Customer Master, Product Master, Product Catalog, Account Hierarchy, Subscription, Contract, Billing, Revenue, Entitlement, or Reference Data.
• Mandatory (Experience 4) – Must have working knowledge of business processes such as CRM, CPQ, Quote-to-Cash (QTC), Order-to-Cash (OTC), Billing, Entitlement Management, Subscription Management, Contract Management, or Revenue Operations.
• Mandatory (Experience 5) – Must have strong understanding of core MDM concepts including Golden Record Creation, Match & Merge Rules, Survivorship Rules, Reference Data Management, Hierarchy Management, Data Stewardship Workflows, Data Quality Rules, and Cross-System Data Synchronization.
• Mandatory (Experience 6) – Must have hands-on experience in data profiling, cleansing, standardization, deduplication, validation, reconciliation, remediation, and data quality improvement initiatives.
• Mandatory (Hike) - AUXO AI follows a compensation policy of offering up to 25% hike on the candidate's current CTC. Candidates whose expectations exceed this range should be screened out during the initial discussion.
• Mandatory (Note) - Only immediate joiners who are available to join within 15 days are considered.
• Mandatory (Domain) – Must have experience working in SaaS, Subscription-based Businesses, Technology Companies, Enterprise Software Organizations, Cloud Product Companies, or Digital Platforms.
• Preferred (Salesforce Ecosystem) – Experience working with Salesforce CRM, Salesforce CPQ, Salesforce Revenue Cloud, Sales Cloud, Service Cloud, or Customer 360 implementations.
• Preferred (MDM Products) – Experience with Informatica Customer 360, Product 360, Reference 360, Cloud Data Quality, Cloud Data Governance, Reltio Connected Data Platform, or Reltio Data Cloud.
• Preferred (Integration Experience) – Experience integrating MDM platforms with Salesforce, CPQ, Billing Systems, ERP Applications, Data Warehouses, Data Lakes, Lakehouse Platforms, or Enterprise Reporting Solutions.

At Mitratech, we are a team of technocrats focused on building world-class products that simplify operations in the Legal, Risk, Compliance, and HR functions. We are a close-knit, globally dispersed team that thrives in an ecosystem that supports individual excellence and takes pride in its diverse and inclusive work culture centered around great people practices, learning opportunities, and having fun! Our culture is the ideal blend of entrepreneurial spirit and enterprise investment, enabling the chance to move at a rapid pace with some of the most complex, leading-edge technologies available.

For over 35 years, the experts at Mitratech have been focused on solving the complex needs. Today, we serve 20,000 client companies of all sizes globally, representing 30% of the Fortune 500 and over 500,000 users in over 160 countries.

As we continue to grow, we’re always looking for resourceful, enthusiastic, and fresh perspectives. Join our global team and see what makes Mitratech a truly exceptional place to work!

Job Overview 

Principal Data Engineer

About Engineering at Mitratech Legal Solutions 

Mitratech's engineering organization is a collaborative and dynamic environment where engineers are empowered to drive technical direction and innovation. Our engineers are passionate about delivering high-quality products and solutions that meet the evolving needs of our customers, and we're committed to fostering a culture of continuous learning and growth. 

About the Role 

Mitratech is a fast-paced and dynamic environment, and this role requires someone who is adaptable, resilient, and able to thrive in a rapidly changing landscape. If you’re a seasoned engineer with a passion for technical leadership, innovation, and collaboration — including building the data foundations that power trusted reporting and agentic AI-driven products — we’d love to hear from you. 

What You Will Do

•  Drive technical direction for a significant product domain or platform capability, ensuring alignment with business objectives and customer needs 

•  Design and maintain data pipelines and reporting models that power trusted business metrics and increasingly feed agentic AI systems (e.g., RAG ingestion, embeddings, vector stores, AI agent workflows) 

•  Use AI-assisted and agentic engineering tools (e.g., Claude Code, Copilot, Cursor, AI agents) as part of your own workflow, and help other engineers adopt agentic development practices effectively 

•  Reduce systemic complexity by identifying and leading architectural debt remediation, and developing strategies for ongoing technical debt management 

•  Partner with Product and Engineering leadership to inform multi-quarter roadmap feasibility, and provide technical guidance and oversight to ensure successful implementation 

•  Elevate engineering craft across multiple teams through RFCs, mentorship, and knowledge sharing, and develop training programs to improve engineering skills and knowledge 

•  Represent Mitratech’s technical capabilities externally, including speaking at conferences, contributing to open-source projects, and engaging with industry peers and thought leaders 

What We Are Looking For 

To be successful in this role, you will need: 

•  10+ years of experience in software engineering, with a focus on technical leadership and architecture 

•  Deep understanding of data engineering principles, including data modeling, data warehousing, reporting, and data governance 

•  Strong technical expertise in SQL, PostgreSQL, ETL/ELT pipelines, BI tools, and analytics platforms 

•  Practical experience with AI/LLM-adjacent and agentic AI data work — e.g., RAG ingestion pipelines, embedding generation, vector store management, or building/operating AI agent workflows over data — using AI coding assistants (Claude Code, Copilot, Cursor, or similar) as a regular part of the engineering workflow 

•  Working knowledge of modern cloud platforms such as AWS 

•  Experience with BI, reporting, dashboards, and customer-facing analytics 

•  Experience leading cross-functional initiatives with product, engineering, analytics, and business teams 

Nice to Have 

•  Working knowledge of Ruby on Rails and React 

•  Experience with a semantic or metrics layer (e.g., dbt Semantic Layer, headless BI) 

•  Understanding of CI/CD, Git-based workflows, and infrastructure-as-code 

The Stack Context 

•  Modern data stack: Fivetran, Airbyte, dbt, Snowflake, GitHub, Terraform, or similar tools 

•  Application context (nice to have): Ruby on Rails, React, or similar backend/frontend frameworks 

•  Data modeling: SQL, analytics models, documentation, testing, naming standards, and version control 

•  Infrastructure: cloud-based data infrastructure, infrastructure-as-code, CI/CD, monitoring, and cloud storage 

•  Data workflows: ingestion, transformation, orchestration, reporting, deployment, and change management 

•  Reporting focus: trusted metrics, scalable reporting models, dashboards, exports, and data quality 

•  AI surface: data pipelines and quality practices supporting AI/LLM and agentic AI use cases (RAG, embeddings, vector stores, AI agents) alongside traditional BI 

Why This Role 

This role offers a unique opportunity to drive technical direction and innovation at a rapidly growing company, while also mentoring and coaching engineers to improve their craft. As a Principal Data Engineer at Mitratech, you will have the chance to work on complex and challenging problems spanning trusted reporting and agentic AI systems, collaborate with cross-functional teams, and represent the company's technical capabilities externally. If you're looking for a role that offers a mix of technical leadership, data and reporting depth, agentic AI innovation, and collaboration, this could be the perfect fit for you. 

We are an equal-opportunity employer that values diversity at all levels. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, national origin, age, sexual orientation, gender identity, disability, or veteran status.

Strong Senior Developer – PL/SQL, SQL & ETL (Microsoft SSIS) Profile

2

Mandatory (Experience 1) – Must have minimum 5+ years of strong hands-on experience in PL/SQL and SQL development, including complex stored procedures, functions, queries, joins, data manipulation, and query/performance optimization.

3

Mandatory (Experience 2) – Must have strong hands-on experience in ETL development using Microsoft SSIS, including building, maintaining, optimizing, and troubleshooting SSIS packages for large-volume data movement and transformation.

4

Mandatory (Experience 3) – Must have solid experience working with Data Warehousing concepts and architectures, including data models, fact/dimension structures, ETL data flows, and enterprise reporting/data warehouse environments.

5

Mandatory (Experience 4) – Must have experience managing batch jobs, scheduling, and data pipelines, ensuring timely and reliable execution of enterprise ETL workflows.

6

Mandatory (Experience 5) – Must have hands-on experience in production support for SSIS/ETL and data warehouse jobs, including monitoring job execution, troubleshooting failures, performing root cause analysis, and implementing preventive fixes.

7

Mandatory (Experience 6) – Must have experience with data quality, validation, and troubleshooting, including identifying and resolving data discrepancies/issues affecting downstream reports, dashboards, and analytics.

8

Mandatory (Experience 7) – Must have experience with unit, integration, and regression testing of SQL, PL/SQL, and ETL components, along with strong documentation of technical designs, data mappings, data flows, and deployment processes.

9

Mandatory (Location) – Must be willing to work in a hybrid model from a city where Cognizant has an office.

10

Mandatory (Notice Period) – Immediate joiners or candidates who can join within 2–4 weeks.

Data & BI Support Specialist - JD

Professional Work Experience

• Microsoft SQL Server skills including SSIS, SSAS, DW and Power BI

• ADF, Databricks and Azure synpase skills will be preffered

• Excellent E-Mail and phone communication skills

• Experience in guiding BI Support Engineers

• Experience in global environment

• Ability to read code and support applications, reports and processes

• Excellent analytical and problem-solving skills

• Ability to contribute both independently and as part of a team

• Excellent listening, communication, interperson

• Excellent analytical and problem-solving skills

Looking for a strong Microsoft SQL Server + SSIS resource with L1, L2, L3 (mix) Production Support experience. Role is 75% support and 25% development. Candidate should be able to troubleshoot existing SQL code, ETL jobs, incidents, and perform RCA. Power BI is only 10%. Please prioritize SQL Support Engineers, SSIS Developers, and SQL Developers with production support exposure