PROFESSIONAL SUMMARY:

• Around 8+ Years of IT Experience in Development and Implementation of Data Warehouses using ETL Tool Informatica Power Center 9.5.1/9.0/8. x/7.x/6.0, Oracle 11g/10g/9i, SQL, PL/SQL. worked wif Informatica Data Quality 8.6.1 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ 8.6.1.
• Experience in Requirement Analysis, Gap Analysis, Data Cleansing, Data Relationships, Source Systems Analysis and Reporting.
• Good noledge on Dimensional Modeling using Star schema and Snow Flake schema for faster, TEMPeffective query processing and Business Analysis Requirements.
• Extensively worked on theETL mappings, analysis and documentation ofOLAP reportsrequirements. Solid understanding of OLAP concepts and challenges, especially wif large data sets.
• Experience in development and design of ETL methodology for supporting data transformations and processing in corporate wide ETL Solutions using Informatica Power Center 9.x/8.x/7.x.
• Strong technical exposure wif good degree of competence in business systems like HealthCare, Insurance, Retail Sales and Banking.
• Performed all dimensions of development including Extraction, Transformation, and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Power Center (Designer, Repository Manager, Workflow Manager, and Workflow Monitor).
• Experience in performance tuning of sources, mappings, targets and sessions.
• Worked on Parameter file to initialize the mapping variables and workflow variables.
• Extensively worked wif Teradata utilities likeBTEQ, Fast Export, Fast Load, Multi Loadto export and load data to/from different source systems including flat files.
• Well versed wif complete SDLC me.e. System study, Requirement gathering, Analysis, Design, Development, Testing, Implementation and Application support.
• Experience wif multiple data sources and targets including Teradata, Oracle, DB2, SQL Server, and flat files.
• Proficient in performance analysis, monitoring and SQL query tuning usingEXPLAIN PLAN,Collect Statistics, Hints and SQL Trace both in Teradata as well as Oracle.
• Good Exposure on Web Services SOAP, REST Full architectures.
• Good noledge in interacting wif Informatica Data Explorer (IDE), and Informatica Data Quality (IDQ).
• Good noledge and Experience on web development frame works Ruby on Rails and their data models
• Extensive design and development of transformations; Normalizer, Lookup, Aggregator, Expression, Sequence Generator, Router, Filter, Joiner, and Union.
• Design and development of re - usable mappings, and mapping specifications.
• Expertise in configuration, performance tuning, installation of Informatica, and in integration of various data sources like Oracle, MS SQL Server, XML, Flat files into the staging area and Design ETL processes dat span multiple projects
• Proficient in using Workflow Manager Tools like Task Developer, Workflow, Designer and Worklet Designer.
• Excellent team player wif good organizational, communication, interpersonal & analytical skills. Possess strong ability to quickly adapt to new applications requirements, processes, platforms and languages.
• Quick learner wif the ability to work in a fast-paced environment.

TECHNICAL SKILLS:

ETL Tools: InformaticaPower Center 9.5/9.0/8.6.1/7.1 (Designer, Manager, Workflow Manager), Power Exchange, Informatica Data Quality 9.1 (IDQ).

Database: Oracle 11g/10g/9i, Teradata, DB2, SQL Server 2000, MS Access, MySQL

Operating Systems: Unix, Windows 2000/NT 4.0 Server

BI & Reporting Tools: Business Objects 6.5/5.x (Designer, Supervisor)

GUI: Forms 4.5/5.0, Reports 2.5/3.0, Visual basic 5.0/6.0, Developer 2000

Web Technologies: C,SQL,PL/SQL, PHP, HTML

Testing Tools: Win Runner, Load Runner, QTP 8.2

Web/App servers: Internet Information Server, JWS, Apache Web server, Web Logic

Additional Tools: Erwin, Toad, SQL Navigator, ControlM, Autosys, Forms 4.5/5.0, Reports 2.5/3.0, Visual basic 5.0/6.0, Developer 2000

PROFESSIONAL EXPERIENCE:

Confidential, Richardson, TX

Sr.ETL Informatica Developer

Responsibilities:

• Analyzed the specifications and identified the source data dat needs to be moved to data warehouse.
• Gathering requirements, conducting a design overview, detailing ETL specifications, data analysis/troubleshooting, implementation tasks, and general mentoring.
• Actively involved in meetings wif the SME’s forbusiness requirements gathering and analysis of source systems data to comprehend their processing patterns.
• Developed the ETL logic to load data from various heterogeneous systems such as DB2, Flat files, Oracle 9i.
• Extracted, cleansed and transformed the data.
• Created complex and robust mappings, workflows using workflow manager. Monitored tasks using workflow monitor.
• Used various transformations like Source Qualifier, Unconnected lookup, connected lookup, Expression, Joiner, Filter, Router, Update Strategy, and Procedure etc.
• Enhanced session and workflows performance by applying performance tuning on targets, sources, mappings and sessions.
• Worked on Informatica Power Center tool -Source Analyzer, Data warehousing designer, Mapping Designer & Maplets, Transformations, Work Flow Manager and Work Flow Monitor.
• Informatica Data Quality (IDQ 8.6.1) is the tool used here for data quality measurement.
• Developed Workflows containing different Tasks like Sessions, commands, Decisions, Timer, Control, Email.
• Designed, developed, implemented and maintained Informatica Power Center and IDQ 8.6.1 application for matching and merging process.
• Coordinated wif the operations team for scheduling the Work Flows.
• Worked extensively wif designer tool to develop Mappings, Mapplets, and Reusable transformations to extract, transform and load the data.
• Through explain plan, analyzed and modified indexes and modified queries wif derived or temporary tables to improve the performance. Also utilized Teradata viewpoint.
• Involved in the performance tuning of Informatica mappings/sessions for large data files by increasing block size, data cache size, and commit interval.
• Created and used parameter files to provide values to the variables used across sessions and workflows of Informatica.
• Involved in process of enhancing the existing Informatica and PL/SQL code and bug fixing.
• Created and executed Unit Test Plans for the various Mappings.
• Created new Linux Scripts and modified the existing scripts for enhancing the performance (optimizing)of the ETL jobs, Database updates, Automate the process, File handling.
• Coordinated wif the QA team and production team during migration phase.
• Designed the framework Model, Report Structure for various subject areas based on their process and data analysis.

Environment: Informatica Power Center 9.5.1, Data Profiling, Teradata, Oracle 11g/9i/10G, PL/SQL, SQL Server 2000/2005, XML, MS Office tools, Clear Case, Linux, Windows.

Confidential, Charlotte, NC

Sr.ETL Developer

Responsibilities:

• Responsible for Business Analysis and Requirements Collection.
• Setup and maintenance of database on Oracle.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development. Attended Business meetings and did Business Analysis and gathered the requirements. Responsible for the Dimensional Data Modeling and populating the business rules using mappings into the Repository for Meta Data management.
• Utilized of Informatica IDQ 8.6.1 to complete initial data profiling and matching/removing duplicate data.
• Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level and the Target Level for Slowly Changing Dimensions Type1, Type2, and Type3 for Data Loads
• Converted data stored in Oracle, XML, Flat files, Oracle Financials, SQL server using Informatica.
• Informatica Data Explorer (IDE) and Informatica Data Quality (IDQ 8.6.1) are the tools are used here. IDE is used for data profiling over metadata and IDQ 8.6.1 for data quality measurement.
• Converted the data mart from Logical design to Physical design, defined data types, Constraints, Indexes, generated Schema in the Database, created Automated scripts, defined storage parameters for the objects in the Database.
• Interact wif functional analysts to understand requirements and write high level design documents.
• Defined various facts and Dimensions in the data mart including Fact less Facts, Aggregate and Summary facts.
• Designed Sources to Targets mapping from primarily Flat files to Oracle using Informatica Power Centre.
• Data Quality Analysis to determine cleansing requirements.
• Worked extensively wif Oracle stored procedures to truncate, move and update data
• Developed ETL methodology to custom fit the ETL needs of Claims Data Mart.
• Developed ETL procedures to ensure conformity, compliance wif standards and lack of redundancy, translated business rules and functionality requirements into ETL procedures.
• Coordinating wif source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance.
• Extracted data from netezza into files using Informatica for outbound interfaces.
• Various kinds of the transformations were used to implement simple and complex business logic. Transformations used are: Aggregator, Joiner, Union, Custom, Router, Expression, Update Strategy, Filter, Sorter transformations, stored Procedure, connected & unconnected lookups, Expressions, source qualifier, sequence Generator, etc.
• Did profiling and Data Quality Analysis of the data to find out anomalies in the data and highlighting the TEMPeffectiveness of the tool (IDQ) to do dat.
• Used IDQ (Informatica Data Quality 9), Address Doctor and Identity Matching to validate the data.
• Created and Configured Workflows, Work lets, and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
• Check and Tune the performance of application for optimum system performance.
• Worked wif QA Team to resolve QA issues.

Environment: Informatica Power Center 9.2, IDQ8.6.1, PL/SQL, SQL Server 2000/2005, XML, Erwin, MS Office tools, Clear Case, UNIX, Windows, Control-M Scheduler, Data Quality 9.

Confidential, Camden, NJ

Sr.Informatica Developer

Responsibilities:

• Logical and Physical data modeling was done using Erwin for data warehouse database in STAR SCHEMA
• Using Informatica PowerCenter Designer analyzed the source data to Extract & Transform from various source systems (oracle 10g, DB2, SQL server and flat files) by incorporating business rules using different objects and functions dat the tool supports.
• Using Informatica PowerCenter created mappings and mapplets to transform the data according to the business rules.
• Used various transformations like Source Qualifier, Joiner, Lookup, Sql, and router, Filter, Expression and Update Strategy.
• Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement.
• Developed Stored Procedures and used them in Stored Procedure transformation for data processing and has used data migration tools
• Documented Informatica mappings in Excel spread sheet.
• Tuned the Informatica mappings for optimal load performance.
• Has used BTEQ, FEXP, FLOAD, MLOAD Teradata utilities to export and load data to/from Flat files. Used BTEQ andSQL Assistant(Query man) front-end tools to issue SQL commands matching the business requirements to Teradata RDBMS.
• Analyzed, identified, fixed bad data and Imported data fromSalesForce - CRM to Oracle. Upstream data integration and migration processes in predefined schemas.
• Created and Configured Workflows and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager. Informatica Web-services and web-portal applications.
• dis role carries primary responsibility for problem determination and resolution for each SAP application system database server and application server.
• Worked along wif UNIX team for writing UNIX shell scripts to customize the server scheduling jobs.
• Constantly interacted wif business users to discuss requirements.

Environment: Informatica Power Center Designer 8.6.1, Informatica Repository Manager, Oracle10g/9i, and DB2 6.1, Teradata, Erwin, TOAD, SAP Version: 3.1.H, Unix- SunOS, PL/SQL, SQL Developer

Confidential, Des Moines, IA

Informatica Developer

Responsibilities:

• Involved in interacting wif Business Analyst in analyzing the requirements
• Involved in documenting the Technical and Functional Documents like High Level Design, Low Level Design and System Specification Document.
• Developed ETL mappings, Transformations and Loading using Informatica Power Center 8.6.2/9.1
• Extensively Performed the data validations and profiling using IDQ
• Extensively worked on Informatica Designer components Source Analyzer, Target Designer, Transformation Developer, Mapping Designer and Mapplet Designer.
• Developed various mappings to load data from various sources using different Transformations including Router, Aggregator, Joiner, Lookup, Update Strategy, Stored Procedure, Sorter, Filter, Source Qualifier, Expression, Union and Sequence Generator to store the data in target tables.
• Developed mapping based on the mapping specification document dat indicates the source tables, columns, data types, transformation required, business rules, target tables, target columns and data types.
• Involved in Unit Testing, Integration Testing and End-End Testing
• Captured the Unit Test Results and documented the test results.
• Used workflow manager to create workflows, sessions, and also used various tasks like command, email.
• Created Workflows, Worklets and Tasks to schedule the loads at required frequency using Workflow Manager.
• Modified existing Unix Shell Scripts as per the requirements.
• Utilized SQL-Loader to import data.
• Designed and implemented Oracle 10g database object to support interface (Table, views, materialized views).
• Writing PL/SQL packages, stored procedures and functions using new PL/SQL features like Collections, Objects, Object Tables, Nested Tables, External Tables, REF Cursors, MERGE, INTERSECT, MINUS, BULK INTO and Dynamic SQL commands.
• Defined Target Load Order Plan for loading data into different Target Tables.
• Used debugger extensively to identify the bottlenecks in the mappings.
• Extensively worked wif various Lookup caches like Static cache, Dynamic cache and Persistent cache.
• Worked on performance tuning and optimization of the Sessions, Mappings, Sources and Targets.
• Used Informatica Power Center 9.1 for mapping and workflow design including the use of mapplets, reusable transformations and worklets.
• Migrated Objects, mappings, workflows from Dev environment to QA environment.
• Created Informatica supported source definition for IMS log files using cobalt copy book in Informatica Power Exchange tool.
• Replicated operational tables into staging tables, to transform and load data into one single database using Informatica.

Environment: Informatica PowerCenter 8.6/7.2 (Repository Manager, PowerCenter Designer, Workflow Manager, Workflow Monitor), Informatica, Oracle 10g, Unix, Window 7/XP, JIRA, AUTOSYS, SQL Developer 3.0, Flat Files, SQL, PL/SQL, Informatica Power Exchanger, IMS log files, Microsoft tools, Putty, Winscp.

Confidential

Application Developer and Tester

Responsibilities:

• Responsible for studying user requirements, preparing documents and developing specifications.
• Worked extensively wif mappings using expressions, aggregators, filters, normalizer, lookup, update strategy and stored procedures transformations.
• Extensively involved in Monitoring, debugging, performance tuning and handling of exception issues resolution of the ETL processes for ODS
• Analyzing and preparing high, low level ETL design documents
• Wrote PL/SQL to preprocess data.
• Creating Users, Roles, Profiles and Granting and revoking the privileges to the Users.
• Developed and modified UNIX shell scripts to reset and run Informatica workflows using pmcmd on Unix Environment.
• Implemented Slowly Changing dimension methodology for accessing the full history of accounts and transaction information
• Error checking and Unit testing of the ETL procedures using Informatica session log and various tracing options
• Developed SQL, PL/SQL programs to keep the Master and lookup tables up to date on a daily basis.
• Performed integrated testing for various mappings. Tested the data and data integrity among various sources and targets.
• Supported and resolved various production issues and minimize the down time.

Environment: Informatica 7.1, MS SQL Server 2000, UNIX, MS Office, Windows XP.