SUMMARY:

• 9.3 years of experience in analysis, design, development, Testing and Implementation of various Data Warehousing, web applications and client/server applications on windows and UNIX platforms.
• Experience in using Informatica Power center 9.5.1/8.6.x (Repository Manager, Designer, Workflow Manager and Workflow Monitor), Informatica Cloud, Ab Initio GDE 1.14.37, repository EME and Co>op sys 2.13.3, Teradata utilities and Talend Integration
• Worked on multiple client specific environments related to Financial, Banking, Healthcare and Retail.
• Experience in using Data sources/targets such as Teradata, Oracle 11g/10g/9i/8i, WSDL, Flat files and Parameterized files
• Worked extensively on various Informatica Data Integration components - Repository Manager, Designer and Workflow Manager and Workflow Monitor
• Experience in designing and developing complex mappings from different transformation logics like Unconnected and Connected Lookups, Aggregator, Normalizer and Transaction control etc…
• Good understanding of Data warehouse concepts, Star & Snowflake Schema, Fact/Dimension tables, Normalization/Demoralization and slowly changing dimension (SCD) types.
• Expertise in Data Analysis, Data Cleaning, Data Mapping, Data Modelling and development of Databases for business applications and Data warehouse environments.
• Used Repository manager to work on Informatica Administrative support activities like Informatica installation process, Creating users, Granting permissions to the users, migrating the code from one environment to other, Label creation and adding objects to the label for code migration etc.,
• Worked on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Sound knowledge on Informatica IDQ, and Informatica MDM
• Designed Source to Target mappings, Code Migration, version control, scheduling tools, shared folders, data movement with ETL best practices.
• Knowledge on Informatica Cloud to migrate the data from relational databases, Flat files to Salesforce using Informatica cloud apps Data Assessment, Data Synchronization and mapping configuration Apps
• Used Teradata to create Global temporary tables for data validation, created MLOAD, FLOAD scripts to load the data into datamarts.
• Good Knowledge on File, ELT, Database components, Log and Error components of Talend Data Integration tool.
• Knowledge of all phases in software development life cycle (SDLC) and software Testing life cycle STLC.
• Worked on different project methodologies like Agile, and Waterfall.
• Excellent interpersonal and communication skills, technically competent and result-oriented with problem solving skills and ability to work effectively as a team member as well as independently.

DOMAIN SKILLS:

• 4 years of experience in Healthcare domain.
• 4 years of experience in Banking & Finance Services.
• 1 years of experience in Retail.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter 9.x/8.x, Informatica MDM, Informatica IDQ, Informatica Cloud, Ab>Initio, Talend Data Integration and Teradata Utilities

Database: Oracle 10g/ 9i/ 8i, Sql Server, DB2 and Teradata 7x, Green Plum

DB Tools: SQL*Plus, TOAD, PL/SQL Developer, Oracle Developer

Environment: WINDOWS XP/2000, and UNIX

Cloud Platforms: Informatica Cloud Secure Agent, Salesforce.com, Web Services

Languages: SQL, PL/SQL, UNIX Shell Scripting

Drafting Tools: Microsoft Visio and Erwin

Other Tools/Utilities: HP Quality Center, JIRA, Confluence Cloud pages

PROFESSIONAL EXPERIENCE:

Confidential, Louisville, KY

Senior ETL Informatica Developer

Responsibilities:

• Discuss business solutions with Confidential Appliance Business Analysts, resolve existing problems and improve the stability.
• Coordinate with business clients, support the BI application and implement the process as per specifications provided.
• Using Informatica Cloud Secure Agent to migrate the data from DB to Salesforce
• Used Informatica cloud configure option to configuring the sources and targets
• Created connections using configure menu (Salesforces, Oralce, and flatfile)
• Created task using contact validation, Data Assessment, Data Synchronization and mapping configuration Apps
• Defined task, created Flatfile, Oracle and salesforce sources and targets for data synchronization,
• Used data filters and field mapping properties to map the source and target fields.
• Created flexible, resulable mappings using Mapping designer of the Informatica cloud
• Designed mappings for multiple connection sources using mapping designer
• Used Joiner, filter, expression and lookup transformations in Informatica cloud to create and schedule the mappings.
• Co-ordinating the technical teams to accommodate the changes across the team. Working on enhancements based on mainframe source system changes, Java application changes and adding new functional to the existing system etc.,
• Regular interaction with the Confidential Managers and functional users, Database administrators, Network Administrators, BI Report Users - all belonging to different departments and divisions of Confidential Appliance to ensure the smooth running of the Data warehousing applications.

