SUMMARY

• Overall 6+years of I.T. experience
• Strong hands on knowledge in using Informatica Power Center for Extraction, Transformation and Loading of data using heterogeneous source & target systems like Flat files (fixed width and delimited),xml files, Oracle server. Also knowledge of SQL server, Netezza, Teradata.
• Hands on knowledge with mapping using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups and Aggregators.
• Knowledge of Change Data Capture (CDC) using Informatica Power Center.
• Strong knowledge in Data Modeling (Relational, dimensional, Star and Snowflake Schema), identifying FACT and Dimensions Tables, Physical and Logical Database design using ERWIN .
• Experience in debugging mappings by analyzing the data flow and evaluating transformations.
• Hands on knowledge of data flow through source, target, sessions and mappings, identifying and resolving performance bottlenecks at various stages using techniques like Session Partitioning.
• Experience in writing UNIX Shell Scripts in UNIX environment for pre - processing with knowledge of Autosys.
• Hands on knowledge of Slowly Changing Dimension Mappings of type I and type II.
• Good skills in retrieving/manipulating data by writing SQL Queries and optimizing SQL.
• Hands on knowledge in creating Reusable Sessions, Mapplets, Transformations and Worklets.
• Have dealt with development, test, pre-production and production environments
• Have supported several Java based banking applications
• Have worked on Build and Release Engineering tools and processes, and built and deployed EARs
• Have worked on tools and technologies like: Ant, Maven. Hudson, Clearcase, HPSA, ETL tool Informatica Powercenter, and done deployments primarily on Websphere. Worked and familiar with other middleware technologies like Apache Tomcat, Weblogic and reporting tool Business Object.
• Worked on UNIX platform through the course of career, with basic working knowledge of shell script skills for automation and also working knowledge of SQL queries
• Have coordinated with multiple internal teams at work
• Customer/Client interaction daily
• Have performed daily checkouts, troubleshooting, analysis, documentation of issues, to have the work done within the required SLA
• Incident management and problem management used as basis for regular work.
• Possess communication, interaction skills and team player
• Strengths are flexibility, diligence, willingness to learn and adapt to new environment

TECHNICAL SKILLS

ETL TECHNOLOGY: Informatica 9.x/8.x/7.x, Informatica PowerExchange 9.x

DATA WAREHOUSE: Star Schema, Snowflake schema and Multidimensional Modeling, Development

DATA MODELING: MS Visio, Erwin 8/7.1

DATABASES: Oracle 11g/10g, MS SQL Server 2012/7.0/2000 , MS Access, Sybase, DB2, MySQL, Teradata V2R6/13

PROGRAMMING: C, C++, SQL, PL/SQL, HTML, CSS, UNIX Scripting

ORACLE TOOLS: Oracle Enterprise Manager, Quest TOAD, SQL*PLUS, SQL*Loader, SQL*Net, SQL Navigator Export/Import, Oracle Discoverer 10g

OPERATING SYSTEMS: Windows 98/NT/2000/XP, MAC, Sun Solaris, UNIX, MS-DOS

APPLICATIONS: MS Office, MS Project, FrontPage, Toad 9.2/8.6, Basecamp, Rally

MANAGEMENT TOOLS: MS-Office 2007, MS Project

PROFESSIONAL EXPERIENCE

Confidential, Washington D.C.

Responsibilities:

• Gathered report requirements with Business Users and converted them into project documentation.
• Arrived at the dimension model of the OLAP data marts in ERWIN.
• Optimized/Tuned mappings for better performance and efficiency. Performance tuning of SQL Queries, Sources, Targets and sessions.
• Responsible for the Dimensional Data Modeling and populating the business rules using mappings into the Repository for Meta Data management. Understand the business needs and implement the same into a functional database design.
• Maintain Development, Test and Production mapping migration Using Repository Manager. Also used Repository Manager to maintain the metadata, Security and Reporting. Modeling and populating the business rules using mappings into the Repository for Meta Data management.
• Worked on System Analysis & Design of process/data flow.
• Worked on Teradata SQL and Utilities like MLOAD, FASTLOAD.
• Populating the business rules using mappings into the target tables.
• Translated the PL/SQL logic into Informatica mappings. Extensively Worked on Database stored procedures and views.
• Configured Informatica Real time workflows to capture CDC.
• Locate data rapidly with flexible object filtering techniques to reduce errors and speed development with a point-and-click interface using PowerExchange.
• Created Informatica PowerExchange Data Map and Registration on Mainframe source files and tables and importing them to Informatica shared folder.
• Used Workflow manager to create and configure workflow and session task to load data. Used Informatica workflow monitor to create, monitor workflow in case of process failures. Performed testing as per UTC.
• Implemented optimization techniques for performance tuning and wrote Pre & Post session shell scripts.
• Configured the sessions using workflow manager to have multiple partitions on source data and to improve performance.
• Involved in end-to-end system testing, performance and regression testing and data validations.
• Worked on Data Extraction, Transformations, Loading, Data Conversions and Data Analysis.

