Lead Developer IBM Datastage ETL

At least 4+ years of relevant experience in DataStage Admin, Development and CDC. At 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 database 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. #J-18808-Ljbffr TechDigital Group