Role: Data Engineer (Informatica Power Center)
Location: New York, NY
Duration: 6 months
Job Summary
The Data Engineer is part of a Corporate Analytics team responsible for supporting data and analytics solutions for Client's Corporate Functions. This individual will collaborate with analytics team to design and implement Client corporate data strategy, ensuring reliable data infrastructure and creating data solutions for variety of business use cases. This individual will primarily support on enterprise financial data warehouse and multiple data marts working with various stakeholders and reporting applications team, successfully delivering the data requirement solutions.
Must Have
8+ years of experience with Oracle and SQL Server databases
8+ years of experience with Informatica Power Center.
8+ years software development experience in one or more of the following areas: ETL, BI and DW
8+ years of experience in DW Multi-Dimensional modelling.
Understanding of the Project Delivery Framework and SDLC
Understanding of Waterfall and Agile Project Management Methodology
Strong analytical, communication and interpersonal skills.
Excellent and proven collaboration skills
We Will Count On You To
Designs, develops, automates, and supports complex applications to extract, transform, and load data.
Ensures data quality of the warehouse and data marts.
Plans and conducts ETL unit and development tests; monitors result and takes corrective action.
Work on basic and advanced transformations in informatica power center independently.
Performance Tuning of SQLs and handles huge volumes of data.