SUMMARY:

• 6+ years of experience in implementing Extraction, Transformation and Loading (ETL) using Informatica Power Center 9.x/8. x.
• Experience in dealing with various Data sources like Oracle, SQL Server, Excel, Flat files, Teradata and DB2 .
• Extensively worked on Relational Databases Systems like Oracle11g/10g, SQL server and Source files like flat files and XML files.
• Experience in all phases of software Development Life Cycle (SDLC) Project Analysis, Requirements, Design Documentation, Development, Unit Testing, User Acceptance Testing, Implementation, Post Implementation Support and Maintenance.
• Expertise in Data warehousing concepts like OLTP/OLAP System Study, Analysis and E - R modeling, developing database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional data modeling.
• Involved in Troubleshooting data warehouse bottlenecks, Performance tuning - session and mapping tuning, session partitioning & implementing Pushdown optimization.
• Extensive experience in designing and developing complex mapping using transformations like Source Qualifier, Sorter, Aggregator, Expression, Connected and Unconnected Lookup, Filter, Joiner, Sequence Generator, Router, Normalizer and Update Strategy.
• Experience in integration of various data sources like Oracle, DB2, SQL server, Teradataand non-relational sources like flat files into staging area.
• Proficiency in data warehousing techniques for Slowly Changing Dimension (type1 & type2), surrogate key assignment, Normalization & De-normalization, Cleansing, Performance Optimization along with the Confidential .
• Experienced in UNIX work environment, file transfers, job scheduling and error handling.
• Well in doing Error Handling using various log files.
• Worked with Teradata loading utilities like Multi Load, Fast Load, TPump and BTEQ .
• Involved in Full Cycle Development (Scrum/Agile) of building a Data Warehouse on windows and Unix Platforms.
• Maintained outstanding relationship with Business Analysts and Business Users to identify information needs as per business requirements along with the experience in web services and application protocol interface.
• Enthusiastic and goal-oriented team player, possessing excellent communication, interpersonal skills with high level of adaptability.

TECHNICAL SKILLS:

ETL Tools: Informatica 9.1/8.6/8.0

Languages: SQL, PL/SQL, UNIX Shell scripting

Databases: Oracle11g/10g, SQL Server2012/2008, DB2 MainframeTeradata v2r6

Database Utilities: Data warehouse:

SQL*plus, BTEQ, Fast load, Multi-Load, Fast Export.: Multidimensional Model Design, Star Schema Development

Data Modeling: Star-Schema Modeling, Snowflake Modeling, MS Visio 2013, Erwin 4.1/3.5

Reporting Tools: SQL Server Reporting Services, Cognos 10

Scheduling Tools: Autosys 11.3, CRON

Operating Systems: Windows 10/7/XP, UNIX

PROFESSIONAL EXPERIENCE:

Confidential, Portland, OR

Informatica Developer

Responsibilities:

• Analyze the requirements and accordingly plan, develop, design, test and implement the functionality and procedure.
• Designing, Implementing and delivering data warehouse ETL power center 9.1 and reporting applications.
• Worked with project managers, design lead and solution architect to achieve business and functional requirements.
• Extensively used Power Connect for SAP R/3 to source master data into DB2 UDB.
• Involved in customizing the Source Qualifier in Informatica with basic ABAP code to extract only the required data from SAP R/3.
• Design/implement queries to extract specific data from legacy system to new data warehouse.
• Designed and created complex source to target mapping using various transformations inclusive of but not limited to Sorter, Aggregator, Joiner, Filter, Source Qualifier, Expression and Router Transformations.
• Effectively used Informatica parameter files for defining mapping variables and workflow variables.
• Supporting, correcting and following up trouble reports Skills.
• Involved in performance tuning and optimization of Informatica mappings and session using features like Partitions and data/index cache.
• Implemented Slowly Changing Dimension mappings of SCD's- Type 1, and Type 2.
• Worked in debugging using Log messages, Server Messages.
• Scheduled jobs using Autosys.
• Perform analysis on quality and source of data to determine accuracy of information being reported.
• Effectively worked on Onsite and Offshore work model.
• Migrated Informatica Meta data from one repository to another repository using static/dynamic deployment groups.
• Involved in Unit Testing, User Acceptance Testing (UAT) to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Actively coordinated with testing team in the testing phase and helped the team to understand the dependency chain of the whole project.

