SUMMARY:

• 10+ years of experience on Informatica Power center, Informatica PowerExchange / Power Connect in all phases of Design, Development, Implementation and support of Data warehousing applications using Informatica power center 10.x,9.x& 8.x, SQL, PL/SQL, Oracle and Unix.
• Full life - cycle project delivery experience from product definition to implementation including: requirements and specification writing, design documentation, unit and system testing, optimization and performance analysis, quality assurance, and release into a production environment.
• Expertise knowledge in domains like Health Care, Clinical, Banking, Finance, Pharma, Manufacture Systems.
• Good knowledge on Master Data Management concepts, Data warehousing concepts and relational database management Systems and dimensional modeling.
• Created Functional, Technical Design and Data mapping documents by Interacting with Customers subject matter expert (SME). In Addition, participating in requirement gathering, Analysed the requirements.
• Formulated the functional rules into technical documents by interaction with business users.
• Experienced in creating entity relational & dimensional relational data models using Kimball Methodology i.e. Star Schema and Snowflake Schema.
• Experience in implementing the business rules by creating transformations like (Expression, Aggregate, Lookup, Router, Rank, Update Strategy, Transaction Control), and developing Mapplets and Mappings. Worked with different data sources like Flat Files and Relational Databases. Good Knowledge of Data Warehousing Concepts.
• Strong in using workflow tasks like Session, Control Task, Command tasks, Decision tasks, Event wait, Email tasks, Pre-sessions, Post-session and Pre/Post commands
• Extensively worked with Teradata utilities like BTEQ, Fast Export, Fast Load, Multi Load to export and load data to/from different source systems including flat files.
• Designed Data Mart for Reporting using Star Schema & Multi-dimensional Analysis.
• Sound knowledge on Informatica IDQ, and Informatica MDM
• Extracted Data from multiple operational sources of loading staging area, Data Warehouse and data marts using SCD (Type1/Type2/Type3) loads.
• Involved in migration of objects in all phases (DEV, QA and PRD) of project and trained developers to maintain system when in production.
• Well acquainted with session partitioning and Performance Tuning of sources, targets, mapping and sessions to overcome the bottlenecks in mappings. Trouble shooting and problem solving applications with Informatica Debugger.
• Extensive experience in creating SQL statements and creating automated jobs using TOAD and SQL Navigator. Proficient in development of Stored Procedures, Functions, Database Triggers, Cursors, Packages, User Defined Functions using PL/SQL.
• Excellent experience in understanding and following coding standard and business norms, handover and takeover of responsibilities. Job responsibilities included system study, design, development, testing and implementation stages.

TECHNICAL SKILLS:

ETL: Informatica Power Center 10.x,9.x,8.X, Data Mart, OLAP, OLTP and IDQ.

Databases: Oracle 11g/10g/9i, Sql Server 2005/2008 R2.

Environment: Windows, Unix.

Tools: Toad,HPQC,ALM

Other Technologies: PL/SQL, SQL

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Sr. ETL Lead Developer

Responsibilities:

• Defines the business process flow in a standard manner and describes the process logic of invocation of the involved web services.
• Developed Unit Test cases for each case in specific modules to test the functionality.
• Involved in writing SQL Queries, PL/SQL procedures, functions, packages, Triggers, Views and materialized views.
• Developed mappings using various transformations like Update strategy, Lookup, Stored Procedure, Router, Filter, Sequence Generator, Joiner, Aggregator, Expression, SQL transformation.
• Worked with different sources such as Oracle, Flat files.
• Using Workflow manager for Workflow and Session Management, database connection management and Scheduling of jobs.
• Extensively worked with Teradata utilities like BTEQ, Fast Export, Fast Load, Multi Load to export and load data to/from different source systems including flat files. performing healthcare data analysis and data validation, producing requirements gathering and writing functional specifications, performing workflow analysis
• Was also involved in development of Unix scripts for doing some basic operations like merging of files, removing header from files etc
• Responsible for cleansing the legacy data by discussing with state people and making them aware of data issues and finding the logics to convert the legacy data in order to fit the target Curam design.
• Experienced in creating entity relational & dimensional relational data models using Kimball Methodology i.e. Star Schema and Snowflake Schema.

Environment: Informatica Power Center 9.x,8.x, (Source Analyzer, Warehouse Designer, Mapplet Designer, Mapping Designer and Transformation developer) SQL, Oracle 10g, TOAD, Windows.

Confidential, DE

Sr. Informatica Developer

Responsibilities:

