Manager Data

Gayatri Gunturu

Email: *******.****@*****.***

Contact: 425-***-****

Professional Summary

• 9 Years of IT experience in handling data warehouse projects involving Informatica including complete SDLC which involves meetings with Business Users, Requirement gathering, POC, Gap analysis, Design, development, Unit testing, Deployment, Support and co-coordinating with On-Site & Off-shore team members.

• Strong data processing experience in designing and implementing Data Warehouse and Data Mart applications, mainly Transformation processes using ETL tool Informatica Power Center.

• Strong Data Warehousing ETL experience of using Informatica PowerCenter Client tools - Mapping Designer, Repository Manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager.

• Proficiency in data warehousing concepts such as slowly changing dimension, surrogate key assignment and strong knowledge of fact and dimension tables.

• Extensively worked on Informatica Components like, Admin console, Repository manager, Designer, Workflow manager, Workflow monitor.

• Expertise in ETL Loading strategy for slowly changing dimensions type 1 and type 2 to maintain the history of records, Incremental loading using parameter, variables, and parameter files.

• Strong Experience in creating complex mappings using various Transformations such as Aggregator, Expression, Ranking, Router, Lookup, Filter, Joiner, Update Strategy transformations.

• Expert in using debugger in Informatica Designer tool to test and fix errors in the mappings.

• Experienced in Performance Tuning of sources, targets, mappings, transformations and sessions.

• Experience in identifying Bottlenecks in ETL Processes, improving the Performance of the production applications using Database Tuning, Partitioning, Index Usage and Aggregate Tables.

• Well versed in developing the complex SQL queries, unions and multiple table joins and experience with Views.

• Experienced with SQL Loader for moving data from flat files to the database tables in Oracle.

• Expertise in creating UNIX shell scripts.

• Experience in using Automation Scheduling tools like Control-M and Autosys.

• Proficient in understanding business processes /requirements and translating them into technical requirements.

• Proficient in Data Warehouse Kimball methodology, dimensional modeling, ETL, database concepts, SQL tuning, materialized views, index strategies.

• Good Understanding of SDLC Methodologies - Waterfall and Agile.

• Proficient in handling production incidents (critical issues) and production related issues involving multiple application stakeholders.

• Strong experience in formulating the Coding standard templates, code review templates, weekly code review meetings, demo, daily scrum meetings and tracking the project status.

• Proficient with HP Quality center, Incident and Change management process using Service manager and Service now.

• Experienced with logging, tracking and updating the production incidents in Jira workflow.

• Independently perform complex troubleshooting, root-cause analysis and solution development.

• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules

• Good Problem solving skills, self-directed and dedicated with strong communication and analytical skills and ability to multi-task.

Technical Summary

ETL Tools: Informatica (PowerCenter) (Designer, Workflow Manager, Workflow Monitor)

Data Modeling: Dimensional Data modeling using Star & Snow Flake schema.

Databases: Oracle Exadata, 12c/11g/10g DB2.

Languages: SQL, PL/SQL, UNIX Shell Scripting

Tools: Control-M, Autosys, SQL plus, SQL Developer, PL/SQL Developer, Toad, SQL Loader, Jira, HP Quality Center, Service Manager, Service Now.

Operating Systems: Windows XP/Vista/7, UNIX, Linux

Professional Experience

Wells Fargo Advisors, St Louis, MO Apr 2018 – Current Date

Role- ETL Informatica Developer

• Gathered user Requirements and designed Source to Target data load specifications based on Business rules.

• Created High Level and Low Level design document and ETL standards document.

• Maintained source and target mappings, transformation logic and processes to reflect the changing business environment over time.

• Designed the ETL processes using Informatica tool to extract the data from sources like Seibel, Oracle and Flat files thereby loading the data into the target Data warehouse.

• Used Informatica features to implement Type I, II changes in slowly changing dimension tables and developed complex mappings to facilitate daily, weekly and monthly loading of data.

• Developed Informatica Mappings for the complex business requirements provided using different transformations like Normalizer, SQL Transformation, Expression, Aggregator, Joiner, Lookup, Sorter, Filter, and Router.

• Created DVO's to compare tables across databases.

• Used Autosys as a scheduler tool to schedule the workflows

• Used the Debugger in debugging some critical mappings to check the data flow from instance to instance and fix the bugs.

• Created and monitored sessions and batches using normal/bulk load options.

• Created parameter files to change the load date and configured that parameter at session level.

• Create reusable failure and success email tasks.

• Developed UNIX scripts to perform the file validation and populate indirect file to process multiple files.

• Involved in Performance Tuning of sources, targets mappings.

• Performed Unit Testing, integration testing and User acceptance testing of the mappings.

• Created Unit test case documents and code review templates.

• Performed Production support for triaging, debugging and fixing the issues reported by Users.

• Documented existing mappings as per standards and developed template for mapping specification document.

Environment: Informatica PowerCenter, DVO, Oracle 12C, Flat files, Autosys, Windows 10, UNIX, Shell Scripts, PL/SQL, SQL Developer, Jira, SQL* Loader, Service Now.

Fidelity Investments, Raleigh, NC May 2015 – Feb 2017

Role - Informatica Developer

