Informatica Support/Developer

Informatica Support –

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

Experience: 5 to 7 Years

Location: Pan India

Notice period: Immediate joiners

Job Description

This is basically for a BI Developer/support role and the person should be ready to work in rotational shifts. This position is responsible for informatica power center production support, break fix, resolving prod issues and communicating customer and application tickets related to Informatica, Oracle, SQL Server database for the Data warehouse/Data Mart platform. Looking for resources who are having minimum 5 years of experience in Informatica power center and SQL/Netezza/ Oracle. Should have knowledge on Azure Databricks & Spark/PySpark as a secondary skill.

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

Job Responsibilities

ü 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

Location- PAN India

Yrs of Exp-6-10 Yrs