SUMMARY

• Over 8 years of experience in Information Technology with a strong background in Database development and Data warehousing and ETL process using Informatica Power Center 9.x/8.x/ 7.1.3/7.1.1/6.2. Repository Manager, Repository Server, Workflow Manager & Workflow Monitor..
• Proficiency in developing SQL with various relational databases like Oracle, SQL Server.
• Knowledge in Full Life Cycle development of Data Warehousing.
• Strong understanding of OLAP and OLTP Concepts.
• Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.
• Created UNIX shell scripts to run the Informatica workflows and controlling the ETL flow.
• Proficient in Oracle Tools and Utilities such as TOAD and SQL*Loader.
• Extensive knowledge working with Metadata.
• Experience with AGILE Methodologies.
• Experienced in the use of agile approaches, including Extreme Programming, Test - Driven Development and Scrum.
• Expertise to follow Agile process in application development.
• Experience in various stages of System Development Life Cycle(SDLC) and its approaches likeAgile,and Prototyping Model
• Experience in SQL performance tuning.
• Experience in maintaining Data Concurrency, Replication of data.
• Good knowledge on BI tools like SQLBI and OBI.
• Thorough Knowledge in creating DDL, DML and Transaction queries in SQL for Oracle database.
• Performed SAP Data Migration by using Business Objects Data Services as the ETL tool.
• Design, Architect BizTalk EDI Interfaces and HIPAA EDI Frame-work components
• Implemented Encryption and Secure Transfer of 834 EDI Enrollment Transactions using BizTalk Adapter
• Manage JAD sessions with developers and business users
• Experience in using SQL developer, SQL*Plus, Procedures/Functions and Performance tuning..
• Responsible for the Data Cleansing of Source Data using LTRIM and RTRIM operations of the Expression Transformation.
• Expertise in RDBMS concepts, with hands on exposure in the development of relational database environment using SQL, PL/SQL, Cursors, Stored Procedures, Functions and Triggers.
• Experience in working with Perl Scripts for handling data coming in Flat files.
• Experience working with UNIX Shell Scripts for automatically running sessions, aborting sessions and creating parameter files.
• Strong with relational database design concepts.
• Expertise in design and development of the three layers(Physical/Business Model and Mapping/ Presentation)ofan OBIEE Metadata Repository(.rpd) using Oracle
• Extracted data from various heterogeneous sources like OracleandSAP.
• Experienced in configuring and set up ofOBIEE Security using LDAP and External Database Tablesand configuring object level and database level security.
• Expertise in Building Executive Dashboards using Dashboard Manager for Siebel Analytics Web / Oracle Presentation Services for Siebel Analytics / OBIEE.
• Expertise in Business Intelligence Applications using Siebel Analytics / Oracle Business Intelligence (OBIEE/OBIA) in Marketing, Sales, Procurement modules.
• Performed data validation by Unit testing, integration testing and System Testing.
• Extensive experience in managing teams/On Shore-Off Shore Coordination/Requirement Analysis/Code reviews/Implementing Standards.
• Experience with managing ODBC connections.
• Knowledge ofIDQ9.6..1 standards, guidelines and best practices
• Worked withInformaticaData Quality 9.6.1 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion,exception handling, and reporting and monitoring capabilities of IDQ 8.6.1.
• Good experience with Informatica Performance Tuning.
• Good knowledge of Data modeling techniques like Dimensional/ Star Schema, Snowflake modeling, slowly changing Dimensions using Erwin.
• Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.
• Able to work independently and collaborate proactively & cross functionally within a team.
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.6/9.5/9.1, 8.6.1/8.5/8.1.1 , Power Exchange 9.6/9.5/9.1/8.6 , Informatica IDQ.

Databases: Oracle 12g/11g/10g, MS SQL Server 2008/2012, MS Access, DB2, Teradata 14/13/12/V2R6, V2R5, Sybase, Greenplum

Operating Systems: UNIX, Linux, Windows 2003/2000/NT, Windows 7/8, AIX, Sun Solaris

Languages: C, C++, SQL, PL/SQL, HTML, PHP, JAVA, UNIX Scripting

Reporting Tools: Business Objects XIR2, SAP BI 7.0, OBIEE 12g/11g

Other tools: Toad, Harvest, SCM, Putty, Tidal, Autosys, ESP, Informatica MDM Hub Console, Informatica Hierarchy Manager (HM).

PROFESSIONAL EXPERIENCE

Confidential, CA

ETL/Informatica Developer/Support Engineer

