Logo
Amadan Recruitment

Informatica PowerCenter ETL Engineer

Amadan Recruitment, New York, New York, us, 10261


Job Title: Data Warehouse / Informatica ETL Engineer

Location: Midtown NYC

Our client is a mid-sized financial services firm committed to delivering exceptional services and innovative solutions. We are currently seeking a skilled Data Warehouse / Informatica ETL Engineer to join their dynamic team and contribute to the design and development of robust ETL processes.

Position Overview: The Data Warehouse / Informatica ETL Engineer will be responsible for the design and development of ETL processes, with a focus on leveraging Informatica PowerCenter tools. This role will involve collaborating with cross-functional teams to ensure the successful implementation of data warehouse solutions, supporting error handling conditions, and contributing to the overall efficiency and effectiveness of our data management systems.

Key Responsibilities:

Design, develop, and implement ETL processes using Informatica PowerCenter tools to extract, transform, and load data from various sources into the data warehouse.Collaborate with stakeholders to understand business requirements and translate them into technical solutions.Assume a senior role within the team, providing guidance and mentorship to junior members as needed.Develop and maintain T-SQL scripts for data manipulation and validation purposes.Implement error handling conditions and validations to ensure data integrity and accuracy throughout the ETL process.Utilize Linux environments for hands-on development and troubleshooting tasks.Explore opportunities for automation and optimization of ETL processes, leveraging Ruby scripting experience where applicable.Stay updated on industry best practices and emerging technologies related to data warehousing and ETL processes.Qualifications:

Bachelor's degree in Computer Science, Information Systems, or a related field.Minimum of 3 years of experience in designing ETL processes, preferably in a senior capacity within a team.Minimum of 8 years of hands-on experience developing ETL processes, with a strong focus on Informatica PowerCenter tools.Proficiency in T-SQL for data manipulation and querying.Experience in designing, building, and supporting ETL error handling conditions and validations.Strong hands-on experience with Linux environments.Experience with Ruby scripting is a definite plus.Excellent problem-solving skills and attention to detail.Ability to work collaboratively in a fast-paced, team-oriented environment.Strong communication and interpersonal skills.Financial services related experience preferred.THIS IS A CONTRACT to HIRE POSITION. Client will not sponsor.