Job Description :
Job Description
Candidate should be around 8-10 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 etcanyone
Good to have:
Hands-on experience applying modeling techniques to actual business solutions.
Knowledge of Salesforce.
Good experience on Onsite and offshore co-ordination and Handling ETL team.
Good communication skills, ability to work independently on ETL tasks, including data-analysis 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