Job Description :
ETL Informatica Developer
12+ months
Skype interview
New York City, NY
Job Description:
Work in our fast-paced investments and risk technology team with minimal oversight over the investments data warehouse.
Principal Responsibilities:
Participate in all aspects of the system development life cycle with specific focus on the design, estimation, construction, and testing of both Service and ETL components.
Take ownership of the full life cycle for the solution, from analysis and design through testing and delivery.
Perform hands on development on medium to large data warehouses using data modeling, dimensional data structures and complex hierarchies.
Perform expert level ETL design, development, and performance tuning using Informatica PowerCenter & Java.
Perform expert-level complex SQL coding/querying/tuning skills in SQL Server.
Design and develop existing codebase and grasp the functionality, design, and refactoring opportunities of the code in Java.
Design and develop solutions using service-oriented architecture. Use BI reporting tools to improve the team''s implementation and development discipline.
Requirements/Competencies for Success:
A computer-related Bachelor’s degree followed by
At least 7 years financial services experience to include:
7 years each with data modeling, ETL, Java, and Informatica.
5 years each with SQL, and Reporting.
Strong expertise in Informatica (Integration tool), Oracle DB and have exposure to other integration platform like Talend, data prep tool Alteryx, and AWS S3.