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.
• 4 years 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