PROFESSIONAL SUMMARY:

• About 7+ years of overall experience in the Information Technology Industry.
• Excellent knowledge of waterfall and agile methodologies of System Development Life Cycle (SDLC).
• Experience in Data Warehousing using various ETL tools Informatica, SQL Server and Data Quality.
• Good understanding of Ralph Kimball approach and experience in Dimensional data modeling, Star schema modeling, Snow - Flake modeling, identification of fact and dimension tables, Normalization, Physical and Logical data Modeling.
• Vast experience in designing and developing complex mappings for strong Data Warehouse using Informatica Power Center 9.5/9.1/8.6.1/8.5./8.1.1/8.0 (Source Analyzer, Data Warehousing Designer, Mapping Designer, Power plugs, Mapplet, Transformations), Warehouse Designer, DB2, Oracle 11g/10g/9i/8i.
• Expertise in Designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Data Transformation Services, SQL Transformation, Normalizer Transformation etc.
• Experience in creating mapping Parameters, Variables and Reusable Tasks (Sessions, Command, Email) and Non-Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment, Worklet, Control).
• Data profiling using Informatica analyst tool.
• Parsing, Standardization, Matching, and ETL integration implementations.
• Extensively worked on developing and debugging Informatica mappings, mapplets, sessions and workflows.
• Address data cleansing using Informatica Address Doctor to discover deliverable personal and business addresses.
• Strong Understanding of Exception Management Processes in Informatica.
• Experienced in Error Handling and Troubleshooting Techniques and resolving Informatica domain/service issues using various log files.
• Installation and Configuration of Informatica software including PowerCenter and Developer core services.
• Experience in upgrading Informatica domain and services and knowledge in latest functionalities of the tools.
• Installed and Configured Metadata Manager and Business Glossary.
• Worked on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Understanding & working knowledge of Informatica CDC (Change Data Capture) Implementation experience of CDC using stored procedures, triggers and using Informatica power exchange.
• Experience in using scheduling tools Autosys, Robot/Schedule to automate running of Informatica Workflows on a daily Batch Jobs
• Experienced in working with tools like TOAD, SQL Server Management studio and SQL plus for development and customization.
• Knowledge in using pmcmd commands.
• Strong skills in data analysis, data requirement analysis and data mapping for ETL processes.
• Very good understanding on Informatica MDM hub process, landing, staging and loading.

TECHNICAL SKILLS:

ETL Tools:: Informatica Power Center 9.x/8.x/10.x

EIM Tools:: Informatica Data Quality 9.x/10.x

Data Modeling:: ERwin 4.0

Databases:: Oracle 11g/10g/9i, Teradata 13.10, MS Access, Netezza, DB2, MS SQL Server 2012

Database Tools:: TOAD, SQL*PLUS, SQL Developer

Programming Tools:: C, C++, SQL, PL/SQL, Unix Shell scripting

Operating Systems:: Windows XP/ 2008/2003/2000/ NT/98/95, UNIX (Solaris, AIX).

Packages:: MS Office

Scheduler:: Informatica Scheduler, Autosys, Robot/Schedule

Reporting:: Business Objects 4.0, Tableau

PROFESSIONAL EXPERIENCE:

Confidential, Albany, NY

Informatica Developer/Administrator

Responsibilities:

• Develop and perform quality testing, identifying data quality issues, and the creation of data quality rules.
• Development within Informatica for data quality services and reporting needs.
• Assist in profiling data and developing data quality rules are needed at the business level as a result of data profiling.
• Writing and tuning SQL queries, views, stored procedures, and functions in support of Data Quality.
• Developing technical documentation.
• Following the established Change Management process.
• Providing advisement and estimates for development tasks.
• Logged and monitored the workflows and performance of Informatica through Admin Console and recommended required changes.
• Performed troubleshoots on failing rules and workflows
• Provide support for end-user issues.
• Manage Informatica environments from Development to Production.
• Installed and configured MetaData Manager and Business Glossary and provided a plan to leverage them.
• Configured Data Integration Services and Human Task Services on Admin Console.
• Patched and maintained the Exception Management Process.
• Processed exceptions in data so that they are approved.
• Upgrade and patch Informatica as an Admin as needed in compliance with NYS policy.
• Ensure integrity, reliability, security, and performance of Informatica environments and services.
• Open Informatica service requests and work with Informatica support to resolve issues.
• Migration of Informatica mappings/sessions/workflows from Dev to Production.

Environment: Informatica Developer Core 9.6.1 HF2/10.1.1, Informatica Analyst 9.6.1/10.1.1, MS SQL Server 2012/2016, Windows Server 2008, Windows 7 Enterprise

Confidential, Raleigh, NC

Informatica Data Quality Developer

Responsibilities:

• Prepared High Level Design and Low Level Design based on Functional and Business requirement documents of the project.
• Interacted with subject matter experts and data management team to get information about the business rules for data cleansing.
• Provide high-level design walkthrough on how the solution will be built for each requirement.
• Designed and developed IDQ solution to support MDM Projects
• Assist in code testing, migration, deployment, enhancement and bug fixes.
• Worked with various developer modules like profiling, standardization and matching.
• Designed various mappings and Mapplets using different transformations such as key generator, match, labeler, case converter, standardize, Address Validator, parser and lookup.
• Worked extensively with Address Validator to cleanse the address elements. Created input and output templates.
• Created Reference Tables that include the crop information.
• Incorporated the DQ mapplets into PC Mappings.
• Implemented PC DQ mappings to test the standardized and cleansed new data.
• Move components across various environments like test, UAT, and finally a production environment
• Understanding on Informatica MDM hub process, landing, staging and loading and also understanding on Match and Merge concepts in defining Match path components and Match rules.

Environment: Informatica Developer 9.5.1 HF2, Informatica Analyst 9.5.1, Oracle 11g, SQL Developer, SQL Server 2008, Linux RHEL 6.3, Windows 7

Confidential, NJ

Informatica DQ/ETL Developer

Responsibilities:

• Working with the business users, gather requirements for a new or improved data warehouse using ETL methodology.
• Translating requirements into entity relationships models with the Data Analysts.
• Prepared a plan to study the data using Informatica Data Explorer (IDE) for any unknown or unusual properties of the data.
• Good understanding of relational database management systems like Oracle, PLSQL, and SQL and extensively worked on Data Integration using Informatica for the Extraction transformation and loading of data from various database source systems.
• Prepared Data Quality standardization & cleansing rules using Informatica Data Quality (9.1) using the facts discovered from profile results.
• Performed Data Quality Checks, Cleansed the incoming data feeds as and profiled the source systems data as per business rules using IDQ.
• Have created Match, and Merge rules, developed address validations etc and developed address validations to countries like US, and also developed reusable error handling rules using IDQ
• Reviewed and demonstrated the abnormalities back to the business and made proper adjustments.
• Incorporated the DQ mapplets into PC Mappings.
• Implemented PC DQ mappings to test the standardized and cleansed new data.
• Developed PC Work Flows to create and test daily jobs.
• Where possible, developed Web Service components from DQ mapplets, which could be utilized in real time environments.
• Tested and documented all aspects of project details.
• Move components across various environments like test, UAT, and finally a production environment.

Environment: Informatica Developer 9.1, Informatica Analyst 9.1, Informatica Power center 9.1, Oracle 11g, Windows Server 2008, Flat files, PL/SQL, SQL

Confidential, PA

Informatica ETL Developer

Responsibilities:

• Involved in creating Detail design documentation to describe program development, logic, coding, testing, changes and corrections.
• Extensively involved in writing ETL Specifications for Development and conversion projects.
• Created shortcuts for reusable source/target definitions, Reusable Transformations, mapplets in Shared folder.
• Involved in requirement definition and analysis in support of Data Warehouse.
• Worked extensively on different types of transformations like Source qualifier, expression, Aggregator, Router, filter, update strategy, lookup, sorter, Normalizer, sequence generator, etc.
• Worked with XML files generation through ETL process.
• Defined and worked with mapping parameters and variables.
• Designed and developed transformation rules (business rules) to generate consolidated (fact/summary) data using Informatica ETL tool.
• Performed the performance evaluation of the ETL for full load cycle.
• Checked Sessions and error logs to troubleshoot problems and also used debugger for complex.
• Worked on Parameterize of all variables, connections at all levels in UNIX.
• Created test cases for unit testing and functional testing.
• Coordinated with testing team to make testing team understand Business and transformation rules being used throughout ETL process.

Environment: Informatica Power center 8.6.1, Oracle 10g, Windows XP, Unix Shell Scripts, SQL, PL/SQL, Flat files.

Confidential, West Chester, PA

Informatica Developer

Responsibilities:

• Prepared technical design/specifications for data Extraction, Transformation and Loading.
• Worked on Informatica Utilities Source Analyzer, warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Analyzing the sources, transforming data, mapping the data and loading the data into targets using Informatica Power Center Designer.
• Created reusable transformations to load data from operational data source to Data Warehouse and involved in capacity planning and storage of data.
• Developed complex mappings such as Slowly Changing Dimensions Type II-Time stamping in the Mapping Designer.
• Used various transformations like Stored Procedure, Connected and Unconnected lookups, Update Strategy, Filter transformation, Joiner transformations to implement complex business logic.
• Used Informatica Workflow Manager to create workflows, database connections, sessions and batches to run the mappings.
• Used Variables and Parameters in the mappings to pass the values between mappings and sessions.
• Created Stored Procedures, Functions, Packages and Triggers using PL/SQL.
• Implemented restart strategy and error handling techniques to recover failed sessions.
• Used Unix Shell Scripts to automate pre-session and post-session processes.
• Did performance tuning to improve Data Extraction, Data process and Load time.
• Wrote complex SQL Queries involving multiple tables with joins.
• Implemented best practices as per the standards while designing technical documents and developing Informatica ETL process.

Environment: Informatica 8.6, Oracle 10g, Netezza, SQL Server, PL/SQL, ERwin, Flat files, Windows, Linux.