Aadya Goswami

About Aadya Goswami

With years of experience as an Data Analyst & ETL Automation Engineer, I specialize in optimizing data processes and ensuring the seamless flow of high-volume data. My expertise lies in developing and executing SQL queries for database operations, as well as validating data accuracy and integrity across complex systems. I bring a strong foundation in data engineering, analytics, and machine learning. I’ve delivered machine learning models with high accuracy scores and successfully deployed them for real-world applications, including inventory optimization and delay forecasting systems.My approach to SQL development emphasizes performance—crafting efficient queries that significantly reduce execution time and enhance overall process agility. I’ve automated regression testing and orchestrated robust ETL workflows using tools like Informatica, Control-M, Azure Data Factory, SSIS, and Pentaho.Beyond backend engineering, I also turn raw data into business insights through dashboards and visual analytics using Power BI. I thrive on building data-driven solutions that are not only technically sound but also impactful in driving decisions and efficiency.I have hands-on experience with Informatica PowerCenter, where I’ve worked extensively on workflows to extract, test, and load data efficiently. A notable contribution includes spearheading data migration from EDW1.1 to EDW2.0, ensuring seamless transitions and minimal downtime.Proficient in Control-M and Azure Data Factory (ADF), I excel in data orchestration, ensuring timely and accurate data movement across systems to support business needs. My passion for leveraging technology to streamline data workflows and drive insights defines my approach to ETL engineering and automation.Let’s connect and explore how I can turn your data challenges into scalable success stories.

Experience

1. Data Analyst

   Deloitte

   Aug 2022 — Present · Gurugram, IN

   Designed and executed SQL queries to validate data and metadata across target tables, contributing to a 30% reduction in data quality issues during ETL testing cycles- Automated regression testing using SQL scripts and pipeline logic, cutting manual test execution time by 40% and improving overall accuracy of recurring data validations- Optimized data workflows by automating load dependencies and enhancing error handling using Control-M and ADF, reducing manual intervention by 40% and improving data integration speed and reporting accuracy by 25%- Data Migration & Testing Analyst – EDW1.1 to EDW2.0 Migration: Led migration of database tables from EDW1.1 to EDW2.0, ensuring 100% data integrity and adherence to 3NF normalization standards across all migrated entities- Executed & Created end-to-end ETL batch orchestration using Control-M, Azure Data Factory, andInformatica to transition financial data from IFRS4 to IFRS17 standards across four business units- Prepared knowledge artifacts such as: ETL defect-fix, Rollback scripts, monthly & quarterly loads, checkpoints for approvals- Triggered and monitored Informatica workflows for loading the data, Imported the source files into the database and raised any requirement gaps with Business Stakeholders- Involved in testing data and metadata of the database tables, test cases preparation and execution, Identifying design and documentation gaps, Created SQL queries to validate the loaded data in Target tables.

Education

• Banasthali Vidyapith

  Bachelor of Technology - BTech

  2018 — 2022