• Created multiple landings and Business Objects and created source systems to create staging tables and defined relationship between the Base Object’s
• Configured Audit Trails and Delta Detection in Mapping Settings to load RAW and PRL tables
• Configured Lookup in staging tables based on foreign key relationships
• Created complex mappings by using cleanse functions and configured stage process.
• Defined trust on various source columns and Configured Validation rules to load trusted data in Base Object’s
• Created match rules like fuzzy match for finding the probabilistic match of the records and exact match for finding the exact match of the records in Base Objects.
• Configured queries and packages to view data in Base Object’s and PUT Packages for manual Merge Process
• Configured Cleans match server for Cleanse functionality and other third party servers for scheduling and secure authentication
• Importing schema from both Hub console built in Databases and external Databases
• Configured Batch Jobs to execute Stage, load, Match and Merge processes and analyzed Load Jobs in Batch Viewer for resolving Bugs/errors
• Run the tokenization process, Match process and used various tables like XREF, MTCH, STRP, RAW, REJ
• Executed manually Data Management tools in MDM Hub to search, edit, flag, merge records queued for merging and unmerging the records in Base Objects
• Worked on server logs for troubleshooting information for support purpose
• Used user exists for constraints based loading and for other Business requirements
• Configured users and user groups and created various roles for secure access of application user in SAM

Environment: Informatica Power Center 9.x,8.x, (Source Analyzer, Warehouse Designer, Mapplet Designer, Mapping Designer and Transformation developer) SQL, Informatica MDM, Windows.

Confidential

Informatica Developer

Responsibilities:

• ETL Design for the Informatica mappings.
• Data analysis and Operation Data store which will be source for Data warehouse.
• Performed migration of mappings and session from Dev to Test repository, taking backup and restoring of Informatica Repository, upgrades and security issues. complex SQL queries in Informatica Mapping and developing stored procedures using PL/SQL.
• Performance tuning of Developed mappings using various transformations like Update strategy, Lookup, Stored Procedure, Router, Filter, Sequence Generator, Joiner, Aggregator, Expression, SQL transformation.
• Worked with different sources such as Oracle, Flat files.
• Using Workflow manager for Workflow and Session Management, database connection management and Scheduling of jobs.
• Responsible for writing targets, sources, mappings and sessions using various components like parameter file, variables and partitioning concepts.
• Worked closely with the DBA team for production and opps team to schedule the maintenance activities for better results in production.
• Designed Data Mart for Reporting using Star Schema & Multi-dimensional Analysis.
• Responsible for creating connections to the Oracle Database for the Source and target tables in informatica to create the sessions.
• Was also involved in development of Unix scripts for doing some basic operations like merging of files, removing header from files etc worked with Teradata utilities like BTEQ, Fast Export, Fast Load, Multi Load to export and load data to/from different source systems.
• Responsible in fixing issues with complex mappings.
• Design and implement the error handling process for the existing data warehouse.

Environment: Informatica Power Center 8.6 (Source Analyzer, Warehouse Designer, Mapplet Designer, Mapping Designer and Transformation developer) SQL, Oracle 10g, TERADATA, TOAD, Windows 2000

Confidential

Informatica Developer

Responsibilities:

• Created and Imported/Exported various Sources, Targets, and Transformations using Informatica Power Center Designer.
• Developed number of Complex Informatica Mappings, Mapplets and Reusable Transformations for the Sales and Marketing Systems to facilitate one time, Daily, Monthly and Yearly Loading of Data.
• Created ER Diagram representation including existing source systems by using Ervin Tool.
• Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and the Target Data.
• Experience in Create, backup, restore for Informatica Repositories.
• Maintain all necessary updates and/or patches for the ETL environments.
• Monitors and tunes ETL repository and system for performance improvements
• Ability to perform root cause analysis, performance monitoring and application related issues
• Coordinate deployments that include Informatica deployments as well as probably Unix Shell Script and Database DDL deployments
• Write Repository Queries in support of developments and Production statistics
• Developed Mappings for the Category, Specification, Code, Type areas.
• Responsible to design, develop and test the software (Informatica, PL SQL, UNIX shell scripts) to maintain the data marts (Extract data, Transform data, Load data)
• Providing solutions to improve efficiency (e.g., reduce costs while maintaining or improving performance levels).
• Optimized SQL queries for better performance using Hints, Indexes and Explain Plan.
• Involved in the development and testing of programs, Informatica mappings and update processes.
• Designed and developed complex Aggregate, Join, Router, Look up and Update transformation rules (business rules).
• Developed schedules to automate the update processes and Informatica Sessions/Batches.

Environment: Informatica Power Center 8/7.1, Oracle 9i, TOAD, SQL, PL/SQL, UNIX