Environment: Informatica Power Center 9.5.1/9.1.1 , Informatica Cloud, Oracle 11i, SQL Developer Tool, UNIX, and Mastero Scheduler, JAVA

Confidential, New York, NY

Senior ETL Informatica Developer

Responsibilities:

• RTB (Run the Business) activities i.e. fixing all the Confidential Corp-DW Projects related issues and bugs that may come up during the production phase. This also includes helping the users in understanding the BI reports and setting up the
• Discuss business solutions with Confidential Corporation Business Analysts, resolve existing problems and improve the stability.
• Coordinate with business clients, support the BI application and implement the process as per specifications provided.
• Worked on project estimations and plan, shared and briefed the team about the process.
• Worked with other ETL developers to provide the deliverables on time.
• Involved in business analysis and technical design sessions with business and technical staff to develop requirements document, and ETL specifications.
• Prepared Detail design documents for the project as per the ETL standards, procedures naming conventions and code fixes.
• Developed various mappings and mapplets in Mapping designer and sessions and workflows in Workflow manager to extract data from Oracle database.
• Developed Transformation logic and designed various complex Mappings in the Designer for data load and data cleansing.
• Designed different types of look-up (connected/unconnected) transformations in both mapping and mapplet according to the requirement of transformation.
• Involved in designing Logical and Physical models for staging , transition of the Data.
• Analysis was done using existing transactional database schema and designing Data Model to support user need for reporting.
• Used Workflow monitor to monitor tasks, workflows and also to monitor performance.
• Written pre session and post session scripts in mappings.
• Created jobs to schedule the loads at required frequency using Mastero Scheduling tool
• Created tables using DDL’s and modified existing tables in the database based on the requirements.
• Created test cases and test scenarios and worked with users on test load analysis.
• Involved in system testing of overall processes and provided production support.
• Performance tuning of ETL Jobs and provide analysis of any outstanding issues.

Environment: Informatica 9.5.1/9.1.1 , Oracle 11i, SQL Developer Tool, UNIX, and Mastero Scheduler

Confidential

Senior ETL Developer

Responsibilities:

• Designed and developed ETL Processes based on business rules using Informatica Power Center.
• Worked extensively on complex mappings using source qualifier, joiner, expressions, aggregators, filters, and lookup and update strategy transformations.
• Used repository views in mappings in order to get the load status.
• Used workflow monitor to monitor the jobs, reviewed error logs that were generated for each session.
• Developed standard and re-usable mappings and mapplets using various transformations like Stored Procedure, Expression, Aggregator, Joiner, Source Qualifier, Router, Lookup, and Filter.
• Designed and developed the workflows, validated the dependencies in between the workflows which involved various tasks like event-wait, command, session tasks.
• Developed reusable transformations and mapplets.
• Migrated Informatica Objects (Mappings, Work-flows and Sessions) from Dev/Test environment to Production environments by creating deployment groups.
• Involved in Performance Tuning of the mappings, used Informatica Debugger.
• Introduced partitioning in sessions based on data regions.
• Also Involved in Informatica Administrative support activities to grant access to the users, code migration, Label creation and adding the objects for the migration etc.,

Tools and Environment: Informatica PowerCenter, Oracle 9i, Flat files, SQL, Erwin, SQL Developer, Unix, JIRA, Confluence and Rally

Confidential

Senior ETL Developer

Responsibilities:

• Involved in the review and walkthrough of the business and technical requirements documents.
• Involved in creating the Webservices and testing them using SOAP UI tool.
• Involved in creating Webservice definitions and developed corresponding WSDL’s for different Webservices.
• Extensively used Data transformation as part of developing the Informatica B2B code.
• Extensively created mapping/mapplets using all the transformations like joiner, lookup, filter, expression, stored procedure, aggregator, update strategy, webservices consumer, SQL.
• Involved in creating UNIX shell scripts for scheduling the jobs using PMCMD and generating the Parameter Files, Manipulate/Archive Source Files.
• Worked on the complete end-to-end processing of the Claims Information. Helped to debug and modify Informatica maps for 837 processing.
• Created, optimized, and executed SQL test queries to validate transformation rules used in source to target mappings/source views, and to verify data in target tables.
• Involved in tuning the SQL queries and the long running ETL mappings.
• Extensively worked with the QA team to ensure that the System and Integration test plans are completed successfully.
• Involved in trouble shooting the performance issues.

