SUMMARY

• Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications.
• Expertise in Informatica Power Center 9.x/8.x/7.x/6.x extracting data from Oracle, SQL Server and DB2 databases.
• Plans data integration process by developing common definitions of sourced data; designing common keys in physical data structure; establishing data integration specifications; examining data applications
• Delivers data integration by implementing shared databases; integrating data shared across legacy, new development, and purchased package environments; developing system modification specifications; mapping data; establishing interfaces; developing and modifying functions, programs, routines, and stored procedures to export, transform, and load data; meeting performance parameters; resolving and escalating integration issues
• Involved in migration of Informatica from 8.x to 9.x.
• Strong Data Warehousing ETL experience of using Informatica 9.1/8.6.1/8.5/8.1/7.1 PowerCenter, Power Exchange, Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager.
• Experience in InformaticaBigDataDeveloperEdition and Autosys..
• Through knowledge of Relational & Dimensional models (Star & Snow Flake), Facts and Dimension tables, Slowly Changing Dimensions (SCD)
• Extensively worked on Teradata queries and Utilities BTEQ, MLOAD, FLOAD, FEXPORT, TPUMP.
• Hands on experience in implementing Slowly Changing dimension types (I, II &III) methodologies
• Experienced in the use of agile approaches, including Extreme Programming, Test-Driven Development and Scrum.
• Experience in Performance tuning in Vertica which includes creation of projection, partition, LAP, and segmentation
• Working experience on IDQ (Informatica Data Quality) which involves developing plans for Analysis, Standardization, Matching and Consolidation of data by using different components
• Effectively develops complex Vertica SQL coding (use of temp/volatile tables, complex joins, etc.)
• Provided technical support to end users regarding SAS applications, tools & server related issues
• Experience in integration of various data sources like SQL Server, Oracle, Teradata, Flat files, DB2 Mainframes into the staging area
• Business Requirements review, assessment, gap identification, defining business process, deliver project roadmap including documentation, initial source data definition, mapping, detailed ETL development specifications and operations documentation
• Expert in Installation and configuration of Informatica server with Sql server, Oracle and able to handle the Informatica administrator tasks like Configuring DSN, creating Connection Strings, copying & moving mappings, workflows, creating folders etc,.
• Strong experience in complex PL/SQLpackages, functions, cursors, triggers, views, materialized views, Confidential -SQL, DTS.
• Expert in troubleshooting/debugging and improving performance Confidential different stages like database,workflows,mapping. Experience in writing UNIX shell scripts and Perl scripts
• Hands on experience in application development using RDBMS, and Linux shell scripting.
• Experience in importing and exporting data using Sqoop from HDFS to Relational Database Systems and vice-versa.Have Got Proven experience leading Team.
• Enthusiastic and goal-oriented team player possessing excellent communication, interpersonal skills and leadership capabilities with high level of adaptability.

TECHNICAL SKILLS

Data warehousing: Informatica PowerCenter 9.6./9.5/9.1/8.6/8.5/8.1 , Informatica PowerExchange 9/6/9.5/9.1,8.6, Metadata Reporter Data Profiling, Data cleansing, OLAP, OLTP, Star & Snowflake Schema, FACT & Dimension Tables, Physical & Logical Data Modeling, Data Stage 7.x, Erwin 4.0, ER Studio, Dial, BTEQ, MLOAD, FLOAD,TPUMP.

BI Tools: Business Objects XI R2

Databases: Oracle 11g/10g/9i, SQL, MS-Access, DB2 8.0/7.0,Teradata14/13/12, Vertica, Hadoop,Greenplum

Languages: XML, SQL, Confidential -SQL, PL/SQL, UNIX, C,C++

Operating System: Sun Solaris 9/8/7/2.6/2.5, SCO-UNIX, LINUX, Windows XP Professional/2000

Other Tools: MS Visual Source Safe, PVCS, Autosys, Control M, Remedy

DB Programming & Tools: RDBMS, Joins, Indexes, Views, Functions, Triggers, Clusters, Procedures, SQL*Plus, SQL*Loader, Export/Import, TOAD, SQL Navigator, Explain plan, SQL Trace

PROFESSIONAL EXPERIENCE

Confidential

Sr. Informatica Developer

Responsibilities:

• Responsible for Business Analysis and Requirements Collection.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Created mapping documents to outline data flow from sources to targets.
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Developed mapping parameters and variables to support SQL override.
• Created mapplets to use them in different mappings.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Used existing ETL standards to develop these mappings.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Extensively used SQL* loader to load data from flat files to the database tables in Oracle.
• Modified existing mappings for enhancements of new business requirements.
• Used Debugger to test the mappings and fixed the bugs.
• Wrote UNIX shell Scripts & PMCMD commands for FTP of files from remote server and backup of repository and folder.
• Involved in Performance tuning Confidential source, target, mappings, sessions, and system levels.
• Prepared migration document to move the mappings from development to testing and then to production repositories.

Confidential

Sr. Informatica Developer

Responsibilities:

• Created mapping between the databases and identified the possibilities of incorporating the new business rules with the existing design.
• Improves data integration by designing and evaluating new data interchange formats; improving physical design; rewriting data policy, standards, and procedures development and implementation of ETL applications using Informatica 9.x/8.x/7.x/6.x/5.x
• Created prototype reporting models, specifications, diagrams and charts to provide direction to system programmers.
• Used Powershell Scripting and Pipeline to do routine SQL tasks.
• Participated in Design team brainstorm and user requirement gathering meetings.
• Played the lead role in Designing and implementing Pricing Analytics, Best Customer and Finance Master Data Alignment Services Data marts.
• Involved in managing the delivery of data extracts from the data sources to the warehouse and downstream applications.
• Used Informatica Data Quality for data profiling, data cleansing, generate reports
• Design and implementation of Informatica (IDQ v9.1), Data Quality applications for the business and technology users across the entire full development life-cycle.
• Supported the BI team by extracting operational data from multiple sources, merging and transforming the data to facilitate enterprise-wide reporting and analysis and delivering the transformed data to coordinated data marts
• Worked with Teradata loading utilities like Multi Load, Fast Load, TPump and BTEQ.
• Involved in Architecture and design of Data extraction, transformation, cleaning and loading.
• Involved in Requirement gathering and source data analysis for the Data warehousing projects.
• Involved in the Logical and Physical design and creation of the ODS and data marts.
• Converted the Business rules into Technical Specifications for ETL process.
• Involved in all phases of SDLC from requirement, design, development, testing, pilot, training and rollout to the field users and support for production environment.
• Implemented mapping techniques for Type 1, Type 2 and Type 3 slowly changing dimensions.
• Developed ETLs for Data Extraction, Data Mapping and Data Conversion using Informatica Power Center.
• Involved in the Development of Informatica mappings and mapplets and also tuned them for Optimum performance, Dependencies and Batch Design.
• Worked on Informatica Power center 9.1/9.6 Tool - Source Analyzer, warehouse designer, Mapping Designer, Workflow Manager, Mapplets, Worklets and Reusable Transformation.
• Wrote scripts for collection of statistics, reorganization of tables and indexes, and creation of indexes for enhancing performance for data access.
• Involved in Testing and Test Plan Preparation, Process Improvement for the ETL developments.
• Involved in Data Quality Assurance, created validation routines, unit test cases and test plan.
• The design document was finalized through conduct of design walkthroughs, and independent review by the user. Prepared Technical Specifications for all the utilities, as per the company's standards.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the Informatica mappings.
• Involved in Design and development ofHadoop system to analyze the SIEM (Security Information and Event Management) data using MapReduce, VSQL, and Sqoop
• Experience in integration of various data sources like SQL Server, Oracle, Teradata, Flat files, DB2 Mainframes into the staging area.

Environment: InformaticaPowerCenter 9.6./9.5, InformaticaPowerExchange 9.6/9.5, SQL server 2008, Oracle 11g, Oracle Exadata, Hadoop, Hive, Teradata 14,UNIX

Confidential, New York

Sr. Informatica Developer

Responsibilities:

• Worked with the business and data analysts in requirements gathering and to translate business requirements into technical specifications.
• Validates data integration by developing and executing test plans and scenarios including data design, tool design, data extract/transform, networks, and hardware
• Understand and discuss the ETL requirements with the Business Unit and preparing the detail design documentation according to the standards.
• Prepared ETL Design-Document and Implementation Plan documents.
• Informatica Data Quality 9.1 is the tool used here for data quality measurement.
• Build a re-usable staging area in Oracle for loading data from multiple source systems using template tables for profiling and cleansing in IDQ or QualityStage.
• All the jobs are integrated using complex Mappings including Mapplets and Workflows using Informatica power center designer and workflow manager. Ver. 9.1
• Used the transformations like Expression, Lookup, Source Qualifier, Transaction Control, XML Generator, Web Service, XML Parser, Joiner, etc.
• Done extensive bulk loading and normalize into the target using GreenplumLoader.
• Worked on GreenPlum clusters from the point data land in staging to the point the data is ready to move to non-pii which is the primary destination cluster where all normalized and validated data is delivered for use in analytics and customer-facing deliverables.
• Extracted the high volume dataset from the XML, Netezza Relational Tables and xml targets.
• Used Workflow manager for session management, database connection management and scheduling of jobs to be run in the batch process.
• Use debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations and Create Mapplets that provides reusability in mappings.
• Involved in Performance tuning Confidential source, target, mappings, sessions, and system levels.
• Performance tuning has been done to increase the through put for both mapping and session level and SQL Queries Optimization as well.
• Monitor and troubleshoot batches and sessions for weekly and Monthly extracts from various data sources across all platforms to the target database.
• Data Validation has been done for various sources to target mappings.
• Migrated ETL objects from DEV to UAT to PRD environments using Repository Manager.
• Provided support and quality validation thru test cases for all stages Unit and Integration testing.
• Involved in Unit Testing and created various test cases and reviewed and fixed issues in the ETL code.
• Supported UAT and resolved issues. Also, worked on CR’s (change request) by the business.

Environment: InformaticaPowerCenter 9.1,InformaticaPowerExchanges 9.1, Oracle 11g, DB2, SQL, PL/SQL, Teradata 13,Greenplum, Netezza 4, Remedy,UNIX, LINUX.

Confidential, Franklin, TN

Informatica Developer

Responsibilities:

• Worked with the business and data analysts in requirements gathering and to translate business requirements into technical specifications.
• Understand and discuss the ETL requirements with the Business Unit and preparing the detail design documentation according to the standards.
• Created number of complex Mappings, Mapplets, Reusable Transformations, Workflows, Worklets, Sessions using Informatica Power center 9/8.6.1 to implement the business logic and to load the data incrementally
• Utilized ofInformaticaIDQ 9.1to complete initialdataprofiling and matching/removing duplicate data.
• Implementing Informatica Data Quality as a service in a SOA
• Moving the data fromAttunityto Power Exchange.
• Used the transformations like Expression, Lookup, Source Qualifier, Normalizer, Aggregator, Filter, Router, Sorter, etc.
• Extracted the data from the Flat files, Excel sheets, Oracle databases into staging area and populated onto Data warehouse.
• Used Workflow manager for session management, database connection management and scheduling of jobs to be run in the batch process. UsedDebugger to test the mappings and fixed the bugs.
• Load Monthly and Daily loads, track issues and resolve them based on the priority.
• Involved in Performance tuning Confidential source, target, mappings, sessions, and system levels.
• Monitor and troubleshoot batches and sessions for weekly and Monthly extracts from various data sources across all platforms to the target database.
• Migrated ETL objects from DEV to UAT to PRD environments using Repository Manager.
• Worked on the UNIX scripts for running the workflows and threshold check for the incoming files.
• Prepared ETL Design-Document and Implementation Plan documents.
• Involved in Unit Testing and created various test cases and reviewed and fixed issues in the ETL code.
• Supported UAT and resolved issues. Also, worked on CR’s (change request) by the business.
• Prepared Support Turnover documents in Production Support, for some interfaces.

Environment: InformaticaPowerCenter 8.6.1, InformaticaPowerExchange 8.6, Oracle 10g, DB2,SQL, PL/SQL, Sun Solaris, Teradata 12, UNIX Shell Scripts, Linux, Erwin, Autosys, Remedy.

Confidential, Des Moines, IA

ETL Developer/DatabaseAnalyst

Responsibilities:

• Interacted with business community and gathered requirements based on changing needs. Incorporated identified factors into Informatica mappings to build the DataMart.
• Developed a standard ETL framework to enable the reusability of similar logic across the board. Involved in System Documentation of Dataflow and methodology.
• Taken the whole responsibility and handled the project with 2 team members.
• Assisted in designing Logical/Physical Data Models, forward/reverse engineering using Erwin 4.0.
• Developed mappings to extract data from SQL Server, Oracle, Flat files and load into DataMart using the PowerCenter.
• Informatica Data Explorer (IDE) and Informatica Data Quality (IDQ 8.6.1& 9.1) are the tools are used here. IDE is used for data profiling over metadata and IDQ 9.1 for data quality measurement.
• Developed common routine mappings. Made use of mapping variables, mapping parameters and variable functions.
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to DataMart.
• Handled Informatica administrative tasks like moving, copying sessions, workflows from DEV to QA.
• Written shell scripts in UNIX to execute the workflow from GUI.
• Written shell scripts to run the workflows and automated them through maestro job scheduler.
• Written SQL Queries, Triggers, PL/SQL Procedures to apply and maintain the Business Rules.
• Troubleshooting database, workflows, mappings, source, target to find out the bottlenecks and improved the performance.
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, Workflows and data base tuning.
• Written Indexes, primary keys and checked other performance tuning Confidential data base level.
• Conducted Database testing to check Constrains, field size, Indexes, Stored Procedures, etc.
• Created testing metrics using MS-Excel
• Worked closely with the business analyst’s team in order to solve the Problem Tickets, Service Requests. Helped the 24/7 Production Support team.

Environment: InformaticaPowerCenter 8.6, SQL Server 2005/2000, Oracle 10g, SQL, PL/SQL,IBM AIX, UNIX Shell Scripts, Linux, Erwin, STAR team, Remedy, Maestro job scheduler

Confidential, Fremont,CA

ETL Developer

Responsibilities:

• Project Life Cycle - from analysis to production implementation, with emphasis on identifying the source and source data validation, developing particular logic and transformation as per the requirement and creating mappings and loading the data into different targets.
• Involved in detail design and development of mappings using Informatica power center.
• Used to extract data from ODS and load it into EDW using Informatica.
• Performed Repository object migration from Development to testing and testing to production Environments.
• Developing several complex mappings in Informatica a variety of PowerCenter transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer using both the Informatica PowerCenter and IDQ.
• Worked with pre and post sessions, and extracted data from Transaction System into Staging Area.
• Performed Unit Tests and tested Mapping logic by passing sample messages.
• Responsible for Self and Peer Review of Informatica mappings under Development Phase.
• Schedule and Run Extraction and Load process and monitor sessions using Informatica Workflow Manager.
• Scheduled the tasks to be run using the Workflow Manager.
• Created Informatica users, maintained folders and given user privileges based on role.
• Implemented various Transformations like Joiner, Aggregate, Expression, Lookup, Filter, Update Strategy, Stored Procedures, and Router etc.
• Extracted data from Flat files and Oracle tables.
• Created and Monitored Sessions and various other Tasks such as Event-Raise Task, Event-Wait Task, Decision Task, Command Task etc. using Informatica Workflow.
• Worked on the UNIX scripts for running the workflows and threshold check for the incoming files.
• Moved the mappings from Development, Testing and to Production.

Environment: InformaticaPowerCenter 8.5, Oracle 9i, PL/SQL, SQL Server 2000,Flat files, Sql loader, UNIX Shell Scripts, Erwin.

Confidential

ETL Developer

Responsibilities:

• Developed ETL mappings, Transformations and Loading using Informatica Power Center 8.1.1.
• Developed mappings and workflows as per business logic, quality and coding standardsprescribed for the module using Informatica Power Center 8.1.1.
• Conducted performance tuning to increase performance of the mappings, sessions & workflows.
• Used PL/SQL with Informatica Power Center 8.1.1 for Oracle10g database.
• Developed mapping document indicating the source tables, columns, data types, transformation required, bulk loading routines, business rules, target tables, columns and data types.
• Performed project management duties including analysis, design, and implementation of Extraction, Transformation and Loading methodologies.
• Resolved issues and bugs raised by QA team.
• Developed, implemented and enforced ETL best practices standards.
• Performance tuning and bottleneck resolution.
• Created and Implemented Reusable tasks like E-mail.
• Involved in Data modeling team for developing Star Schema.
• Developed application using UNIX operating system including scripting.

Environment: s: Informatica Power Center 8.1, Mainframes, Oracle 10g, SQLServer 2005, Unix, Toad 9.5, SQL*Plus, Windows XP.