Hello Partner,
Hope you doing well
Role: ETL DataStage Developer
Location - Chicago, Illinois (Hybrid, Need Locals)
Experience: 9+ Years
MANDATORY SKILLS:
· ETL
· IBM DataStage
· Data Warehouse / BI
· RDBMS
· Oracle and DB2
JOB DESCRIPTION:
· 8+ years of experience with back end RDBMS and data modeling / database design(Oracle and DB2 preferred)
· 5+ years of hands on experience in Design, Development & Build activities in IBM Datastage(v8.5 and above) ETL Projects
· Experience in software development life cycle
· Experience in DW/BI related technologies and tools – MUST
· Experience in Project life cycle activities on DW/BI development and maintenance projects
· Experience in Design and Architecture review
· Knowledge of IBM Datastage Architecture, Stages/Transformations, Design, ETL flow, advanced sqls-Knowledge of data loading techniques using Datastage
· Develop Datastage Parallel Extender jobs using different stages like Aggregator, Join, Merge, Lookup, Source dataset, External Filter, Row generator, Column Generator, Change Capture, Copy, Funnel, Short, Peek stages etc
· Using a Datastage Director for running and monitoring the jobs.
· Created Datastage sequences to run the batch jobs.
· Knowledge Best Practices in Datastage, Performance improvements, implementing CDC, UDFs
NOTE: PLEASE DON`T SUBMIT CPT, OPT, H1-T & GREEN CARD HOLDERS
Thanks & Regards
Teja
HCL Global Systems, Inc
Email Id: Te...@hclglobal.com
Hangouts: Teja.h...@gmail.com | LinkedIn: Teja Teju | LinkedIn
Certified Minority Business Enterprise (MBE)