Pavithra N
Bangalore
Summary
Informatica Developer with extensive experience at Schneider Electric, focusing on ETL processes and data integration. Proficient in Informatica PowerCenter and performance tuning, consistently optimizing mappings to improve operational efficiency. Strong collaborator in Agile environments, dedicated to maintaining data integrity and ensuring smooth workflows.
Overview
7
7
years of professional experience
Work History
Informatica Developer
Schneider Electric
Bangalore
04.2023 - Current
- Developed mappings and enhancements according to technical requirement documents for new and existing feeds.
- Developed ETL processes using Informatica for data integration projects.
- Collaborated with business analysts to gather requirements for data workflows.
- Optimized existing mappings, enhancing performance and efficiency of data loads.
- Deployed developed objects into different environments such as Development, QA, UAT and Production.
- Created reusable transformations using Joiner, Lookup, Filter, Expression, Aggregator, and Worklets.
- Modified existing mappings based on user requirements while maintaining sessions and workflows.
- Validated flat files, loaded data to database, and ensured compliance with data rules.
- Managed metadata documentation and generated parameter files, supporting consistency across all tasks.
- Maintained star schema and loaded data into dimension and fact tables for reporting.
- Processed various file types (.csv, .xls, .txt) using Unix and loaded them into the database.
- Conducted unit testing, wrote test cases, and facilitated migration to UAT environment.
Informatica Developer
Accenture
Bangalore
01.2019 - 03.2023
- Created reusable transformations using Joiner, Lookup, Filter, Expression, Aggregator, Update Strategy, and Worklets.
- Developed mappings and enhancements based on technical requirement documents, ensuring accuracy for new and existing feeds.
- Modified existing mappings to meet user requirements while ensuring integrity of sessions and workflows.
- Automated job runs through Unix scripts to improve operational efficiency.
- Validated flat files before loading them into the database, applying necessary data rules.
- Maintained metadata and generated parameter files for all tasks involved in processes.
- Managed star schema design, loading data into dimension and fact tables for reporting.
- Conducted unit testing and system integration testing, preparing comprehensive test cases for UAT migration.
Education
Information Technology -
SITAMS College of Engineering JNTUA
Chittoor, Andhra Pradesh01.2014
Skills
- Informatica PowerCenter
- SSIS and ETL development
- SQL Server
- DB2 database management
- Data validation
- Mapping optimization
- Performance tuning
- Unit testing
- Control M job scheduling
- Unix operating system
- Visual Studio
- Agile practices
- JIRA project tracking
- BMC Remedy
Languages
English
Upper Intermediate (B2)
B2
kannada
Intermediate (B1)
B1
Telugu
Upper Intermediate (B2)
B2
Hindi
Intermediate (B1)
B1
Tamil
Beginner (A1)
A1
Timeline
Informatica Developer
Schneider Electric
04.2023 - Current
Informatica Developer
Accenture
01.2019 - 03.2023
Information Technology -
SITAMS College of Engineering JNTUA