• Expert skills and extensive experience in Datastage development.
• Good DWH experience.
• Should be a senior Architect level in DWH
• Oracle DB, Greenplum development experience is a plus
experience in software design and development.
experience in Data Integration for Data Warehouses including IBM Info Sphere/WebxSphere/AscentialData stage (9.x / 10. X /11.X) (8.7/8.5/8.0.1/7.5.1/7.5.2) Server Edition
experience in Analysis, Design, Development and Implementation of Relational Database (OLTP) and Data Warehousing Systems (OLAP), Data Modeling phases conceptual, experience in working with Casandra, Data warehouse development life cycle and Design of Data marts and Integrated Schemas.
Candidates should be able to answer and strong in scenario based quetions on OLTP & OLAP, File to Database Transformation and other Transformation process.
1. Experience in ASP.NET web application
2. C#.NET experience is must with good hands on in Delegates, Threading, WCF, etc
3. SQL Server 2012 or above with good knowledge in Stored Procedures, Functions, Triggers
4. SSIS ETL – SQL Server Integration Service is value added
5. Crystal Reports experience is a plus