SUMMARY:

• 7 years of experience in IT industry with full development life cycle.
• Experienced in Analysis, Design, Development and Maintenance of various software applications mainly in Data Warehousing, ETL Informatica PowerCenter, Oracle, Microsoft SQL server, Unix.
• Extensive experience on Informatica PowerCenter with strong business understanding and knowledge of ETL of data from heterogeneous source systems like Flat files, Excel, XML, Oracle, MySQL, Microsoft SQL Server.
• Experience in Informatica 9.6.1 using components such as Mapping Designer, different types of Transformations such as (Source Qualifier, Filter, Aggregation, Router, Update Strategy, Connected and Unconnected Lookups, Union, Expression, Joiner, Sorter, Stored Procedure, Sequence Generator etc.)
• Experienced in creating Reusable Sessions, Mapplets, Transformations and Worklets
• Proficient in using Informatica Workflow Manager, Workflow Monitor to create, schedule and control Workflows, Tasks, and Sessions
• Testing and Debugging of Informatica Mappings, Mapplets, Sessions, Tasks, Worklets and Workflows
• Self - motivated and energetic, able to set priorities with adherence to guidelines and deadlines
• Using prototyping skills when appropriate, clarify customer requests/problems and determine appropriate action with proven success exceeding customer expectation
• Capable of working under high stress environment with resource constraints
• Strong organizational and problem solving capabilities
• Technical team leadership
• Excellent communicator with emphasis on clearly presenting information and developing strong interpersonal relationships

TECHNICAL SKILLS:

Database: Oracle, MySQL, Microsoft SQLServer

ETL Tools: Informatica PowerCenter

Data Modeling: ERWIN, Microsoft Visio, Visual Paradigm

Reporting Tools: SAP Crystal Reports

Scheduling Tools: Control-M

Languages & Frameworks: Java (Hibernate ORM, Spring), PL/SQL, ColdFusion, PHP, Python

Web Technologies; HTML5, CSS, JavaScript, AJAX, jQuery, JSON

Operating Systems: Windows, UNIX/Linux, Mac OS X, Android

Tools: SQL Developer, TOAD, ANT, JUnit, Eclipse, Microsoft Project, Dreamweaver, Subversion, CVS, IBM Rational RTC

PROFESSIONAL EXPERIENCE:

Confidential,

Washington DC

Informatica Developer

Responsibilities:

• Responsible for Requirements gathering & analysis, and Business Analytics. Design of Data Warehouse to meet the requirements. Prepare ETL design documents and review with the data modelers for data integrity.
• Determine data sources, their types, and perform data source analysis. Using mapping standards design simple transformations from complex data sources to the Data Warehouse. Create mapping documents to outline data flow from sources to targets.
• Create a warehouse data model using ERWIN and dimensional modeling techniques like Star and Snow Flakes Schema in order to meet the tactical and strategic business requirement.
• Designed and developed mappings, defined workflows and tasks, monitored sessions, exported and imported mappings and workflows, backups, and recovery.
• Created mappings, which involved transformations, like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Sorter, Source Qualifier, Joiner, Update Strategy, Expression and Aggregator transformations to load the funds allocation transactions data. Used debugger to test the mappings and fixed the bugs.
• Extensively used ETL to load data from flat files involving both fixed width as well as delimited files, and also from the relational databases, Oracle and MySQL.
• Developed slowly changed dimensions (SCD) Type 2 for loading data into Dimensions and Fact.
• Developed common routine mappings. Made use of mapping variables, mapping parameters and variable functions.
• Using Informatica Workflow Manager, define and develop workflow tasks like session, events raise, event wait, decision, e-mail, command, worklets.
• Extensively involved in writing SQL queries (Sub queries and Join conditions), Store Procedures and PL/SQL programming.
• Created and used reusable Mapplets and Worklets to reduce the redundancy.
• Analyzed the session and error logs for troubleshooting mappings and sessions.
• Test transformation output with expected outcome generated using SQL queries. Used Debugger to test the mappings and fixed the bugs.
• Performance tune source, target, mappings, and sessions.
• Generated various drill down and cross tab reports using SAP Crystal Reports.
• Created shell scripts in UNIX to automate the batch jobs.
• Used PMCMD to schedule jobs and shell scripting to upload data files into tables of the Oracle database.
• Define, configure and establish deployment best practices using development, staging and production environment. Prepare migration document to move the mappings from development to staging and then to production repositories.
• Assist Production Control team during deployments. Provided support for any production issues that may arise.

Environment: Informatica Power Center 9.6.1, Oracle 11g, MySQL 5.6, SAP Crystal Reports 2011, UNIX Shell Scripting

Confidential, Herndon, VA

Informatica Developer

Responsibilities:

• Interacted with technical, functional and business audiences across different phases of the project life cycle.
• Researched on available data sources and identify data gaps. Collaborate with right data owners to bridge the data gaps and create new data sources. Also perform analysis and cleanup of existing data for redundancy and referential integrity.
• Designed and developed complex ETL mappings by making use of transformations like Source Qualifier, Joiner, Update Strategy, Connected and unconnected Lookup, Rank, Expression, Router, Filter, Aggregator and Sequence Generator transformations.
• Developed Informatica mappings, sessions and workflows as per the business rules and loading requirements.
• Created Workflows using various tasks like sessions, decision, e-mail, command, worklet, assignment and worked on scheduling of the workflows.
• Used mapping parameters and variables.
• Prepared mapping specification document, which gives the data flow and transformation logic for populating each column in the data warehouse table.
• Used debugger to analyze the data flow between source and target to fix data issues.
• Developed PL/SQL procedures, functions to facilitate specific requirement.
• Design & optimization of complex SQL queries.
• Implemented audit and reconcile process to ensure Data Warehouse is matching with the source systems in all reporting perspectives.
• Prepared the Standard Operating Procedure (Knowledge Transfer) document, which provides necessary information, required for the maintenance and operation of the application.
• Created the release requests for QA builds to include all the release requirements and involved in the implementation of QA, UAT and Production releases.
• Provided data loading, monitoring, and system support and worked on data issues raised by end user during its production support phase.

Environment: Informatica Power Center, Oracle, SQL Server, Flat files, Toad, UNIX

Confidential, McLean, VA

ETL Developer

Responsibilities:

• Interacted with Business Analysts for requirements gathering (BRD), business analysis, and translated the business requirements into technical specifications to build the Enterprise Data Warehouse.
• Developed mappings for fact and dimension tables using the various transformations to extract data from different source databases Oracle, Microsoft SQL Server, Excel spreadsheet and flat files.
• Responsible for data reconciling activity between legacy system & Enterprise Data Warehouse.
• Developed number of complex Informatica mappings, Mapplets, reusable transformations to implement the business logic and to load the data incrementally.
• Implemented Slowly Changing dimensions Type 1 &Type 2 methodology for the transaction history of Data Mart.
• Developed PL/SQL procedures, functions to facilitate specific requirement.
• Worked with the DBA to improve ETL performance and query performance by collecting statistics and defining relevant indexes on database tables.
• Implemented audit and reconcile process to ensure Data warehouse is matching with the source systems in all reporting perspectives.
• Involved in performance tuning in Informatica for source, transformation, targets, mapping and session.
• Developed and Documented Unit Test cases as part of the interface development deliverable.
• Involved in System and Integration Testing in order to detect and resolve development defects.
• Provided Production Support to ensure smooth execution of the interfaces.

Environment: Informatica Power Center, Oracle, Microsoft SQL Server, Excel spreadsheets, Flat Files, UNIX