SUMMARY

• Have 8 years of IT experience - including six years of experience in ETL tools like InformaticaPowercenter Repository Manager, Powercenter Designer (Source Analyzer, Target Designer, Transformation Developer, Mapplet Designer, Mapping Designer), Workflow Manager (Task Developer, worklet designer, workflow designer) and workflow monitor.
• Have two years of experience in informaticapower exchange.
• Experienced with InformaticaPowerExchange(5.x/8.x) for Loading/Retrieving data from mainframe systems.
• Understanding & Working knowledge of InformaticaCDC (Change Data Capture).
• Experience in using the Informatica command line utilities like pmcmd, pmrep to schedule and control sessions and batches and repository tasks.
• Expert in designing and developing various transformations such as Aggregator, Filter, Router, Joiner, Java, Expression, Lookup, Source qualifier, Stored procedure, Sequence Generator, Transaction Control, Update strategy, Sorter transformations in mapping and mapplet designer.
• Experience in understanding High level design documents and creating Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Experienced in preparing Technical design document, Mapping documents, Detail design document for the Source / Target mapping.
• Experience in closely working with the business teams and gathering the requirements.
• Working experience on the various phases of SDLC like Analysis, Design, Development, Testing, UAT, Deployment and Production.
• Excellent hands on experience in preparing the documents like HLD, LLD, Technical Design and UTC Docs.
• Exclusive hands on experience in writing UNIX shell scripts and in using UNIX commands.
• Excellent hands on experience in writing the PL/SQL packages&stored procedures.
• Experienced with relational databases such as Oracle 10g, Oracle 9i, SQL Server 2005/2008, DB2 and working experience on TERADATA as back end for the ETL process.
• Good experience in Teradata using queries and utilities like BTEQ, MLOAD, FLOAD and TPUMP and fast export.
• Experience using SAS ETL tool, Talend ETL tool and SAS Enterprise Data Integration Server highly preferred.
• Expertise in Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDM solutions.
• Experience in installation and configuration of core Informatica MDM Hub components such as Hub Console, Hub Store, Hub Server, Cleanse Match Server and Cleanse Adapter in Windows.
• Expertise in design and configuration of landing tables, staging tables, base objects, hierarchies, foreign-key relationships, lookups, query groups, queries/custom queries and packages
• Knowledge on implementing hierarchies, relationships types, packages and profiles for hierarchy management in MDM Hub implementation.
• Experience in Mainframe (JCL, COBOL) - creation, review, analysis of scripts
• Dedicated and self-motivated achiever committed to success and adept Confidential juggling multiple tasks in a high-pressured environment.
• Has the ability to quickly understand & acquire the additional application skills that are required for project.
• An effective team member with excellent interpersonal and communication skills.
• Having working experience in Financial, Insurance, Healthcare, Supply Chain and Manufacturing projects.

TECHNICAL SKILLS

ETL Tools: Informatica Power center 9.x, 8.x, 7.x (Repository Manager, Powercenter Designer, Workflow Manager, Workflow Monitor), Informatica Power Exchange, B2B DT DX DTA6

DDL & DML: Oracle SQL, MS-SQL, Teradata SQL

Job Scheduler: Control-M, Crontab, Autosys, Informatica Workflow Scheduler

Data modeling tool: ERwin 7.2/7.1/4.5/4.0 , Visio 2003, Oracle Designer,Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, FACT, Dimensions), Entities, Attributes, Cardinality, ER Diagrams.

Platform: UNIX, Windows 2008/2003/XP, Sun Solaris, AIX 5.0/6.1, Red Hat Linux 7.3

Protocols: FTP, SFTP, HTTP, TCP/IP, HL7, HIPAA, EDI

RDBMS: MS SQL Server 2005/2008, Oracle 11g (SQL, PL/SQL, Stored Procedures, Functions) 10g/9i, MS-Access 2000/2003, Teradata, DB2 9.7, Netezza 6

Languages: C, C++, JAVA, HTML, DHTML, XML, PL/SQL, Visual Basic, UNIX Shell Scripting

Data Base Tools: SQL*Loader, TOAD, Teradata SQL Assist, SQL*Plus, Oracle SQL developer

Web Technology: J2EE, HTML, CSS, VB Script, Java Script, Wordpress

PROFESSIONAL EXPERIENCE

Confidential, Lewisville TX

Sr. Informatica Developer

Responsibilities:

