Informatica PowerCenter Developer

Job Title: Informatica PowerCenter Developer

Duration: Fulltime

Location: Hybrid Tuesday Wednesday Thursday

Charlotte NC; Colorado Springs CO; Conshohocken PA; Dallas TX; Fargo ND; Florham Park NJ; Garden City NY; Houston TX; Jacksonville IL; Lenexa KS; Lubbock TX; Mt Juliet TN; New York NY; Purchase NY; Topeka KS

Job Description:

We are seeking a highly skilled and experienced Informatica PowerCenter Developer to join our team. As an Informatica Developer you will be responsible for designing developing maintaining and enhancing ETL processes for our data warehouse using Informatica PowerCenter. The ideal candidate will have extensive experience in ETL development strong leadership skills and expertise in Informatica tools and processes.

Key Responsibilities:

• Design develop and maintain Informatica mappings workflows and processes to extract transform and load data into the data warehouse.
• Lead and coordinate an Informatica development team providing guidance mentoring and technical expertise.
• Collaborate with stakeholders to gather requirements and design solutions that meet business needs.
• Develop and optimize complex SQL queries to support ETL processes and data analysis.
• Utilize integration technologies and processes to ensure seamless data flow between systems.
• Perform data validation and testing using tools such as Query Surge.
• Work in a Windows environment to deploy and manage Informatica solutions.
• Apply Kimball design methodology to ensure efficient and scalable data warehouse designs.
• Provide support and troubleshooting for Informaticarelated issues.

Required Skills:

• 10 years of handson experience in ETL development for a data warehouse.
• 10 years of handson experience in development maintenance and enhancements of Informatica Mappings Workflows and processes.
• 8 years of leadership experience including the management and coordination of an Informatica team.
• Strong proficiency in complex SQL.
• Expertise with integration technologies and processes.
• Experience with Query Surge for data validation.
• Experience working in a Windows environment.
• Knowledge of testing tools and techniques.
• Working knowledge of Kimball design methodology.

Educational Qualifications:

• Bachelors degree in Computer Science Information Technology or related field (or equivalent experience).