Aishwarya

SQL and ETL Testing Trainer in Bengaluru

Data Analysis Expressions
ETL Testing
SQL

Location: Bengaluru, India
Trainer Since: January, 2020

Trainer profile

SQL and ETL Testing Trainer in Bengaluru

About Aishwarya

Aishwarya is a highly accomplished professional with an impressive track record of over 5 years in the field of data management. With vast expertise in various aspects of data management, Aishwarya has extensive knowledge and experience in data modeling, data analysis, data pipeline, data profiling, data quality, ETL, data warehouses, data marts, and data lakes. She is a seasoned data management professional capable of delivering efficient and effective solutions for businesses to consume data through reports and dashboards, which can be used for everyday decision-making processes.

With a strong foundation in data management and an ability to work with large datasets, Aishwarya has demonstrated a knack for identifying and addressing business data-related issues. Her expertise in data modeling, data analysis, and data quality has helped her develop a comprehensive understanding of the complex data landscape, allowing her to make informed decisions about data warehousing, data marts, and data lakes.

Aishwarya is a Corporate Trainer For

Data Analysis Expressions

Training Since:January, 2022

ETL Testing

Training Since:January, 2020

SQL

Training Since:January, 2020

Work Experience

Senior Software Engineer
Energy and Power · August, 2022 - present
Roles & Responsibilities
- Responsible for data pipeline, data quality, and data analysis and provided ETL / DW design and enhancements as part of technology migration for various ETL / DW components currently using GCP and Azure
- Responsible for successful design, development, and delivery of ETL, database, and reporting projects
- Built a digital hygiene dashboard to bring transparency to the system across the globe
- Reduced the mismatch between supply -demand in electricity generation & distribution
- Utilized data mining tools to apply different cost layering methods to reconstruct and validate average cost and sales pricing of electricity sold with negative margins to customers, leading to leaked revenues or losses.
- Built many Python-based auto e-mailers for reporting and solved ad hoc analyses
- Created multiple dashboards for tracking important KPIs and metrics daily
Senior Software Engineer
Healthcare · March, 2020 - March, 2021
Roles & Responsibilities
- Worked closely with the quality assurance, operations, and production support group to devise the test plans, answer questions, and solve any data issues
- Prepared and automated the SQL Scripts for validating data pipelines
- Defined, configured, and optimized various MDM processes, including landing, staging, base objects, hierarchies, foreign-key relationships, lookups, and query groups
- Verified the mapping, process flow, business logic, calculations, exception handling, and transformations rules and built a data dictionary
- Used stored procedures, triggers, and views to provide structured data to business units by combining millions of rows of data from 19 disparate data sources
- Performed operations like data reconciliation, validation, and error handling after extracting data into SQL Server twice a week
Quality Analyst
Hospitality and Tourism · June, 2017 - March, 2020
Roles & Responsibilities
- Integrated and standardized customer/transactional data in visualization dashboards to provide more visibility and quickly analyze, develop, and test potential use cases
- Executed end-to-end analytics to extract, clean, standardize, and analyze voluminous booking data such as booking, payment, onboarding, sales, discount, and inventory and provide new insights
- Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse)
- Worked on fast-paced agile development environment projects that provided real-time and historical analysis, decision support, and reporting services
- Understood the project scope, identified activities/ tasks, task level estimates, schedule, dependencies, and risks, and provided inputs to the module lead for review
- Participated in all SDLC levels of testing to provide SME validation and recommendations for corrections or improvement
- Used data profiling, data quality tools, and database queries to uncover and determine the root causes of data quality issues
- Reached testing goals by performing ETL process flow validation, error handling, and error logging validation, data completeness, business logic validation, IBM cognos report testing, and SCD types validation to ensure the accuracy of data
- Wrote test cases in rally and defect report generation using rally (Application Lifecycle Management) experience in integrating various data sources with multiple relational databases like Oracle, SQL Server, SSMS, and Flat Files
Consultant
Healthcare · March, 2021 - August, 2022
Roles & Responsibilities
- Applied project methodology to lead the project team through the process of defining and documenting project scope and objectives
- Drove direction from strategy to execution of applying data analytics, including data scoping, analysis, visualization, and delivering actionable insights
- Prepared and created analytic reports on customer insights such as user geographic location, age groups, and gender using SQL, Python, and PowerPoint
- Designed analytics database integrating large volumes of data from disparate systems to build holistic views of medicare data and reporting.
- Worked with business SMEs to identify and provide recommended resolutions for data quality issues identified by: interrogating legacy data/data profiling and identification of business rules to support requirements and mappings
- Collaborated with offshore and onshore developers and stakeholders for technical and business peers on development efforts, requirement analyzing, and designing
- Worked on data warehousing & data lake, analyzing data issues at the initial stages, their implementation approach in production, and automated the process
- Identified methods of improving performance in ETL design and ensured that the ETL design includes restart-ability, error handling, and audit throughout ETL processes.
- Implemented logical and physical data modeling using SQL database modeler with snowflake schema in data marts, ensuring that correct mappings and data quality