• Analyzing the given business requirements, creating designs, developing mappings and workflows usingInformaticapower center designer and workflow manager tools, testing and maintaining the applications to support the business units.
• Schedule the Jobs usingAutosysJob scheduling tool.
• Participating in design and code reviews with other developers in the team.
• Collaborate with QA (Quality Assurance) team in creation of their test plans and participate in reviews.
• Implementedslowly changing andrapidly changing dimensionmethodologies.
• Createdaggregate fact tablesfor the creation of ad-hoc reports.
• Extensively UsedChange Data Capture (CDC)to simplify ETL in data warehouse applications.
• Extracted and loaded data using Power Exchange forNetezzatables.
• Created Power Exchange Registration for CDC on DB2 mainframe tables, created DataMap to extract data from file on mainframe.
• Worked in developing Mapplets and Re-usable Transformations for reusability and reducing effort.
• Implemented Type1 and Type 2 Incremental aggregation complex scenarios using Informatica 9.5.1
• Used various transformations like aggregator, Lookups, filters, routers etc. extensively with in Informatica Mappings.
• Extensively used Debugger functionality for testing the mapping behavior.
• Made extensive use of Parameter files, mapping variables/parameters and workflow variables wherever needed.
• Used target load plan functionality within the Informatica mapping that has multiple data flows.
• Tested all the business application rules with test & live data and automated, monitored the sessions using Work Flow Manager and Workflow Monitor
• Monitoring the Workflow performance and the status with Workflow Monitor.
• Extracted and loaded data into Teradata tables.
• Worked on OBIEE Answers to create the reports as per the client requirements and integrated them into the Dashboards.
• Worked on Performance Testing, Works within an Oracle environment performing PL/SQL code development, building high performing Oracle queries, and tuning existing queries.
• Used principles of Normalization to improve the performance. Involved inETLcode usingPL/SQLin order to meet requirements for Extract, transformation, cleansing and loading of data from source to targetdatastructures.
• Responsible for communication, resolution and escalation of critical technical issues and day to day prod issues.
• Communicate plans and status to management and other development team members.
• Prepare user and systems documentation as needed.

Environment: Oracle 11g, InformaticaPowercenter 9.5.1, Power Exchange (CDC),Informatica B2B DT,Teradata 14,OBIEE 11g, Netezza,Autosys (Job Scheduling tool), SQL, PLSQL, Perforce (version Control System), Version 1 (tool for tracking issues/stories in Agile development environment).

Confidential, Atlanta, GA

Sr. Informatica/ETL Developer

Responsibilities:

• Involved in developing Mappings &Transformations using Informatica (PowerCenter) Designer.
• Performed data cleansing and transformation using Informatica.
• Source System data from the distributed Environment was Extracted, Transformed and Loaded into the Data warehouse Database using Informatica (PowerCenter).
• Developed Mappings using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, update strategy, etc.
• Implemented SCD Type1 & SCD Type 2 and Scheduled workflows using 3rd party tool Autosys.
• DevelopedPL/SQL triggersandmaster tablesfor automatic creation of primary keys.
• Created PL/SQLstored procedures, functionsandpackagesfor moving the data from staging area to data mart.
• Developed Pre and Post SQL scripts, PL/SQL stored procedures and functions.
• Involved in data loading usingPL/SQLandSQL*Loadercalling UNIX scripts to download and manipulate files.
• Extracted Data from Flat Files and various Relational Databases to Oracle Data Warehouse Database.
• Conducted the Peer review for Mappings developed and Tested.
• Creating Test plans and developing Test Scripts: Unit Testing, UAT support, Document results, fixes assigned & UAT defects and provides status for tracking.

Environment: Informatica power center 9.1, PL/SQL, SQL* Loader, Oracle 11g, UNIX, Flat-files (.csv, .dat)

Confidential, Columbus, OH

ETL Developer

Responsibilities:

• Involved in Data Analysis to extract useful data, finding patterns and regularities from the sources and develop conclusions.
• Interacted with functional/end users to gather requirements of core reporting system to understand exceptional features users expecting with ETL and Reporting system and also to successfully implement business logic.
• Actively involved in Data Warehouse system design discussions.
• Extensively used various transformations like LookUp, Update Strategy, Joiner, Aggregator, Union and few other transformations.
• Extensively used Mapping Variables, Mapping Parameters, and Parameter Files for capturing Delta loads.
• Involved in creating Fact and Dimension table mappings to load Fact and Dimension tables.
• Developed Slowly Changing Dimension (SCD) Type1, Type2, and Type3 mappings.
• Worked with Reusable Mappings (Mapplets), Reusable Workflows (Worklets) and Reusable Transformations.
• Worked with Session Logs, Informatica Debugger, and Performance Logs for error handling the workflows and session failures.
• Identify the flow of information, analyzing the existing systems, evaluating alternatives and choosing the "most appropriate" alternative.
• Worked with tools like TOAD to write queries and generate the result.
• As per the requirement, performed Initial loading,monthly loading and monthly cleanup update processing.
• Developed restart token on UNIX server for Real-time Informatica workflows and customized real-time Power Exchange workflows.
• Used SQL Override in Source qualifier to customize SQL and filter data according to requirement.
• Wrote PRE and POST SQL commands in session properties to manage constraints that improved performance.
• Performed Pushdown Optimization to increase the read and write throughput
• Wrote SQL queries and PL/SQL procedures to perform database operations according to business requirements.
• Document all ETL related work per company's methodology.
• Used OBIEEDAC to Schedule the Informatica mappings in the correct order, dependencies between them based on the sources and targets.
• Involved in system end to end testing (Unit and System Integration Testing) as part of the SDLC process and performance tuning Confidential the mapping level, session level, source level, and the target level.
• Prepared estimates and tracked each and every task and strictly adhered to the estimated deadlines.

