Akhila K C

1. Project Summary:
Worked on a data transformation project . The primary focus was on building scalable data pipelines to extract data from multiple source systems, perform transformations, and load into the target data warehouse. The solution supported seamless data migration across DEV, SIT, and UAT environments with emphasis on automation and validation.

Tools & Technologies:
IIG (Infosys Information Grid), Genome Management Console (GMC), DBeaver, GIT, Bitbucket, MWAA, IDP, WinSCP

Key Responsibilities:

• Analyzed data models and validated source tables and views for transformation requirements.
• Designed and developed source queries based on the data model specifications.
• Created target tables in the integrated local layer using GMC.
• Developed reusable views for pipelines and implemented DDL scripts.
• Migrated tables from local to integrated environments using Git and IDP tools.
• Built and managed data processing steps and dataflows to support ETL operations.
• Triggered dataflows to load data into target tables in DEV environment.
• Facilitated migration of tables and metadata to SIT and UAT environments.
• Conducted comprehensive unit testing to ensure pipeline quality and reliability.

2.Project Summary:

Worked on internal Infosys projects involving data integration, transformation, and reporting using Excel and SSIS. The project focused on ingesting business data from multiple Excel templates, loading it into cube partitions, validating with business rules, and visualizing results in dashboards for delivery and reporting.

Tools & Technologies:

Power BI Desktop, SQL Server Management Studio (SSMS), Visual Studio, SSIS

Key Responsibilities:

• Analyzed Excel templates provided by delivery teams for data structure and completeness.
• Automated data loading processes using SSIS packages and validated the load across different partitions.
• Executed business-defined SQL queries in SSMS and verified row-level data consistency.
• Conducted data validation checks to ensure alignment with business requirements.
• Refreshed dashboards in Power BI and shared reports with the delivery team.

• Internship at Keltron knowledge Centre Vazhuthacaud, Trivandrum, Kerala on front end development and introduction to bootstrap for a period of two weeks

Attended an internship on Laptop maintenance and repair in my college.