Sai Nitin Madduri Venkata
ETL Developer
Austin,TX
Summary
ETL Developer building and validating data pipelines that move provider, fleet, and SaaS data into Oracle, Snowflake, and analytics-ready datasets. Delivers reliable Informatica PowerCenter, IICS, Python, and SQL workflows through source-to-target mapping, reconciliation, and exception handling. Supports reporting and decision-making by turning complex operational data into trusted datasets for Tableau, Power BI, and Amazon QuickSight.
Overview
7
7
years of professional experience
Work History
ETL Developer
Client: Deloitte | Texas Health and Human Services Commission (HHSC)
Austin, TX
04.2025 - Current
- Developed ETL workflows in Informatica PowerCenter to move provider enrollment data from legacy C21/SSMS sources into Oracle and analytics environments.
- Supported HHSC’s PEMS under MES Modernization by loading provider data into a centralized Oracle data mart.
- Defined source-to-target mappings for provider enrollment data and analytics-ready structures.
- Applied business rules including one-request-to-one-NPI, one-NPI-to-multiple-locations, and multiple programs/licenses/certificates/principals per location.
- Transformed and validated master and transaction records for enrolled and in-flight providers, including status and revalidation dates.
- Performed cleansing, reconciliation, and exception handling to improve data quality and consistency.
- Wrote SQL queries to validate counts, investigate issues, and reconcile source, ETL, and target data.
- Resolved ETL issues related to source inconsistencies, mapping gaps, and load exceptions.
- Partnered with HHSC stakeholders to ensure the data mart supported analysis of enrolled providers, in-flight applications, and monthly revalidation activity.
- Prepared and validated datasets used by the reporting team for Tableau-based reporting
- Medicaid Enterprise Systems (MES) Modernization | Provider Enrollment Management System (PEMS)
ETL Developer
Client: Deloitte | Texas Department of Public Safety (DPS)
Austin, TX
07.2024 - 03.2025
- Developed API-driven ETL pipelines using Python and Informatica Intelligent Cloud Services to ingest Samsara IoT and telematics data into Snowflake for analytics and reporting.
- Integrated VIN-based vehicle records and transformed raw device feeds into structured, analytics-ready datasets to support fleet performance analysis and dashboard reporting.
- Captured and processed mileage, fuel usage, driver rotation, trip activity, and geofencebased fueling events to enable operational tracking across TX DPS vehicles.
- Developed SQL queries and validation logic to reconcile source-to-target data, identify data-quality issues, and ensure accurate vehicle, driver, and fueling event mapping.
- Applied exception handling and data cleansing techniques to improve reliability and consistency across ETL workflows and downstream reporting outputs.
- Collaborated with technical and business stakeholders to clarify requirements, resolve discrepancies, and support delivery of trusted analytics datasets.
- Supported dashboard preparation and predictive analysis by delivering validated data used to assess vehicle usage, aging trends, and annual mileage estimates.
- Technology Services Support (TSS) - Samsara Fleet Management
Business Analyst
American Technology Consulting
Des Moines, IA
09.2023 - 06.2024
- Supported cross-functional teams on Auzmor, a SaaS learning platform for employee training, by gathering and validating business and system requirements in an Agile environment.
- Collaborated with product owners, developers, and business stakeholders to refine feature requirements and support product delivery for learning-platform enhancements.
- Created user stories, acceptance criteria, and process documentation to define platform improvements and support release readiness.
- Used SQL to analyze platform data, validate business rules, and support reporting on product usage, training activity, and operational decisions.
- Created and maintained Tableau dashboards to monitor product performance, user adoption, and key training metrics.
- Used Jira to manage requirements, defects, and delivery tracking, contributing to a 26% month-over-month improvement in feature-development speed.
Business Analyst
Winuall
01.2022 - 06.2022
- Supported a SaaS-based learning platform that enabled individual tutors and small institutions to manage students, share notes, assign tests, and deliver online learning workflows.
- Gathered and documented business and system requirements in an Agile environment; collaborated with product owners, developers, and stakeholders to refine features and delivery scope.
- Created user stories, acceptance criteria, and process documentation to support platform enhancements and configuration changes.
- Used SQL to analyze platform data, validate business rules, and support reporting on student activity, usage patterns, and test performance.
- Built and maintained Power BI dashboards to monitor product adoption, platform performance, and key user engagement metrics.
Business Analyst
Vedantu Innovations
02.2021 - 12.2021
- Collaborated with product owners, developers, and business stakeholders to define requirements and improve platform functionality.
- Created user stories, acceptance criteria, process flows, and functional documentation using Jira, Confluence, and Microsoft Visio.
- Performed gap analysis and supported the design of improved business processes.
- Developed SQL queries to analyze business data and identify opportunities that contributed to a 40% increase in revenue.
- Participated in user acceptance testing, defect tracking, and quality assurance activities.
Renewal Specialist
Byjus
08.2020 - 01.2021
- Managed customer renewal activities and analyzed customer usage patterns to identify retention and upselling opportunities.
- Supported a business opportunity valued at approximately $100,000 through customer engagement and renewal planning.
- Analyzed product usage data and contributed to a 16% improvement in product adoption.
- Prepared performance reports and dashboards to support management decision-making.
Business Development Associate
Oxfordcaps
05.2019 - 07.2020
- Supported business development, stakeholder engagement, and process-improvement activities.
- Analyzed customer and marketing data to identify opportunities for improved outreach and conversion.
- Worked with cross-functional teams to streamline operational processes and improve customer experience.
- Contributed to achieving 100% customer satisfaction across assigned activities.
Education
Master of Science - Business Analytics
Hult International Business School
Cambridge, MA08-2023
Bachelor of Business Administration - undefined
PES University
Bangalore, India01-2019
Skills
- AWS
- Informatica
- Snowflake
- Visual Studio
- SQL
- Python
- PySpark
- Tableau
- Source-to-target mapping
Timeline
ETL Developer
Client: Deloitte | Texas Health and Human Services Commission (HHSC)
04.2025 - Current
ETL Developer
Client: Deloitte | Texas Department of Public Safety (DPS)
07.2024 - 03.2025
Business Analyst
American Technology Consulting
09.2023 - 06.2024
Business Analyst
Winuall
01.2022 - 06.2022
Business Analyst
Vedantu Innovations
02.2021 - 12.2021
Renewal Specialist
Byjus
08.2020 - 01.2021
Business Development Associate
Oxfordcaps
05.2019 - 07.2020
Bachelor of Business Administration - undefined
PES University
Master of Science - Business Analytics
Hult International Business School