Informatica PowerCenter Lead
Mahika ArzareUnited StatesLEADPosted 45m ago
IICS - IDMCInformatica PowerCenterMS SQL ServerDatabricksPower BI
About the Role
We are looking for an experienced Informatica PowerCenter Lead to join our team in Short Hills, NJ. This role involves working on ETL-based projects using Informatica PowerCenter and IICS Cloud.
Key Responsibilities
• Understand where to obtain information needed to make appropriate decisions
• Break down problems into manageable pieces and implement effective, timely solutions
• Identify the problem versus the symptom
• Manage problems that require involvement of others to solve
• Reach sound decisions quickly
• Carefully evaluate alternative risks and solutions before taking action
• Optimize the use of all available resources
• Develop solutions to meet business needs that reflect a clear understanding of the objectives, practices, and procedures of the corporation, department, and business unit
Requirements
• 7+ years of work experience in Informatica PowerCenter and IICS
• Strong SQL fundamentals
• Experience in data migration on cloud projects involving Informatica
• Good analytical and logical skills in writing SQL stored procedures and creating marts/views in SQL Server/Oracle
• End-to-end knowledge of the ETL landscape, starting from source systems, data warehouse marts, and reports
• Very strong ETL concepts and hands-on experience with Informatica ETL tool (Basic/Advanced)
• 4-year degree in a related field or equivalent experience
• Experience working within a highly matrixed organization
• Strong communication and presentation skills