Previous Job
Previous
ETL / Data Analyst
Ref No.: 18-30340
Location: New York City, New York
Position Type:Full Time/Contract
Start Date: 05/02/2018
Job Description:
8-10 years of development experience on ETL and SQL
Expert knowledge of Teradata (or similar DB), SQL Stored Procedures, Triggers, and data querying optimization
Ability to understand and analyze the data to find patterns and valuable business insights
Extensive experience in designing and developing of complex mappings, applying various transformations such as lookup, source qualifier, update strategy, router, sequence generator, aggregator, rank, stored procedure, filter, joiner and sorter transformations
Good knowledge of Unix scripting
Experience in integration of various data sources like Teradata, Hadoop, SQL Server, and Flat Files into the staging area
Expert in designing Parallel jobs using various ETL transformations.
Good knowledge in identifying performance bottlenecks and also in tuning the Mappings and Sessions
Excellent communication, interpersonal, analytical and leadership skills, self-motivated, quick learner and a team player. Ability to work in a team and individually, independent thinker, focused on meeting deliverables in a remote environment
Clear understanding of RDBMS, ER, 3rd n forms, OLAP dimensional Models