Environment: Informatica Power Center 8.6 (Repository Manager, Designer, Workflow Manager, and Workflow Monitor), Windows XP, Oracle 11g, DB2, PowerExchange 8.6, Teradata 13, TOAD, PL/SQL Developer, SQL Plus, OBIEE 10g, Sun Solaris.

Confidential, Dallas, TX

Informatica ETL Analyst

Responsibilities:

• Analyzed source systems, business requirements and applied business rules for building the data warehouse.
• Developed technical specifications of the ETL process flow.
• Designed and developed Informatica mappings, workflows to load data into Oracle ODS.
• Created data models for PeopleSoft & DB2 with appropriate Data Source inputs for source, staging and target data stores.
• Used Repository Manager to create groups, users and assign privileges.
• Extensively worked with Aggregator, Lookup, Filter, Router, Joiner, Expression, Sorter, Rank, XML Source Qualifier, Sequence Generator and Stored Procedure transformations to develop robust mappings in the Informatica Designer.
• Involved in designing and development of mappings for Project Costing(PC) Project VFRAME by applying complex mappings between several Tables and performing multiple Translations.
• Developed mappings for VSPB, PEGAS&CMSActuals interfaces using several features like Data definitions, Transformations, Mappings, Workflows, sessions etc.
• Created PL/SQL packages and stored procedures to load data from various sources to staging area.
• Performed Unit testing, Integration testing and system testing of Informaticamappings.
• Used Debugger in troubleshooting the existing mappings.
• Creation of required DB2 tables, views, procedures and extensively using DB2/SQL functions for mapping PeopleSoft source data definitions to target data definitions of external systems.
• Worked on different tasks in Workflow Manager like Sessions, Events raise, Event wait, Decision, E-mail, Command, Worklets, Assignment, Timer and Scheduling of the workflow.
• Created test cases, and test data for End-to-End testing.

Environment: Informatica Power Center 9.0.1, DB2 9.7, Oracle 11g, SQL, PL/SQL, PeopleSoft, Mainframes, MS Share Point, Terminal services, Cognos 8 BI Suite, Erwin, Windows XP

Confidential, Plano, TX

Informatica Developer

Responsibilities:

• Analyzed requirement specifications for implementing EDW.
• Used ETL methodology for complete processing of Data Extraction, transformations and loading steps, in a corporate-wide-ETL solution using Informatica.
• Extensively used Informatica Client tools - Source Analyzer, Target Designer, Mapplet Designer, Mapping Designer, Repository Manager and Workflow Manager.
• Used several transformations like Source Qualifier, Expression, Lookup, Aggregator, Joiner, Sequence Generator, Filter, Router, Java, SQL, Stored Procedure and Update Strategy transformations for complex mappings.
• Developed stored procedures and functions in PL/SQL using Oracle SQL Developer.
• Designed and developed various mappings using Active and Passive Transformations.
• Created complex Mappings which involved Slowly Changing Dimensions to capture the historical records in the source systems.
• Extracted data from various Source IT systems such as Oracle, SQL Server, Files (Products, Customers, Rates and Actuals etc.)
• Configured Sources, Targets, Transformations, Mappings and Connections to extract thousands of Fund records from Siebel into Oracle DB.
• Automation and scheduling of UNIX shell scripts and Informatica sessions and batches using Autosys.
• Wrote UNIX shell scripts to work with flat files, to create pre and post session commands and scheduling workflows.
• Used debugger, session and workflow log files and performance monitor to tune Informatica mappings to identify and remove processing bottlenecks.
• Wrote UNIX shell scripts to schedule workflows.
• Created dynamic PL/SQL procedures to load data from staging area to the data marts.
• User level testing Confidential each stage & also assisting in regression testing.

Environment: InformaticaPowerCenter 8.6, Oracle 9i, PL/SQL, Teradata, SQL Server 2008, Oracle SQL Developer, SAP R/3, Siebel, Autosys, UNIX, Cognos Tools.

Confidential

Informatica Developer

Responsibilities:

• Gathered business requirements from Business Analyst.
• Designed and implemented appropriate ETL mappings to extract and transform data from various sources to meet requirements.
• Designed and developed Informatica ETL mappings to extract master and transactional data from heterogeneous data feeds and load
• Installed and Configured the Informatica Client tools.
• Worked on loading of data from several flat files to XML Targets.
• Designed the procedures for getting the data from all systems to Data Warehousing system.
• Created the environment for Staging area, loading the Staging area with data from multiple sources.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Created UNIX shell scripts for Informatica ETL tool to automate sessions.
• Monitored sessions using the workflow monitor, which were scheduled, running, completed or failed. Debugged mappings for failed sessions.

Environment: Informatica Power Center 5.1.2/7.1, Erwin 4.5, Oracle 9i, Windows NT, Flat files, SQL, Relational Tools, Clear Case, UNIX (HP-UX, Sun Solaris, AIX) and UNIX Shell Scripts.