SUMMARY

• 7+ years of work experience in Information Technology as Informatica Developer with strong background in ETL Data warehousing experienced using Informatica Power Center 10x/9x/8x.
• Experience in using Informatica Power Center Transformations such as Source Analyzer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Expertise in design and implementation of Slowly Changing Dimensions (SCD) type1, type2, type3.
• Experience 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.
• Database experience using Oracle 11g/10g/9i, MS SQL Server 2008/2005/2000 and MS Access.
• Experience in UNIX Operating System and Shell scripting.
• Working knowledge of data warehouse techniques and practices, experience including ETL processes, dimensional data modeling (Star Schema, Snow Flake Schema, FACT & Dimension Tables), OLTP and OLAP.
• Experience in data mart life cycle development, performed ETL procedure to load data from different sources into Data marts and Data warehouse using Informatica Power Center.
• Used Debugger in Informatica Power Center Designer to check the errors in mapping
• Experience in writing complex SQL queries.
• Excellent skills in fine tuning the ETL mappings in Informatica.
• Extensive experience using database tool such as SQL *Plus, SQL *Developer and TOAD.
• Experienced in automating the Informatica jobs, also experienced in Informatica scheduler, and Autosys scheduling tools.
• Good working knowledge of various Informatica designer transformations like Source Qualifier, Expression, Filter, Router, Lookup, Aggregator, Normalizer, Rank, Joiner and Update Strategy.
• Effective working relationships with client team to understand support requirements, and effectively manage client expectations.
• Excellent communication, presentation, project management skills, a very good team player and self-starter with ability to work independently and as part of a team.

TECHNICAL SKILLS

ETL Tools: Informatica 10.x/9.x/8.x/7.x (Power Center/Power Mart) (Designer, Workflow Manager, Workflow Monitor, Server Manager, Power Connect).

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

Databases: Oracle 12c/11g/10g, MS SQL Server 2014, MS Access.

Languages: PLSQL, SQL, C, C++, Data Structures, Unix Shell Script.

Tools: Toad, SQL* Developer.

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

PROFESSIONAL EXPERIENCE

Confidential, Prudential, NJ

Sr. Informatica Developer

Responsibilities:

• Extracted Data from the source Oracle and developed mappings, sessions and workflows using Informatica Power Center 10.1.
• Designed the ETL processes using Informatica to load data from Oracle, Flat Files (Fixed Width and Delimited) to staging database and from staging to the target Warehouse database.
• Prepared design specification documents as per the inputs received from the architect and the business analyst.
• Used Informatica workflow manager for creating, running the Batches and Sessions and scheduling them to run at specified time.
• Extracted data from source database which is VPAS, that contains annuities information.
• Developed Informatica ETL mappings, sessions and workflows based on the technical specification document.
• Created mappings using transformations like source qualifier, joiner, aggregator, expression, filter, router, lookup, and update strategy.
• Applied slowly changing dimensions Type I and Type II according to the business requirements.
• Extensively worked in Informatica Performance Tuning and thereby improving the load time.
• Apply business rules using complex SQL and validation rules to check data consistency.
• Involved in requirement gathering, design, testing, project coordination and migration.
• Effectively understood session error logs and used debugger to test mapping and fixed bugs.
• Worked with the team to schedule the jobs that run every day using Autosys scheduler.
• Fine-tuned ETL processes by considering mapping and session performance issues.
• Created workflow and other tasks to schedule the loads at required frequency using Informatica scheduling tool.
• Created session, event, command, control, decision and email tasks in workflow manager.
• Responsible for handling large volume data conversions, data cleansing and following data delivery standards.
• Written unit test cases for the mappings.
• Used knowledge of data and systems to proactively contribute to report design process.
• Used the knowledge on UNIX scripts to move files from one location to another.
• Maintained the proper communication between other teams and client.

Environment: Informatica 10.1 hotfix2, Oracle 12c, UNIX, Windows, Autosys scheduler.

Confidential, OH

Sr. Informatica Developer

Responsibilities:

• Involved in analysis of source systems, business requirements and identification of business rule and responsible for developing, support and maintenance for the ETL process using Informatica.
• Created / updated ETL design documents for all the Informatica components changed.
• Developed Informatica ETL mappings, sessions and workflows based on the technical specification document.
• Analyze trades/Licenses from various Source systems like Denado/AMS/AMF/PDS and integrate with existing Nationwide data to help with licensing analysis.
• Created the ETL design documentation, Mapping document, Migration document, Test cases and set the standards for development and testing.
• Actively involved in analysis, development, testing and performance tuning.
• Implemented Slowly Changing Dimensions.
• Involved in Design review and code review.
• Extensively worked in Informatica Performance Tuning and thereby improving the load time.
• Created Index, Partitioning, Analyzed Tables and improved performance.
• Created Informatica Mappings using Mapping Designer to load the data from various sources using different transformations like Source Qualifier, Normalizer, Aggregator, Expression, Stored Procedure, Filter, Joiner, Lookup, Router, Sequence Generator, and Update Strategy transformations.
• Used Informatica job scheduler to schedule UNIX shell scripts and Informatica jobs.
• Actively supported in Unit Testing, Integration Testing and Performance Testing of ETL.
• Responsible for handling large volume data conversions, data cleansing and following data delivery standards.
• Apply business rules using complex SQL and validation rules to check data consistency.
• Performed Data validation and massaging to ensure accuracy and quality of data.
• Created Unix Scripts to Move files from one location to other and to create Parameter files.
• Used knowledge of data and systems to proactively contribute to report design process.

Environment: Informatica 9.5, Oracle 11g, Toad, SQL, UNIX, Windows, Informatica scheduler.

Confidential, OH

Informatica Developer

Responsibilities:

• Based on the requirements, created Technical design specification documents for ETL Process.
• Developed mappings and mapplets using Informatica Designer to load data into ODS from various source systems.
• Used Informatica Designer to import the sources, targets, create various transformations and mappings for extracting, transforming and loading operational data into the centralized warehouse from ODS.
• Used various transformations such as expression, filter, rank, source qualifier, joiner, aggregator and Normalizer in the mappings and applied surrogate keys on 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 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 9.1x/8.6x, Oracle 11g, Toad, Windows, Informatica scheduler.