PROFESSIONAL SUMMARY:

• Informatica Professional with 7+ year of IT consulting experience in analysis, design, development, testing and implementation of Data Management projects using ETL (Informatica Powercenter and Informatica Data Quality) and Databases (Oracle and Microsoft Sql Server). Exposure to various domains like Health care and Manufacturing.
• Experience in Data Extraction, Transformation and Loading data using Informatica Power Center 9.6.1/10.0
• Experience in designing complex mappings using Source Qualifier, Update Strategy, Expression, Sequence Generator, Aggregator, Filter, Joiner, Router, Connected Lookup, Unconnected Lookup, Normalizer, Rank, XML, Sorter, Transaction Control and Union to load data into different target types from different sources like Flat files (Delimited files and Fixed width files) like text files or CSV files, Oracle, SQL server.
• Worked on Workflow Manager by creating Sessions/tasks, Workflows, Worklets, Reusable Tasks like Sessions, Command, Email and Non - Reusable tasks like Decision, Event Wait and Event Rise.
• Experience in Creating Data Quality Rules, Mappings, Profiles and Scorecards
• Experience in Informatica Address Doctor configuration
• Experience in Scheduling Tools like Control-M and Informatica inbuilt schedulers.
• Worked with Powercenter Based version control
• Experience in Integrating Informatica Powercenter and Informatica Data Quality.
• Experience in using the Informatica command line utilities like PMCMD, PMREP and INFACMD to execute Powercenter\Data Quality workflows.
• Knowledge on Data Cleansing, Data Staging, Data profiling, Error Handling, Session log files, Workflow log files and Performance optimization like Pushdown Optimization (PDO), session partitioning, which troubleshoots the bottleneck problems at different levels like source, target, mapping, session and system.
• Worked on different databases versions of Oracle and SQL Server
• Good Knowledge of Data Warehousing/Data Modeling using ERwin, staging tables, stored procedures, Functions, cursors, Dimension tables, Fact tables, Surrogate Key, Primary keys, Foreign Keys, Star Schema, Snow Flake Schema, Triggers and Normalization/Denormalization.
• Knowledge on Slowly Changing Dimensions (SCD) Type 1, Type 2 and Type 3, Data Marts, OLAP, OLTP and Change Data Capture (CDC).
• Experienced in performance tuning like creating indexes at database level.
• Good understanding of PL/SQL procedures.
• Experience in using Oracle Development tools such as Tool for Oracle Application Development (TOAD).
• Good Knowledge on Oracle utilities like SQL Loader, SQL Developer.
• Hands on experience in writing Simple/Complex SQL Queries sing Sub queries and multiple table joins using left, right, inner joins.
• Experience in UNIX Shell Scripting and batch scripting for creating executing informatica jobs through command line.
• Good communication skills both verbal and written, hardworking, self-motivated, ability to work independently or co-operatively in a team, eager to learn and ability to grasp quickly.
• Good experience in ETL technical documentation.
• Open learner of new modules and functionality/technology depending on project needs.

TECHNICAL SKILLS:

ETL: Informatica PowerCenter 9.6.1/10.0, Informatica Data Quality 9.6.1/10.0

Databases: Oracle 11g,12c, SQL Server 2012/2008/R2

Methodologies: Star schema and Snowflake schema

Languages: SQL, PL/SQL, JAVA, UNIX shell scripting, Batch scripting

Operating system: UNIX, Windows Server, Linux

Tools: Putty, WinSCP, Toad, Control-M, SVN

Utilities: SQL Loader

PROFESSIONAL EXPERIENCE:

Confidential, New Jersey

ETL Informatica Developer

Responsibilities :

• Analysis of source systems, business requirements and identification of business rules.
• Creation of data Quality Profiles and Scorecards to Analyze and monitor data quality
• Creation of Reference tables to maintain reference data required for Standardization
• Creation of standardization process for solving the data quality issues
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica PowerCenter.
• Worked on complex mappings, mapplets and workflow to meet the business needs ensured they are reusable transformation to avoid duplications.
• Worked on Mbox to read and write files between systems
• Extensively used ETL to transfer and extract data from source files (Flat files), load the data into the Stage database and to target files .
• Documented Mapping and Transformation details, user requirements, implementation plan and schedule.
• Used Control-M for Scheduling and monitoring.
• Designed and developed efficient Error Handling methods and implemented throughout the mappings.
• Worked with several facets of the Informatica PowerCenter tool - Source Analyzer, Data Warehousing Designer, Mapping & Mapplet Designer and Transformation Designer. Development of Informatica mappings for better performance.
• Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level and the Target Level.
• Prepared Unit/ Systems Test Plan and the test cases for the developed mappings.

