SUMMARY:

•   Over 3 years of experience in the Development and Implementation of   Data  Warehousing with information Power Center, OLTP and OLAP using   Data Extraction, Transformation, Loading and Analysis. 
• Experience in designing and implementing   Data  Mart /  Data Warehouse applications using Informatica Power Centre 9.5/ 8.x / 7.x. 
• Worked on developing and implementing complex business rules by creating Mappings, Mapplets, Sessions, Workflows, and worklets for   data  loads. 
• Experienced in requirements gathering, project estimating, planning design, build, maintenance, report design, user navigation design, testing and implementation. 
• Knowledge of complete SDLC including Requirement analysis and gathering, Project Management, Design, implementation, development and Testing. 
• Using agile methodology for SDLC and utilize scrum meetings for creative and productive work. 
• Extensively used various transformations such as Filter, Expression, Update Strategy, Look - up, Sequence, Joiner, Router, Aggregate, and Stored procedure transformation. 
• Expertise in Dimensional  data  modeling, Star schema, Snowflake schema,   Data  Normalization, Informatica Utilities Source Analyzer, warehouse Designer, Mapping Designer, Mapplets Designer and Transformation  Developer. 
• Strong expertise in Relational database systems like Oracle, Teradata, MS Access, design and database development using SQL, PL/SQL, SQL PLUS, TOAD 
• Design and developed complex mappings such as Slowly Changing Dimensions Type 2 (SCD Type 2). 
• Experience in writing/debugging/enhancing UNIX Shell Scripts. 
• Extensively Worked on UNIX shell scripts to handle Job Control Process. 
• Expertise in writing Oracle PL/SQL Stored Procedures, Functions, Packages, Cursors and Triggers. 
• Ability to meet deadlines and handle pressures coordinating multiple tasks in project environment, excellent communication, interpersonal, analytical skills.

TECHNICAL SKILLS:

ETL  Tools: Informatica Power Center, Informatica Power Analyzer/ Power mart 9x.

Operating System: Windows, UNIX, Linux. 

RDBMS: Oracle, SQL Server, DB2, Teradata, MS Access.

Programming Languages: SQL, PL/SQL, UNIX Shell Scripting, C, C++, XML/XSD, UNIX Shell Scripting, Quality Center 9.0/8.2. 

Web Technologies: HTML, XML, Front page, Dreamweaver. 

Reporting Tool: SSRS, SSAS, Cognos, SAP BO. 

Other Tools: SQL *Plus, Toad, MS Office.  Dimensional   Data  Modeling DDM (Dimensional   Data  Modeling). Start & Snow Flake modeling, Erwin, Putty, Wisp.

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

ETL/Informatica Developer

Environment:   Informatica  Power Center 10/9.6, EBS, Teradata 12, SSRS, Oracle 11/10g, PL/SQL, Map reduce, Autosys, TOAD 9.x,   Informatica   Cloud, Hive, Hadoop, Erwin, Oracle Financials, Shell Scripting, MS SQL Server 2012, Oracle SQL *Loader, SSIS 2008 and Sun Solaris UNIX, OBIEE, Windows-XP.

Responsibilities: 

• Used   Informatica   Power Center for extraction, transformation and load (ETL) of data in the data warehouse. 
• Extracted data from Teradata database. 
• Using  Informatica   Power Centre tools developed Workflows using task   developer, worklets designer, and workflow designer in Workflow manager and monitored the results using workflow monitor. 
• Data modeling in Erwin. 
• Expertise in creating Packages using SQL Server Integration Services (SSIS). 
• Expertise in Dynamic SQL, Collections and Exception handling. 
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio. 
• Worked on optimizing and tuning the Teradata views and SQL's to improve the performance of batch and response time of data for users. 
• Used   Informatica   power center 9.6.1 to Extract, Transform and Load data into Netezza Data Warehouse from various sources like Oracle and flat files. 
• Involved in Analyzing/ building Teradata EDW using Teradata   ETL   utilities and  Informatica. 
• Data Modelling and high Level designing (HLD), Analysis and Preparation of Low level design (LLD). 
• Web Methods installation, clustering, apply patches, and maintenance of application servers. 
• Used  Informatica  Power Exchange for loading/retrieving data from mainframe system. 
• Analyzed data sources and targets using   Informatica  Data Profiling option. 
• Write Shell script running workflows in UNIX environment. 
• Worked with Control- M for Scheduling jobs.
• Applied slowly changing dimensions like Type 1 and 2 effectively to handle the delta Loads. 
• Prepared various mappings to load the data into different stages like Landing, Staging and Target tables. 
• In EDW we load the consignment related data based business rules, this data we extract from SAP source system. 
• Used various transformations like Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, Update Strategy Designing and optimizing the Mapping. 
• Extracted data from Oracle and SQL Server then used Teradata for data warehousing.
• Implemented slowly changing dimension methodology for accessing the full history of accounts. 
• Wrote PL/SQL scripts for pre & post session processes and to automate daily loads. 
• Wrote heavy stored procedures using dynamic SQL to populate data into temp tables from fact and dimensional tables for reporting purpose. 
• Optimizing performance tuning at source, target, mapping and session level 
• Created various tasks like Session, Command, Timer and Event wait. 
• Modified several of the existing mappings based on the user requirements and maintained existing mappings, sessions and workflows. 
• Tuned the performance of mappings by following   Informatica  best practices and also applied several methods to get best performance by decreasing the run time of workflows. 
• Prepared SQL Queries to validate the data in both source and target databases. 
• Participated in weekly status meetings, and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.

Confidential

ETL/ Informatica Developer

Environment: Informatica Power Center 9.5, Power Mart, Oracle Oracle11g, PL/SQL, Teradata, SAP BO, SSRS, Windows, UNIX, ERwin, Putty, Autosys, WINSCP, Windows XP, Linux, IBM Mainframes.

Responsibilities:

• Worked on Informatica Repository Manager, Designer, Workflow Manager & Workflow Monitor. 
• Interacted with the Business Users in gathering and analyzing the Business requirements. 
• Worked on Designing, Development and Testing of Workflows and Worklets according to Business Process Flow. 
• Created mappings using various transformations like update strategy, lookup, stored procedure, router, joiner, sequence generator and expression transformation. 
• Extensively involved in writing ETL Specifications for Development and conversion projects. 
• Created technical design specifications for data Extraction, Transformation and Loading (ETL). 
• Extensively worked on Change Data Capture/Incremental loading of SCD Type I/II. 
• Design the ETL process and schedule the stage and mart loads for the data mart. 
• Worked on Informatica Utilities Source Analyzer, warehouse Designer, Mapping Designer, Mapplets Designer and Transformation Developer for defining Source and Target, and coded the process from source system to data warehouse. 
• Extensively used transformations like Stored Procedure, Connected and Unconnected lookups, Update Strategy, Filter transformation, Joiner transformations to implement business logic. 
• Extensively created Re-Usable Transformations and Mapplets to standardized Business logic. 
• Extracted the data from various Flat files and Loaded in Data Warehouse Environment and written Unix Shell scripts to move the files across the Servers. 
• Used Informatica Workflow Manager to create workflows, database connections, sessions and batches to run the mappings. 
• Used Variables and Parameters in the mappings to pass the values between mappings and sessions. 
• Used Unix Shell Scripts to automate pre-session and post-session processes. 
• Created shortcuts for reusable source/target definitions, Reusable Transformations, mapplets in Shared folder.