Environment: Informatica Power Center 9.1, DB2 UDB 8.1, SQL*Plus, Windows XP, Oracle 11g,UNIX Shell Scripting, Erwin 4.1 and Autosys.

Confidential, Mahwah, NJ

Informatica Developer

Responsibilities:

• Used TeradataSQL assistant for running the SQL Queries to check the data loaded to the Target Tables.
• Designed and developed mappings, mapplets and sessions from source to target database using Informatica Power Center.
• Used simple to moderately complex debugging techniques to test ETL applications.
• Developed Test Cases for testing the ETL mappings.
• Conducted code reviews and design reviews to assure compliance.
• Involved in migration of ETL code from Development environment to QA environment and finally to Production environment.
• Followed Informatica development standards and enforce best practices.
• Worked with various file formats like fixed length and delimited.
• Used Teradata Utilities fastload, multiload, tpump to load data.
• Involved in creation of BTEQ Script for validating the data quality like referential integrity, not null check.
• Maintained the proper communication between other teams.
• Utilizing the existing UNIX shell scripts to run the Informatica workflow through process control.
• Scheduled sessions and batch process based on demand, run on time, run only once using Informatica Workflow Manager.
• Identified BI reporting problems, and suggests practical resolutions.
• Participates in *on-call* support for ODS and the data warehouse.
• Involved in documentation to describe program development, logic, coding, testing, and any changes and corrections.

Environment: Informatica Power Center 9.1/8.6, Teradata v2r6, SQL, Windows XP, UNIX Shell Script.

Confidential, Renton, WA

Informatica Developer

Responsibilities:

• Collecting requirements, analyzing data, design and development of Data warehouse.
• Involved in the requirements definition and analysis in support of Data Warehousing efforts.
• Working closely in designing and implementation of client information using dimension model techniques.
• Designing Logical/Physical Data Model (LDM/PDM) using Erwin 4.0.
• Forward and Reverse Engineered Data models for database creation.
• Experienced in creating Star Schema for Multi-Dimensional modeling within an enterprise wide Data Warehousing effort.
• Created mappings using the Transformation like Source qualifier, Aggregator, Expression, lookup, Router, Filter, Rank, Sequence Generator, and Update Strategy.
• Created workflows, commands and created pre-andpost-session scripts as required.
• Involved in writing the UNIX shell scripting, automation of ETL process and scheduling of jobs using CRON.

Environment: Informatica Power Center 8.6, SQL, Windows XP, UNIX Shell Script.

Confidential, Norwalk, CT

Informatica Developer

Responsibilities:

• Collected requirements, analyzing data, design and development of Data warehouse.
• Involved in the requirements definition and analysis in support of Data Warehousing efforts.
• Designing and implementation of client information using dimension model techniques.
• Designing Logical/Physical Data Model (LDM/PDM) using Erwin 4.0.
• Experienced in creating Star Schema for Multi-Dimensional modeling within an enterprise wide Data Warehousing effort.
• Created mappings using the Transformation like Source qualifier, Aggregator, Expression, lookup, Router, Filter, Rank, Sequence Generator, and Update Strategy.
• Debugged mappings by creating logic that assigns a severity level to each error, and sending the error rows to error table so that they can be corrected and re-loaded into a target system.
• Experience in reusable transformation, mappings and codes using Mapplets for faster development and standardization.
• Migrated Informatica Meta data from one repository to another repository using static/dynamic deployment groups.
• Executed sessions, tasks, sequential and concurrent batches for proper execution of mappings.
• Created workflows, commands and created pre-andpost-session scripts as required.
• Involved in writing the UNIX shell scripting, automation of ETL process and scheduling of jobs using CRON.

Environment: Informatica Power Center 8.6/7.1,SQL*Plus, Windows XP, Oracle 10g, UNIX Shell Scripting, Erwin 4.1 and CRON.