SUMMARY

• 8+ years of experience in implementing Extraction, Transformation and Loading (ETL) using Informatica Power Center 9.x/8.x/7.x/6.x(Source Analyzer, Data Warehousing Designer, Mapping Designer, Maple Designer, Transformation developer).
• Extensively worked on Relational Databases Systems like Oracle11g/10g/9i/8i, MS SQL Server and Source files like flat files, XML files and COBOL 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.
• Working experience in Data warehousing and Business Intelligence concepts with emphasis on ETL and life cycle development using Power Center, Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Experience in integration of various data sources like Oracle, DB2, Sybase, Teradata, SQL server and MS access and non-relational sources like flat files into staging area.
• Proficiency in data warehousing techniques for Slowly Changing Dimension (type1, type2, type3), surrogate key assignment, Normalization & De-normalization, Cleansing, Performance Optimization along with the CDC (Change Data Capture).
• Worked on Tpump, Mload, Fload, TPT and BTEQ scripts to load the data into Teradata tables.
• Experienced in UNIX work environment, file transfers, job scheduling and error handling.
• Experience in creating pre-session and post-session scripts to ensure timely, accurate processing and ensuring balancing of job runs.
• Well in doing Error Handling using various log files.
• Involved in Full Cycle Development (Water, 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.
• Enthusiastic and goal-oriented team player, possessing excellent communication, interpersonal skills and leadership capabilities with high level of adaptability.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.5/9.1/8.6Informatica power Exchange

Databases: Oracle 11g, 10g &9i, SQL Server 2012

Database Tools: Toad 10.1.1, SQL, SQL plus, Power Designer, SQL Assistant

Program Languages: SQL, PL/SQL, UNIX, C, Java

Operating systems: Windows 95/98/NT/2000, UNIX, Linux

Testing Tools: HP Quality Center (QC)

Project Management & Data Modeling Tools: MS-Project, Microsoft Visio

Methodologies: Agile/Scrum, Waterfall.

PROFESSIONAL EXPERIENCE

Confidential - Plano, TX

Sr. Informatica Developer

Responsibilities:

• Analyze the requirements and accordingly plan, develop, design, test and implement the functionality and procedure.
• Designing, Implement and delivering data warehouse ETL and reporting applications.
• Worked with project managers, design lead and solution architect to achieve business and functional requirements.
• Establish controls to ensure the accuracy and consistency of data.
• Review existing systems to determine compatibility with projected and select appropriate systems, including ensuring forward compatibility of existing systems.
• Review existing systems to determine compatibility with projected and select appropriate systems, including ensuring forward compatibility of existing systems
• Database development and ETL process in Oracle l0g and Greenplum using PSQL, SQL, PERL and UNIX scripting.
• Design/implement queries to extract specific data from legacy system to new data warehouse.
• Preparation of the various technical and functional documents consisting of Detailed Design Documentation, function test specification with use cases.
• Analysis of source systems and work with business analysts to identify study and understand requirements and translate them into ETL code.
• Supporting, correcting and following up trouble reports Skills.
• Worked in debugging using Log messages, Server Messages.
• Perform analysis on quality and source of data to determine accuracy of information being reported.
• Actively coordinated with testing team in the testing phase and helped the team to understand the dependency chain of the whole project.

Environment: Oracle 11g, PSQL, PERL, Unix, SQL, SQL Developer, SQL Data Modeler, Sun Solaris, VM Ware, Greenplum 4.0/4.1.

Confidential, Pleasanton, CA

Informatica Developer

Responsibilities:

• Worked with Data Modeler to understand the business requirements and business rules
• Prepared ETL Specifications to help develop mapping.
• Extracted data from various sources (Flat files, SQL Server, DB2 Databases).
• Designed and developed Informatica Mappings and sessions based on business user requirements and business rules.
• Developed Slowly Changing Dimensions for Type 1 SCD and Type 2 SCD
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Created mappings to read from Flat files, RDBMS and to load into RDBMS tables.
• Based on business Rules Debugged code, tested and validated data after processes are run in development..
• Prepared and maintained mapping specification documentation.
• Modified the existing mappings for the updated logic and better performance.
• Developed Logical Data Flow Diagrams in Visio for every mapping that is developed. Assisted QA Team to fix and find solutions for the production issues.
• Involved in Unit testing, User Acceptance Testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.

Environment: Informatica9.1, DB2, ERWIN, Oracle 10g, SQL Server 2012, Visual Basic.Net, MS Access, Business objects 6.5,Toad, SQL, UNIX, Java, Windows 2000, HP Quality Center.

Confidential, Dearborn, MI

Informatica Developer

Responsibilities:

• Analysed application requirements and provided recommended design and studied the current system to understand the existing data structures.
• Participated actively in user meetings and collected requirements from users.
• Cleanse the source data, extract and transform data with business rules and built mapplets using in Informatica design.
• Worked with Workflow Manager for the creation of various tasks like Worklets, Sessions, Batches, E-mail notifications, Decision and to Schedule jobs
• Extensively used the Slowly Changing Dimensions-Type II in various data mappings to load dimension tables in Data warehouse
• Scheduled jobs using Autosys
• Involved in extensive performance tuning by determining bottlenecks using Debugger at various points like targets, sources, mappings, sessions or system, this led to better session performance.

Environment: InformaticaPower Center 8.6.1, Oracle 10g, TOAD 10.1 for Oracle, Flat Files, PL/SQL, UNIX shell scripting, Autosys.

Confidential, New York, NY

Informatica Developer

Responsibilities:

• Involved in creating the technical architecture and design documents for small project change requests.
• Work with business users directly in gathering requirement and implementing them and working close with offshore developers.
• Extensively used Source Qualifier Transformation to filter data at Source level rather than at Transformation level.
• Created mappings to extract, transform & load data from different sources using various Transformations.
• Prepared user requirement documentation for mapping and additional functionality.
• Interpreted logical and physical data models for business users to determine common data definitions and establish referential integrity of the system.
• Analyzed the requirements and framed the business logic for the ETL process.
• Involved in cleansing and extraction of data and defined quality process for the warehouse.
• Developed slowly changing dimension mappings (Type 1 and Type 2).
• Worked on populating the EDW / Data Marts, multiple fact and dimension tables with star methodology.
• Designed and developed reusable mapplets and used mapping variable and mapping parameters in the ETL mapping.
• Involved in writing various UNIX shell scripts for writing automated scripts for scheduled queue process.
• Optimized the performance of the mappings by various tests on sources, targets and transformations. Identified the different bottlenecks.

Environment: Informatica Power Center (Source Analyzer, Data warehouse designer, Mapping Designer, Mapplet, Transformations, Workflow Manager, Workflow Monitor), Oracle 10g, SQL/PLSQL, Windows and SQL server.

Confidential

Informatica Developer

Responsibilities:

• Designed Parameter driven Informatica mappings and sessions for extracting, cleansing, transforming and loading the data from the Complex Flat Files into the data warehouse
• Used various transformations like Unconnected /Connected Lookup, Aggregator, Expression
• Joiner, Sequence Generator, Router for creating complex business logic in ETL
• Developed logic using sequence generator transformation to replace missing keys and create unique keys
• Created Worklets and workflows in the workflow manager to synchronize OLAP system with OLTP system with the logic to run set of tasks at the scheduled times
• Used Repository Manager to migrate Informatica mappings across the development, test and production environments
• Involved in extensive performance tuning by determining bottlenecks at targets, sources, mappings, sessions.
• Extensively used PL/SQL for creating views, stored procedure, and indexes on the tables.
• Involved in error checking and testing of ETL procedures and programs in Informatica session log.
• Developed Component documentation for every product designed.

Environment: Informatica 7.1, SQL Server 2005, SQL Navigator, Visio, Windows XP, SunOS 5.6.