Environment: Informatica Power Center 10.0, Informatica Data Quality 10.0, Unix, Toad for Oracle Oracle 11g,12c, Putty, Winscp, Mbox (managed file transfer)

Confidential, King of Prussia, PA

ETL Informatica Developer

Responsibilities:

• Extraction, Transformation and Loading (ETL) of data by using Informatica Power Center.
• Mostly worked on the Data Migration part from different databases to Oracle along with the ETL.
• Worked on Informatica Designer Tool’s components - Source Analyzer, Transformation Developer, and Mapping Designer.
• Wrote SQL-Overrides and used filter conditions in source qualifier thereby improving the performance of the mapping.
• Worked with Functional team to make sure required data has been extracted and loaded and performed the Unit Testing and fixed the errors to meet the requirements.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Worked with Static, Dynamic and Persistent Cache in lookup transformation for better throughput of Sessions.
• Developing Informatica mappings, SQL queries and tuning them when necessary.
• Developed Informatica mappings and Mapplets by using various transformations like Lookup, Joiner, Expression, Aggregator, Update Strategy etc.
• Implemented complex business rules in Informatica Power Center by creating re-usable transformations, and robust Mapplets.
• Worked with Mapping Parameters and session parameters to pass the values dynamically.
• Extensively used ETL tool informatica to load data into Siebel database tables.
• Implemented Type 1 Slowly Changing Dimensions.
• Involved in the implementation of Master data management and supports whenever required.
• Extracted data from heterogeneous sources like oracle, fixed width and Delimited Flat files Transformed the data according the business requirement and then Loaded into multiple databases
• ETL Monitoring in DAC and Development of DAC Tasks.
• Map the requirements with the BI solution using Informatica ETL tool
• Performance tuning of ETL Mappings to reduce loading times
• Supporting day to day technical issues of the Business users
• Involved in Code Migration Dev to Test and Test to Production

Environment: Informatica Power Center 9.1, Workflow Manager, Workflow Monitor, Repository Manager, Oracle 11g, Unix, Remedy, Jira, DAC, SQL Developer, PL/SQL.

Confidential

ETL Informatica Developer

Responsibilities:

• Created analysis of source systems, business requirements and identification of business rules.
• Creation of data Quality Profiles and Scorecards to monitor data quality
• Creation of Reference tables to maintain reference data required for Standardization
• Creation of standardization process for solving the data quality issues
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica PowerCenter.
• Worked on complex mappings, mapplets and workflow to meet the business needs ensured they are reusable transformation to avoid duplications.
• Worked on SFTP server to read and write files between systems
• Extensively used ETL to transfer and extract data from source files (Flat files), load the data into the Stage database and to target files.
• Documented Mapping and Transformation details, user requirements, implementation plan and schedule.
• Used Informatica inbuilt scheduler for Scheduling and monitoring.
• Designed and developed efficient Error Handling methods and implemented throughout the mappings.
• Worked with several facets of the Informatica PowerCenter tool - Source Analyzer, Workflow manager, Mapping Designer & Mapplet Designer and Transformation Designer. Development of Informatica mappings for better performance.
• Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level and the Target Level.
• Prepared Unit/ Systems Test Plan and the test cases for the developed mappings.
• Involved in environment setup and migration of Code to different environment.
• Preparation of Technical Specifications during following phases of project like, Analysis, Detailed Design, Code Walkthrough.

Environment: Informatica Power Center 9.6.1, Informatica Data Quality 9.6.1, Unix, Microsoft SQL server 2008 R2, Putty, WinSCP, SFTP server

Confidential

Informatica developer

Responsibilities:

• Involved in the requirements definition and analysis in support of Data Warehousing efforts
• Worked on ETL design and development, creation of the Informatica source to target mappings, sessions and workflows to implement the Business Logic.
• Created Informatica mappings with PL/SQL Procedures/Functions to build business rules to load data.
• Used most of the transformations such as the Source qualifier, Aggregators, Lookups, Filters, Sequence and Update strategy, Router.
• Data cleansing, data validation, data profiling and matching/removing duplicate data.
• Designed and developed Informatica DQ Jobs, Mapplets using different transformation like Address validator, matching, consolidation, rules etc. for data loads and data cleansing.
• Scheduled and Run Workflows in Workflow Manager and monitored sessions using Informatica Workflow Monitor.
• Involved in Data Quality checks by interacting with the business analysts.
• Performing Unit Testing and tuned the mappings for the better performance.
• Maintained documentation of ETL processes to support knowledge transfer to other team members.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and automated execution of workflows.
• Validated and tested the mappings using Informatica Debugger, session logs and workflow logs

Environment : Informatica Power Center 8.6.1, SQL Server, Oracle 11g, Flat files, MySQL, Teradata 13, Notepad++, Toad, UNIX scripting, Windows NT.