SUMMARY

• 7+ years of IT experience in Analysis, Design, Development and Testing of ETL methodologies in all the phases of the Data Warehousing.
• Experience in designing and developing complex mappings to extract data from various legacy diverse sources including flat files, Oracle, MS SQL Server, and Salesforce into a common reporting and analytical Data Model using Informatica Power Center.
• Experience in Extraction Transformation Loading (ETL) process, Dimensional Data Modeling experience using Data modeling, Star schema/Snowflake modeling.
• Experience in Developing/Optimizing/Tuning mappings using Informatica.
• Experience on various types of transformations like Lookup, Update Strategy, Joiner, Filter, Aggregator, Rank, Router, Sorter, Sequence Generator, and Source qualifier and SCD Type - 2 etc.
• Expertise using Debugger, Mapping wizards, Workflow administrator and Workflow Monitor
• Expertise in Create/Build/Run/Schedule Batch Job streams, Sessions, Workflows using the Workflow Manager, Server Manager.
• Experience in writing UNIX shell scripting.
• Expertise monitoring workflows, pipeline partitioning.
• Knowledge in writing PL/SQL stored procedures, functions.
• Team player with strong communication and interpersonal skills.
• Good knowledge and experience in implementing practices in Software Development Life Cycle (SDLC).
• Expertise in design and implementation of Slowly Changing Dimensions (SCD).
• 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.
• Demonstrated understanding of best practices in SQL queries in different RDBMS such as Oracle and SQL Server.
• Involved in designing and implementing Data Mart applications, mainly transformation Process using ETL tools like Informatica Power Center.
• Experienced with Integration of data from heterogeneous sources such as Relational tables, flat files, MS Excel, and XML files.
• Good knowledge with techniques involved among Legacy systems.
• Used Debugger in Informatica PowerCenter Designer to check the errors in mapping.
• Excellent skills in fine tuning the ETL mappings in Informatica.
• Effective working relationships with client teams to understand support requirements, and effectively manage client expectations.
• Ability to learn new technologies quickly.

TECHNICAL SKILLS

ETL/DW TOOLS: Informatica Power Center 10.2/9.6, IICS

Operating Systems: Windows 10/NT/XP, UNIX

DBMS: Oracle 11g, SQL Server

Programming Languages: SQL

Scheduling Tools: Autosys

Management Tools: JIRA, ServiceNow, SVN

PROFESSIONAL EXPERIENCE

Confidential, Denver, CO

Informatica Developer

Responsibilities:

• Worked with the Business customers to identify the different sources of data in operational systems and developed strategies to load the data to the target database tables.
• Created Informatica mappings using Power Center and extracted data from Oracle SQL server and transformed data according to the requirement and loaded into the target Azure database.
• Created mappings using different transformations like Source Qualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy and Sequence Generator, etc.
• Work with the Admins to facilitate migration of code from Informatica PowerCenter to IICS and validation once the code is implemented in IICS
• Ongoing user support and code enhancement and bug fixes.
• Develop mappings, mapping tasks, Task Flows, connections in Informatica IICS
• Extensively involved in testing the data and involved in migrating the code in different environments.
• Extensively used debugger for identifying the root issues in the ETL Code.
• Participate in Peer reviews to ensure organization codes standards are followed.
• Parameterized the mappings and increased the re-usability.
• Used Informatica Power Center Workflow manager to create sessions, workflows, and batches to run with logic embedded in the mappings.
• Worked with Business users to fix defects and implemented the best practices for conducting best Unit Testing and Integration Testing and document the Test result for User Acceptance.

Environment: Informatica Power Center 10.2, Informatica IICS, SQL Developer, UNIX, MS SQL Server, Oracle 12c, SQL Server management studio, Azure SQL Server.

Confidential, San Francisco, CA.

Informatica Developer

Responsibilities:

• Successfully developed and maintained ETL mappings to Extract, Transform, and Load data from various data sources to the Enterprise Data warehouse (EDW). This Data warehouse collects full life cycle data right from the new product introduction through its ordering, shipping, inventory, sales, customer information, and maintenance system. The data warehouse is used to make decisions for sales improvements, introduction of promotions for existing products, shelf movement, and sales.
• Extensively involved in testing the data and involved in migrating the code in different environments.
• Extensively used debugger for identifying the root issues in the ETL Code.
• Participate in Pier reviews to ensure organization codes standards are followed.
• Ongoing user support and code enhancement and bug fixes.
• Provided source system analysis, data transformation, loading, validation for data marts, and data warehouse
• Used heterogeneous files from different sources and imported stored procedures from Oracle for transformations
• Designed and coded maps, which extracted data from existing source systems into the data warehouse
• Generated completion messages and status reports using Informatica workflow manager

Environment: Informatica PowerCenter 10.2, Oracle 12c, UNIX, SQL, MS SQL Server 2017

Confidential, NY

Informatica Developer

Responsibilities:

• Confidential ’s M-3 project was developed to replace the existing system with ETL mappings, consolidate different databases replicated across different servers, and create data marts which would help in the business analysis and reporting process.
• Created the current state document
• Worked extensively with Informatica to move data from legacy sources to Data warehouse.
• Worked extensively on various transformations in aggregator, expression, filter, joiner, connected and unconnected lookup, router, sorter, stored procedure, update strategy, sequence generator, and union transformations
• Extensively involved in testing the data and involved in migrating the code in different environments.
• Extensively used debugger for identifying the root issues in the ETL Code.
• Ongoing user support and code enhancement and bug fixes.
• Participate in Peer reviews to ensure organization codes standards are followed.

Environment: Informatica PowerCenter 9.6, SQL Developer, UNIX, MS SQL Server, Oracle 11g, SQL Server management studio.