SUMMARY

• IT Professional with 10 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, Pharma, Health and Insurance industries.
• 8 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 Developer Client 9.6 and MSBI stack (SSIS, SSRS).
• 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.
• Experience in Data Verification and Validating the ETLs using different types of testing like Regression Testing, Functional Testing and Smoke Testing
• Good understanding of agile scrum methodology and attended the daily scrum calls
• Created the Data mapping sheet for ETL mappings and implemented the data quality rules in integration process
• Implemented processes that conduct service calls through APIs that interface with applications on cloud
• 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 data Warehousing techniques for Data Analysis, Data Profiling, Data Cleansing, Transformation, Consolidation, Integration, Data Import, Data Export using Oracle, MS SQL Server, DB2, Teradata, Greenplum and Hadoop into Data Warehouse/Data Marts using Informatica.
• 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, $U., 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
• Strong understanding of languages like XML, XSD, VB Script, SQL, T-SQL, PL/SQL, C, C++, Java, Flash.
• Received Customer Appreciation Certification for successfully delivering the projects without any defects within scheduled time.
• 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: InformaticaPowerCenter9.6, 9.5.1/9.0.1/8. x/7.x,InformaticaPowerExchange9.6, 9.0.1/8.6/8.5/8.1 , Informatica Developer Client 9.6, Data cleansing, OLAP, ROLAP, MOLAP, Star Schema, Snowflake Schema, OLTP, SQL*Plus, SQL*Loader, BTEQ, MLOAD, FLOAD, FEXPORT, TPUMP.

Data Modeling: Dimensional Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin 7.2/7.0, Visio 2003, Oracle Designer, TOAD.

Databases: Oracle Exadata/11g/10g,pgAdmin, Greenplum, SQL Server 2012/08/05, MS Access, SAP, Teradata 13/V2R6, DB2, Sybase, IBM Mainframe

Programming: ProgrammingC, C++, SQL, PL/SQL, ANSI SQL, T-SQL, SQL*Plus 3.3/8.0, Java 1.4, J2EE HTML, UNIX Shell Scripting, VB Scripting.

Environment: UNIX, LINUX, Windows 2000/XP/Vista/NT, Sun Solaris, AIX

Reporting& Scheduling Tool: OBIEE 10g, BO XI, ESP, Ctrl-M, Tidal, Tivoli (TWS), $U, eTP

Other Tools: Putty, WinScp, Remedy, MS Office, Jira, Rally, Toad, Sql Developer, ServiceNow, SVN

PROFESSIONAL EXPERIENCE

Confidential, Denver, CO

Sr. Informatica Developer

Responsibilities:

• Work with Stakeholders regarding business requirements, functional specifications and enhancements, based on the business needs create technical design and functional specification documents.
• Used File Bridge for flat file automatic DQ and IDQ validations.
• Involved in design and development of Informatica mappings using various transformations like expression, lookup, router, joiner, union sorter, aggregators etc.
• Involved in developing SCD type 1, type 2 mappings in Informatica level and also involved in writing the stored procedure to perform type 1 and type 2 operations.
• Involved in the development of automated stored procedures to use as post and pre SQL in the Informatica session level which are useful to load the dimension and fact tables based on the table type.
• Used SQL Server as database and design various stored procedures using SQL Server.
• Used SVN to store all the automated scripts and regular insert scripts to run automatically after every data model deployment.
• Used TIDAL and $U auto scheduling tool for automate the process.
• Involved in writing shell scripts to automate the jobs which were used in the TIDAL.
• Widely used JIRA Dashboard to track the issues and communicate with the team members upon the particular issue.
• Responsible for building Stored Procedures using MS-SQL Server.
• Interacted and conducted various meetings with end users for Data Reconciliation purposes.
• Collaborated with the QA team to get solve the outstanding issues.
• Perform the unit testing for files using UNIX commands.
• Perform the unit testing as per the design document and as per the mapping design flow.
• Responsible to fix the issues during the load failure due to MLOAD or Locks on the target tables.
• Used the Volatile tables’ concept in writing the BTEQ Scripts.
• Used BULKLOAD and FAST LOAD metadata Utility to load data into stage tables.
• Responsible for writing the BTEQ Scripts to populate the Dimensions and the Fact Tables used for
• KPI generation purposes by the end users.
• 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.
• Extracting data from various source systems like Oracle, Sql server, Salesforce into data warehouse
• Creating Mapping, mapping configurations and task flows in Informatica cloud.

Environment: Informatica 9.6, PL/SQL Developer, OBIEE,, SharePoint, UNIX, Oracle 11g, DB2, SQL Server, SSIS, Teradata, Big Data Developer, Hive, Hue Putty, WinSCP,, Tial., $U, enterprise turn point (eTP), SharePoint, MS Visio; JIRA, SVN,Salesforce

Confidential, Los Angeles, CA

Sr.Informatica Developer /ETL Lead

Responsibilities:

• Worked extensively on Informatica designer to design a robust end-to-end ETL process involving complex transformation like Source Qualifier, Lookup, Update Strategy, Router, Aggregator, Sequence Generator, Filter, Expression, Stored Procedure, External Procedure, Transactional Control for the efficient extraction, transformation and loading of the data to the staging and then to the Data Mart (Data Warehouse) checking the complex logics for computing the facts.
• Worked extensively on the HIPPA 4010 transactions and HIPPA 5010 transactions as the source data like 834,835, 277,276.
• Participated in the initial Impact Analysis (ICD-10) for all the critical functions, i.e., Membership & Enrollment, Claims Processing, Utilization Management, Medical Policy, Reporting, Vendor Management, etc
• Performed impact analysis on 5010 upgrades and ICD-10 conversions
• Participated in ICD 9 to ICD 10 codes conversion requirement gathering sessions and created high level business requirement document and Involved in analyzing the ICD 9 and ICD 10 for the data mapping from ICD 9 - ICD 10 and ICD 10 - ICD 9 in source and target level
• Involved in analyzing different modules of facets system and EDI interfaces to understand the source system and source data and extensively used the reusable transformation, mappings and codes using Mapplets for faster development and standardization and used reusable Session for different level of workflows.
• Collaborated with the data architect, database administrators and other team members to understand dimensional requirements and translate into functional specifications.
• Extensively involved in performance tuning by determining bottlenecks at various points like targets, sources, mappings and sessions.
• Created variables and parameters files for the mapping and session so that it can migrate easily in different environment and database.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Defined and worked with mapping parameters and variables and designed various tasks using Informatica workflow manager like session, command, email, event raise, event wait and so on.
• Design the architecture for production support in order to scheduling the tasks (without any manual intervention) using Unix Shell Scripting.
• Used Unix Command and Unix Shell Scripting to interact with the server and to move flat files and to load the files in the server.
• Involved in resolving the issues related with the migration of designs from Dev and QA Server to Prod Server and also helped in resolving issue related with the production support of the Data Warehouse.
• Wrote complex SQL queries PL/SQL function, procedure, packages, cursor and triggers to retrieve the data from sources system and to count and validate the data and data set.
• Actively involved in Data Migration from source to target Database.
• Performed Unit testing by writing simple test scripts in the database and involved in integration testing and minus SQL script comparing from source to target.
• Interacted with User Groups/ Corporate Testing Groups/Business People.
• Worked with Business Objects for generating ad-hoc report.

Environment: Informatica Power Center 9.6, Informatica PowerExchange 9.6, SQL Server 12, Oracle 11g, DB2, TOAD, PL/SQL Developer, Big Data Developer Edition, Peoplesoft, Autosys, Hive, Hue, XML, Shell Scripting, Putty, WinSCP.

Confidential, Wilmington, DE

Sr.Informatica Developer

Responsibilities:

• Coordinated with testing team to make testing team understand Business and transformation rules being used throughout ETL process. Widely used Informatica client tools -- Source Analyzer, Warehouse designer, Mapping designer, Transformation Developer and Informatica Work Flow
• Worked with Business analysts and the DBA for requirements gathering, business analysis and designing of the data warehouse. Designed and developed transformation rules (business rules) to generate consolidated (fact/summary) data using Informatica ETL tool.
• Developed mappings for customers, Investments and Risk analysis.
• Done extensive bulk loading and normalize into the target using Greenplum Loader.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Assisted the team in the development of design standards and codes for effective ETL procedure development and implementation.
• Extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings and sessions. Defined and worked with mapping parameters and variables.
• Developed UNIX Shell scripts to automate repetitive database processes and maintained shell scripts for data conversion.

Environment: Informatica Power Center 9.6, Informatica 9.6 Big Data Developer Edition, Autosys, Hive, Hue, Aginity, XML, Linux, Shell Scripting, Putty, WinSCP.

Confidential, Cambridge, MA

Responsibilities:

• Involved with Business Analysis, requirement gathering & designing Logical/Physical Data Models.
• Extensively worked on Data warehouse design and created Logical and Physical Data Model using MS Visio and ERWIN.
• Created complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Union, Expression and Aggregator transformations to pipeline data to extract data from various databases, Flat files and load into Data Mart using the Designer tool. Also, made use of variables and parameters.
• Used Informatica Workflow Manager for Creating, Running Sessions and scheduling them to run at specified time.
• Involved in designing real-time Informatica mappings and workflows.
• Created Scripts for pmcmd commands, restart deadlock workflow, space check and dependency scripts
• Created reusable transformations & mapplets and used them in various mappings.
• Created PL-SQL procedures to detect CDC methodologies and developed Slowly Changing Dimension Type 1 & Type 2.
• Created Indexes, primary keys and checked other performance tuning at database level.
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows. Worked with Change data capture option to enhance business agility.
• Developed Oracle Stored Procedures, Package, Function and Trigger. Performed fine Tuning of SQL & PL/SQL stored procedures.
• Used JAXB to generate Java classes from an XML Schema to access external data.
• Designed and developed Java Server Pages and Servlets for the Presentation Layer
• Performed Unit testing by comparing the source and target data.
• Created Teradata utilities like BTEQ, MLOAD, FLOAD, TPUMP.
• Created Web Services Source, Target and mappings for sending and receiving message from portal.
• Extensively worked on XML source and target. Worked on XML parser and generator.
• Created MQ sources and target and configured workflows to retrieved message and send messages.

