Navya D. Email & Phone Number

Dallas, Texas, United States

 Evaluation of Business/technical requirements including assessment of how requirements can be best supported with existing platform/technical architecture. Requirements gathering and data analysis. Detailed analysis of existing logics and methodologies. Creation and management of new tables as required. Transforming data from source(oracle) to Teradata target tables, Mappings, Workflows and Tasks creation and parameterization of variables. Autosys job scheduling for running workflows and Assisted fully for migration activities. Manage prominent changes at ETL and handled the migration activity throughout. Involved in Performance tunning at source to Target, mapping, session and system levels and also use partition logics at database level. Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.

Texas, United States

Responsibilities :• Responsible for Business Analysis and Requirements Collection.• Followed Agile Methodology and daily involved in Scrum meetings• Parsed high-level design specification to simple ETL coding and mapping standards.• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.• Created mapping documents to outline data flow from sources to targets.• Extracted data from different sources like Oracle, Flat files and Sql server databases into staging area and then to the base tables(DWH).• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.• Used various transformations like Source Qualifier, Filter, Aggregator, Lookup, Sorter, Expression, Normalizer, Router, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.• Designed and developed with Cigna standard, transformation logic and processes in Informatica for implementing business rules and standardization of source data from multiple source systems into the data warehouse.• Modified existing mappings for enhancements of new business requirements.• Created Unit Test documents for the mappings to test the data load.• Involved in data validation from Source to staging to Target.• Identified sources, targets, mappings and sessions bottlenecks and tuned them to improve performance.• Extensively involved in writing queries for testing the target data against source data.• Supported during QA/UAT/PROD deployments and bug fixes.• Worked closely with QA team to discuss the UAT defects and responsible for maintaining the• Using ESP(Enterprise System Platform) scheduling tool to create jobs to run the informatica workflows.• Involved in code Reviews as per ETL/Informatica standards and best practices• Followed Informatica recommendations, methodologies and best practices.

Dallas, Texas, United States

Responsibilities :• Involved and understanding the Business requirements/ discuss with Business Analyst, analyzing the requirements and preparing business rules.• Developed mappings using Informatica to load the data from sources such as Relational tables, Flat files, Oracle tables into the target Datawarehouse.• Developed mappings/Transformation/mapplets by using mapping designer, transformation developer and mapplets designer using Informatica PowerCenter.• Experienced in methodologies like SDLC and Agile methodologies such as SCRUM.• Contributed and actively providing comments for user stories review meeting within an AGILE SCRUM environment.• Extensively worked with transformations like Lookup, Expression, Router, Joiner, Update Strategy, Filter, and Aggregate.• Implemented several different tasks (Session, Assignment, Command, Decision, Timer, Email, Event-Raise, Event-Wait, Control) in the workflow.

Texas, United States

Responsibilities :• Involved in design, development, and maintenance of database for Data warehouse project.• Involved in Business Users Meetings to understand their requirements.• Designed, Developed and Supported Extraction, Transformation and Load Process (ETL) for data migration with Informatica 7.X.• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.• Created complex mappings which involved Slowly Changing Dimensions, implementation of Business Logic and capturing the deleted records in the source systems.• Extensively worked with various Lookup caches like Static cache, Dynamic cache, and Persistent cache.• Extensively worked with Joiner functions like normal join, full outer join, master outer join and detail outer join in the Joiner transformation.

India

Responsibilities:• Converting Business Requirements into Technical Requirement documents • Converting used cases and applying business scenarios to the ETL design • Design and build mappings based on the requirements • Worked on Teradata utilities FastLoad, Multiload and BTEQ • Worked on complex transactions and high-volume transactions that are more than 1TB • Identify the tasks and logic that can be reused • Unit Test and documentation of the development tasks • Support during UAT, Build dashboards and visualizations• Complete all required support documentation