SUMMARY:

• 9 years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application systems for Health care, Pharmaceutical, Financial, Insurance, Telecom and Banking.
• Proficient in Analyzing Business processes requirements and translating them into technical requirements. Implemented various ETL solutions as per the business requirement using Informatica 9.x/8.x/7.x/6.x. Involved in the full development lifecycle from requirements gathering through development and support using Informatica Power Center, Developer Tool, Repository Manager, Designer, Workflow Manager, and Workflow Monitor.
• Experienced in designing/developing complex mapping using Informatica transformations Experienced in defining data modeling, data warehouse, Star/Snowflake Schema Designs with requirements analysis - definition, database design, testing and implementation, and Quality process. Successfully managed operations on Informatica Enterprise Data Warehouse (EDW) including creation, designing, development, implementation, and testing.
• Experience in integration of various data source definitions like SQL Server, Oracle, Flat Files, HDFS, Hive, Avro, SAP and XML Experience in creation of S-T mapping with respective to the BRD and in creation of FSD for the developers Experienced in debugging and performance tuning of sources, targets, mappings, and sessions in Informatica. Experience with Data modeling and Reporting tools like Erwin 4.X, OBIEE 10.1.3x., Cognos Report Net 1.1, and Business Objects 5.0 Experienced in implementing Application Lifecycle Management for bug detection and fixing in testing. Excellent communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high adaptability to new technologies and tools. Strong Team working spirit and relationship management skills.

TECHNICAL SKILLS:

Data Modeling: Erwin 4.5/4.0/3.x, MS Visio

Data Warehousing: Informatica Power Center 9.x/8.x/7.x/6.x, OLAP, OLTP

Data Base: Oracle 11g/10g/9i/8i/7.x, DB2, Tearadata 12/13,MS SQL Server 2000/2005, Sybase.

Business Intelligence: Cognos Report Net 1.1, Business Objects 5.0, Siebel Analytics/ OBIEE 10g

Languages: SQL, PL/SQL

Web Tools: HTML, DHTML, XML

Tools: Toad 9.1, Query Builder, Microsoft Project 2003, Quality Center, PVCS, Control-M, Autosys, SQL Developer

Operating Systems: Microsoft XP/2000/NT, UNIX

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Sr. Informatica ETL Developer

Responsibilities:

• Created documents for use cases based on discussions with Project managers and Business users. Designed and developed mappings, sessions and workflows with Informatica Power center 9.6.1 and Developer Tool to load data into Hadoop. Read from and wrote files into, Hadoop system and worked within the file system to browse through files using FS shell commands. Data load into HDFS in formats like Hive and Avro. Queried data using Impala and Hive Web browsers.
• Monitored jobs with job trackers and Validated data files in HDFS file system Worked with flat file data object specified connections and directories for source and target system. Implemented source, target and full push down optimization and worked on trouble shooting errors encountered. Provided QA team knowledge on Hive queries and HDFS File system Web browser techniques. Worked on
• UNIX scripts and logs to troubleshoot QA issues and production issues. Processed large number of files, capturing exceptions, rejections and auditing source data. Worked on mappings to load flat files to oracle database. Scheduled and documented meetings to log progress and discuss change requests. Created technical design documents to reflect new implantation and analyze the difference from current production processes. Supported defect resolution and updated Application portal with detailed comments facilitating code migration across environments.

Environment: Informatica PowerCenter and Developer Tool 9.1/ 9.6.1, Hadoop,Oracle 11g, Oracle SQL, XML, MS, MS Excel, MS Visio, LINUX Shell.

Confidential, Erlanger, KY

Sr. Informatica ETL Developer

Responsibilities:

