Informatica ETL Hadoop UNIX DB Team Lead at NYC

Title: Informatica ETL Hadoop UNIX DB Team Lead

Location: NYC

Duration: Contract

Note: Need someone with strong Informatica, UNIX, SQL and Data warehouse skills and Hadoop Hive experience

Job Description:

Analytics and Data team at client is responsible for delivering the data strategy enterprise reporting and big data capabilities to its business partners
The team is looking for Hadoop Scoop Hive Spark Scala UNIX SQL skills to help advance its goals to build a world class data driven enterprise

Responsibilities

The person will be primarily responsible for Creating and maintaining data streams and processes within the EDW platforms
Profile and analyze various data sources
Design and implement data ingestion strategy
Design develop code test and debug complex new code packages or make significant enhancements to existing code packages
Interact with business users to understand and document the requirements

Required Skills

Overall 8 years experience in Data and Data Management Technology
2 year experience using Hadoop Scoop Hive Spark Dataiku Scala SQL skills
Knowledge of Kafka desired
Knowledge or experience with Informatica ETL Unix RDBMS e g Oracle DB2 Teradata desired
Strong data warehousing concept
Good knowledge of database structures theories principles and practices
Financial domain experience is must
Excellent business communication desired
Experience interacting with Technical and Business stakeholders
Experience with Global Delivery Model must have acted as Team Lead for a team of 10 15 people