Informatica Power Center-IDMS/IICS

Introduction:

This position requires 8 to 10 years of experience in Informatica Power Center, IDC, PowerShell, and informatica Packages such as IDMC/IICS. The ideal candidate should have hands-on Informatica development experience with preference given to those with ETL consulting experience, MDM, and Analytics reporting.

Responsibilities:

• Hands-on experience with Data Module & Framework Manager development with Power Center.
• Strong SQL proficiency (Oracle, SQL Server, Teradata, etc.) and understanding of data modeling.
• Expertise in Teradata utilities like BTEQ, Multi-Load, view point, SQL assistant, Azure SQL Databases, Fast Export, TPT.
• Experience with Large Enterprise Clients and knowledge of Unix/Linux shell scripting for automation and scheduling tools (e.g., Control-M, Autosys).
• Advanced knowledge of SQL and Java.
• Create mapping, mapplets, sessions, and workflows, ensuring alignment with technical specifications.
• BI Data Modeling – Informatica or Python, ability to analyze complex data sets, ensure data quality/integrity.
• Implement data quality rules and governance policies to ensure the accuracy, consistency, and completeness of customer data.
• Manage the lifecycle of customer data, ensuring compliance with relevant regulations (e.g., GDPR, CCPA).
• Analyze customer data to identify trends, patterns, and insights for customer experience initiatives.
• Develop and maintain dashboards and reports that provide actionable insights to stakeholders.
• Utilize advanced analytics tools and techniques (potentially AI/ML) to segment customers, predict future behavior, and identify improvement opportunities.

Requirements:

Required Skills: Informatica PowerCenter, IICS, IDMS

Preferred Skills: ETL consulting experience, MDM, Analytics reporting