• Discussing business requirement with Business Analysts to develop technical specifications and design and develop ETLs. Extracted data from Oracle, DB2, flat files and XML files and transformed data using Source qualifier, Expression, Sequence Generator, Sorter and Router transformations.
• Created Mapping parameters, session parameters and generated the parameter file using ETL. Implemented Reusable transformations, mappings, User Defined Functions, Sessions. Used Built in Informatica Scheduler to schedule the process on a daily basis. Responsible for writing/documenting the Unit Test Cases with different testing scenarios to meet all the complex business rules implemented in ETL mappings. Adhered to the quality code standards described by the client. Prepared process level reports such as Regression Testing Reports, Execution Reports, Effort Estimation Reports, Tractability Reports, and Change Request (CR) Estimation Reports etc.
• Creation of sessions and workflows according to the data load in to different systems. Maintained Coding standards and participated in Code Review. Involved in Performance tuning of mapping level and session level. Maintained all the documents in the clear case and CVS for Version control. Executed Unit, Functional, Integration, Regression and System testing and preparation review documents for the same.

Environment: Informatica PowerCenter 9.1/ Oracle 11g,Oracle SQL, DB2, XML, MS SQL Server 2005,MS Excel, MS Visio, UNIX(AIX), UNIX Shell.

Confidential, Tampa, FL

Sr. Informatica ETL Developer

Responsibilities:

• Responsible for coordinating with the Business Analysts to understand business requirement, functional requirements and conversion of business rules into technical specifications. Responsible for creating High level and low level design specification documents for the ETL mappings. Extracted data from a wide variety of Sources like Flat files, XML files, XML Schema,XSLT,XSD,Relational Databases (Oracle, SQL Server) and from the legacy Mainframes and SAP source systems by using Informatica Power Exchange. Extensively worked with Slowly Changing Dimensions Type1, Type2 for Data Loads. 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. Designed and developed complex ETL's using various transformations like Source Qualifier, Unconnected and Connected lookups, Normalizer, Union, Router, Filter, Expression, Aggregator, Sorter, Joiner, and Update Strategy. Improved performance of the sessions by creating partitions.
• Extensively worked with the Debugger for handling the data errors in the mapping designer. Have good experience with the various environments like Development, Testing and Production and handled all kinds of change management requirements by interacting with DBAs and System Administrators.

Environment: Informatica PowerCenter 9.5/Power Exchange/Informatica Cloud,IDQ 8.6.1, Tivoli, Oracle 11g,PLSQL, DB2, XML, MS SQL Server 2005,SQL* PLUS,MS Excel, UNIX(AIX), UNIX Shell..

Confidential, Plano, TX

Sr.ETL/Informatica Developer

Responsibilities:

• Analysis of requirements and finding the gap between use cases, User interface documents and ETL specifications. Creation of ETL Design documents with the help of use cases and User Interface documents, Business rule documentation and PDM. Creation of mappings according to the use cases by following the ETL specifications.
• Creation of Informatica mappings to build business rules to load data using transformations like Source Qualifier, Expression, Lookup, Filter, Joiner, Union, Aggregator, Sorter, Sequence generator, Router, Update Strategy, and Stored procedure.etc. Extracted data from of different types of Flat files, Oracle. Implemented the Error handling mechanism. Worked on Teradata-Mload,Fload,TPump and Bteq scripts to load the data in to TD database Created and tested Power Exchange Data maps for Oracle CDC capture. Involved in identifying the
• Power Exchange Oracle CDC limitations and supplementary solutions. Involved in migrating the power center maps. Worked on to Extract the data from Source and cleanse and apply transformations according to the client requirements and load data in target Teradata Database using Teradata utilities like TPUMP,MLOAD and FLOAD Developed the strategy for the incremental loads, delta load and MDM. ICreation of Unit, Functional, Integration and System test cases based on Requirement Specification Documents, Use Case Docs, PDM, and User Interface Specifications. . Involved in Unit, Functional, Integration and System testing and preparation review documents for the same. Extensively used mapping parameters, mapping variables to provide the flexibility and parameterized the workflows for different system loads. Involved in Load schedule plan.

Environment: Informatica Power Center 8.6.1/9.0.1 , Oracle 10g/11g, Flat Files, XML Files, PL/SQL, TOAD for Oracle, Business Objects XIR3, MS Visio, and Windows 2000.

