SUMMARY

• Eight plus years (8+ years) of IT experience in the Analysis, Design, Development, Testing and Implementation of business application systems for Telecommunication, Health care, Pharmaceutical, Insurance, and Banking.
• Data Processing experience in designing and implementing Data Mart applications, mainly transformation processes using Informatica Power Center.
• Implemented various ETL solutions as per the business requirement using Informatica 9.x /8.x /7.x.
• 4+ years of experience in Data Stage and Business Objects.
• 5+ years of experience in Data Quality and fixing the issues related.
• Involved in the full development lifecycle from requirements gathering through development and support using Informatica Power Center, Repository Manager, Designer, Workflow Manager, and Workflow Monitor.
• Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, and Sequence Generator.
• Experienced in defining data quality, data modeling, data warehouse, Star/Snowflake Schema Designs with requirements analysis - definition, database design, testing and implementation, and Quality process.
• Extensive Knowledge in creating SCD Type I, Type II mappings.
• Extracted sources from flat-files, DB2, Oracle, Teradata and MSSQL.
• Involved in Performance tuning of the informatica mappings, sessions and oracle.
• Expertise in integration of various data source definitions like SQL Server, Oracle, Flat Files, SAP, and XML.
• Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages and Triggers.
• Extensively worked with SQL loader for bulk loading into the oracle database.
• Experience in complete life- cycle of test case design, test plans, test execution, defect management.
• Experience in UNIX Shell Scripting.
• Proficient in understanding business processes / requirements and translating them into technical requirements.
• Good Knowledge in Data Modeling
• Experienced in Implementing HP Quality Center for bug detection and fixing in testing.
• Managed Onsite-offshore model.
• 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

ETL Tools: Informatica PowerCenter 9.x/8.x/7.x, and PowerExchange

Databases: Oracle 11g/10g/9i/8i, MS-SQL, MS-Access, DB2, Teradata

BI Reporting Tools: Oracle Business Intelligence (OBIEE 10.x), Dashboards.

Languages: SQL, PL/SQL, Java, C, JavaScript, HTML, DHTML, XML, UNIX Shell Script, Visual Basic 6.0

Data Modeling Tools: MS Office Suite, MS project, MS Visio, Model Right (Data Modeler Tool), Erwin Data Modeler 4.1, UML

Web: Oracle Apex, Microsoft Front-page, HTML, DHTML and XML.

Operating Systems: Windows XP/2000/NT 4.0/Vista/7/8, UNIX, Linux.

Multimedia Tools: Adobe Photoshop and Dreamweaver.

PROFESSIONAL EXPERIENCE

Confidential, NC

Informatica ETL Developer

Responsibilities:

• Study the existing system and responsible for acquiring business requirements from the client
• Generated the data as per the Clients specifications using mappings and transformations.
• Involved in a process of Generating Dynamic Parameters file.
• Involved in maintaining Meta Data Management for Auditing, Logging and Error Handling.
• Implemented a process for retrieval of corporate systems data, both current and historical
• Involved in Debugging and Performance Tuning at various levels from sources to the mappings and to the Targets, session level and at workflow levels.
• Responsible for Improving Data Model and for Designing of High Level and Low Level Design Documents
• Performed mapping to identify the customer profitability, customer lifetime value, and to understand customer segmentation, attrition analysis, and affinity analysis
• Developing well-tuned Mappings using Informatica Designer Tool which involves identifying and rectifying the bottle necks at various levels like Source, Target, Mapping, Session and System
• Created Parameter files to run the workflows and performed batch scheduling of tasks
• Extensively used Informatica to load data from DB2, Flat Files and mainframes to Teradata/Oracle
• Extensively used various transformations of Informatica including Aggregator, Stored Procedures, Update Strategy, Sequence Generator and many other
• Development of Exception Handling and Error Handling Process
• Tuning the Informatica mapping, session performance by using various techniques like pushdown optimization and Optimizing Target, Source and even at the Database level
• Rigorous Unit Testing and Functional Testing to reduce the defects before QA
• Coordinated with all the technical resources and delivery of the quality solutions in the timely manner with overall project objectives

Environment: Informatica Power Center 9.1/9.5, Flat files, Oracle 11, CDC, SQL Server 2008/2010, UNIX, Teradata

Confidential

ETL Senior Developer

Responsibilities:

• Contributed as ETL tech Lead for the Data Ware housing Project that involved the design, analysis of Enhancements to the Data warehouse of Confidential Insurance and Mortgages project.
• Involved in the complete design and modeling of small business Insurance databases in SQL server 2010.
• Contributed to the detailed study of the existing data warehousing model that was completely handled in SQL SERVER 2008/2010 STORED PROCS and to the documentation for migration from STORED PROCS to Informatica mappings.
• Worked on designing and analyzing the ETL requirements for Informatica 8.5.1. Helped the ETL developers in the coding and testing phase and processes.
• Contributed to the development of ETL complex mappings including joiner, sorter, router, aggregator, union, lookup and filter transformations etc. involving facts/dimension tables, using Informatica Power Center8.5.1 (Power Exchange, Power Center Repository Manager, Power Center Designer, Power Center Workflow Manager, Power Center Change Data Capture, Power Center Workflow Monitor)
• Involved in all the ETL data architecture process such as data loading, scheduling, re-start ability and the execution of around 40 workflows and sessions which involved the facts and dimension data into the data warehouse.
• Developed a number of stored procedures, triggers, SQL (in Oracle and MS SQL Server 2008/2010) and UNIX Korn shell and Perl scripts for the business logic and the interface between UNIX, AIX and Informatica.