Environment: Informatica PowerCenter 9.5/9.1, Power Exchange 9.5/9.1, Teradata 13, Oracle 11g, Erwin 8, Putty, Sun Solaris. Rally, Basecamp, WinSCP, and SCM.

Confidential

Informatica Developer

Responsibilities:

• Gathered report requirements with Business Users and converted them into project documentation.
• Arrived at the dimension model of the OLAP data marts in ERwin.
• Optimized/Tuned mappings for better performance and efficiency. Performance tuning of SQL Queries, Sources, Targets and sessions.
• Responsible for the Dimensional Data Modeling and populating the business rules using mappings into the Repository for Meta Data management. Understand the business needs and implement the same into a functional database design.
• Maintain Development, Test and Production mapping migration Using Repository Manager. Also used Repository Manager to maintain the metadata, Security and Reporting. Modeling and populating the business rules using mappings into the Repository for Meta Data management
• Designed and developed complex mappings using Mapping Designer to load data from various sources.
• Created Informatica Power Exchange Data Map and Registration on Mainframe source files and tables and importing them to Informatica shared folder.
• Locate data rapidly with flexible object filtering techniques to reduce errors and speed development with a point-and-click interface using Power Exchange.
• Extensively created mapplets for reusable business rules.
• Used Pipeline partitioning and External Loader to improve Session performance, created indicator files for event driven sessions.
• Used the update strategy to effectively load data from source to target.
• Involved in Data Quality Assurance, created validation routines, unit test cases and test plan.
• Created tasks, workflows and worklets using workflow manager.
• Used pmcmd to run workflows and Autosys to automate their schedules.
• Involved in identifying bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing bugs so that they conform to the business needs.
• Handled Incremental loading using mapping variables and Implemented versioning of folders in the Informatica Designer tool.
• Worked on System Analysis & Design of process/data flow.
• Worked on Teradata SQL and Utilities like MLOAD, FASTLOAD.
• Populating the business rules using mappings into the target tables.
• Translated the PL/SQL logic into Informatica mappings. Extensively Worked on Database stored procedures and views.
• Configured Informatica Real time workflows to capture CDC.
• Used Workflow manager to create and configure workflow and session task to load data. Used Informatica workflow monitor to create, monitor workflow in case of process failures. Performed testing as per UTC.
• Implemented optimization techniques for performance tuning and wrote necessary Pre & Post session shell scripts.
• Configured the sessions using workflow manager to have multiple partitions on source data and to improve performance.
• Involved in end-to-end system testing, performance and regression testing and data validations.

Environment: Informatica 9.0.1/8.6, Power Exchange 9.0/8.6, Teradata V2R5/13, Oracle 11g, Erwin, Sun Solaris, Unix.

Confidential

ETL Developer

Responsibilities:

• Created and Documented ETL Test Plans, Test Cases, Test Scripts, Expected Results, Assumptions and Validations.
• Extensively made use of sorted input option for the performance tuning of aggregator transformation.
• Used SQL Override function in Source Qualifier Transformation.
• Responsible for migrating the workflows from development to production environment.
• Designed Audit Strategy to audit the data between Source System, Target System and Other Parallel Reporting Systems.
• Extensively worked with Incremental Loading using Parameter Files, Mapping Variables and Mapping Parameters.
• Extensive oracle backend PL/SQL development writing stored procedures, packages, functions and triggers.
• Creation of database and database objects.
• Resolved the daily issues in production environment.
• Created Weblogic domains, Websphere cell/profiles and WAR files.
• Analyzed, debugged and fixed defects

Environment: Informatica Power Center 9.1, Oracle WebLogic Server 11g, Oracle 11g, SQL Server 2008, MS Windows Server 2008 VM., Cognos 9

Confidential

Informatica Developer

Responsibilities:

• Worked with Business analysts to understand business requirements in order to transform business requirements into effective technology solutions.
• Worked with various transformations like Filter, Aggregator, Expression, Joiner, Rank, Router, Sorter, Source Qualifier, Update Strategy, Sequence Generator and Connected and Un-Connected Lookups Transformation
• Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level and the Target Level.
• Responsible for the Data Cleansing of Source Data using LTRIM and RTRIM operations of the Expression Transformation.
• Responsible for Performance in Informatica PowerCenter at the Target Level, Source level, Mapping Level, Session Level, and System Level.
• Created jobs in UNIX to run the workflow through pmcmd command. Also wrote shell scripts for file transfers, file renaming and several other database scripts to be executed from UNIX.

Environment: Informatica Power Center 8.6, Oracle Developer Suite 10g, PL/SQL, Unix.