
Kshitiz Shrivastava
Verified Expert in Engineering
ETL Architect and Developer Developer
Toronto, ON, Canada
Toptal member since April 1, 2025
Kshitiz is a results-driven technology leader with 18+ years of experience in infrastructure modernization, data analytics, and business intelligence (BI) strategy. He has a proven track record of modernizing enterprise BI infrastructures and leading multi-million-dollar government, retail, CPG, insurance, and finance projects. Kshitiz specializes in ETL architecture, Oracle EPM infrastructure, data analytics, and cloud transformation.
Portfolio
Experience
- PL/SQL - 18 years
- Oracle - 18 years
- Informatica - 18 years
- Data Visualization - 10 years
- Oracle Data Integrator (ODI) - 9 years
- Oracle Hyperion Planning - 9 years
- Oracle OEM 13c - 9 years
- Tableau - 4 years
Availability
Preferred Environment
Informatica, Oracle, Oracle Data Integrator (ODI), Tableau, Oracle Hyperion Planning, Azure Data Factory (ADF)
The most amazing...
...project I've participated in reduced infrastructure costs by 50% by consolidating Hyperion and Oracle Data Integrator (ODI) infrastructure.
Work Experience
Principal BI Consultant | EPM Infrastructure Lead | ETL Architect | ETL Developer
Government of Ontario
- Reduced infrastructure costs by 50% by consolidating systems.
- Improved data processing times by 30% by optimizing data pipelines and PL/SQL code.
- Led enterprise performance management (EPM) upgrades in complex clustered, load-balanced, and multiplatform environments.
- Conducted Informatica and Oracle Data Integrator (ODI) upgrades.
- Migrated Hyperion's Essbase from a physical server to a virtual machine, reducing the operating cost of the environment by 20%.
- Spearheaded the migration of on-prem Hyperion applications to Azure Cloud.
Principal BI Consultant
Iconomics
- Led EPM infrastructure upgrade projects in complex clustered and load-balanced Windows and Solaris environments.
- Researched Change Data Capture features in SQL Server environments for reporting.
- Conducted research and evaluation of Oracle Cloud and Oracle Analytics Cloud (OAC) to lift and shift Oracle Business Intelligence Enterprise Edition 11g (OBIEE).
- Supported Hyperion EPM infrastructure and applications, including data integration and loading using ODI and FDMEE.
ETL Architect | Informatica Lead Developer | Cognos Support Specialist
Tata Consultancy Services
- Led the BI system merger when Kraft Foods acquired Cadbury.
- Managed the BI system split when Kraft Foods split into Mondelez.
- Conducted the Informatica upgrade from 8.6 to 9.5 and designed and developed ETL processes for indirect sales reporting.
Experience
Hyperion EPM Infrastructure Modernization
I then executed the upgrade, performing in-place upgrades on both Windows and Linux nodes, applying patches, reconfiguring WebLogic, updating database schemas, and ensuring seamless integration with existing applications. Post-upgrade testing involved conducting rigorous functional, performance, and regression testing across planning, Essbase, and reporting modules to confirm data integrity and system performance.
The upgrade was successful as it minimized disruptions in business operations while ensuring a stable, high-performing EPM environment with enhanced security and extended Oracle support.
Cadbury and Kraft Foods BI Systems Merger
This project involved strong collaboration with IS project teams and key stakeholders to assess system-driven changes, define migration strategies, and align change management efforts. I ensured a seamless data transition, improved reporting accuracy, and minimized business disruptions during the integration.
Kraft and Mondelez BI Systems Split
Education
Bachelor's Degree in Information Technology
Shri Govindram Seksaria Institute of Technology (SGSITS) - Indore, MP, India
Certifications
Create Mapping Data Flows in Azure Data Factory
Coursera
Informatica Data Management Cloud (IDMC) Foundation
Informatica
Azure DevOps for Beginners
Academy Accreditation – Databricks Fundamentals
Databricks
Microsoft Certified – Azure Data Fundamentals
Microsoft
Tableau Desktop Specialist
Tableau
Oracle Cloud Platform Enterprise Analytics 2021 Certified Specialist
Oracle
Oracle Autonomous Database Cloud 2021 Certified Specialist
Oracle
Oracle Cloud Infrastructure Foundations 2020 Certified Associate
Oracle
Oracle Cloud Infrastructure 2019 Cloud Operations Certified Associate
Oracle
Informatica Developer Specialist
Informatica
Skills
Tools
Oracle OEM 13c, Tableau, Oracle BI Publisher, Oracle Business Intelligence Enterprise Edition 11g (OBIEE), IBM Cognos, Jira, Autosys, Microsoft Power BI, Erwin, Hyperion
Paradigms
Oracle ODI, ETL, Azure DevOps
Platforms
Oracle Data Integrator (ODI), Oracle, WordPress, Azure, Oracle Analytics Cloud (OAC), Databricks
Storage
PL/SQL, Oracle Cloud, SQL Server Integration Services (SSIS), SQL Server DBA, Azure Cloud Services
Languages
Java
Other
Informatica, Software Engineering, Unix Shell Scripting, Batch Scripting, Oracle Hyperion Planning, Azure Data Factory (ADF), Change Data Capture, SAP, Data Visualization, Informatica Cloud, Oracle Hyperion EPM, Information Technology, FDMEE
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring