Lead Developer IBM Datastage ETL

Lead Developer IBM Datastage ETL 10 yrs of Experience t least 4 years of relevant experience in DataStage Admin, Development and CDC t least 2 years of recent hands-on experience in IBM Data Stage using v11.x ETL tool and rest in other ETL tools. Expertise in Data Warehousing ETL Tool DataStage using Components like DataStage Designer, DataStage Director and DataStage Operations Console. Efficient in all phases of the development lifecycle, coherent with Data Cleansing, Data Conversion, Performance Tuning and System Testing. Efficient in identifying and finalizing the various source file formats and frequencies from different source systems. In depth experience in troubleshooting of Datastage jobs and addressing issues like performance tuning. Expert level proficiency in UNIX skills Experienced in automation of the jobs using Unix scripts. Experience in developing of reusable Unix Jobs/components Strong understanding of Data warehousing concepts, dimensional Star Schema and Snowflakes Schema methodology. Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using Snowflake Cloud Datawarehouse as well as SQL and Azure 'big data' technologies Work with stakeholders including the Executive, Product, Data and Design teams to assist with data-related technical issues and support their data infrastructure needs. 4years of experience in databases technologies like DB2, Oracle, TERADATA, Hive and HBase. Very efficient in developing SQL queries and debugging complex SQL queries. Expert level SQL tuning skills in any of the RDBMS. Good knowledge on AutoSys scheduler is desired