Environment: Informatica Power Center 8.6.1/7.1, SQL SERVER 2008/2010, SQL Navigator, SQL, PL/SQL, star Schema, Snowflake Schema, UNIX, AIX.

Confidential, Tampa, FL

Informatica ETL Developer

Responsibilities:

• Worked closely with the business analyst and Data warehouse architect to understand the source data and need of the Warehouse. Worked in different stages of Data Stage basically on Hash Partitions
• Involved in designing of star schema based data model with dimensions and facts.
• Used Informatica as ETL tool for building the data warehouse.
• Worked on DQ team for fixing issues related to DQ tickets and worked on Data Stage for extracting and loading ODBC and data storages.
• Developed Data mappings using Informatica Designer and workflows using Workflow Manager.
• Extensively worked on different subject areas like Product, Individuals, Accounts, Scores, Billing, Services, Demographics, Call details and summary details.
• Created mappings with heterogeneous sources like flat files, Oracle databases and created targets in Oracle using Informatica Mapping Designer
• Designed and developed aggregate, join, lookup transformation rules (business rules) to generate consolidated (fact/summary) data using Informatica Power center.
• Designed and developed mappings using Source qualifier, Aggregator, Joiner, Lookup, Sequence generator, stored procedure, Expression, Filter and Rank transformations.
• Created session variables to build sessions more effectively by using Informatica server manager.
• Developed mappings to dynamically use parameter files used by other mappings.

Environment: Informatica Power Center 8.6, Oracle 10g, TOAD, Control-M, UNIX, Windows XP.

Confidential

Senior ETL Developer

Responsibilities:

• Interact with end users and Business Analyst to gather and understand the Business process and requirements.
• Worked with the Source analysts to figure out the different source systems involved for the project and also provided necessary information as per development perspective.
• Involved in design review meetings to finalize the Data Model and the design documents necessary for the development. Prepared and reviewed Technical design documents for ETL coding. Worked on SCD Implementation in Data Stage.
• Created Sessions and workflows for related mappings
• Performed unit test for the code developed before promoting code to QA
• Worked with the configuration team for getting the environment setup for QA testing and also supported the end to end QA testing and successfully fixed the defects raised by the QA analyst.
• Involved in Informatica Admin tasks like Objects Migrations through different environments, creating folders and users.
• Developed the ETL design and Restart document for Production support team to fix the production failures that may occur after the post production of the project.
• Majorly involved in improving Operational Process and procedures.
• Additional responsibilities included, Educating new developers and assisting in designing and automation using
• Autosys, organizing team meetings, review of Autosys job Docs, Monitoring Batch schedule

Environment: Informatica Power Center 8.6, Oracle 10g, SQL Developer, UNIX, Autosys, HP Quality Center, Windows XP.

Confidential

Informatica ETL Developer

Responsibilities:

• Involved in analysis of source systems, business requirements and identification of business rules.
• Extracted sources from flat-files, DB2 & oracle and load them into Oracle & Teradata.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Powercenter.
• Implemented Slowly Changing Dimensions (Type 1 &2).
• Created mappings using the transformations like Source qualifier, Aggregator, Expression, lookup,
• Router, Filter, Update Strategy, Joiner, and Stored procedure transformations.
• Worked on Informatica Power Center 8.5 tool - Source Analyzer, Data warehousing designer, Mapping
• Designer & Mapplets, Transformations, Work Flow Manager (Task Developer, Worklets, and Work Flow Designer) and Work Flow Monitor.
• Extensively used Informatica to load data from DB2, Flat Files and mainframes to Teradata/Oracle
• Created reusable transformations and Mapplets and used them in mappings.
• Involved in the process in documentation of source-to-target documentation design documentation of the Data Warehouse Dimensional Upgrades. Extensively used Informatica for loading the historical data from various tables for different departments.
• Created complex mappings and transformations.

Environment: Informatica Power Center 8.5, Oracle 10g, DB2, TOAD, SQL Developer, UNIX, Autosys, WINDOWS XP.

Confidential

ETL Developer

Responsibilities:

• Study the existing system and responsible for acquiring business requirements from the client
• Coordinating the team and delivering the products in time
• Responsible for Improving Data Model and for Designing of High Level and Low Level Design Documents
• Performed mapping to identify the customer profitability, customer lifetime value, and to understand customer segmentation, attrition analysis, and affinity analysis
• Created Parameter files to run the workflows and performed batch scheduling of tasks.
• Extensively worked in Oracle SQL, PL/SQL.
• Designed and developed Informatica mappings for data loading, manipulation etc
• Extensively worked on Informatica Mapping Designer and Informatica Workflow Manager
• Extracted data from sources like Oracle, Flat Files and Loaded the data into target Oracle database.
• Analyzing and Design the ETL mappings of all transactions.
• Developed complex mappings using a range of transformations on the extracted data according to the Transformation Business Rules and user requirements.
• Used session parameters whenever the same session was to be run using different values.

Environment: Informatica 8.1, Oracle, Flat files, MS SQL Server 2005, UNIX.