Isha Bisht
Summary
ETL Developer with over 7 years of experience in designing and optimizing ETL processes. Expertise in large-scale data integration, ensuring high data quality and performance across multiple platforms. Proficient in industry-standard tools including Snowflake, SQL, and SSIS, as well as Python, PowerBI, Tableau, and cloud technologies like AWS and Azure.
Overview
7
7
years of professional experience
Work History
Lead Assistant Manager
EXL Service
Pune
06.2025 - Current
- Contributed to design, development, and support of end-to-end data pipelines for Healthcare Insurance project.
- Developed Snowflake dynamic scripts for accurate and efficient handling of historical and incremental data loads.
- Utilized Informatica Intelligent Cloud Services to extract data from Teradata and generate files on AWS S3.
- Designed and implemented Snowpipes for automated loading of data into Snowflake tables from AWS S3.
- Built and maintained Snowflake transformations to support downstream processing and analytics.
- Employed Azure CI/CD pipelines for automated deployment of Snowflake scripts across various environments.
- Supported development efforts, enhancements, bug fixes, and defect resolution to ensure system stability.
- Collaborated with cross-functional teams to troubleshoot performance issues and align with business requirements.
Senior Data Engineer
IBM
Gurgaon
11.2023 - 06.2025
- Developed an automated solution for whitelisting IPs for network policies in Snowflake, enhancing security and efficiency.
- Designed dynamic stored procedures and scheduled tasks to automate the execution of these procedures in Snowflake.
- Implemented storage integrations, stages, streams and Snowpipes to streamline the ETL process in Snowflake.
- Administered Snowflake by granting access, creating schemas, implementing data masking policies, and optimizing query performance.
- Led the migration of the legacy IICS warehouse system to Snowflake, integrating various technologies (Snowflake, Python, AWS Lambda) for seamless data transfer from source systems to the Snowflake database.
- Worked as both an ETL developer and report developer, implementing a data warehouse architecture that utilized AWS S3 for storage, Snowflake for data processing, and dashboards for reporting.
- Developed Python Lambda functions to automate unzipping of folders and converting XLSX files into CSV format for further data processing.
- Collaborated with a leading glass manufacturing company to migrate from an outdated SQL Server warehouse system to a modern Snowflake-based data warehouse.
- Successfully migrated and developed new stored procedures, along with creating dimension and fact tables in Snowflake.
- Integrated Snowflake, AWS Glue, and Power BI to create a robust data management and reporting system, ensuring smooth data flow from source to visualization.
- Designed and implemented data pipelines that stored data in AWS S3, loaded it into Snowflake, transformed it, and visualized it using Power BI.
- Engineered Snowflake data warehouse architecture, including schema design, table creation, Snowpipes, and data retrieval processes.
- Created and maintained dynamic Power BI dashboards for vehicle sales and marketing analytics, showcasing sales by region, brand, and model over different periods.
- Collaborated with stakeholders to gather reporting requirements and delivered actionable insights through effective data visualizations, supporting strategic decision-making.
Senior Software Engineer
CGI
Bengaluru
03.2022 - 11.2023
- Developed solutions using Snowflake, including stored procedures, functions, and snow pipes to meet business requirements.
- Created interactive dashboards and reports in Power BI, collaborating with stakeholders to implement effective data visualizations.
- Designed and maintained new ETL applications while enhancing existing ones for improved performance and response time.
Senior Software Engineer
Coforge
Gurgaon
10.2018 - 03.2022
- Developed and maintained data warehouse systems, ensuring optimal ETL processes for Lloyd's and London Market.
- Implemented and supported ETL solutions using SSIS and SQL to enhance data accommodation.
- Designed business intelligence reports through PowerBI and SSRS to facilitate data-driven decision-making.
- Collaborated with cross-functional teams to improve data integration and system performance.
- Optimized data quality and accuracy while leveraging cloud technologies like AWS and Azure.
- Developed solution for Brexit, insurance policies belong to UK union or European union.
- Developed SSIS packages for seamless integration between SQL Server and client legacy applications.
- Analyzed performance issues, performed root cause analysis, and resolved production bugs to ensure smooth operations.
Education
B.tech - Computer Science
Dev Bhoomi Group of Institutions
Dehradun, Uttarakhand07.2018
Diploma - Computer Science Engineering
Govt. Girls Polytechnic
Dehradun, Uttarakhand06.2015
Skills
- Snowflake
- Amazon AWS
- Python
- SQL
- Azure CI CD
- Teradata
- SSIS
- PowerBI
- SSRS
- Tableau
Personal Information
- Title: Senior Data Engineer
- Date of Birth: 04/12/95
- Nationality: Indian
- Place of Birth: Uttarakhand
Timeline
Lead Assistant Manager
EXL Service
06.2025 - Current
Senior Data Engineer
IBM
11.2023 - 06.2025
Senior Software Engineer
CGI
03.2022 - 11.2023
Senior Software Engineer
Coforge
10.2018 - 03.2022
B.tech - Computer Science
Dev Bhoomi Group of Institutions
Diploma - Computer Science Engineering
Govt. Girls Polytechnic