SUMMARY:

• 10+ years of experience on Informatica Power center 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 Sales,Health Care, Clinical, Banking, Finance, Pharma, Manufacture Systems.
• 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.
• 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, IDQ

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

Environment: Windows, Unix.

Tools: Toad

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.
• Created Conceptual model based on the business process and identified the entities, attributes and relationships and converted the conceptual model to the Physical and logical data model
• Converted the logical model to Physical Model by giving accurate data types, created indexes on keys and forward engineered the DDL.
• Worked with business Analyst to gather the business requirements and created functional and non-functional requirements documents.
• Experience in loading Dimension, Fact stage and Fact tables
• Developed mappings using various transformations like Update strategy, Lookup, Router, Filter, Sequence Generator, Joiner,JAVA Expression.
• Worked with different sources such as Oracle, Flat files.
• Using Workflow manager for Workflow and Session Management, database connection management and Scheduling of jobs. performing Veeva source data analysis and data validation, producing requirements gathering and writing functional specifications, performing workflow analysis
• Performed many multiple tasks effectively and involved in troubleshooting the issues.
• Experience in deploy informatica objects Dev,UAT and Production Environments
• Helping the reporting Qlik view team to understand the functionality and monitor the reports.
• Experiencing in performance tuning by using PDO in target level.
• Created references tables, applications and workflows and deployed that to Data integration service for further execution of workflow.
• 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 tables

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

Confidential NJ

Sr. ETL Informatica 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. performing healthcare data analysis and data validation, producing requirements gathering and writing functional specifications, performing workflow analysis
• Used IDQ’s standardized plans for addresses and names clean ups.
• Worked on IDQ file configuration at user’s machines and resolved the issues.
• Used IDQ to complete initial data profiling and removing duplicate data.
• Performed many multiple tasks effectively and involved in troubleshooting the issues.
• Created references tables, applications and workflows and deployed that to Data integration service for further execution of workflow.
• Used IDQ to profile the project source data, define or confirm the definition of the metadata, cleanse and accuracy check the project data, check for duplicate or redundant records, and provide information on how to proceed with ETL processes.
• 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, PL/SQL, SAP, IDQ,TOAD, Windows.

Confidential , DE

Sr. Informatica Developer.

Responsibilities:

• 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.
• Outage Handling (Escalation Procedure, running metadata queries and procedures, checking database, creating outage log)
• Performed migration of mappings and session from Dev to Test repository, taking backup and restoring of Informatica Repository, upgrades and security issues.
• Involved in migration of Informatica objects in all phases (DEV, INT and PRD) of project and trained developers to maintain system when in production.
• Regular monitoring of the informatica server environment on UNIX Server.
• 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 and XML sources.
• Using Workflow manager for Workflow and Session Management, database connection management and Scheduling of jobs.
• Responsible for writing complex SQL queries in Informatica Mapping and developing stored procedures using PL/SQL.
• Performance tuning of targets, sources, mappings and sessions using various components like parameter file, variables and partitioning concepts.
• 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

Environment: Informatica Power Center 9.x,8.x, (Source Analyzer, Warehouse Designer, Mapplet Designer, Mapping Designer and Transformation developer) SQL, PL/SQL, SAP, Oracle 10g, TOAD, 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
• Responsible in fixing issues with complex mappings.
• Gap Analysis of existing Cognos reports and Informatica 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, PL/SQL, Oracle 10g, 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