Mekala Devi M. Email & Phone Number

- Developed a data trash collection utility using IICS and a bash script that runs daily to delete files and sources exceeding the threshold days, while also notifying stakeholders of any folder modifications via email.- Transformed the stored procedures of the relational data vault into optimized IICS Taskflows, enhancing performance and providing data lineage for ingested data.- Improved existing RDV Taskflows by integrating an audit process, which captures execution details during taskflow runs.- Collaborated with the data modeling team to analyze and categorize relational data vault tables into their classifications.- Worked on ingesting various data sources into BigQuery.

- Build an end-to-end data transformation and validation framework for data migration of various streams utilizing GCP - BigQuery. This streamlined the processes and significantly reduced manual data corrections.- Developed taskflows in IICS for the scheduling module to audit logs and trigger taskflows based on events.- Worked on ingesting various data sources into BigQuery

- Analyzed production data issues, including bug fixes and enhancements.- Modified existing ETL code to improve performance and adjust business logic to meet evolving business needs.

- Developed and managed the ETL process using Informatica Power Center 10.2/10.4, including design, development, data transformation, conversion, loading, data analysis, and unit testing of mappings and workflows, adhering to ETL best practices.- Conducted data analysis and optimized code performance to effectively handle large data volumes.- Performed data load validations to ensure target data accuracy using UNIX.- Monitored production jobs using the ESP Scheduler.

- Completed comprehensive training in Python (focusing on OOP and data structures), SQL, and DBMS, along with specialized training in Business Intelligence tools (SSIS, SSAS, SSMS, SSRS), which enhanced my skills in data acquisition and enabled me to create interactive SSRS reports effectively.- Performed Data Analysis and Data Integration using SSAS and SSIS.

Bachelor Of Engineering - Be, Electronics And Communication Engineering

Activities and Societies: Additional Secretary - Department Association (2018 - 2019) Join Secretary - Department Association (2017.

Mathematics And Biology

Activities and Societies: Science Club Secretary (2013 - 2014)