Confidential, Omaha, NE

ETL Developer

Responsibilities:

• Analyzed the Change requests (RFC) and Business Requirement Documents (BRD) as per requests Create, backup, restore for Informatica Repositories Involved in migration of objects in all phases (DEV, INT and PRD) of project Involving Testing, Debugging, Validation and Performance Tuning of data warehouse, help develop optimum solutions for data warehouse deliverables.
• Designed dynamic SSIS packages to transfer data crossing different platforms, validate data and data clearing during transferring, and archived data files for different DBMS Created SSIS Packages to migrate slowly changing dimensions. Modified and Tested UNIX Shell scripts and necessary Test Plans to ensure the successful execution of the data loading process. Interacted with Business Analyst and user for requirement gathering and created High Level and Low Level design documents.
• Suggested redesign of ETL processes and also re-architecture of existing ETL processes. Support defect resolution and perform change management by updating Technical system specification documentation, this will require analysis of existing software systems, and designing and implement testing for existing and new software systems. Gather Requirements, Perform Impact Analysis and Create the functional and Technical documentation for ETL process for Real time data process. Work closely with business users and involve in designing, developing high complexity mappings.

Environment: Informatica Power Center 8.6/8.1, Oracle10g/9i, Flat files, PL/SQL, Toad v9.1, SQL Developer, ERWIN 7.2, Mercury Quality Center, MS Visio, Windows Server 2003, Windows XP.

Confidential, Collegeville, PA

ETL Developer/Data Analyst

Responsibilities:

• Assisted gathering business requirements and worked closely in various Applications with Business Analyst teams to develop Data Model, ETL procedures to design Data Warehouse. Designed and developed schema model for target database using Erwin Data modeling. Effective implementation of Hierarchical Data model using Contextia ETL tool. Extracted data from Legacy Systems to Flat files and then to Postgres and by using
• Contextia finally loaded into Nexsure Warehouse. Designed and developed Context for faster development, standardization and reusability purposes. Tuned performance of Contextia mapping and databases by Target based commit interval, and mappings by dropping and recreation of indexes. Involved in pre and post session migration planning for optimizing data load performance. Extensively involved in performance tuning of the Contextia Mappings by increasing the caching size, overriding the existing SQL. Understanding client process to work efficiently and deliver solutions in accordance with Confidential quality control standards and business practices and procedures.
• Have developed a level of competency, which helps to anticipate issues solve them in advance.
• Involved in analyzing, resolving and providing temporary fix for the Data issues Also he had to interact with the business users to intimate and do the recovery steps if there is any problem in the process
• Deployment to various servers & Migration activities.

Environment: Informatica Power Center 8.1, Power Exchange, Oracle 10g, SQL, PL/SQL, AIX/DB2, Toad, UNIX HP/ Linux and Win XP.

Confidential

Informatica Developer

Responsibilities:

• Involved in understanding requirements, analyze new and current systems to quickly identify required sources and targets Prepared technical documentation, design transformations that are consistent with the goals of the existing data warehouse, and worked with the development team to implement the solution Worked in legacy code to analyze problems, confirm requirements, and create designs, code and testing. Experience in designing, developing, and testing Informatica extract/transform/load processes in a Data Warehouse.
• Extensively worked on Mapping Parameters, Workflow Variables, Mapping Variables, and Session Parameters. Used the Workflow Manager to create Workflows, Worklets and Tasks. Wrote complex SQL queries and demonstrated ability to collaborate with other developers during Design, Development, and Testing. Used design and development techniques that resulted in efficient, maintainable, and high quality ETL processes. Used problem solving skills and quickly understood relationships between data with little documentation or guidance.

Environment: Informatica PowerCenter 8.1, Oracle 9i, Flat Files, PL/SQL, DB2, Quest Central for DB2, Business Objects 6.5, Talend, MS Visio, ERWIN tool, AQT, Windows 2000, UNIX