SUMMARY

• Experience as a Software Engineer / Informatica Developer for over 5 years in developing large - scale Data Warehouse and Client/Server Applications, including Data Profiling, Data Migration, Data Modeling, Business Process, Design and Development, Integration and Testing, Database Programming, SDLC, Project Management and Production Support.
• Experience in complete Software development life cycle (SDLC) with a strong background in Design/Modeling, database development and implementation of various business intelligence and data warehouse / datamarts projects that cover gathering Business Requirements, Development, Implementations and Documentation.
• Strong work experience with Business Users to analyze the business process model and made necessary changes to schema objects to cater users reporting needs.
• Extensive experience in ETL methodologies for supporting Data Migration, Data Exchange, Data Transformation using Informatica Power Center v 10.x/9.x/8.x Suite.
• Implemented Informatica Naming standards and Best Practices for the full life cycle of data warehouse projects, right from design to development through go-live and support.
• Well acquainted with Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer, Workflow Manager and Monitor.
• Sound knowledge of Relational and Dimensional modeling techniques of Data warehouse (EDS/Data marts) concepts and principles (Kimball/Inman) - Star, Snowflake schema, SCD, Surrogate keys, and Normalization/De normalization.
• Experience in integration of various data sources like Oracle, Teradata, DB2, SQL Server, Flat Files, Excel, and XML files.
• Worked on Slowly Changing Dimensions (SCD's) and its implementation (Type1, Type 2, and Type 3) to keep track of historical data.
• Extensively used various Performance Tuning techniques to improve the performance for data loads.
• Strong Quality Assurance and debugging skills in ETL Process.
• Solid understanding of OLAP concepts and challenges with large sets of data.
• Proficient in writing UNIX Shell scripts, SQL Scripts for development, automation of ETL process.
• Experience in using Tivoli and Autosys scheduling tools to organize and schedule jobs.
• Worked with cross-functional teams such as QA, DBA and Environment teams to deploy code from development to QA and Production server.

TECHNICAL SKILLS

Data Warehousing ETL: Informatica PowerCenter 10.x/9.x/8.x, Informatica Data Quality (IDQ) v 10.x

Data Modeling: Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling

Databases: Oracle, MS SQL Server, TERADATA 14, DB2, Sybase

Programming: SQL, T-SQL, Unix, Shell Scripting, C, Java

Tools: TOAD, SQL*Plus, sql assistant, Autosys, Tivoli

Environment: UNIX, Windows XP/Vista/8/10, Linux

PROFESSIONAL EXPERIENCE

Confidential, Franklin Lakes, NJ

Senior Informatica/ETL Developer

Responsibilities:

• Used ETL tools Informatica 10.2 to extract data from source systems, cleanse Transform, and Load data into XML and Flat files.
• Developed mappings using Power Center -Designer for data transformation as per the technical requirements.
• Extensively used Transformations like Router, Aggregator, Sorter, Filter, Expression, Lookup, Joiner, Update strategy and Sequence generator, Procedure.
• Used Update Strategy to insert and update for inserting and updating the audit tables.
• Worked extensively with Mapping Parameters, Mapping Variables and Parameter files for Incremental Loading.
• Created mapping using Teradata, Flat files and XML, Oracle, DB2 sources,
• Used Reusable Transformations for different validations.
• Implemented slowly changing dimension (SCD) for accessing the full history of Customer. Implemented Type I, and II changes in slowly changing dimension tables.
• Analyzed newly converted data to establish a baseline measurement for data quality in data warehouse.
• Created Tivoli coding for scheduling and Shell scripts to trigger the workflows.
• Extensively worked on UNIT TESTING and created different unit test case documents for different subject areas.
• Designed workflows that are used to run a set of maps together one after the other, the results such as the execution time, start time, end time and status are stored in a run time repository which can be accessed by other users.
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once using Workflow Manager.
• Used debugger to test the mapping and fixed the bugs.
• Tuned and optimized mappings to reduce ETL run times thereby ensuring the mappings ran within the designated load window.
• Generated the Profiles for analyzing the source data and discussed with the business for populating the target columns.
• Co-ordinate with Business teams for any data related issues and updated the QA team with the mapping document.

Environment: UNIX, Teradata V14.0, Informatica 10.2, Tivoli, Windows 7 /UNIX

Confidential, Santa Clara, CA

Informatica ETL Developer

Responsibilities:

• Created ETL mappings using Informatica IDQ to extract the data from multiple sources like Flat files, SQL Server, csv, Delimited files transformed based on business requirements and loaded to target system.
• Created the Source and Target Definitions usingIDQ
• Participate in deployment, system testing, UAT.
• Created mapping to Load the DNB data from multiple Base objects in to single flat structure.
• Created mapping to load Base Object in MDM through an IDQ mapping.
• Created web services in IDQ using Web Service Consumer transformation.
• Used the Address Doctor Geo-coding table to validate the address and performed exception handling reporting and monitoring the data.
• Created Logical Data Objects in IDQ as per the business requirement.
• Migrated the code from one environment to another and performed testing.
• Address and resolve technical design issues as they are appropriately escalated.
• Performed the restarting of the services in case of any failures.
• Prepared implementation plans when moving a code to production.
• Performed system testing and monitoring.
• Created and deployed the workflows and applications for scheduling purpose.

Environment: Informatica Data Quality (IDQ) 10.1, Informatica Power Center 10.1, Sql server

Confidential, Wilmington, DE

ETL Developer

Responsibilities:

• Used ETL tools Informatica 9.6 to extract data from source systems, cleanse Transform, and Load data into databases.
• Developed mappings using Power Center -Designer for data transformation as per the technical requirements.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression, Lookup, Update strategy and Sequence generator, Procedure. Knowledge in use of SQL and XML Transformations.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner and Stored procedure transformations.
• Used Update Strategy DD INSERT, DD UPDATE, DD DELETE and DD REJECT to insert, update, delete and reject items based on the requirement.
• Worked extensively with Mapping Parameters, Mapping Variables and Parameter files for Incremental Loading.
• Created mapping using Teradata sources.
• Used Reusable Transformations and Reusable Mapplets for different validations.
• Analyzed newly converted data to establish a baseline measurement for data quality in data warehouse.
• Involved in Version control of the jobs to keep track of the changes in the Development Environment.
• Extensively worked on UNIT TESTING and created different unit test case documents for different subject areas.
• Designed work flows, that are used to run a set of maps together one after the other, the results such as the execution time, start time, end time and status are stored in a run time repository which can be accessed by other users.
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once using Workflow Manager.
• Used debugger to test the mapping and fixed the bugs.
• Developed UNIX shell scripts to schedule the jobs for running.
• Tuned and optimized mappings to reduce ETL run times thereby ensuring the mappings ran within the designated load window.
• Documented the purpose of mapping to facilitate the personnel to understand the process and in corporate the changes as and when necessary.
• Co-ordinate with QA and BI reporting teams for any data related issues.

Environment: UNIX, Teradata V14.0, Informatica 9.6, Tivoli, Windows 7 / UNIX

Confidential

ETL Developer

Responsibilities:

• Collected requirements from Business Users analyzed and prepared the technical specifications.
• Developed rules and Mapplets that are commonly used in different mappings.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner and Stored procedure transformations.
• Created new mappings and enhancements to the old mappings according to changes or additions to the Business logic.
• Worked on Power Center Tools like designer, workflow manager, workflow monitor and repository manager.
• Implemented SCD1, SCD2 type maps to capture new changes and to maintain the historic data.
• Worked on extract and load type of mappings.
• Worked with command line program pmcmd to interact with the server to start and stop sessions and batches, to stop the Informatica server and recover the sessions.
• Developed Unix shell scripts to schedule Informatica sessions.
• Created documents that have the detail explanation of the mappings, test cases and the expected results and the actual results.
• Created procedures to drop and recreate the indexes in the target Data warehouse before and after the sessions.
• Responsible for Performance Tuning at the Mapping Level and Session level.
• Used Debugger to troubleshoot the mappings.
• Responsible for migration of the work from Dev environment to testing environment.
• Performed unit testing, knowledge transfer and mentored other team members.

Environment: UNIX, Oracle 12c, Informatica 9.1, Tivoli, Windows 7 / UNIX