Sushil Kumar Tiwari

Sushil Kumar Tiwari is an enterprise data engineering and cloud integration leader with 15+ years of experience designing and delivering data warehouse and analytics platforms across banking, insurance, and financial services. His career centers on a practical mandate: turn fragmented enterprise data into governed, high-performance, decision-ready assets—delivered through repeatable ETL/ELT patterns, cloud-native architectures, and disciplined testing and migration programs. Across roles spanning engineering leadership, cloud ETL/BI delivery, and large-scale modernization, he has consistently translated platform transitions into measurable improvements in cost, throughput, and operational reliability.

Tiwari’s technical foundation is anchored in enterprise data platforms and integration stacks, including Informatica PowerCenter 10.x, IDMC (Informatica Cloud Services), Snowflake, BODI, and a broad set of AWS services. He has built deep hands-on capability in Snowflake-native patterns—ETL/ELT design, SnowSQL, SnowPipe, and Dynamic Tables—with supporting exposure to AWS orchestration and warehousing capabilities such as Step Functions and Redshift. His work connects data engineering to analytics consumption through BI layers including Tableau, Power BI, SSRS, and AWS QuickSight, grounded in dimensional modeling, OLAP concepts, and SQL/PLSQL optimization for performance-critical pipelines. In regulated BFSI contexts, this platform mastery is coupled with practical alignment to enterprise data warehouse (EDW) standards and compliance-driven requirements.

A significant portion of Tiwari’s record involves modernization programs where the core challenge is not building from scratch, but migrating large estates of jobs, models, and operational controls without breaking business reporting and downstream dependencies. As an ETL Test Lead at Appzlogic for Harvard Business School, he led testing strategy for the Student Admissions & Programs Data Warehouse during a migration of 230–300 jobs from PowerCenter to IDMC across multiple source systems. By introducing automation via UNIX shell scripting and Python, he reduced manual testing effort by 30–40%, improving release confidence and accelerating verification cycles—an impact that directly reduces delivery friction during platform transitions.

At Synechron, supporting Asurion, Tiwari served as Lead Cloud ETL/BI Engineer on data ingestion and migration programs and helped establish a Snowflake-centered data warehousing strategy. He delivered measurable platform economics, including a 40% reduction in data storage cost, and led migration patterns that replaced a Redshift framework with a Databricks Lakehouse + AWS architecture while consolidating heterogeneous sources—flat files, JSON, SQL Server, and Oracle—into Snowflake with a Presto exposure layer. In parallel, he led Tibco deprecation and migration efforts for Asurion’s LATAM telecom services, moving legacy integrations to Informatica PowerCenter and building dedicated client datamarts supporting providers such as TelCel, AT&T Mexico, and Claro. These programs required careful orchestration of enterprise data layers—processing customer status and transactional data from BG, DAX, and finance systems—while maintaining operational correctness across multiple file formats and delivery schedules.

One of the most scale-intensive parts of his portfolio is reflected in Asurion’s Enterprise Data Services initiatives (e.g., ATLAS/EDP). Tiwari contributed to migration patterns moving data from SQL Server/Oracle into AWS Redshift and Hive, processing on the order of 100 million unstructured events per day generated by approximately 60 million mobile app users. He introduced virtualization patterns using Denodo on S3-backed data lakes and enabled analytics through HiveQL, Redshift Spectrum, and VQL query layers under ActiveBatch orchestration—supporting downstream reporting via Power BI and SSRS. This work highlights a combination of high-volume data engineering, federated access design, and operational orchestration that is typically required only in large, consumer-scale telemetry environments.

In financial services, Tiwari has delivered governed reporting and data quality improvements where accuracy and auditability are essential. At Emirates NBD, he led the KSA MIS initiative spanning debit/credit card data, KRI reporting, net banking, and ATM transactions—implementing Data Quality rules using Informatica Data Quality and building structured Stage/Summary data flows using Sybase control files to enable consolidated reporting. At Accenture, supporting Massachusetts Financial Services, he drove a SAGENT-to-Informatica migration by reverse-engineering legacy jobs and rebuilding Informatica pipelines supporting fund and asset management operations—serving pensions, retirement accounts, foundations, endowments, and sovereign wealth clients. These programs demonstrate the ability to modernize legacy ETL estates while protecting the correctness requirements of financial reporting and investment operations.

Earlier, at Wipro for Genpact, Tiwari led automation initiatives that combined data engineering with operational finance workflows. The Cash Collection Tracker Automation program tracked approximately 100 transactions daily totaling around $4.5M, consolidating payment information across multiple modes (Lock Box, online/wire, ACH, IBS) sourced from BOA statements. He also contributed to USGAAP automation replicated across multiple global delivery locations, extracting from Oracle Financial systems into standardized data flow applications—work that demands consistency, reproducibility, and governance across distributed teams. At Capgemini, supporting Kingfisher Technology Services, he contributed to the Castorama MOVE program by resolving ETL performance issues and coordinating migrations between Informatica environments for a large international retail footprint.

Beyond delivery, Tiwari maintains visible engagement with the professional community through memberships (IEEE, ACM, ASA, DAMA Northeast, and others), participation as a judge in AI hackathons, and service on academic review panels evaluating research and white papers. He has also contributed to professional knowledge resources by co-authoring three book chapters on AI and Business Intelligence (IGI Publication). Recognition through awards such as Spot Award, Star of the Month, and Best Team Contributor reinforces a track record of peer-acknowledged impact. Taken together, his profile reflects a practitioner who blends platform depth with modernization leadership—building data systems that are cost-efficient, scalable, and trusted for decision-making in regulated enterprises.