ETL Informatica Lead

Job Title: ETL Informatica Lead (Day1 Onsite)

Location: Branchville, NJ,  

Years of Experience: 7- 12 Years

 Job Summary:

We are seeking a highly skilled Informatica Administrator to join our Support Function team. The ideal candidate will have extensive experience in Informatica Administration, with a proven track record of managing and optimizing ETL processes. This role requires a detail-oriented professional who can ensure the smooth operation of our data integration systems while providing exceptional support to our internal teams.

 Responsibilities:

• Administer and maintain Informatica PowerCenter environments, ensuring optimal performance and availability.
• Monitor ETL processes, troubleshoot issues, and implement solutions to enhance data processing efficiency.
• Collaborate with data architects and developers to design and implement data integration solutions.
• Manage user access and security settings within Informatica, ensuring compliance with company policies.
• Conduct regular system audits and performance tuning to ensure high availability and reliability of ETL processes.
• Provide technical support and training to team members on Informatica best practices and functionalities.
• Document processes, configurations, and troubleshooting steps for future reference.
• Stay updated with the latest Informatica features and industry trends to recommend improvements.

Mandatory Skills:

• Strong expertise in Informatica Administration, including installation, configuration, and maintenance.
• Proficient in ETL processes and data integration methodologies.
• Experience with performance tuning and optimization of Informatica workflows.
• Solid understanding of database technologies (e.g., Oracle, SQL Server) and data warehousing concepts.
• Excellent problem-solving skills and the ability to work under pressure.
• Strong communication skills, both verbal and written, to effectively collaborate with cross functional teams.

Preferred Skills:

• Experience with cloud-based data integration solutions.
• Knowledge of scripting languages (e.g., Shell, Python) for automation tasks.
• Familiarity with Agile methodologies and project management tools.
• Certifications in Informatica or related technologies.

Qualifications:

• Bachelor’s degree in computer science, Information Technology, or a related field.
• 7 10 years of experience in Informatica Administration or a similar role.
• Proven experience in managing large scale data integration projects.