• Involved in analysis of source systems, gathering business requirements, analyzing and translating the Functional Requirements into Technical Specifications.

• Interacting with the clients on a regular basis to discuss day-to-day issues and matters.

• Designed the ETL processes using Informatica tool to extract the data from sources like DB2, Oracle and Flat files thereby loading the data into the target Data warehouse.

• ETL flows are developed from Source to Stage, Stage to Work tables and Stage to Target Tables.

• Provide support for 300 Informatica workflows/mapping which are running into Production environment at client location.

• Used Informatica features to implement Type I, II changes in slowly changing dimension tables and developed complex mappings to facilitate daily, weekly and monthly loading of data.

• Developed Informatica Mappings for the complex business requirements provided using different transformations like Normalizer, SQL Transformation, Expression, Aggregator, Joiner, Lookup, Sorter, Filter, and Router.

• Used Control-M as a scheduler tool to schedule the workflows. Assisted in streamlining processes to reduce and make daily workload more efficient using Control-M.

• Responsible for the implementation of batch schedules. Perform job abend diagnosis and resolution.

• Researched and recommended scheduling enhancements that improved system performance.

• Attended daily status meeting to follow-up and resolve outstanding group issues.

• Used the Debugger in debugging some critical mappings to check the data flow from instance to instance.

• Supported weekend systems upgrades: provided technical support and knowledge of system availability times; in need of back outs, would set up conference calls to engage technical resources to coordinate action plan.

• Performed disaster recovery tests to ensure system availability and functionality.

• Created Work Flows with Command Tasks, Worklets, Decision, Event Wait and Monitored sessions by using workflow monitor.

• Created and monitored sessions and batches using normal/bulk load options.

• Created parameter files to change the load date and configured that parameter at session level.

• Create reusable failure and success email tasks.

• Involved in Performance Tuning of sources, targets mappings.

• Performed Unit Testing, integration testing and User acceptance testing of the mappings.

• Created Unit test case documents and code review templates.

• Developing UNIX shell scripts for automating and enhancing/streamlining existing manual procedures.

• Performed Production support for triaging, debugging and fixing the issues reported by Users.

• Documented existing mappings as per standards and developed template for mapping specification document.

Environment: Informatica PowerCenter, Oracle Exadata/11g/10g, DB2, Flat files, XML

files, Control-M, Windows 7, UNIX, Shell Scripts, PL/SQL, SQL Developer, Jira, SQL* Loader, Service

Now, SVN.

Tennessee Valley Authority, Chattanooga, TN Nov 2014 to Mar 2015

Role: Informatica Developer

• Gathered user Requirements and designed Source to Target data load specifications based on Business rules.

• Created High Level and Low Level design document and ETL standards document.

• Maintained source and target mappings, transformation logic and processes to reflect the changing business environment over time.

• Designed and developed ETL Mappings to extract data from flat files, SQL Server and Oracle to load the data into the target database.

• Developed mappings to load into staging tables and then to Dimensions and Facts.

• Worked on complex Source Qualifier queries, Pre and Post SQL queries in the Target.

• Developed SCD Type I and SCD Type II dimension table mappings and complex mappings to facilitate daily, weekly and monthly loading of data.

• Created complex mappings to load the data mart and monitored them. The mappings involved extensive use of Aggregator, Filter, Router,

• Developed mapping parameters and variables to support SQL override.

• Expression, Joiner, Union, Normalizer and Sequence generator transformations.

• Extensive use of Persistent cache to reduce session processing time.

• Extensively used workflow variables, mapping parameters and mapping variables.

• Created sessions, batches for incremental load into staging tables and scheduled them to run daily.

• Implemented Informatica recommendations, methodologies and best practices.

• Worked on ensuring compliance with performance criteria through database SQL and tuning the Informatica mappings.

• Create reusable failure and success email tasks.

• Performed operational support and maintenance of ETL bug fixes and defects.

• Performed unit testing at various levels of the ETL and actively involved in team code reviews.

• Identified problems in existing production data and developed one time scripts to correct them.

• Optimizing performance tuning at source, target, mapping and session level.

Environment: Informatica Power Center 9.1, MS SQL Server 2010, Oracle 10g, XML, SQL, PL/SQL,

Toad, Windows 7, UNIX.

DQ Entertainment, Hyderabad, India May 2010 - May 2013

Role- Informatica Developer

• Responsible for gathering the requirements from business users.

• Developed customized routine (ETL system) to capture and load data from external (Oracle 8x, Flat files) data sources into Oracle database.

• Extensively used Informatica to load data into Centralized Data Warehouse.

• Update mappings, sessions and workflows as a part of ETL change.

• Develop and documented Data Mappings/Transformations, and Informatica sessions as per the business requirement.

• Used change data captures to get only new and updated records from ODS and load the target tables.

• Create mappings, sessions, tasks and workflows to meet the requirements.

• Schedule the workflows in the workflow manager.

• Create reusable failure and success email tasks.

• Involved in production support doing the debugging and troubleshooting the incidents.

• Work on SQL tools like TOAD, SQL Developer to run SQL Queries to validate the data.

• Modifications to existing ETL Code and document the changes.

• Administered end user documentation for application.

Environment: Informatica 8.6, Oracle 10G, PL/SQL, TOAD, Windows.

Contact this candidate