SUMMARY

• 5+ years of expertise in Analysis, Design, Development, Implementation, Modeling, Testing, and support for Data warehousing applications.
• Extensive experience in using Informatica tool for implementation of ETL methodology in Data Extraction, Transformation and Loading.
• Extensively worked on Dimensional modeling, Data migration, Data cleansing and Data Staging of operational sources using ETL processes and providing data mining features for data warehouses.
• Involved in Full Life Cycle Development of building a Data Warehouse.
• Extensive experience with Healthcare, Financial Investment and Retail .
• Have clear understanding of Data warehousing and Business Intelligence concepts with emphasis on ETL and life cycle development Using Informatica PowerCenter (Repository Manager, Designer, Workflow Manager and Workflow Monitor).
• Worked on Slowly Changing Dimensions (SCD’s) and its implementation to keep track of historical data.
• Actively involved in Performance Tuning, Error handling Product support on various Platforms.
• Experience in coding using SQL, SQL * plus, PL/SQL procedures/functions, triggers and exceptions. Good experience in Relational Database concepts, Entity relation diagrams.
• Have work experience with Relational data model Erwin 4.0.
• Performed system Analysis and QA testing and involved in Production Support.
• Expertise in OLTP/OLAP System Study, Analysis and E - R modeling, developing database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional data modeling.
• Experience in UNIX working environment, writing UNIX shell scripts for Informatica pre & post session operations.
• Experience creating reports using Report Studio (IBM Cognos)
• Experience in implementing update strategies, incremental loads and change Data capture.
• Knowledge of complete software development life cycle including Requirement Analysis, Requirement Gathering, Cost Estimation, Project Management, Design, Development, Implementation and Testing.
• Excellent communication and interpersonal skills. Ability to work effectively as a team member as well as an individual.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 10/ 9. 6.1/9.5 .0/9.1 (Source Analyzer, Repository Manager, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager, Workflow Monitor, Warehouse Designer and Informatica Server), Data Quality 10.2. Master Data Management.

Operating Systems: Microsoft Windows 7/Vista/XP/2000/NT, UNIX

Language: SQL, PL/SQL, XML, UNIX Shell Scripting

Business Intelligence: OBIEE, IBM Cognos

Database: Oracle 11g/10g/9i/8i, SQL Server, DB2, Teradata V2R5, Netezza

Reporting Tools: Crystal Reports, Tableau

Tools: /Utilities: PLSQL Developer, TOAD, SQL Developer, Erwin, Microsoft Visio, Talend 5.3.1

Scheduler: Control-M, AutoSys, Active Batch 7

PROFESSIONAL EXPERIENCE

Confidential

Informatica Data Quality Developer

Responsibilities:

• Using Informatica Data Quality 10.2 Designer and using transformations like Source Qualifier, Expression, Filter, Router, Joiner, Sequence generator, Update Strategy, Lookup, Sorter, Aggregator, XML Source Qualifier, Stored Procedure etc. for extraction, transformation and loading of data.
• Using Master Data Management SIF calls to do activities on MDM schema like Execute Batch Group, Clean Schema, Search Match etc.
• Working on IDQ Web Services to process the data in real time and load into MDM base object tables.
• Integrate Real time web services to make them consumable by the Java team.
• Creating Mapping Variables, Mapping Parameters and Session Parameters to increase the re-usability of the Mappings.
• Creating various Batch Scripts for scheduling various data cleansing scripts and loading processes.
• Implemented performance tuning logic on targets, sources, mappings, and sessions to provide maximum efficiency and performance.
• Extensively using Informatica debugger to eliminate the bottlenecks for optimum performance. Also involved in troubleshooting existing ETL bugs.
• Communicate with different team members to provide the best solution and make the whole team aware of process.

Environment: Informatica Data Quality, Master Data Management SIF calls, SQL Server Management Studio, JIRA, Confluence

Confidential

ETL Technical Lead

Responsibilities:

