ANKITA M G

Developed, enhanced, and supported end-to-end ETL processes using SSIS, ensuring seamless data integration across business applications and data sources.

• Worked in a very large and highly transactional database and troubleshooting issue in different environments (Production, SIT and UAT)
• Worked with Business Analysts to gather requirements and translate them into Technical specifications. Worked on all stages of SDLC like Requirement Analysis, Estimation, Design, Coding, Unit Testing, Deployment and maintenance.
• Designed and implemented SSIS packages to efficiently extract, transform and load data from both cloud-based and on-premises systems to the Data Warehouse.
• Wrote and optimized SQL Server queries for data extraction, transformation, and reporting, ensuring efficient data retrieval and manipulation for ETL processes.
• Created SSIS Packages to load data into data warehouses using various SSIS tasks like Execute SQL task, File System Task, Data flow task, Execute Package Task, Bulk Insert Task, Execute Package Task, Send Mail Task
• Monitoring the SSIS jobs, debugging and fixing the job failure or issues.
• Extensively used CTEs, Joins and sub-queries for complex queries involving multiple tables.
• Created and maintained Tables, Stored Procedures, Functions, Triggers and Views.
• Provided support for database related queries and issues.
• Participated in sprint planning, weekly status meetings, and code reviews to ensure alignment with project goals and timely delivery of deliverables.
• Documented troubleshooting procedures and created knowledge sharing materials to improve team efficiency and reduce response times for common issues.