Environment: Informatica Power center 9.5/9.0.1, Power Exchange 9.0.1/9.5, Oracle 11g, DB2, TOAD, PL/SQL Developer, SQL Loader, Erwin r7.1, SQL, PL/SQL, Java 1.4, J2EE,UNIX Shell Scripts, AIX, Teradata 13, Autosys.

Confidential, Wilmington, DE

Sr Informatica Developer

Responsibilities:

• Fast paced project involving understanding the business, current processes and requirements.
• Gathered Requirements from users, translated user inputs into ETL design documents.
• Performed Business Analysis, Designed, Developed, Tested and Implemented Informatica transformations and Workflows for extracting the data from the multiple legacy systems.
• Developed complex mappings using multiple sources and targets in different databases, flat files.
• Used various transformations like unconnected lookup, connected lookup, aggregator, rank, joiner, stored procedure etc.
• Applied performance tuning on targets, sources, mappings, sessions and database to improve system performance.
• Created and Executed UNIX shell scripts and PL/SQL procedures, Pre-session and Post- Session Scripts to ensure timely, accurate processing and ensure balancing of job runs.
• Performed Unit testing of Informatica Mappings, Workflows and Mapplets and tuned them to improve performance.
• Worked with the team to create reusable ETL solutions to achieve enormous improvements.
• Assisted in the process of preparation of documenting Informatica transformation Development Standards.
• Generated Cognos reports to help QA team achieve quick and efficient turnarounds.
• Involved in developing user interface (UI) using HTML, JavaScript, and JSP.
• Designed user-interface and checking validations using JavaScript.
• Validated fields using both JavaScript and Spring level validations

Environment: Informatica Power Center 8.6, Informatica Power Exchange 8.6, PL/SQL, Oracle 10g, TOAD, Tidal, Windows 2000, Java 1.4, J2EE,SQL Server 2008, Tidal, Cognos, Teradata, LINUX, Business Object XI.

Confidential, New York, NY

Informatica Developer

Responsibilities:

• Requirement gathering and Business Analysis. Involved in data modeling and created LDM and PDM.
• Participated and coordinated in onsite-offshore meetings.
• Worked on various HIPAA terms &functionalities.
• Translated business requirement to technical specifications and developed Informatica mapping/Workflows.
• Used shell Scripting and Scheduled pmcmd to interact with Informatica Server from command mode.
• Used ETL to extract and load data from Global Repositories, Folders, Permission and user using repository manger.
• Maintaining source definitions, transformation rules and targets definitions using Informatica Repository Manager.
• Worked on performance tuning for ETL processes.
• Created complex mappings using Unconnected, Lookup, and Aggregate transformations for populating target table in efficient manner.
• Developed various Sessions, Batches for all Mappings for loading from various sources like flat files, tables, XMLs and csv file to Target tables.
• Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
• Used PL-SQL procedures to detect CDC methodologies and developed Slowly Changing Dimension for Type 1 and Type 2.
• Created Indexes, primary keys and checked other performance tuning at data base level.
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows.
• Developed Oracle PL/SQL Stored Procedures. Performance and fine Tuning of SQL & PL/SQL stored procedures.
• Performed Unit testing by comparing the source and target data.
• Loaded data to Staging area using Teradata FLOAD utilities. Created BTEQ Script for ETL processing.

Environment: Informatica Power Center 8.6, Power Exchange 8.6, Oracle 10g, TOAD, PL/SQL Developer, SQL Loader, Erwin r7.1, SQL, PL/SQL, UNIX Shell Scripts, Linux, Teradata V2R6.

Confidential, Parsippany, NJ

ETL/Database Developer

Responsibilities:

• Design and Unit test different Modules and Applications.
• Worked on the Master test plan and test cases.
• Worked onintegration testing.
• Physical and logical data modeling using ERWIN.
• Wrote triggers and stored procedures in PL/SQL.
• Involved in the requirement gathering and analysis in support of data warehousing efforts.
• Involved in Designing the Data warehouse using Informatica ETL tool.
• Performing unit testing on the data and reports validation.
• Wrote re-usable mapplets to create Error handling routines.
• Performance tune ETL code and SQL Query.

Environment: Informatica Power center 7.1, UNIX, Oracle 10g, TOAD, SQL*plus, SQL* Loader, MS Office, AIX, ESP, Teradata, Business Objects.