Vanitha Murugesan
Chennai
Summary
Over 9+ years of experience in the Information Technology industry in retail, life science, and banking domains that includes around 4 years of experience in ODI and around 4 years of experience in Talend tool and around 1.5 years of experience in matillion.
Overview
10
10
years of professional experience
Work History
ETL Lead
Gradmenener technologies
10.2021 - 09.2022
- Worked on developing the jobs in matillion and talend based on business requirements
- Self learnt matillion and trained the team on matillion and talend
- Migrated the talend and BODS codes to matillion
- Monitored the BODS jobs and reported the issues.
- Trained the team on matillion
- Assisted the team on technical aspects in troubleshooting and code development
- Worked on various projects
- Worked on debugging and fixing the production issues.
Senior Software Engineer
Xoriant Solution Pvt. Ltd.
06.2020 - 07.2021
- This project is for monitoring the transactions and reporting if any illegal transactions happened
- Worked on Ab Initio to Talend code migration jobs
- Delivered the talend codes with zero defects
- Worked on talend code for finding country codes based on the address provided
- Created the Shell Script for validating whether all the product processors data loaded or not in corresponding tables
- Worked on debugging the production issues
- Environment: Talend Data Integration 6/ 7.1, Oracle
Consultant
Virtusa
09.2018 - 05.2020
- Involved in the back end team for doing transformation, validation and cleansing of the input data received
- Developed ETL jobs to load Excel files and CSV files to MySQL databases with corresponding transformation and validations as per the requirements
- Refactored the Java codes used in Talend with SQL logic in Talend
- Created reusable jobs for loading data from one database to other databases and generic validation job and sending mail job
- Worked on jobs deployment in TAC server and Jenkins
- Created generic Talend job for reprocessing SQS messages from dead letter queue
- Used Git clone/ push commands for contexts management
- Used Bitbucket for context management and AWS S3 basic commands
- Trained the junior members in jobs development
IT Analyst
TCS
01.2013 - 09.2018
- Worked as part of the Data warehouse team, where we will receive the source files and will load those files by doing certain transformation and validations as per the business requirement using ODI jobs
- Initially jobs were designed in ODI tool, later ODI code migrated into Talend
- As an ETL Developer, designed and developed packages, scenarios using procedures, interfaces, and variables for various sources including fixed width files, delimited files, and relational databases according to the given business requirements in ODI
- Worked on ODI code migration into Talend
- Worked on migrating databases from Netezza to Redshift and Oracle to Postgres
- Created reusable jobs in Talend
- Worked on all the phases like analysis, design, implementation, and documentation of the project using Agile methodology
- Environment: Talend Data Integration, Oracle Data Integrator, Netezza, Oracle, Redshift, Postgres
Education
Bachelor of Engineering - Electronics and Communication Engineering
Anna University
01.2012
Skills
- ETL Tools: Matillion
- ETL Tools: Talend
- ETL Tools: ODI
- ETL Tools:BODS
- Databases: Netezza
- Databases: Oracle
- Databases: Redshift
- Databases: Postgres
- Databases: MySQL
- Others: Jenkins
Certificates Trainings And Achievements
- Talend Certified
- Got On the Spot Award for the good team player and guiding the team members.,
- Got Rewards and Appreciations from client and team leaders for the successful prod deployment.
Timeline
ETL Lead
Gradmenener technologies
10.2021 - 09.2022
Senior Software Engineer
Xoriant Solution Pvt. Ltd.
06.2020 - 07.2021
Consultant
Virtusa
09.2018 - 05.2020
IT Analyst
TCS
01.2013 - 09.2018
Bachelor of Engineering - Electronics and Communication Engineering
Anna University
Similar Profiles
Venkata Nagaraju InakolluVenkata Nagaraju Inakollu
Technical Lead(System Design) at Relysys Technologies Pvt Ltd (now Invendis Technologies pvt ltd)Technical Lead(System Design) at Relysys Technologies Pvt Ltd (now Invendis Technologies pvt ltd)
Sachin HatoleSachin Hatole
Quality Analyst at Mindpool Technologies Pune, Mindpool TechnologiesQuality Analyst at Mindpool Technologies Pune, Mindpool Technologies
Keith LawrenceKeith Lawrence
Material Handler at Casting Technologies TechnologiesMaterial Handler at Casting Technologies Technologies