SUMMARY

• Over 7 years of extensive experience with ETL tool Informatica Power Center /Power Mart Power Exchange in designing and developing Mappings, Mapplets, Transformations, Workflows, Worklets, Configuring the Informatica Server and scheduling the Workflows and sessions.
• Over 7 years of Database experience using Oracle, PL/SQL, SQL Server. Strong Experience on database interfaces like SQL developer and TOAD.
• Have performed various testing activities like Unit Testing, Integration, System Testing, Regression Testing and User Acceptance Testing and ensured that the code is ideal.
• Worked on Client developed automation tool to automate the Informatica jobs and testing automation in IFT and UAT environment.
• Experience in Slowly Changing Dimensions Type 1, Type 2 and Type 3 for inserting and updating Target tables for maintaining the history.
• Experienced in automating the Informatica jobs, also experienced in Autosys, UNIX scripts for automation
• Extensive experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner.
• Experience in various domains like Telecom, Healthcare, Banking and Insurance.
• Implemented data warehousing methodologies for Extraction, Transformation and Loading using Informatica Designer, Repository Manager, Workflow Manager, Workflow Monitor.
• Experience on Debugger to validate the mappings and gain troubleshooting information about data and error conditions.
• Extensive experience in production support, solving various tickets within SLA's.
• Able to finish all the assigned user stories with in the sprint including Unit testing and documenting the results.

TECHNICAL SKILLS

• Data Warehousing / ETL Tools: Informatica Power center (Repository Admin Console, Repository Manager, Designer, Workflow Manger, Workflow Monitor, Power Exchange).
• Data Modeling: Star Schema Modelling, Snow Flake Modelling.
• Databases: Oracle, SQL Server.
• Languages: SQL, PL/SQL, core java basics, Unix Shell Scripting.
• Tools: Toad, SQL* plus, Putty, SVN, Autosys, Tivoli, Confidential RTC.
• Operating Systems: Windows& Linux
• Agile: Rally, Kanban, Jira.
• Testing: Quality center.

PROFESSIONAL EXPERIENCE

ETL - Informatica Developer,

Confidential, Raleigh, NC.

Responsibilities:

• Involved in requirement gathering meetings to get the requirement and the process of the business.
• Created mappings, sessions, workflows for the requirements and conducted code reviews and Test results review.
• Worked on testing ETL applications in testing environments Acceptance, Integration and Performance environments of the Data hodlers team.
• Created and modified SCD Type1, Type2 and Type3 mappings.
• Followed the project development standards to clearly log information of failure or succeeded whenever a work flow executed.
• Used different types of transformations like router, expression, update strategy, Aggregate and joiner.
• Created Stored procedures, SQL/PLSQL scripts for informatica Load process.
• Worked on creating informatica workflows which runs daily, weekly and monthly(On Demand).
• Worked on Performance tuning of the existing workflows without affecting the existing business requirement.
• Worked on fixing the informatica production issues.
• Worked with different source systems DB2, Postgres, ODS and flat files.
• Created parameter files for the inofrmatica workflows and sessions.
• Created test scripts and executed them to test the application.
• Prepared Technical specification document (TSD) and test results documents.

Environment: Informatica power center 10.2.0, Oracle Exadata, SQL/PLSQL, Unix, Putty, Winscp, SQL developer, jira Kanban board, Agile, windows 10.

Confidential, Knoxville, TN

Responsibilities:

• Gathered user requirements and reporting requirements for a better understanding of the business process and the current reporting system.
• Constantly interacted with the Business Intelligence team and the Data Warehouse Architecture team to understand the requirements and implement them seamlessly.
• Created mappings, sessions, workflows as per the business requirement and tested those applications in QA environment before pushing them to Production.
• Worked on different types of defects in all the applications we have in Discovery Data services team.
• Worked on performance tuning of the existing work flows and improved the performance without changing and failing the existing business scenario.
• Improved the mapping performance using SQL overrides. UsedPL/SQL to write stored procedures to increase the performance.
• Provided support to the existing applications, fixed the production job failures instantly.
• Implemented Slowly Changing Dimension (SCD)Type 1 and Type 2 for inserting and updating Target tables for maintaining the history.
• Extensively created Reusable Transformations and Mapplets to implement the business logic for loading to the target database.
• Developed post-session and pre-session shell scripts for tasks like merging flat files after Creating, deleting temporary files, changing the file name to reflect the file generated date etc.
• Wrote SQL/PLSQL and stored procedures as per the business requirement.
• Developed the UNIX shell scripts to send out an E-mail on success of the process indicating the destination folder where the files are available.

