SUMMARY:

• IT Professional with 8 plus years of Experience in Information Technology with strong background in the areas of ETL Design and Development in Data Warehousing using Informatica Power Center in various verticals such as Financial, Retail, Health and Insurance industries.
• 7 plus years of ETL /Data Warehousing experience using Informatica Power Center 9.6/ 9.5/9.1/8. x/7.1 and Informatica Power Exchange 9.1/8.6/8.1. Informatica cloud, Informatica Developer Client 9.6 and MSBI stack (SSIS, SSRS).
• Extensively expertise in working with all major components of Informatica Power Center like Repository Manager, Designer, Workflow Manager, and Workflow Monitor.
• Experience in building operational data store (ODS) and Enterprise Data Warehouse with the knowledge of Data mart, OLAP, ROLAP, MOLAP, OLTP and logical and physical Dimensional modeling concept Star/Snowflakes Schema, fact and dimension table and proficient in identification of Facts, measures and dimensions.
• Experience in deploying best practices and methodologies with technology to address real - time Data and Application integration challenges in a variety of Cloud (SaaS, PaaS, iPaas)
• Built and maintain the end-to-end integration processes between Salesforce and other third party systems using Informatica cloud real time.
• Implemented processes that conduct service calls through APIs that interface with applications on cloud
• Experience in data Warehousing techniques for Data Analysis, Data Profiling, Data Cleansing, Transformation, Consolidation, Integration, Data Import, Data Export using Oracle, MS SQL Server, DB2, Teradata, and Hadoop into Data Warehouse/Data Marts using Informatica.
• Knowledge on Oracle Hyperion Financial Management (HFM)
• Expertise in extracting data from Flat Files, Unstructured data, XML formats and PDF format files and transforming and loading into Oracle database, flat file JMS Queue, COBOL and vice versa.
• Expertise in handling performance tuning of Oracle using SQL trace, SQL Plan, Oracle partitioning, join types and various indexes.
• Extensively worked with PL/SQL/Oracle Stored Procedures, Functions, Packages Triggers, Index, Cursors and Exception handling.
• Experienced in handling error, and performance and optimization issues involved with complex mappings, sessions and workflows.
• Expertise in installing and configuring Informatica server and client component in different environment as well as expertise in migration of repository server and its data from older version to newer version.
• Excellent in first logic, normalization for database designs purpose and extensively worked on Data warehouse Design and created Logical and Physical Data Model using MS Visio.
• Expertise in Health care domain like Medicare, Medicaid and Insurances compliance within Health Insurance Portability and Accountability Act (HIPAA) regulation and requirement.
• Worked extensively on the HIPPA 4010/HIPPA 5010 transactions (refers to the revised set of HIPAA electronic transaction standards adopted to replace the current Version 4010/4010A standards) and heavily involved in analyzing the ICD 9 and ICD 10 for the data mapping from ICD 9 and ICD 10 in source and target level.
• Experience in Unix Shell Scripting for data manipulation and scheduling tasks.
• Hands-on experience defining job control processes, preferably with Tivoli Workbench Scheduler (TWS) and Autosys, Tidal Enterprise Scheduler
• Performed standard ETL administration tasks such as deployment, package migration and relocation, and managing metadata as well as hot fixes them in production environment.
• Expertise in designing and development of CDC real time and batch processing using Informatica Power Exchange.
• Experience in various stages of System Development Life Cycle and its approaches like Waterfall, Spiral, Agile, and Prototyping Model.
• Experience in Unit testing, System testing while moving the code from development to production
• Excellent team player with an ability to perform individually, good interpersonal relations, strong communication and analytical skills. A hard working and quick learner with an aptitude for taking responsibilities and high level of motivation to work in a fast-paced and demanding environment.

TECHNICAL SKILLS:

Data warehousing: Informatica Power Center 9.6.1/9.5.1/9.1.1/8.6/8.5/8.1/7.1, Informatica Power Exchange 9.1/8.6/8.1, Erwin 8/7.5/4.0

Business Tools: 9 Years experience of Star-Schema Modeling, Snowflake Modeling, MS Visio, Erwin, WinSCP, Autosys, Tax pad, MS Visual Source Safe, PVCS, Control M, Harvest, Remedy, Plan view, Leeyo and Filegilla.

Databases: 9 Years experience of Oracle 10g, Oracle 11g, HFM, Oracle R12 MS SQL Server7.0/2000, MS Access, Sybase, DB2, MySQL, Teradata V2R6, Single View, Revpro

Languages: 9 Years XML, SQL, T-SQL, PL/SQL, UNIX Shell Scripting, Perl, Java

Operating System: 9 Years experience of Windows98/NT/2000/XP, MAC, SunSolaris, Linux/UNIX, MS-DOS, Web Logic.

PROFESSIONAL EXPERIENCE:

Confidential, Middlebury, CT

Sr.Informatica Developer

Responsibilities:

• Interacted with the Business Users in gathering and analyzing the Business requirements.
• Worked on Designing, Development and Testing of Workflows and Work lets according to Business Process Flow.
• Created mappings using various transformations like update strategy, lookup, stored procedure, router, joiner, sequence generator and expression transformation.
• Extensively involved in writing ETL Specifications for Development and conversion projects.
• Created technical design specifications for data Extraction, Transformation and Loading (ETL).
• Extensively worked on Change Data Capture/Incremental loading of SCD Type I/II.
• Gather Requirements from the source system and creating Process using Informatica cloud.
• Building Design Spec for the ETL Process flow based on the requirements using Informatica cloud.
• Design the ETL process and schedule the stage and mart loads for the data mart.
• Worked on Informatica Utilities Source Analyzer, warehouse Designer, Mapping Designer, Mapplets Designer and Transformation Developer for defining Source and Target, and coded the process from source system to data warehouse.
• Extensively used transformations like Stored Procedure, Connected and Unconnected lookups, Update Strategy, Filter transformation, Joiner transformations to implement business logic.
• Extensively created Re-usable Transformations and Mapplets to standardized Business logic.
• Extracted the data from various Flat files and Loaded in Data warehouse Environment and written Unix Shell scripts to move the files across the Servers.
• Used Informatica Workflow Manager to create workflows, database connections, sessions and batches to run the mappings.
• Used Variables and Parameters in the mappings to pass the values between mappings and sessions.
• Used Unix Shell Scripts to automate pre-session and post-session processes.
• Created shortcuts for reusable source/target definitions, Reusable Transformations, mapplets in Shared folder.
• Coordinated with testing team to make testing team understand Business and transformation rules that have been used throughout ETL process.

Environment: Informatica power center 9.6.1, Informatica TD Studio, PowerMart(Source Analyzer, Data warehousing designer, Mapping Designer, Workflow Manager, Workflow Monitor, Worklets, Mapplet, ErWin, winSCP Root, Taxpad), Star-Schema Modeling, Snowflake Modeling, Power Exchange, Oracle 11g, HFM, Toad 12.5.1.1, PL/SQL, Autosys Unix r11 client,, Business Object and XML File.

Confidential, LA, CA

Sr.Informatica Developer

Responsibilities:

• Analyzing the data and Mapping the data requirements developing Stored Procedures and Functions
• Designed Mapping document, which is a guideline to ETL Coding.
• Developed ETL mappings , transformations using Informatica Power C enter .
• Implemented source and target definitions in workflow designer and production deployments.
• Involved in Information administration including creating new users and groups, backing up the repository and domain as well as handling various upgrades.
• Working on new projects to fulfill the business needs.
• Reviewed high-level design specification, ETL coding and mapping standards.
• Involved in writing and modifying UNIX shell scripts.
• Worked with data quality team to fix the production data issues and also provide solutions to the business users.
• Used Toad for data quality verification and unit testing the data.
• Migrated mappings from Development to Testing and Testing to Production.
• Developed stored procedures to extract the data from different sources and load it into data warehouse.
• Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures.
• Maintaining daily batch cycle and providing 24 hour Production support.
• Preparation of the Test Cases and involvement in Unit Testing and System Integration Testing.

Environment: Informatica Power Center 9.5/9.1, Informatica PowerExchange 9.5/9.1, Oracle Exadata, Teradata 13, MSSQL Server 2008 R2, T-SQL, ERWin 8, SQL Server 2008, TOAD, PL/SQL Developer, Linux, Tidal, Shell Scripting, Perl Scripting, Windows XP, Putty, DB2 Mainframe, Informatica Cloud, Sales force.

Confidential, Washington DC

Sr.Informatica Developer

Responsibilities:

• Work closely with project managers, business analysts, DBA’s to understand business and functional requirements.
• Extensively worked on the transformations like Source Qualifier, Filter, Joiner, Aggregator, Expression, Normalizer, and Lookup.
• Worked on Informatica PowerCenter tool - Source Analyzer, Target Designer, Mapping Designer, Mapplets Designer and Transformation Developer.
• Assisted in the design and Maintenance of the Metadata environment.
• Created Workflows and Sessions to load data from the SQL Server, Oracle, flat file, and XML file sources that exist on servers located at various locations.
• Extensively used Source Qualifier Transformation to filter data at Source level
• Created different transformations such as Source Qualifier, Joiner, Expression, Aggregator, Rank, Lookups, Filters, Stored Procedures, Update Strategy and Sequence Generator.
• Created and monitored workflows and task using Informatica PowerCenter Workflow Manager.
• Responsible for creating business solutions for Incremental and full loads.
• Created different parameter files and changed Session parameters, mapping parameters, and variables at run time.
• Created high-level design document for extracting data from complex relational database tables, data conversions, transformation and loading into specific formats.
• Developed standard and re-usable mappings and mapplets using various transformations like Expression, Lookups, Joiner, Filter, Source Qualifier, Sorter, Update strategy and Sequence generator.
• Performed unit testing, Integration testing and Functional testing of the mappings.

