Saurabh Dua

Datawarehouse Etl Architect - Assistant Vice President @Barclays

Pune, IN

Datawarehouse ETL Architect - Futures and Options datawarehouse - Prime Data ServicesTechnologiesDomain : Equities, derivatives and FICC ( Fixed Income Cash and Commodities ) Extraction Transformation Loading (ETL) Tool: Informatica PowerCenter 9.1 for batch processing Perl and shell scripts for Batch automation Loading Methodology: ETL – Intraday and End of Day batch Other Technologies: SSRS, Spotfire Archival Solution: RainStor : WORM CompliantTechnical Architect Developer for Equities DWH Technologies Databases: IBM Pure Data Appliance (Netezza) for Intraday US and Global Historical Repository and Oracle for Intraday in EMEA and APAC Extraction Transformation Loading (ETL) Tool: Informatica PowerCenter for batch processing and Java code for real-time loading Loading Methodology: ELT or ETL – Real Time, Near Real Time, Mini Batching, End of Day Other Technologies: Java.Net, Apache Lucene, Business Objects Archival Solution: RainStorMetrics & Performance Daily Volume Received: Averaging 100+ GB of data representing 250 - 300 Million rows with peak volume seen at 650 Million rows Current Data Size: 256+ Terabytes representing 100 + Billion Rows of data SLA: The platform supports 300+ users with query response times ranging from few seconds to a maximum of 90 seconds depending on the level of complication, load on the system and network bandwidth. The performance is closely monitored and tracked to avoid cascading impact on regulatory SLA’s from Data Warehouse

Gita Convent School

High School Examination

Maharshi Dayanand University

B.E.Hons