Aishwarya Bengaluru India

Aishwarya

SQL and ETL Testing Trainer in Bengaluru
Location
Bengaluru, India
Trainer Since
January, 2020
Data Analysis Expressions
ETL Testing
SQL
Location
Bengaluru, India
Trainer Since
January, 2020
Data Analysis Expressions
ETL Testing
SQL

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

Skills

SQL
Python
Linux
GCP
IBM Infosphere
Datastage
Power BI
Azure
Cognos
SQL
MySQL
Communication Skills
Team Management
Team Leading

Education

B.Tech

Electronics and Instrumentation:
2013-2017

Projects

Posts

Courses

Data Analysis Expressions
ETL Testing
SQL

Want Aishwarya for your Next Training?

Request a Demo

Other Trainers

First Time Managers Trainer in Bangalore
Mehak
Bangalore, India
Trainer since
February, 2012
Design Thinking
Soft Skills
+7 more...
View Mehak’s Profile
Project Management Trainer in Abuja
Oyiboka
Abuja, Nigeria
Trainer since
February, 2015
Business Communication Skills
Email Marketing
+4 more...
View Oyiboka’s Profile
Change Management Trainer in Bangalore
Ravi
Bangalore , India
Trainer since
February, 2014
Cybersecurity
Change Management
+5 more...
View Ravi’s Profile
Cybersecurity Fundamentals Trainer in Hyderabad
Satyanarayana
Hyderabad, India
Trainer since
February, 2019
Cybersecurity Fundamentals
View Satyanarayana’s Profile
Motivational Skills Trainer in Bangalore
Nibedita
Bangalore, India
Trainer since
July, 2017
Motivational Skills
View Nibedita’s Profile
Self Awareness Trainer in Al Wajba
Roberta
Al Wajba, Qatar
Trainer since
January, 2015
Self Awareness
Cultural Intelligence (CQ) for Leaders
+2 more...
View Roberta’s Profile
MongoDB Trainer in Hyderabad
Venu
Hyderabad, India
Trainer since
March, 2007
MongoDB
Linux Essential
+5 more...
View Venu’s Profile
Personality Development Trainer in Gurgaon
Mrinal
Gurgaon, India
Trainer since
October, 2004
Business Communication Skills
Personality Development
+3 more...
View Mrinal’s Profile
Self Awareness Trainer in Ubud
Simon
Ubud, Indonesia
Trainer since
January, 2017
Self Awareness
View Simon’s Profile
Team Building Trainer in Delhi
Yogesh
Delhi, India
Trainer since
January, 2012
Stress Management
Team Building
View Yogesh’s Profile
First Aid and CPR Trainer in Ahmedabad
Harshil
Ahmedabad, India
Trainer since
January, 2016
First Aid and CPR
Healthy Living
+1 more...
View Harshil’s Profile
Emotional Intelligence Trainer in Pune
Amol
Pune, India
Trainer since
February, 2014
Emotional Intelligence
Business Communication Skills
+3 more...
View Amol’s Profile

More Corporate Training Programs

Sustainable Fashion Training
Green Transportation Training
Green Chemistry Training
Sustainable Supply Chains Training
Smart Cities Training
Water Stewardship Training
Biodiversity Management Training
Eco-Design & LCA Training
Nature-based Solutions Training
Carbon Markets Training
ESG Reporting Essentials Training
Climate Risk Management Training
Net-Zero Strategy Training
Circular Economy Fundamentals Training
Green Building Essentials Training
RoHS (Restriction of Hazardous Substances) Training
REACH Regulation Training
Retail Management Training
Sales Funnel Training
Insight Selling Training
For Business Queries
contact@edstellar.com
Reach Us at
USA
+1 682 297 4830
AUS
AUS
+44 151 453 4009
INDIA
IND
+91 6364833830

Edstellar is a one-stop instructor-led corporate training and coaching solution that addresses organizational upskilling and talent transformation needs globally. Edstellar offers 2000+ tailored programs across disciplines that include Technical, Behavioral, Management, Compliance, Leadership and Social Impact.

Follow Us:
© 2021-2025 Edstellar. All rights reserved.
Modern Slavery
|
Privacy Policy
|
Terms and Conditions