Environment: Informatica Power Center 9.5.1, Oracle Oracle11g, SQL, Teradata, DB2, Windows NT, Oracle LINUX Flat files (delimited), UNIX Shell Scripting, Erwin, TOAD, Mercury Quality center, Windows XP.

Confidential, Dillon, Montana

ETL/Informatica Developer

Responsibilities:

• Responsible for this project, Generated the code for designing and developing of mappings, mapplets, sessions and work flows for load the data from source to target database using Informatica Power Center and tuned mappings for improving performance.
• Involved in ETL process from development to testing and production environments.
• Extracted date from various sources like XML file, Flat files, Oracle and loaded it into Target systems using Informatica power Center 9.6.1.
• Developed mappings using various transformations like update strategy, lookup, stored procedure, router, joiner, sequence generator and expression transformation.
• Used Informatica Power Center Workflow Manager to create sessions, batches to run with the logic embedded in the mappings.
• Tuned mappings and SQL queries for better performance and efficiency.
• Performed Unit testing and validated the data.
• Created & Ran shell scripts in UNIX environment.
• Created and ran the Workflows using Workflow manager in Informatica Maintained stored definitions, transformation rules and targets definitions using Informatica repository manager.
• Created tables and partitions in database Oracle.
• Written stored procedures in Oracle.

Environment: Informatica Power Center 9.5, ColdFusion Power Mart, Oracle Oracle11g, PL/SQL, Teradata, Informatica Cloud, SAP BO, SSRS, Windows, UNIX, Erwin, Putty, WINSCP, Windows XP, Linux, IBM Mainframes.

Confidential, Tampa, FL

Informatica Developer

Responsibilities:

• Created Complex Mappings to load data using transformations like Source Qualifier, Expression, Aggregator, Dynamic Lookup, Connected and unconnected lookups, Joiner, Sorter, Filter, Stored Procedures, Sequence, Router and Update Strategy.
• Developed Mapping using parameters, used Session parameters, Mapping variable/parameters and created Parameter files and run workflows based on changing variable values.
• Performed Performance tuning using source Qualifier, Master-Detail Joiner, Partitioning, reassigned transformation, sorted data, creating work table, Partitioning, and pushdown optimization.
• Worked with IDQ toolkit, Analysis, data cleansing, data matching, data conversion, using important transformations such as labeler, standardizer, address doctor, key generator etc.
• Provided Production support and troubleshoots issues for ongoing application, rerun the job for table lock, connection lost, incorrect source, IS down on a very regular basis.
• Implemented Slowly Changing Dimensions (SCD Type 2) in Mappings.
• Utilized Decision task, Email task, pre-session and post-session command to file watch event, Collect statistics, Drop and create index, unzip then create source file, move source and target file, email reports, assigned timestamp to file name.
• Developed ETL mappings to extract data from multiple source systems like Oracle, Flat Files and SQL server, and loaded into Oracle system.
• Developed Informatica Workflows and sessions connected with the mappings using Workflow Manager.
• Involved in creating new table structures and modifying existing tables discussing with Data Modeler.
• SQL overrides usage in Lookups and Source qualifiers, data flow management into multiple targets using Routers by expression assigned flag. Used Connected and unconnected lookup.
• Experience in writing documentation like Micro documents from Macro documents, High level and low level design, analyzing Source to Target Mapping (STM’s), Test cases and Code migration report.
• Developed Mapplets, Source and Target definitions, mappings, Reusable Transformations, using Informatica Power Center 9.6.
• Update the tables as per the requirements by generating queries using SQL to check the data consistency in the table.
• Checked Sessions and error logs to troubleshoot problems and also used debugger. .
• Created shortcuts for reusable transformation, source/target definitions, mapplets in Shared folder.
• Interacted with Business Analyst to identify the process and requirements gathering, implementing designs process, development and preparing business rules.
• Worked in Software Development Life Cycle (SDLC) like in Agile Scrum methodologies.
• Actively performed in the meeting and providing comments for user story review meeting in Agile Scrum environment

Environment: Informatica Power Center 9.1, Oracle 11g/10g, Power mart, Pl/SQL, Windows, Flat files (fixed width/delimited), Erwin, Putty, WinScp, Linux, XML, SharePoint, Quality Center.

Confidential, Charlotte, NC

Oracle Developer

Responsibilities:

• Analyses and discuss the business requirements with the clients.
• Creation of database, cloning database, exporting database and importing database.
• SQL application tuning and usage of DBMS SQLTUNE advisor.
• Patch Management.
• Memory Management through Oracle PL/SQL using Oracle Objects and Collections features.
• Advanced features of Oracle like Start with, Connect By Prior, Order By Siblings and Oracle Text etc
• Coding in PLSQL and Maintenance of Database.
• Testing of Unit Test cases.
• Bug tracking and fixing.

Environment: Oracle SQL Developer, TOAD, PL/SQL Developer, Shell Scripting, Windows XP, Putty