Tools and Environment: Informatica PowerCenter , DB2, SQL Server, Web application and SFDC

Confidential

ETL Developer

Responsibilities:

• Developed Transformation logic and designed various complex Mappings in the Designer for data load and data cleansing.
• Responsible for using the capabilities of PowerCenter namely list files, pmcmd, pmrep, Target override, Persistent lookup, Dynamic & Static lookup.
• Develop Logical and Physical data models that capture current state/future state data elements and data flows using Erwin.
• Created and Monitored Workflows using Workflow Manager and Workflow Monitor.
• Developed Informatica Mappings , Re-usable Transformations , and Mapplets for data load to data warehouse and database.
• Involved in creating ETL model ( snowflake schema ), normalizing and documenting .
• Involved in Re-Design that includes dynamic creation of the logic when the new data is added to the system avoiding recoding.
• Walked through the Logical and Physical Data Models of all source systems for data quality analysis .
• Support between developers and end users, functional managers and Teradata regarding issues with database software , SQL programming , tuning , releases and development with Teradata utilities like Mload, Fastload and Tpump .
• Used Mload, Fastload utilities to load the data into warehouse

Tools and Environment: Informatica PowerCenter 8.6 and 9x, Teradata 7.1, UNIX AIX, Windows XP, Flat files (Host - VSAM file), ERWIN

Confidential

ETL Developer

Responsibilities:

• Created Informatica ETL mappings that transfer data from Oracle source systems to the Data Mart.
• Involved in designing of star schema based data model with dimensions and facts.
• Wrote shell scripts in UNIX environment.
• Involved in writing lot of Functions, Stored Procedures in PL/SQL as per the requirements.
• Used Dashboards and created complex SCD type 2 mappings using dynamic lookup , Joiner , Router , Union , Expression and Update Transformations.
• Partitioned sources to improve session performance .
• Developed data-driven approaches to support event-based job workflow scheduling.
• Performance Tuning of Sessions and Mappings.
• Developed several complex Mappings, Mapplets and Reusable Transformations to facilitate one time and Monthly loading of Data.
• Creating Relational Connections , Migrating the Mappings from Dev to Test and Test to Production.
• Created design documents and performed Unit Testing on the Mappings.
• Created scripts to load the data with Fastload to load the stating tables (Volatile tables).
• Created scripts to Mload scripts to load the data into multiple tables.
• Worked with Global temporary tables to validate the data in Unit testing

Environment: Informatica Power Center 8.1/7.1.3, Business Objects 6.0, ERWIN 4.0, XML, Teradata V2R6, UNIX, Windows.

Confidential

ETL Developer

Responsibilities:

• Data Analysis to extract useful data, finding patterns and regularities from the sources and develop conclusions.
• Developed number of complex Ab>Initio Graphs and reusable components to implement the business logic and to load the data incrementally. Created table mappings to load Fact and Dimension tables.
• Developed Ab>Initio graphs by usage of input/output datasets, Aggregator, Reformat, XFRs, PDLs, Lookups, parameters Created multiple Type 2 mappings in the Customer mart for both Dimension as well as Fact tables, implementing CDC logic.
• Ab>Initio graphs loaded data into Teradata database as per business logic and validation scripts prepared in Teradata.
• Have worked on performance tuning of the SQL used in BTEQs and Fastexport utilities. Currently ETL (Informatica) Processes pulls data from various sources including teradata, oracle, Unix Flat files, Mainframe etc and loads it into Teradata. Used Bteqs, Mloads, Fastloads and Tpump to load the data. This is an ETL maintenance/Enhancement project and aims at improving the current performance of the existing processes.

Tools and Environment: Ab Initio GDE 1.14.37, repository EME and Co>op sys 2.13.3, TeradataV2R6, UNIX, and Hummingbird