Infomatica Support

Intellics Global Services; Pune District, Bengaluru; On-site; INR 900,000 - 1,300,000; Full time

Job summary

Tech Mahindra seeks an experienced Informatica PowerCenter specialist to support BI ETL processes and data validation. You will develop ETL mappings, monitor jobs, and tune performance while ensuring SLA adherence.

You will participate in production support, incident resolution, and stakeholder communication, with weekend shifts if required, and experience with Azure Databricks a plus.

Qualifications

• Must have hands-on experience in Informatica PowerCenter, ETL and SQL with production support and Azure.
• Strong experience developing ETL processes, writing complex queries, performance tuning and data validation.
• Experience using parameter files, parameters/variables and troubleshooting using advanced Informatica techniques like session partitioning, push down optimization.

Responsibilities

• Provide application support for BI ETL Informatica tools.
• Monitor, analyze and resolve ETL jobs related issues.
• Maintain batch processing jobs and respond to production issues; communicate with stakeholders on recommendations.
• Resolve incidents within SLA; willing to work weekends when needed.
• Work independently on production support incidents.

Skills

Informatica PowerCenter

ETL

SQL

Production support

Azure

Tools

Informatica PowerCenter Designer

Workflow Manager

Workflow Monitor

Repository Manager

Azure Databricks

Spark/PySpark

Job description

Role & responsibilities :

MUST Skill: Strong hands-on experience in Informatica PowerCenter, ETL , SQL. , production support experience, AZURE

Strong hands-on experience in Informatica PowerCenter and SQL, with expertise in developing ETL processes, writing complex queries, performance tuning, and data validation.

Preferred candidate profile

• Provide application support for business intelligence (ETL) Informatica tools.
• Monitor, analyze and resolve ETL jobs related issues.
• Maintain batch processing jobs and respond to critical production issues communicate well with stakeholders on his her proposal recommendations
• Resolve all incidents, service requests, Align within SLA targets and. Willing to work in weekends when needed.
• Can work independently on production support incidents
• Prior experience in Informatica production support is a Big Plus.
• Experience using parameter files, parameters/variables and troubleshooting using advanced informatica techniques like session partitioning, push down optimization etc.
• Experience in developing Informatica PowerCenter ETL mappings using Designer, Workflow Manager, Workflow Monitor, and Repository Manager
• Expertise in Datawarehouse and Mart model w.r.t Informatica/SQL
• Ability to Analyze data warehousing systems
• Strong collaboration and teamwork skills
• Self-starter with "can-do" attitude, a must in a fast-paced business and technical environment
• Should have experience in writing/preparing/analyzing SQL queries.
• Knowledge on Azure Databricks & Spark/PySpark is an added advantage.

Must have skills

• Informatica
• SQL/Oracle/Netezza
• Note: we are looking for only immediate candidates and serving notice period candidates only

Experience: 9 to 11 Years

Location: Pan India

Company : Tech Mahindra