Informatica Specialist

Job Title: Informatica Specialist

Location: Hyderabad

Experience: 513 Years

Work Model: Hybrid (3 days in office, 2 days WFH)

Job Summary:

We are seeking an experienced Informatica Specialist with 5 to 13 years of hands-on expertise in Informatica PowerCenter to design, develop, optimize, and support ETL processes. The ideal candidate will collaborate with business stakeholders and technical teams to ensure the delivery of high-quality, scalable, and efficient data integration solutions.

• Design, develop, and deploy ETL mappings and workflows using Informatica PowerCenter.
• Collaborate with business stakeholders and the CIO to gather and refine data integration requirements.
• Analyze, troubleshoot, and resolve ETL-related incidents, performance bottlenecks, and environment issues.
• Create comprehensive documentation including design specifications, development artifacts, and operational procedures.
• Ensure data quality and integrity through thorough testing, validation, and review processes.
• Maintain, enhance, and optimize existing Informatica workflows for improved performance and scalability.
• Stay updated with emerging Informatica technologies, tools, and best practices to continuously improve ETL processes.

Roles & Responsibilities:

• Monitor daily batch jobs, ETL workflows, and data movement processes to ensure seamless production operations.
• Coordinate with L1 support teams for incident detection, investigation, and resolution related to Informatica PowerCenter.
• Perform root cause analysis on production issues and implement preventive and corrective actions.
• Manage incident, problem, and change records using enterprise tools such as ITSM and JIRA.
• Provide timely communication and status updates to business stakeholders regarding incidents and resolutions.
• Collaborate with development, QA, and support teams to address recurring issues and contribute to system improvements.
• Recommend and support process automation initiatives to reduce manual dependency and enhance system reliability.
• Support release management activities and ensure smooth deployment of ETL changes into production environments.

Required Skills (Mandatory):

1. Informatica PowerCenter
2. Informatica PowerExchange
3. ANSI-SQL
4. Dimensional Data Modeling
5. Informatica Administration