Environment: Informatica Power center 10.2.0, Oracle, SQL/PLSQL, SQL Developer/Toad, Unix, Putty, winscp, Bitbucket, Jira Kanban board, Agile, Windows 10.

Confidential, Charlotte, NC.

Responsibilities:

• Gathered requirements from SME and contributed in meeting with BA's for new enhancements and adhoc reports.
• Involved in various phases of SDLC from requirement gathering, analysis, design, development and testing to production.
• Working closely with Architects and Project Manager for the applications assessment to all the Data Masking Team on Proxy server and proving support on the databases and applications.
• Worked with Offshore and lead a team of 5.
• Extensively used Informatica Power center designer to create mapping with various transformations.
• Created Mappings, Mapplets, Workflows, Sessions.
• Created Parameter files and validation scripts.
• Extensively worked on various Defects and Enhancements for more than 80 applications.
• Modified and developed new ETL logic, transformations, indexes, data staging areas, summary tables, and data quality routine based upon redesign activities
• Did performance tuning to improve Data Extraction, Data process and Load time without affecting the code. Optimized the performance of the mappings by various tests on sources, targets and transformations.
• Worked with flat files, loaded data from flat files to Oracle.
• Used Mapping Parameters to create Incremental Loading.
• Created test cases for unit testing and documented the results.
• Used RTC to push the code into higher environments.
• Migrated Informatica, UNIX code and maintained versioning using Subversion.
• Created SCD1, SCD2 mappings to load history tables and capture the changes.
• Created efficient Error logging mythologies by using PostSession Commands and Error logging tables.
• Wrote SQL, PL/SQL , stored procedures for implementing business rules and transformations.
• Presented many KT sessions to the offshore team.

Environment: Informatica Power center 10.1,Confidential RTC, Oracle, PL/SQL, SQL, Autosys, UNIX, Toad, Putty, Rally, Windows 10.

Confidential, Lake Oswego, Oregon

Responsibilities:

• Created mapping, sessions, workflows, both re-usable and non-reusable depending on the requirement.
• Worked on Informaticatesting automation (DEV/IFT/UAT) by using client developed testing automation tool and automated the jobs by using the automation tool instead of Autosys. Used Quality center to write the test cases and also to track the defects.
• Used Informatica Power Exchange to import source definitions from Mainframe system to Informatica Power Center.
• Used shell scripts to invoke workflows and capture the log files.
• Provided support to Autosys team to schedule the developed workflows based on time and calendar constraints
• Extensively used almost all types of transformations like filter, joiner, sorter, rank, update strategy, expression, Java transformations and aggregation.
• Developed concurrent work flows for the regions HI, NW, CO, SC, NC, MA and GA.
• Improved the workflow runtime by tuning the mappings.
• Involved in the process design documentation of the Data Warehouse Dimensional Upgrades.
• Deployed code into production for Informatica, Unix, Oracle and Autosys using subversions
• Created shell scripts to invoke workflows and run jobs via Autosys.
• Involved in creating Technical Specification Document (TSD) for the project.
• Involved in gathering business requirements, logical modeling, physical database design, data sourcing and data transformation, data loading, SQL and performance tuning.
• Experience in debugging and performance tuning of sources, targets, mappings and sessions

Environment: Informatica 9.5.1, Power Exchange, Windows 7, Oracle, PL/SQL, SQL, Autosys, UNIX, Toad, Quality center, Kanban.

Confidential,

Responsibilities:

• Gathered business requirements and prepared high level design documents.
• Worked with architect in designing the architecture and building the tables.
• Extensively used Informatica Power center designer to create tables and generate shell scripts.
• Created Parameter files and validation scripts.
• Extensively used almost all types of transformations like filter, joiner, sorter, rank, update strategy, expression and aggregation.
• Used Repository Manager to migrated code for different environments, from stage to development, development to test.
• Worked with pmcmd command line program to communicate with the Informatica server, to start, stop and schedule workflows.
• Created several job scripts in Unix to run jobs automatically
• Used and developed Shell Scripts used for Pre and Post Session commands for the developed Mappings and scheduling.
• Worked on performance tuning to get the optimum results.

Environment: Informatica Power Center 9.1,Oracle 10g,PL/SQL, Flat Files, UNIX, Win XP, SQL * Plus, Putty, Toad.