Job Description :
Position: Datastage Developer
Company: TCS/Synovus
Location: Columbus, GA
Duration: 6 Months (Contract)
Exp : 6+ Yrs
Skills:
Technical/Functional Skills: The candidate should have excellent hands-on experience on –
Min. 5 to 8 years of hands on experience in IBM Data stage ETL Projects
Experience in Project life cycle activities on DW/BI development and maintenance projects
Knowledge of IBM Data stage Architecture, Stages/Transformations, Design, ETL flow, advanced SQLs
Should have worked in project run on Agile methodology • Knowledge of data loading techniques using Data stage
Develop Data stage Parallel Extender jobs using different stages
Using Data stage Director for running and monitoring the jobs.
Created Data stage sequences to run the batch jobs.
Knowledge Best Practices in Data stage, Performance. improvements, implementing CDC, UDFs •
Extensive Experience in Teradata, SQL Server and Oracle SQL, PL/SQL.
Good experience with database development tools (Toad, SQL Developer)
Roles & Responsibilities:
Responsible for supporting and contributing to delivery of development services
Identify key drivers of a defined problem and proposes solutions
Identify and solve problems using analysis, experience, and judgment
Design and code ETL jobs (Parallel, Server and Sequential) in IBM DataStage to load the Data-warehouse
Develop Unix Shell scripts for data analysis and DataStage job execution
Write SQL queries in IBM DB2 to perform data validation Exposure pulling data from multiple sources including: xml, delimited flat files, and other data sources
Experience translating functional ETL requirements into technical design documentation