SUMMARY

• Enthusiastic and highly skilled with over 7 years of software development experience in the field of Data Warehousing using the Informatica ETL tool.
• A Self - starter with strong leadership, communication, Interpersonal skills and the ability to meet deadlines, Professional skills and competencies include the following:
• Experience in Full Life Cycle development of building a Data Warehouse.
• Good understanding of dimensional data modeling (Star Schema Modeling, Snow-flake Schema FACT and Dimension Tables).
• Experience in Extraction, Transformation, Loading data using Informatica (PowerCenter 9.1, 9.0.1/8.6.1/8.1.1 ) - Power Center Client tools - Designer, Repository manager, workflow manager/monitor and Server tools - Informatica Server, Repository Server manager.
• Hands on experience with managing Slowly Changing Dimensions (SCD) such as Type I, II, III and Cleansing, Profiling, Conversion, Aggregation, and Performance Optimization and setting up Change Data Capture (CDC) mechanisms.
• Experience in data transformations such as Source Qualifier, Joiner, Filter, Router, Expression, Lookup (Connected and Unconnected), and Aggregator, Sorter, Normalizer, Update Strategy, Sequence Generator and Stored Procedure transformations.
• Extensive experience with Data Extraction, Transformation, and Loading(ETL) from heterogeneous Data sources of Multiple Relational Databases like Oracle, Netezza, Teradata, DB2, SQL Server, MS Access and Worked on integrating data from flat files like fixed width and delimited, CSV, XML into a common reporting and analytical Data Model using Informatica.
• Identified bugs in existing mappings/workflows by analyzing the data flow and evaluating transformations.
• Experience in using versioned controlled tools IBM Clear Quest, IBM Clear Case, Quality Center and WinCVS.
• Design and database development experience with SQL, PL/SQL, Stored procedures, Functions, triggers.
• Experience in UNIX Shell Scripting and DOS bat files and automated scripts for scheduled queue process and PMCMD commands.
• Worked with Pre-Session and Post-Session scripts and Involved in migration/conversion of ETL processes from development to production environment.
• Expertise in doing Unit Testing, Integration Testing, System Testing and Data Validation for Developed Informatica Mappings.
• Excellent verbal and written communication skills with technical documentation skills.

TECHNICAL SKILLS

Informatica: Informatica Power Center 9.x/8.x/7.x, RepositoryManager, Designer,Work Flow Manager, Work Flow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Task Developer, Worklet Designer, mappings, re-usable transformations, Mapplets, Shortcuts, sessions, and workflows

Data Modeling: Dimensional Modeling, Star Schema, Snow Flake Schema, Fact Tables, Dimension Tables, Erwin, ERStudio Data Architect 9.6

Databases: Oracle 11g/10g/9i, Exadata, SQL, PL/SQL, MS SQL Server, DB2.

Programming languages: SQL, PL/SQL, T-SQL.

Operating Systems: UNIX, LINUX, Windows.

Tools: / Methodologies: SQL Loader, SQL Developer, TOAD, MSVisio, Autocad, Staad Pro, SAP, TOAD 9.7/10.6.1, Erwin 7.3, MSVisio, OpCon 5.7.1.0, Corticon 4.2, Aginity, HP Quality Center 10.0, Wincvs 2.0, IBM Clear Quest, IBM Clear Case, TWS, dbForge Data Compare 3.9, Tidal

Others: Microsoft Word, Microsoft Excel

PROFESSIONAL EXPERIENCE

Sr. Informatica Developer

Confidential, Omaha, NE

Responsibilities:

• Worked as ETL developer to integrate data across IDS (Integrated Data Store) and Data Hubs to provide single-view to the business.
• Worked with power center tools like Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Developed mapping parameters and variables to support SQL override.
• Created Mapplets to use them in different mappings.
• Developed shared objects that can be used across the folders.
• Involved in Sprint planning to discuss the stories to be worked on the sprint and point the stories.
• Worked with Product Owner, Scrum Master, Developers and Testers to achieve the goals to keep up with the sprint velocity.
• Participated in Enterprise Demo to demonstrate the goals achieved not only as a team but also as an individual participant.
• Prepared ETL flow of data from Staging to IDS and to Hub.
• Developed/Modified physical data model using ERStudio Data Architect.
• Used Visual Studio Team Foundation Server to track changes for Database objects, Test Cases and Stories.
• Implemented the Slowly Changing Dimensions for the purpose of incremental loading of the Hubs.
• Responsible for Debugging & Performance Tuning of the Informatica mappings and sessions.
• Configured workflows to run concurrently which helped other Blue’s to leverage the ETL process.
• Managed production issues and delivered all assignments/projects within specified time lines.
• Involved in scheduling the workflows through Tidal Job scheduler.
• Involved in unit testing and also in internal quality analysis procedures and reviews.