Environment: Informatica Power Center 9.6.1, Oracle 11g, Linux, Autosys, Toad, Greenplum, Wherescape Red, Powerexchange.

Responsibilities:

• Involved in client meetings on daily basis for understanding and analyzing the business requirements.
• Coordinating with client and offshore to complete work on time.
• Preparing the technical documents (like design documents, HLD’s, LLD’s) from business requirement documents.
• Prepare test strategies and execution plan. Monitoring progress of work.
• Extensively developed informatica mappings, mapplets and workflows.
• Used informatica Workflow manager to develop, schedule sessions and send pre and post session emails to communicate success or failure of session execution.
• Extensively used Greenplum SQL
• Maintenance existing GL application.

Confidential, CA

ETL/Informatica Developer

Environment: Informatica Power Center 9.6.1, Oracle 11g, Linux, Autosys, Toad, Greenplum

Responsibilities:

• Extensively used Informatica Client tools - Power Center Designer, Workflow Manager, Workflow Monitor and Repository Manager
• Developed complex mapping using Informatica Power Center tool and configured Informatica with DAC.
• Extracting data from Oracle and Flat file, Excel files and performed complex joiner, Expression, Aggregate, Lookup, Stored procedure, Filter, Router transformations and Update strategy transformations to load data into the target systems.
• Used concept of staged mapping in order to perform asynchronous Web Services request and response as part of Informatica Mappings.
• Working with various sources such as Flat files, Relational, XML and Web services as part of Informatica Mappings.
• Extracted the data from various data source systems into the Landing Zone area by creating the Informatica mappings using the Teradata fast Loader Connections.
• Designed Mappings using B2B Data Transformation Studio.
• Extensively used Informatica Client tools - Power Center Designer Cloud, Work flow Manager, Work flow Monitor and Repository Manager
• Developed complex mapping using Informatica Power Center Cloud.
• Created Sessions, Tasks, Workflows and worklets using Workflow manager.
• Worked with Data modeler in developing STAR Schemas
• Involved in performance tuning and query optimization.
• Experience in converting SAS scripts to Informatica.
• Worked on utilities like FLOAD, MLOAD, FEXP of Teradata and created batch jobs using BTEQ.
• Extracting data from Oracle and XML,SAP, MS SQL, T-SQL and performed Delta mechanism using Expression, Aggregate, Lookup, Stored procedure, Filter, Router transformations and Update strategy transformations to load data into the target systems.
• Integrated Oracle EBS with Informatica Power Center and OBIEE. Configured DAC for Finance.
• Responsible for Configuration and administration of Meta data Manager.
• Used TOAD, SQL Developer to develop and debug procedures and packages.
• Involved in developing the Deployment groups for deploying the code between various environment (Dev, QA).v
• Experience developing and supporting complex DW transformations
• Excellent understanding of Star Schema Data Models; Type 1 and Type 2 Dimensions.
• Created pre sql and post sql scripts which need to be run at Informatica level.
• Worked extensively with session parameters, Mapping Parameters, Mapping Variables and Parameter files for Incremental Loading.
• Extracted data from various heterogeneous sources like Oracle, SQL Server, XML,XSD’s,Flat Files, Teradata.
• Expertise in using both connected and unconnected Lookup Transformations.
• Extensively worked with various Lookup caches like Static cache, Dynamic cache and Persistent cache.
• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD
• Monitored and improved query performance by creating views, indexes, hints and sub queries
• Extensively involved in enhancing and managing Unix Shell Scripts.
• Developed workflow dependency in Informatica using Event Wait Task, Command Wait.
• Work on the performance improved areas. Debug the issues and coming up with the proper solutions which will reduce the process times.
• Created mappings by cleansing the data and populate that intoStagingtables, populating the staging to Archive and then to Enterprise Data Warehouseby transforming the data into business needs & Populating theData Martwith only required information

Confidential, CA

ETL/Informatica Developer

Environment: Informatica Power center 9.6.1/9.5/8.6.1 , Oracle 12/11g, SQL server 2008, LINUX, LSF (Job scheduling), UNIX shell scripting, SAS Enterprise guide and MS Visual studio (TFS) for version control, IDQ, DIH, Toad, RDBMS.

Responsibilities:

• Expertise in UNIX shell scripting, FTP, SFTP and file management in various UNIX environments.
• Used Informatica Power Center 9.5 for Extraction, Transformation and Loading data from heterogeneous source systems into the target data base.
• Experienced in the use of agile approaches, including Extreme Programming, Test-Driven Development and Scrum
• Extensive experience with Healthcare, Energy and Media domains.
• Experience with the healthcare data inHIPPA ANSI X12, 4010, 5010formats including NDC, DRG, CPT, NCPDP, NSF code,ICD 10,ICD 9, 997,837,834,835,277,271,270
• Extensive knowledge on theInboundandOutbound HIPAA transaction setswith both 4010A and 5010A HIPAA versions.
• Expertise in working with direct submitters, clearing houses and providers in regards to all the issues with EDI setup, claim submissions, eligibility transactions and ERA’s.
• Researched the existing client processes and guided the Vendors in aligning theHIPAA complianceoutput with the client systems.
• Worked on Claims database for claims processing.
• Worked on patient ally applications for claim processing. customizing workflow parameters
• Testing web services API publication and subscription
• Running publication and subscription on command line API customizing the mappings in powercenter which created by DIH tool
• Creating Target definition.
• Expertise to follow Agile process in application development.
• Highly motivated and goal-oriented individual with a strong background inSDLC ProjectManagement and Resource Planning using AGILE methodologies.
• Experience in various stages of System Development Life Cycle (SDLC) and its approaches likeAgile,and Prototyping Model.
• Created Informatica maps using various transformations like SAP BAPI/RFC, SAP IDOCs transformations, Web services consumer, XML, HTTP transformation, Source Qualifier, Expression, Look up, Stored procedure, Aggregate, Update Strategy, Joiner, Union, Filter and Router.
• Worked on de-dup process to cleanse the data for Finance and Controlling objects to help better cleanse data that can be loaded on SAP.
• Worked closely with Accenture load team for Data load into SAP (Direct Load Method/ LSMW/ BAPI)
• Experience working with Business users and architects to understand the requirements and to pace up the process in meeting the milestone.
• Perform impact analysis of the existing process of RRP-variant and designing the solution for automating input and output processes to/from RRP.
• Good experience with IDQ analyst tool and Developer tool.
• Good experience in Glossary and Rule specifications.
• Good experience in creating connections in IDQ tool like standardizer, Labeller, Match and Merge.
• Good experience in creating mapplets for Powercenter in IDQ tool.
• Good experience in creating IDQ transformations in
• UsedInformatica Power Exchangefor loading/retrieving data from mainframe system.
• Effectively communicates with other technology and product team members..
• Extensively used Informatica Power Centre tools and transformations such as Lookups, Aggregator, Joiner, Ranking, Update Strategy, Mapplet, connected and unconnected stored procedures / functions / SQL overrides usage in Lookups / Source filter usage in Source qualifiers.
• Created Pre/Post Session and SQL commands in sessions and mappings on the target instance.
• Responsible for Performance tuning at various levels during the development.
• Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance.
• Extracted/loaded data from/into diverse source/target systems like SQL server, XML and Flat Files.
• Used stored procedures to create a standard Time dimension, drop and create indexes before and after loading data into the targets for better performance.
• Developed process for TeradatausingShell ScriptingandRDBMSutilities such asMLoad,FastLoad(Teradata)
• Developed shell scripts, PL/SQL procedures, for creating/dropping of table and indexes of performance for pre and post session management.
• Responsible for migrating the workflows from development to production environment.
• Worked using Parameter Files, Mapping Variables, and Mapping Parameters for Incremental loading.
• Managed post production issues and delivered all assignments/projects within specified time lines.
• Extensive use of Persistent cache to reduce session processing time.

Confidential, Richmond VA

Informatica Developer

Responsibilities:

• Gathered requirements from the end users and Involved in analysis of source systems, business requirements and identification of business rules.
• Involved in the Data Warehouse Data modeling based on the client requirement.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center.
• Extracted sources from flat-files, Oracle, SQL Server and load them into Oracle.
• Responsible for creating system design and detail design documents based on the requirement document provided by the business users.
• Provides strategic thinking, leadership pertaining to new ways of leveraging information to improve business processes.
• Experienced in database design, data analysis, development, SQL performance tuning, data warehousing ETL process and data conversions.
• Based on the logic, developed various Mappings & Mapplets to load data from various sources using different transformations like Source Qualifier, Expression, Filter, Router, Update strategy, Sorter, Lookup, Aggregator, Joiner in the mapping. Also developed Error Processing to capture the error records and loads them into Message Log table.
• Worked with Stored Procedure Transformation for time zone conversions.
• Created UNIX scripts to automate the activities like start, stop, and abort the Informatica workflows by using PMCMD command in it.
• Fine-tuned the mappings by analyzing data flow and Worked with Memory cache for static and dynamic cache for the better throughput of sessions containing Lookup, Joiner and aggregator transformations.
• Provided production support including error handling and validation of mappings.
• Addressed and track requests for system enhancements, improvements from end users/customer and also resolved production issues.
• Utilized of InformaticaIDQ to complete initialdata profiling and matching/removing duplicate data.
• Extensively used Debugger Process to modify data and applying Break Points while Session is running.
• Used various Informatica Error handling techniques to debug failed session.
• Created Test cases for Unit Test, System Integration Test and UAT to check the data.
• Responsible for migrating the folders or mappings and sessions from development to test environment and Created Migration Documents to move the code from one Environment to other Environment.