• Used Informatica 9.6.1 PowerCenter Designer and used transformations like Source Qualifier, Expression, Filter, Router, Joiner, Sequence developer, Update Strategy, Lookup, Sorter, Aggregator, Normalizer, XML Source Qualifier, Stored Procedure etc. for extraction, transformation and loading of data.
• Improved mapping performance by analyzing the mapping and doing the SQL and Informatica Code changes.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Created Design Specification Documents to understand the high level of the project with Client.
• Created Mapping Specification Documents with SME to implement the informatica code properly.
• Created Rollback Stored Procedure to roll back data loaded.
• Used Netezza as source database to extract data.
• Loaded 4 years of history data into target database and defect resolution.
• Review code from development team and schedule the deployment into higher environment.
• Extensively used Informatica debugger to eliminate the bottlenecks for optimum performance. Also involved in troubleshooting existing ETL bugs.
• Used B2B, Unstructured Data Transformation and experience in EDI files.
• Used Mapping Variables, Mapping Parameters and Session Parameters to increase the re-usability of the Mappings.
• Used Informatica Update Else Insert session property and Update Override extensively to improve the performance of the data loads.
• Used Push Down Optimization to improve the performance of the system.
• Created various batch Scripts for scheduling various data cleansing scripts and loading process.
• Used Erwin for Logical and Physical data modeling and designed Star Schemas.
• Extensively used informatica developer tool for IDQ for address validator.
• Worked as Production support to manage the resolve the issue on demand basis in higher environment or in cases when code needs to be changed directly into production.
• Hosted On-site and Off-Shore meeting to receive daily status and be in sync.

Environment: Informatica 9.6.1 (Power Center Repository Manager, Designer, Workflow Manager, and Workflow Monitor, developer), Tableau, Oracle 11g, SQL Developer, PLSQL, SQL, Control M, IDQ

Confidential

Informatica ETL Developer

Responsibilities:

• Used Informatica 9.6.1 PowerCenter Designer and used transformations like Source Qualifier, Expression, Filter, Router, Joiner, Sequence developer, Update Strategy, Lookup, Sorter, Aggregator, Normalizer, XML Source Qualifier, Stored Procedure etc. for extraction, transformation and loading of data.
• Used Talend 5.3.1 for profiling the data and accessing the data quality of the source data.
• Created new Pre-stage tables and staging tables for the data loads.
• Developed complex mappings in Informatica to load the data from various sources.
• Created Stored procedures to use oracle generated sequence numbers in Mappings instead to using Informatica Sequence generator.
• Created RollBack Stored Procedure to roll back data loaded.
• Created complex Mappings and implemented Slowly Changing Dimensions (Type 1, Type 2 and Type 3) for data loads.
• Created complex Mappings to implement data cleansing on the source data.
• Created Mappings to implement one time as well as Incremental loads.
• Created Mappings to load 150 million historical Transactions.
• Extensively used Informatica debugger to eliminate the bottlenecks for optimum performance. Also involved in troubleshooting existing ETL bugs.
• Used Mapping Variables, Mapping Parameters and Session Parameters to increase the re-usability of the Mappings.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Used Informatica Update Else Insert session property and Update Override extensively to improve the performance of the data loads.
• Developed Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings.
• Created various batch Scripts for scheduling various data cleansing scripts and loading process.
• Created Technical Documentation for all the developed mappings for presentation with Business.
• Used Erwin for Logical and Physical data modeling and designed Star Schemas.
• Extensively used informatica developer tool for IDQ.

Environment: Informatica 9.6.1 (Power Center Repository Manager, Designer, Workflow Manager, and Workflow Monitor, developer), SAP Business Objects 4.0, Oracle 11g, SQL Developer 3.2.1, Toad, PLSQL, SQL, Control M, Talend 5.3.1, ERWIN, IDQ

Confidential

Informatica Production Support

Responsibilities:

• Interacting with the clients on a regular basis to discuss day-to-day issues and matters Provide support for Informatica workflows/mappings (developed using Informatica 9.6.1 and Informatica 9.5.0) which are running into Production environment at client location
• Conduct training and knowledge sharing sessions to the developers and testers on Healthcare domain and functional areas.
• Worked on IBM ticketing tools Rational ClearQuest, ClearCase and VersionOne.
• Resolved tickets within SLA agreement.
• Ensuring top-quality deliverables from Xerox to the client.
• Involved in data analysis and handling the ad-hoc requests by interacting with business analysts, clients and customers and resolve the issues as part of production support
• Developing UNIX shell scripts for automating and enhancing/streamlining existing manual procedures used at client location
• Involved in the development of Informatica mappings and preparation of design documents, technical specification documents and unit testing documents.
• Actively participating in proving technical proposals and Informatica upgraded from 9.5.0 to 9.6.1.
• Working off hours and on call support.
• Verify the workflow job status and Execution sequence.

Environment: Informatica 9.6.1/9.5.0 (Power Center Repository Manager, Designer, Workflow Manager, and Workflow Monitor), Oracle 11g, SQL Developer, PLSQL, SQL