Environment: Informatica PowerCenter 9.6.1, Microsoft SQL Server 2014, SQL, Flat files, Tidal, Visual Studio 2015, ERStudio Data Architect 9.6, Team Foundation Server 2015, dbForge Data Compare 3.9 and MS-Office tools.

Sr. Informatica Developer/Analyst

Confidential, Chicago, IL

Responsibilities:

• Lay to populate the Data Warehouse from the CARES and TOPS source systems.
• Used Informatica PowerCenter 9.1 to create and manipulate source definitions, target definitions, mappings, mapplets, transformations, re-usable transformations, etc.
• Implemented partitioning and bulk loads for loading large volume of data. Used partition exchange to swap data.
• Involved in loading the data from Source Tables to ODS (Operational Data Store) Tables using Transformation and Cleansing Logic using Informatica.
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading
• Worked with Repository Manager for managing of repositories, creation of users, creation of user groups and folders.
• Based on the requirements, used various transformation like Source Qualifier, Normalizer, Expression, Filter, Router, Update strategy, Sorter, SQL, Lookup, Aggregator, Joiner, Stored procedure transformations in the mapping.
• Developed mapplets and worklets for reusability.
• Experience in performance tuning of SQL using TOAD and changing the hints with use of explain plan.
• Used ABAC (Audit bound and Control) process to log parameter file properties.
• ABAC process will handle all Control tables to capture aggregated data from historical loads and use that audit data for Incremental processes.
• Involved in performance tuning of mappings, transformations and (workflow) sessions to optimize session performance.
• Developed Informatica SCD Type-I and Type-II mappings.
• Extensively used almost all of the transformations of Informatica including complex lookups, Stored Procedures, Update Strategy, mapplets and others.
• Experience in using version controlled tools IBM Clear case, IBM clear quest, Quality Center to check-in the code.
• Created UNIX Shell scripts and called as pre session and post session commands.
• Involved in scheduling the workflows through TWS (Tivoli Workload Scheduler) Job scheduler using UNIX scripts.
• Creating Test cases, technical design specification and detailed documentation for Unit Test, System, Integration Test and UAT to check the data quality.

Environment: Informatica PowerCenter 9.1/8.6.1/8.1.1 , Oracle 11g/10g/Exadata, SQL, PL/SQL, TOAD 9.7/10.6.1, Star Schema, Flat files, TWS, IBM Clear case, IBM clear quest, Quality Center and MS-Office tools.

Informatica Developer

Confidential, IL

Responsibilities:

• Responsible for developing the Mappings to load the data from Source to Staging area and then into the Data warehouse based on the STT Documents.
• Designed and developed validation scripts based on business rules to check the Quality of data loaded into EDW.
• Extensively used Informatica Designer to create and manipulate source and target definitions, mappings, mapplets, transformations, re-usable transformations.
• Used various transformations like Expression, Filter, Sorter, Sequence Generator, Aggregator, Lookup, Update Strategy, Router, and Joiner.
• Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup Connected/Unconnected, and filter.
• Developed UNIX Shell Scripts and PL/SQL procedures.
• Production Support & addressing the issues as per the SLA’s.
• Created Dynamic parameter file creation mappings.
• Tuned Informatica mappings and sessions for better performance using various strategies based upon the analysis performed.
• The performance is monitored and relative steps are taken to enhance the performance
• Involved in identifying bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing the bugs so that they conform to the business needs.

Environment: Informatica Powercenter 9.0.1/8.6, Repository Manager, Designer, Oracle 10g, CSV files, PL/SQL(Stored Procedure, Trigger, Packages), SQL Developer,UNIX.

Informatica Developer

Confidential

Responsibilities:

• Analyzed source systems, business requirements and identified business rules for building the data warehouse.
• Designed and developed Informatica Mappings, Workflows to load the data into Oracle DB, SQL server.
• Used Informatica workflow manager, monitor, and repository manager to execute and monitor workflows and assign User Privileges.
• Extensively worked with Aggregator, Sorter, Router, Filter, Join, Expression, Lookup and Update Strategy, Sequence generator transformations. .
• Performingmanualtesting by performing the operations mentioned in the design steps. Compared the expected results with the actual outcome and recorded the results.
• Involved in Performance Tuning of Sessions and Mappings.
• Used the Workflow manager to create workflows and tasks, and also created Worklets.
• Involved in Production Support in resolving issues and bugs.
• Worked on SQL stored procedures, functions and packages in Oracle.
• Wrote Test Cases for ETL to compare Source and Target database systems.

Environment: Informatica Power Center 8.1, Oracle 10g, SQL, SQL Plus, Testing, MS Access, Windows XP.