Environment: Informatica 9.1, UNIX, Windows, Oracle 10g, PL/SQL, MSSQL 2008R2, SQL, Flat Files and CSV, Shell Scripting, Putty, PL/SQL Developer

Confidential

Application ETL Developer

Responsibilities:

• Responsible for design and development of Sales Data Warehouse.
• Worked with Business Analyst and application users to finalize Data Model, functional and detailed technical requirements.
• Extracted data from heterogeneous sources like Oracle, SQL Server
• Created detailed Technical specifications for Data Warehouse and ETL processes.
• Conducted a series of discussions with team members to convert Business rules into Informatica mappings.
• Used Transformations like Look up, Router, Filter, Joiner, Stored Procedure, Source Qualifier, Aggregator and Update Strategy extensively.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Created Mapplets and used them in different Mappings.
• Involved in doing error handling, debugging and troubleshooting Sessions using the Session logs, Debugger and Workflow Monitor.
• Monitoring the Data Quality, Generating weekly/monthly/yearly statistics reports on production processes - success / failure rates for causal analysis as maintenance part and Enhancing exiting production ETL scripts.
• Worked with SAP and Oracle sources to process the data.
• Worked on SAP for data migration Human Resources and Finance and converted various objects on Organizational Structure, Addresses, Time, Basic Pay, Bank Details, Recurring Payments, Tax assignment, Insurance Plans, Payroll etc., to generate report from SAP BI system.
• Worked with Pre and Post Session SQL commands to drop and recreate the indexes on data warehouse using Source Qualifier Transformation of Informatica Power center.
• Created Unix Shell Scripts to automate sessions and cleansing the source data.
• Implemented pipeline partitioning concepts like Round-Robin, Key-Range and Pass Through techniques in mapping transformations.
• Involved in Debugging and Performance tuning of targets, sources, mappings and sessions.
• Worked on the data masking activities for cloning the GDW for several buyers

Environment: Informatica Power Center 8.6, Oracle9i, Teradata v2r6, SAP, SAP BI 7.0, SQL Server, Sun Solaris.

Confidential

ETL Developer

Environment: Informatica PowerCenter8.1, SQL server 2005, DB2, PL/SQL, Toad, Business Objects 6.0, Windows NT, UNIX Shell Scripts.

Responsibilities:

• Interacted with Business Analysts for Requirement gathering, understanding the Requirements, Explanation of technical probabilities and Application flow.
• Developed ETL mappings, transformations using Informatica Power Center 8.6.1
• Extracted data from flat files, DB2 and loaded the data into Oracle staging using Informatica Power Center.
• Designed and created complex source to target mapping using various transformations inclusive of but not limited to Sorter, Aggregator, Joiner, Filter, Source Qualifier, Expression and Router Transformations.
• Extensively used Lookup Transformation and Update Strategy Transformation while working with Slowly Changing Dimensions (SCD) and also performed reading and loading high-volume Type 2 dimensions.
• Created various transformations such as Union, Aggregator, Lookup, Update Strategy, Joiner, Filter and Router Transformations.
• Involved in Performance tuning. Identified and eliminated bottlenecks (source, target, and mapping).
• Used reusable Session for different level of workflows.
• Designed various tasks using Informatica workflow manager like session, command, email, event raise, event wait and so on.
• Designed and developed UNIX shell scripts as part of the ETL process to automate the data load processes to target.
• Involved in Unit Testing, User Acceptance Testing (UAT) to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements
• Developed Mappings that extract data form ODS to Data mart and Monitored the Daily, Weekly and Monthly Loads.
• Created and monitored Sessions/Batches using Informatica Server Manager/Workflow Monitor to load data into target Oracle databas