PROFESSIONAL SUMMARY:

• Around 6 years of work experience in Information Technology as Informatica Developer with strong background in ETL Data Warehousing and experienced using Informatica Power center 9.x/8.x/ 7.x., Informatica IDQ 9.X, MDM.
• Expertise in Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDM solutions.
• Experience in installation and configuration of core Informatica MDM hub components such as Hub console,Hub Store, Hub Server, Cleanse Match Server and Cleanse adapter in Windows.
• Expertise in SDLC including requirement gathering, analysis, designing, testing, integration, quality assurance, maintenance, and support.
• Experienced in domains like Financial, Insurance, and Retail.
• Experience in Production Support. Extensively worked on production support issues and resolved them using session logs, workflow logs and used e - mail task for capturing issues.
• Experience in using Informatica Powercenter Transformations such as Source Analyzer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Experience in integration of various data sources like SQL Server, Oracle, Flat Files, and XML files.
• Expertise in Teradata
• Experienced in storing data to Data Lake
• Experienced in ETL testing
• Used unix scripts to schedule sessions, tasks and to automate the deployment group.
• Expertise in design and implementation of Slowly Changing Dimensions (SCD) type1, type2, type 3.
• Experienced in loading data, troubleshooting, debugging mappings, performance tuning of Informatica (Sources, Targets, Mappings, and Sessions) and fine-tuned transformations to make them more efficient in terms of session performance.
• Used Debugger in Informatica Power Center Designer to check the errors in mapping
• Experience in writing complex SQL queries.
• Interacting with Business Analyst and users to get new requirements and enhancements.
• Excellent skills in fine tuning the ETL mappings in Informatica.
• Extensive experience using database tools such as SQL *Plus, SQL *Developer, and PostgreSQL
• Good verbal & communication skills, clear understanding of business procedures and ability to work as an individual and as a part of a team.

TECHNICAL SKILLS:

ETL Tools: Informatica 9.x/8.x/7.x (Power Center/Power Mart) (Designer, Workflow Manager, Workflow Monitor, Informatica Data Quality (IDQ), Data Quality/IDE.

Data Modeling: Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, Fact, Dimensions), Entities, Attributes, Cardinality, ER Diagrams.

Databases: Oracle 11g/10g/9i/8i, PostgreSQL, Teradata, DB2

Tools: Toad, SQL* Developer, PGadmin.

Operating Systems: Windows Server, NT/2008/2003/XP/Vista/7, UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Senior ETL Developer

Responsibilities:

• Involved in the design, development, and implementation of the Enterprise Data Warehousing (EDW) process.
• Configured and installed Informatica MDM Hub server, cleanse Server, resource kit in Development, QA, Pre-Prod and Prod Environments.
• Involved in implementing the Land Process of loading the Data Set into Informatica MDM from various source systems.
• Configured match rule set property by enabling search by rules in MDM according to Business Rules.
• Performed match/merge and ran match rules to check the effectiveness of MDM process on data.
• Created Unit Test Case document.
• Provided data warehouse expertise including data modeling, Extract, Transform and Load (ETL) analysis, design, and development.
• Hands-on Experience in working with Source Analyzer, Mapping Designer, Mapplets to extract, transform and load data.
• Worked with various Active and Passive transformations like Source Qualifier, Sorter, Aggregator, Filter, Union, and Router Transformations, Sequence Generator and Update Strategy Transformations.
• Handled versioning and dependencies in Informatica.
• Developed schedules to automate the update processes, Informatica sessions, and batches
• Developed data transformation processes, maintain and update loading processes
• Developed and tested all the mappings, sessions and workflows.
• Used Informatica Powercenter Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Involved in creation of Folders, Users, Repositories, Deployment Group using Repository Manager.
• Developed PL/SQL code at the database level for the new object.
• Used shell Scripting to run the workflows, Scheduling the session, to automate the deployment group.

Environment: Informatica 9.5.1,Informatica Multidomain MDM 9.5.0, Oracle11g, SQL Server 2008, Teradata TOAD, SQL Navigator, Windows Server 2008, UNIX.

Confidential, Hartford, CT

ETL Developer

Responsibilities:

• Gathered User Requirements and designed Source to Target data load specifications based on business rules.
• Used Informatica Powercenter 9.0.1.for extraction, loading, and transformation (ETL) of data in the DataMart.
• Designed and developed ETL Mappings to extract data from Flat files and Oracle and to load the data into the target database.
• Developing several complex mappings in Informatica a variety of Power enter transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer using Informatica Power Center.
• Built complex reports using SQL scripts.
• Created complex calculations, various prompts, conditional formatting and conditional blocking etc., accordingly.
• Created complex mappings to load the data mart and monitored them. The mappings involved extensive use of Aggregator, Filter, Router, Expression, Joiner, Union, Normalizer and Sequence Generator transformations.
• Interacting with Business Analyst and users to get new requirements and enhancements.
• Design roles and groups for users and resources using AWS Identity Access Management (IAM).
• Ran the workflows on a daily and weekly basis using workflow monitor.

Environment: Informatica 9.0.1, PL/SQL, AWS, Framework Manager, Transformer, Teradata, Oracle 11g, TOAD, Windows Server 2008, UNIX

Confidential

Informatica/ Database Developer

Responsibilities:

• Gathered User Requirements and designed Source to Target data load specifications based on business rules.
• Used Informatica Power Center 8.6.1.for extraction, loading, and transformation (ETL) of data in the DataMart.
• Designed and developed ETL Mappings to extract data from flat files, MS Excel and Oracle to load the data into the target database.
• Developed several complex mappings in Informatica using a variety of PowerCenter transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer using Informatica PowerCenter.
• Created complex mappings to load the data mart and monitored them. The mappings involved extensive use of Aggregator, Filter, Router, Expression, Joiner, Union, Normalizer and Sequence Generator transformations.
• Ran the workflows on a daily and weekly basis using workflow monitor.
• Maintained the target database in the production and testing environments.

Environment: Informatica PowerCenter 8.6.1, Oracle 10g/9i, PL/SQL, Flat files, XML, MS Access, Web services, Unix, Toad, Business Objects

Confidential

Informatica Developer

Responsibilities:

• Based on the requirements, created Functional design documents and Technical design specification documents for ETL Process.
• Developed mappings and mapplets using Informatica Designer to load data into ODS from various transactional source systems.
• Used Informatica Designer to import the sources, targets, create various transformations and mappings for extracting, transforming and loading operational data into the EDW from ODS.
• Used various transformations such as expression, filter, rank, source qualifier, joiner, aggregator, and Normalizer in the mappings and applied surrogate keys on the target table.
• Used the Informatica Server Manager to register and monitor the server, create and run the sessions/batches for loading the data using the earlier created mappings.
• Created mapplets and reusable transformations.
• Created Workflow, Worklets, and Tasks to schedule the loads at required frequency using Workflow Manager.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Migrated mappings from Development to Testing and performed Unit Testing and Integration Testing.

Environment: Informatica Powercenter 8.x, Repository Manager, Designer, Oracle 8i, SQL, UNIX, Win 2000/NT