Meher R.

Etl Informatica Developer @Wells Fargo

Charlotte, NC, US

Extensively worked with the Business Analysts in understanding the requirements.• Played a major role in preparing STM (Source to Target Mapping) design with the business and data architect team.• Analyze different data sources and create data flow document for Data validation.• Development of code and writing complex SQL queries to use in mappings. • Participated in regular discussions with the business analyst to gather the requirements. • Extracted data from various sources like SQL, mainframe, csv files and flat files and loaded into the target SQL database. • Created mapping using various transformations like Joiner, Filter, Aggregator, Lookup, Stored Procedures, Router, Sorter, Rank, Expression, Normalizer and Update Strategy. • Extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings and sessions. • Created and executed workflows and worklets using Workflow Manager to load the data into the Target database. • Extensively worked on mapping variables, mapping parameters, workflow variables and session parameters. • Developed session parameter files for the workflows. • Participated in regular discussions with the Facets team to enter test data. • Analysis on source fields and wrote SQL queries for field-to-field validation by referring source to target mapping document. • Provided test data as per the test data requirements provided by the Data Governance team.• Handled production issues and monitored Informatica workflows in production. • Worked with session logs, and Informatica Debugger at the designer level before creating the workflow for error handling• Created workflows to run different mappings and monitored them using Monitor.•Created reference table using Informatica Analyst tool. • Prepared Test Cases and executed test cases using HP ALM • Prepared test plan, test scripts, Defect report, requirement traceability matrix and end user demo templates

Fairleigh Dickinson University

Electrical engineering, Information Technology