Meghana Tamatam
Summary
IT Professional with over 7+ years experience in building Enterprise Data Warehouse, Data Marts, Operational Data stores for Healthcare/ Banking/ Financial industry field. Expertise in developing and implementing ETL processes to extract, transform, and load data from multiple sources into a data warehouse. Detail-oriented team player with strong organizational skills. Ability to handle multiple projects simultaneously with a high degree of accuracy. Encouraging manager and analytical problem-solver with talents for team building, leading and motivating, as well as excellent customer relations aptitude and relationship-building skills.
Overview
8
8
years of professional experience
Work History
Mgr, Application Dev (IC)
CVS Health
01.2024 - Current
- Collaborated with team of engineers and analysts to design, develop and implement automated data integration solutions for Retail applications using ETL, Oracle Database.
- Enhanced data integration by designing and developing efficient ETL processes using Informatica PowerCenter.
- Investigate data to identify potential issues within ETL pipelines, notify end-users and propose adequate solutions.
- Increased team productivity by implementing streamlined processes and effective communication strategies.
- Mentored junior developers in best practices for ETL development using Informatica tools, fostering a cohesive team environment.
- Supervised a team of 2 IT analysts and managed relationships with external vendors and advisors.
- Streamlined workflows by identifying bottlenecks in existing systems and proactively addressing these challenges through appropriate solutions implementation.
- Established team priorities, maintained schedules and monitored performance.
- Design user stories, tasks, features for the sprint planning.
- Developed UNIX shell scripts, commands to implement ETL process
- Involved in debugging and troubleshooting Sessions using the Debugger and Workflow Monitor.
- Implemented change management procedures throughout the development lifecycle ensuring minimal disruption during production transition.
Senior Informatica Developer (Consultant)
CVS Health
06.2022 - 02.2024
- Responsible for extracting employee and retail store data from the flat files and transforming that data into comprehensive reports using Informatica Power center.
- Involved in requirement analysis and translated functional specifications into technical specifications.
- Streamlined ETL processes by designing reusable transformations and mapplets for optimized performance.
- Improved data quality with thorough testing and validation of Informatica jobs, ensuring accuracy and consistency.
- Reduced development time by creating reusable templates and automating common tasks in the ETL process.
- Worked under Agile methodology and used Rally to track the tasks.
- Created tests plans based on the test strategy on ETL mapping document
- Ensured timely delivery of high-quality projects by efficiently managing workloads and prioritizing tasks based on business impact.
- Written and used UNIX shell scripts for scheduling and pre/post session management.
- Supported ongoing maintenance efforts with regular reviews of existing jobs, identifying areas for improvement or refactoring as necessary.
ETL Informatica Developer (Consultant)
Santander Bank
10.2018 - 04.2022
- Enhanced data integration by designing and developing efficient ETL processes using Informatica PowerCenter.
- Based on the requirements created Functional design documents and technical design specification for ETL Process.
- Collaborated with business analysts to translate complex requirements into functional ETL mappings, meeting project goals and timelines.
- Developed Informatica mappings based on mapping documents, performed all the activities related to various phases of SDLC analysis with business user, design, development, and testing
- Worked with Oracle SQL Developer to export and load the data to/from different source systems including flat files.
- Provided support during production deployments by troubleshooting issues and ensuring seamless transitions between environments.
- Performed system integration testing to make sure business requirements are implemented as needed.
- Experienced in Scheduling sessions on Events, Timer for data loading, maintenance of backup files, parallel & sequential running of Tasks.
- Implemented SCD Type-1 and Type-2 mappings to update slowly changing dimension tables.
- Experienced in writing complex SQL for development and setting up Data Quality checks.
ETL Developer(Consultant)
Prudential Financial
07.2018 - 09.2018
- Analysis and designing the ETL architecture, development, Data migration, deployment, maintenance
- Based on the requirements created Functional design documents and technical design specification documents for ETL Process
- Experienced in Agile-scrum methodology and efficient in delivering tasks on time
- Worked on Power Center Client Tools like Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
- Documented technical specifications and designs, facilitating knowledge sharing among team members and supporting future development efforts.
- Resolved production issues quickly and efficiently, minimizing downtime and maintaining high levels of user satisfaction.
ETL Developer(Consultant)
NYS ITS Office of Mental Health
06.2017 - 06.2018
- Enhanced ETL processes by optimizing complex SQL queries and streamlining data extraction procedures.
- Designed functional requirement documents and mapping documents.
- Developed ETL routines using Informatica Power Center and created mappings using transformations.
- Worked on Power Center Client Tools like Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
- Assisted in the migration of legacy systems to modern platforms, ensuring seamless integration with existing workflows.
- Worked on Designer Tools like Source Analyzer, Transformation Developer, Mapplet Designer, and Mapping Designer and using mapplets for audit columns.
- Developed Slowly Changing Dimension Mappings (SCD) for Type 1, 2 SCD’S.
- Worked with Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy.
- Maintaining confidentiality in data processing of files from HIPAA and following standards of PHI (protected health information) regulations for data security purposes.
- Interacted with DBA’s for creating scripts to load data into Data marts for reporting.
- Extensively used ETL to load data from Flat files which involved both fixed width as well as Delimited files and from the relational database
- Code migration from development to QA and production environments
- Experienced in monitoring workflows, Session Logs, and Workflow Logs for Error handling and troubleshooting.
- Developed various SQL queries using joins, sub-queries & analytic functions to pull the data from various relational DBs i.e., Oracle & SQL Server.
Informatica Developer
Ventois
08.2016 - 06.2017
- Developing Informatica mappings based on mapping documents, performed all the activities related to various phase of SDLC analysis with business user, design, development, and testing
- Applying business rules and migrated data to target.
- Worked on Power Center Client Tools like Designer, Workflow Manager, Workflow Monitor, and Repository Manager
- Improved data accuracy by conducting thorough testing and debugging of Informatica mappings and workflows.
- Worked with application developers to design and develop database objects and structures according to project specifications, addressing data quality issues with users, vendors, and management
- Prepared unit test document and executed the test cases and inserted the data with respect to business logic
- Developed UNIX shell scripts, commands to implement ETL process.
Education
Master of Science - Computer Science
Western Illinois University
Macomb, IL05.2016
Bachelor of Technology - Electronics And Communications Engineering
Jawaharlal Nehru Technological University
Hyderabad, India05.2013
Skills
- ETL development and optimization
- Data warehouse design and implementation
- Data integration and transformation,Data analysis and validation
- SQL and database programming
- ETL tools (eg, Informatica), Scheduling (Control-M)
- Scripting languages (Unix Shell)
- Version control systems (eg, Git, SVN)
- Agile methodologies and project management
- Analytical Thinking,Strategic Planning & Team Leadership
Timeline
Mgr, Application Dev (IC)
CVS Health
01.2024 - Current
Senior Informatica Developer (Consultant)
CVS Health
06.2022 - 02.2024
ETL Informatica Developer (Consultant)
Santander Bank
10.2018 - 04.2022
ETL Developer(Consultant)
Prudential Financial
07.2018 - 09.2018
ETL Developer(Consultant)
NYS ITS Office of Mental Health
06.2017 - 06.2018
Informatica Developer
Ventois
08.2016 - 06.2017
Master of Science - Computer Science
Western Illinois University
Bachelor of Technology - Electronics And Communications Engineering
Jawaharlal Nehru Technological University
Similar Profiles
Tanishia RatcliffeTanishia Ratcliffe
Shift Supervisor at CVS HealthShift Supervisor at CVS Health
Lucy BlaizeLucy Blaize
Senior Account Manager at CVS HealthSenior Account Manager at CVS Health
Maureen Kanayo OmesuhMaureen Kanayo Omesuh
Pharmacy Manager at CVS HealthPharmacy Manager at CVS Health
Mohamed Elattar, PharmD, MSITMohamed Elattar, PharmD, MSIT
Pharmacy Manager at CVS HealthPharmacy Manager at CVS Health
Roshan ThimmannaRoshan Thimmanna
Technical Lead Business Intelligence and Data Engineer at Victoria's Secret India Pvt. LtdTechnical Lead Business Intelligence and Data Engineer at Victoria's Secret India Pvt. Ltd