Datawarehouse Engineer

Description

Job Description Candidate should be around 810 years of experience and work location would be Century City, California.
Knowledge of IBM DataStage Architecture, Stages/Transformations, Design, ETL flow, advanced SQLs.
Knowledge of data loading techniques using DataStage
Hands on ETL development experience with good knowledge of Data warehousing concepts and experience on data modeling.
Experienced in DataStage Parallel jobs development using different stages like Aggregator, Join, Merge, Lookup, dataset,Filter, Row generator, Column Generator, Change Capture, Copy, Funnel, Sort, peek,Routines etc.
Knowledge and experience on DataStage Director for running, monitoring and error management the jobs.
Experienced in development of DataStage sequences to run the batch jobs.
Understanding and Experience on Unix/Linux system, file systems, shell scripting
knowledge of scheduling tools such as Control M,Autosys,Tivoli etc.(anyone).
Good to have Handson experience applying modeling techniques to actual business solutions.
Knowledge of Salesforce.
Good experience on Onsite and offshore coordination and Handling ETL team.
Good communication skills, ability to work independently on ETL tasks, including dataanalysis and documentation.
Project Description
Westfield is into Real Estate commercial Lease Management solution. They currently have Lease Management application which is in production, Tavant is involved in enhancing application and fixing production issues. There are upstream applications from where data flows into salesforce application. We are looking someone who can work on ETL side to fix data issues