KOKILA PRIYA MATHESWARAN
Chennai
Summary
Industrious Senior Systems Engineer dedicated to fostering continuous improvement efforts to add value in a role. Well-versed in automating tasks to improve productivity and reduce corporate expenses. Offering Data Integration technical experience as a developer in System Analysis, Design, Development, Testing using SQL, DBT, DataStage and Snowflake in Banking and Insurance domain. Experience in SDLC requirement gathering and client interaction.
Overview
3
3
years of professional experience
1
1
Certification
Work History
Senior Systems Engineer
Tata Consultancy Services
Chennai
04.2023 - Current
- Implemented data models in DBT for accurate data transformation and alignment with business needs.
- Written and optimized SQL queries within DBT to enhance data transformation processes and improve overall performance.
- Developed and implemented a data quality process in Snowflake that reduced data errors by 50% and improved overall data accuracy by 30%.
- Performed transformations using DBT in conjunction with Snowflake, ensure the effective transformation and load data from diverse sources into data warehouse, allowing for faster data access and improved reporting capabilities.
- Designed and managed a series of DBT jobs using batch processing, coordinating with Control-M for optimized scheduling.
- Knowledge in using Erwin as leading data modeling tool for Logical and Physical Data Model.
- Experience in troubleshooting of jobs and addressing production issues like data issues, performance tuning and enhancements.
Systems Engineer
Infosys Limited
Chennai
01.2021 - 03.2023
- Systems Engineer with 2 years of Extensive ETL Tool Experience using IBM Infosphere DataStage.
- Worked on DataStage tools like DataStage Designer, DataStage Director and DataStage Administrator.
- Strong understanding of the principles of Data warehousing using Fact table, Dimension table and Star/snowflake schema modeling.
- Developed parallel jobs using different processing stages like Transformer, Aggregator, Merge, Lookup, Filter, Copy, Sort and CDC.
- Experience in scheduling DataStage parallel and sequence jobs using Autosys scheduling tools.
Education
Bachelor of Technology - Information Technology
Sona College of Technology
10-2020
Skills
- SQL
- DBT
- Snowflake
- DataStage
- Data Migration
- Data Warehousing
- Agile Methodologies
- Control-M/Autosys
- GitLab/Bitbucket
Certification
InfosphereInfosysAutosysAutosys
- AWS Cloud PraInfosyser
- Infosys Certified Agile Infosyser
- Infosys Certified DataStage Developer.
Timeline
Senior Systems Engineer
Tata Consultancy Services
04.2023 - Current
Systems Engineer
Infosys Limited
01.2021 - 03.2023
Bachelor of Technology - Information Technology
Sona College of Technology
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services