Sai Venkata SriVasthav Chengalva
Data Architect/Data Modeler
Hyderabad
Summary
Accomplished data architect and modeler with over 12 years of expertise in ELT and ETL-driven data warehouse design and scalable analytics solutions utilizing Snowflake, DBT, AWS, and Redshift within Banking and healthcare sectors.
Overview
2
2
Certifications
12
12
years of professional experience
Work History
Data Architect/Data Modeler
Globant(Datavant)
08.2022 - Current
- Designed and implemented modern ELT data warehouse architecture using Snowflake and DBT, replacing legacy Redshift and Airflow-based ETL pipelines.
- Defined enterprise dimensional data models (facts and dimensions) in DBT to support scalable analytics and reporting use cases.
Translated existing Airflow DAG-based ETL workflows into modular DBT transformation models, ensuring clean lineage and maintainability.
Established DBT project architecture (staging, intermediate, marts layers) following best practices for modular and reusable transformations. - Designed and standardized data modeling principles including grain definition, surrogate keys and conformed dimensions.
Built incremental models in DBT to optimize performance and support efficient ELT processing in Snowflake. - Documented data flow diagrams for better understanding of systems.
Leveraged Snowflake capabilities such as micro-partitions, compute-storage separation, and clustering for optimized warehouse design. - Defined data lineage, transformation logic, and dependency mapping within DBT and Snowflake for end-to-end traceability.
- Used Lucid Charts for documenting ER Relationship.
- Collaborated with business stakeholders to convert reporting requirements into dbt models and KPI definitions.
Data Engineer/Data Modeler
Wipro(Allied Irish Bank)
08.2019 - 08.2022
- Designed and developed scalable ETL/ELT data pipelines using Apache Airflow for automated workflow orchestration.
- Built and maintained Amazon Redshift data models to support analytics and business reporting.
- Developed complex SQL transformations for data ingestion, processing, and loading into data warehouse.
- Implemented fact and dimension models using snowflake schema for optimized reporting structures.
- Optimized Redshift performance using distribution keys, sort keys, and query tuning techniques.
- Automated data workflows with scheduling, monitoring, and failure handling in Airflow DAGs.
- Ensured data quality, validation, and consistency across multiple data sources and pipelines.
- Collaborated with stakeholders to translate business requirements into scalable data solutions.
Senior Software Engineer
Virtusa Consulting Services(City Bank)
03.2018 - 08.2019
- Designed and developed data models and ETL solutions using Ab Initio graphs and plans for large-scale data processing.
- Built and maintained Ab Initio ETL workflows for extracting, transforming, and loading data from multiple heterogeneous sources.
- Integrated data from multiple databases as sources into Teradata as the target data warehouse.
- Developed reusable and optimized Ab Initio components, graphs, and parameterized plans to improve scalability and performance.
- Performed data transformation, cleansing, and validation to ensure high data quality and consistency.
- Optimized ETL performance by tuning Ab Initio graphs and improving data flow design.
- Collaborated with business and technical teams to translate requirements into efficient data integration solutions.
- Supported deployment, testing, and production support activities for ETL workflows and resolved data issues.
Software Engineer
Birlasoft(Synchrony Financials)
06.2017 - 03.2018
- Contributed to the design and development of data models and ETL solutions using Ab Initio graphs and plans as part of a data engineering team.
- Assisted in building and maintaining ETL workflows to integrate data from multiple source systems into Teradata data warehouse.
- Worked on development of Ab Initio components, graphs, and parameterized plans for scalable data processing.
- Participated in implementing data transformation, cleansing, and validation rules to ensure data accuracy and consistency.
- Supported the team in optimizing ETL performance and workflow efficiency through graph tuning and design improvements.
- Collaborated with developers and analysts to translate business requirements into technical ETL solutions.
- Involved in testing, deployment, and production support of ETL pipelines and resolving data-related issues.
- Assisted in troubleshooting and monitoring ETL jobs to ensure smooth data flow into Teradata systems.
Associate Software Engineer
Tata Consultancy Services
06.2014 - 06.2017
- Provided L3 support and development for Ab Initio with hands-on ETL design experience.
- Enhanced ETL workflows to optimize performance and reliability.
- Utilized SQL, PL/SQL, and Unix/Linux shell scripting for effective debugging and automation.
- Analyzed complex incidents, performed root cause analysis, and delivered permanent fixes.
- Managed incident, problem, and change processes to enhance service delivery within ITIL frameworks.
- Collaborated with cross-functional teams to ensure stable data flows and maintain business continuity.
- Focused on process improvements and system optimizations to enhance reliability and prevent issues.
- Demonstrated strong analytical troubleshooting abilities and effective communication skills.
Education
B.Tech/B.E. -
Koneru Lakshmaiah College of Engineering (KLCE)
ArniSkills
Data modeling and architecture
Snowflake and dbt
AWS
SQL and Python
Amazon Redshift
Apache Airflow
Certification
Snowflake Platform Certifcate
Timeline
Databricks Data Engineer Associate
04-2026
Data Architect/Data Modeler
Globant(Datavant)
08.2022 - Current
Data Engineer/Data Modeler
Wipro(Allied Irish Bank)
08.2019 - 08.2022
Senior Software Engineer
Virtusa Consulting Services(City Bank)
03.2018 - 08.2019
Software Engineer
Birlasoft(Synchrony Financials)
06.2017 - 03.2018
Associate Software Engineer
Tata Consultancy Services
06.2014 - 06.2017
B.Tech/B.E. -
Koneru Lakshmaiah College of Engineering (KLCE)
Total Work Experience
11 Years 8 Months