Technical Specialist - ELT Sr. Developer with Wherescape RED ELT Tool, Informatica is plus

Work Location: Los Angeles, CA,MP office

Desired skills and responsibilities:

ELT Developer: (We need ELT Sr. Developer with Wherescape RED ELT Tool, Informatica is plus)

6+years of experience as Wherscape/ELT Sr. Developer
Data Warehousing within the last 3 years
Data Integration within the last 3 years
Thorough understanding of DWH
Proficient and hands-on experience in Wherescape RED
Proficient and hands-on experience in MPP databases (Greenplum / Teradata / Netezza, etc.,)
Understanding of Data Models: Conceptual, Logical, and Physical & Dimensional/Relational Data Model Design.
Should able to understand Data Warehouse architecture and code
Banking/Financial sectors experience is a plus
Develop detailed ETL specifications based on business requirements
Develop Source to Target Mapping
Analyze functional specifications and assist in designing potential technical solutions
Identifies data sources and works with source system team and data analyst to define data extraction methodologies
Excellent troubleshooting skills
Good experience on Data Analysis, Data Profiling and Root Cause Analysis
Defines, develops, documents and maintains Wherescape/ Informatica ELT/ETL mappings and need to be well versed in Unix shell scripting
Good knowledge in writing complex queries on RDBMS
Unit/Integration testing activities and assist in User Acceptance Testing
Maintain batch processing jobs and respond to critical production issues
Good team player and positive attitude