Saurabh Dua
ETL Architect - Futures and Options datawarehouse - Barclays Global Service Centre Pvt Ltd Pune
- Role
- Datawarehouse Etl Architect - Assistant Vice President at Barclays
- Location
- Troy, MI, US
- LinkedIn followers
- 500 followers
About Saurabh Dua
Primary Expertise : Business Intelligence, Data Warehousing, Data Architecture, Data Analysis, Data Modeling, ETL & Reporting. Informatica 9.1 Upgradation Consultancy
Experience
Datawarehouse Etl Architect - Assistant Vice President
May 2013 — Present · 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
Education
Gita Convent School
High School Examination
1989 — 2001
Maharshi Dayanand University
B.E.Hons
2001 — 2005
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.