Sasi Kumar Ravipati
Summary
Software Engineer and Data Engineer with 4+ years of experience designing, developing, optimizing, and supporting enterprise-scale ETL/ELT pipelines, cloud data warehouses, data integration solutions, and business intelligence reporting across Banking, Financial Services, Insurance, and regulatory compliance environments.
- Data Engineering & ETL/ELT: Strong hands-on expertise in IBM DataStage, dbt, Informatica IICS, Snowflake, SQL, Python, UNIX Shell scripting, and Java, with experience in scalable data pipelines, batch processing, incremental loads, Change Data Capture (CDC), Slowly Changing Dimensions (SCD Type 1/2), and reusable transformation frameworks.
- Cloud Data Platforms & Warehousing: Experience with Snowflake, Google BigQuery, and Microsoft Azure, including cloud data integration, data ingestion, warehouse design, data transformation, query optimization, and migration from legacy ETL platforms. Knowledge of Snowpipe, Snowflake Streams and Tasks, Time Travel, Zero-Copy Cloning, and layered data architectures spanning landing, staging, curated, and reporting environments.
- Data Quality & Automation: Developed automated data validation and Git-based validation agents for schema checks, source-to-target reconciliation, row-count balancing, duplicate and null checks, data freshness monitoring, dbt test execution, pull-request validation, branch policy enforcement, and deployment readiness.
- Production Support & Scheduling: Experienced in Control-M job scheduling and monitoring, batch processing, production incident troubleshooting, failure analysis, data pipeline maintenance, reconciliation, and operational support to maintain data accuracy, reliability, and availability.
- Business Intelligence & Analytics: Experience with Tableau and Microsoft Power BI for dashboards, data-quality and reconciliation reporting, report refresh monitoring, data visualization, dashboard migration, content validation, User Acceptance Testing (UAT), and production reporting support.
- Financial Services & AML: Working knowledge of Anti-Money Laundering (AML) data processing, NICE Actimize alert feeds, Customer Due Diligence (CDD), Suspicious Activity Monitoring (SAM) datasets, transaction monitoring inputs, alert-generation support, and audit-related business data analysis.
- Development, DevOps & AI Tools: Familiar with Git, GitLab, GitHub, Azure DevOps, UrbanCode Deploy (UCD), Jira, QTest, Hadoop, Hive, SPSS Modeler, and AI-assisted development and Copilot integrations, supporting collaborative development, testing, deployment, and continuous improvement.
Overview
6
6
years of professional experience
Work History
Software Engineer
USAA Federal Savings Bank
San Antonio, Texas
01.2024 - Current
- Designed, developed, and supported end-to-end ETL/ELT data processing pipelines to ingest, transform, validate, and publish banking, transaction, customer, account, and operational datasets for downstream analytics and reporting.
- Developed and supported web applications using JavaScript and Python, and migrated legacy IBM DataStage pipelines to a Snowflake and dbt-based cloud architecture—improving scalability, modularity, code reusability, deployment control, and production-support efficiency.
- Built automated data pipelines for structured and semi-structured files including CSV, JSON, DB2, Oracle, Teradata, flat files, and cloud-staged files into Snowflake landing, staging, curated, and reporting layers.
- Developed DBT staging, intermediate, and mart models to standardize business data, apply transformation rules, support incremental loads, create reusable logic, and deliver reporting-ready datasets.
- Implemented reusable DBT macros for audit columns, surrogate keys, date logic, source-specific cleansing, deduplication, incremental load filters, data type standardization, and common business transformations.
- Used Snowflake Streams and Tasks for incremental processing and automated downstream transformations; used Time Travel and Zero Copy Cloning to support recovery, release testing, and environment isolation.
- Automated Snowpipe ingestion from staged files and implemented file-arrival checks, load-history checks, rejected-record reviews, control-file validation, and downstream completion monitoring.
- Optimized Snowflake and DBT processing by tuning SQL joins, filters, clustering strategy, warehouse sizing, incremental models, table design, query execution patterns, and reusable transformations for large datasets.
- Created Python-based data validation agents to perform schema validation, data type checks, null/blank checks, duplicate detection, referential integrity checks, threshold anomaly detection, data freshness checks, and source-to-target reconciliation.
- Created Git validation agents to verify branch naming, commit standards, pull-request readiness, DBT model dependencies, SQL quality checks, environment configuration, test execution, and deployment-readiness gates before code promotion.
- Automated pre-load and post-load reconciliation by comparing source counts, target counts, control totals, rejected records, checksum values, and exception tables to reduce manual validation effort during releases.
- Implemented DBT tests and custom Python validation tests for not-null checks, unique key checks, accepted values, relationship checks, schema drift, data freshness, and regression validation across critical datasets.
- Developed Tableau reconciliation dashboards and data-quality dashboards to monitor row-count mismatches, load status, SLA breaches, missing files, rejected records, and data completeness across multiple pipelines.
- Supported Tableau report refresh monitoring, workbook validation, dashboard issue analysis, data-source verification, extract refresh checks, and report-level defect triage for business reporting users.
- Supported Tableau content migration activities by validating migrated workbooks, data sources, extracts, calculated fields, filters, user access, refresh schedules, and report output consistency across environments.
- Partnered with business analysts, QA teams, reporting users, compliance teams, and client data teams to convert requirements into source-to-target mappings, technical designs, data validations, and production-ready pipelines.
- Integrated Control-M schedules for daily, weekly, and monthly batch processing, including dependencies, calendars, prerequisites, reruns, failure alerts, and SLA-based monitoring.
- Enabled CI/CD deployments using Git, GitLab/GitHub, Azure DevOps, SnowSQL, and UCD for controlled migration from development to QA, UAT, and production environments.
- Prepared release notes, deployment documents, rollback plans, validation checklists, post-deployment smoke-test results, and audit-ready evidence for production approvals.
- Resolved high-priority incidents, ServiceNow tickets, SAORNOW requests, and production data issues by performing root-cause analysis, code fixes, data corrections, job reruns, and permanent remediation.
- Supported AML-related data processing for transaction monitoring, customer due diligence (CDD), SAM data feeds, suspicious activity monitoring, and alert-ready datasets while maintaining strong focus on scalable data engineering delivery.
- Worked with NICE Actimize-aligned data feeds and downstream reporting requirements to support alert generation, alert monitoring, exception analysis, and traceability of transaction and customer data used by AML business teams.
- Supported audit-related queries for business and compliance teams by preparing source-to-target evidence, reconciliation outputs, control reports, data lineage details, load history, and validation results for review and sign-off.
- Assisted with CDD and SAM data validation by checking customer identifiers, account relationships, transaction attributes, risk indicators, missing values, duplicates, and rejected records before downstream consumption.
- Mentored junior engineers on DataStage, DBT, SQL, Snowflake, Git process, Control-M scheduling, Tableau validation, test evidence preparation, and production troubleshooting best practices.
Teaching Assistant
Southern Arkansas University
Magnolia, Arkansas
09.2022 - 02.2023
- Assisted faculty in teaching undergraduate courses related to Data Analytics, Database Management, SQL, and Data Engineering concepts.
- Guided students in understanding ETL processes, data modeling, relational databases, data warehousing, and data quality best practices.
- Conducted lab sessions on SQL, database design, data transformation, and data visualization using industry-standard tools.
- Assisted students with assignments, projects, and debugging SQL queries, data pipelines, and database-related problems.
- Evaluated assignments, quizzes, and project submissions while providing constructive feedback to improve technical understanding.
- Supported curriculum development by preparing lecture materials, lab exercises, sample datasets, and technical documentation.
- Demonstrated concepts including data extraction, transformation, loading (ETL), normalization, joins, aggregations, and performance optimization.
- Helped students develop dashboards and reports using Tableau and other data visualization tools to analyze and present business insights.
- Collaborated with faculty to maintain course materials, organize workshops, and support classroom and laboratory activities.
- Assisted in conducting practical sessions involving SQL Server, Hadoop, Hive, and data analysis techniques.
- Provided one-on-one mentoring to students on database concepts, data analysis, and project implementation.
- Supported grading, attendance management, and academic administration while ensuring timely completion of course activities.
- Environment: SQL, SQL Server, Tableau, IBM DataStage, Hadoop, Hive, Git, Excel, Jira, UNIX, Data Warehousing, ETL Concepts.
Software Engineer
Synergina Pvt Ltd
12.2020 - 11.2021
- Worked with business analysts and technical teams to convert business requirements into source-to-target mappings, low-level designs, high-level designs, and ETL development deliverables.
- Developed reusable DataStage jobs for extracting, cleansing, transforming, and loading securitization data from source systems into staging, warehouse, and Hadoop/Hive environments.
- Implemented CDC and SCD logic using DataStage CDC stages and mapping rules to support historical tracking, incremental processing, and accurate downstream reporting.
- Designed reusable extract and load frameworks to improve development consistency, reduce duplicate logic, and simplify operational support for repeated batch processes.
- Scheduled and monitored DataStage jobs through Control-M, reviewed logs, resolved warnings/errors, and performed reruns for failed or delayed batch cycles.
- Created archiving processes for Hadoop/Hive data to support data retention, reprocessing, historical analysis, and scalable data processing requirements.
- Prepared detailed LLD, HLD, ETL architecture documents, support runbooks, migration documents, and deployment documentation for enhancements and production releases.
- Led onsite/offshore coordination, reviewed deliverables, supported junior team members, and ensured timely completion of enhancement and production support activities.
- Performed DataStage performance tuning by optimizing partitioning, sorting, lookup strategy, transformer logic, join strategy, and database access patterns.
- Supported system, functional, regression, and reporting validation by assisting QA teams with test data preparation, SQL validation queries, defect analysis, and evidence capture.
- (Asset Backed Securitization)
- Environment: IBM DataStage, DB2, Oracle 11g, SQL, UNIX, Control-M, Git, Hadoop, Hive, Jira, UCD
Education
Master's Degree - Computer and Information Science
01-2023
Bachelor's Degree - Computer Science and Engineering
01-2020
Skills
- Azure DevOps
- Snowflake
- AWS
- Oracle
- SQL
- DB2
- BigQuery
- Python
- Java
- DBT
- ETL / ELT Tools
- IBM DataStage
- Informatica IICS
- Control-M
- CI / CD
- Git
- GitLab
- GitHub
- ServiceNow
- Tableau content migration / Admin
- QTest
- Jira
- Prompt Engineering
- Claude & Copilot Assisted
Key Data Processing Reporting And Cloud Highlights
- Data Validation Agents: Automated schema drift detection, duplicate detection, null/blank checks, data type checks, accepted-value checks, referential integrity checks, threshold anomaly detection, data freshness checks, and source-to-target reconciliation.
- Git Validation Agents: Automated branch naming checks, commit-message checks, pull-request checklist validation, DBT dependency validation, SQL quality checks, test coverage checks, configuration validation, and deployment-readiness gates.
- Tableau Reporting: Supported reconciliation dashboards, data-quality dashboards, report refresh monitoring, dashboard migration validation, extract checks, data source validation, and reporting defect resolution.
- Snowflake Cloud Processing: Supported Snowpipe ingestion, Streams/Tasks incremental processing, DBT transformations, Time Travel recovery, Zero Copy Clone testing, load-history review, warehouse tuning, query optimization, staging/file-format setup, and cloud migration validation.
- AML / NICE Actimize Support: Supported NICE Actimize-related data feeds, CDD and SAM validation, alert generation support, alert monitoring, exception review, and business audit query responses using SQL, ETL controls, and reconciliation evidence.
- Release & Audit Validation: Created pre-deployment and post-deployment validation checklists to confirm row counts, job status, rejected records, error tables, DBT tests, Control-M completion, business audit evidence, and report refresh status.
Core Skills
ETL/ELT pipelines, high-volume batch processing, incremental loads, CDC, data replication, data mirror, SCD Type 1/2, data cleansing, data profiling, metadata-driven processing, error handling, restart/recovery, audit logging, audit support, alert generation support, Snowflake, Snowpipe, Streams, Tasks, Time Travel, Zero Copy Cloning, stages, file formats, warehouses, DBT incremental models, SnowSQL, cloud migration, performance tuning, virtual warehouses, roles/grants support, load history analysis, IBM DataStage, DBT, Informatica IICS, Control-M, UCD, Git, GitLab, GitHub, Azure DevOps, Tableau dashboards, reconciliation reports, data-quality dashboards, Tableau content migration, workbook migration validation, data-source migration, extract refresh validation, user access validation, report performance checks, Python validation frameworks, DBT tests, SQL reconciliation, QTest, Jira, source-to-target testing, regression testing, automated evidence generation, Oracle, SQL Server, DB2, Teradata, Netezza, Snowflake, Hadoop, HDFS, Hive, Sqoop, SQL, Python, UNIX Shell scripting, SnowSQL
Timeline
Software Engineer
USAA Federal Savings Bank
01.2024 - Current
Teaching Assistant
Southern Arkansas University
09.2022 - 02.2023
Software Engineer
Synergina Pvt Ltd
12.2020 - 11.2021