SUMMARY

• Over 6+ years of diversified experience in the field of Information Technology with an emphasis on Data warehousing using Informatica PowerCenter 9.5/9.1/8.x Target Databases and developing Strategies for Extraction, Transformation and Loading (ETL) mechanism - using Informatica.
• Involved in understanding of Business Processes, grain identification, identification of dimensions and measures for OLAP applications.
• Strong work experience in Data Mart life cycle development, performed ETL procedure to load data from different sources like SQL Server (2008/2012), Oracle, Teradata, and flat files into data marts and data warehouse using Power Center Repository Manager, Designer, Server Manager, Workflow Manager, and Workflow Monitor
• Involved in developing mappings and mapplets using Informatica Source Analyzer, Warehouse designer, Mapping Designer & Transformation Developer.
• Used various Transformations such as Expressions, Filters, and aggregators, Lookups, Routers, Normalizer, and Sequence Generator etc. to load data into different Oracle, SQL, Teradata databases.
• Experienced in PL/SQL.
• Automation and scheduling of UNIX shell scripts and Informatica sessions and batches using Autosys.
• Expertise in implementing complex Business rules by creating complex mappings/mapplets, shortcuts, reusable transformations and Partitioning Sessions.
• Experience in Performance Tuning of sources, targets, mappings, transformations and sessions.
• Extensive Data modeling experience using Dimensional Data modeling, Star Schema modeling, Snowflake modeling, and FACT and Dimensions tables.
• Extensively involved in project coordination activities by keeping track of various project milestones and organizing weekly project reviews throughout the entire SDLC.
• Worked on data analysis and data validations and preparing Unit Test Cases.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.
• Experienced Informatica Data Quality (IDQ).

TECHNICAL SKILLS

ETL Tools: Informatica Power Center, 9.5,9.1, 8.x. IDQ

Databases: Oracle 10g, 11g, MS SQL Server 2008/2012, Teradata, Netezza

Environment: s UNIX, Windows, Linux

Tools: Toad 9.1, SQL developer, ERWIN

Languages: UNIX shell Script, SQL, PL/SQL

PROFESSIONAL EXPERIENCE

Confidential, Elmhurst, IL

ETL/Informatica Developer

Responsibilities:

• Worked closely with business analyst and Data Warehouse architect to understand the source data and need of the Warehouse.
• Translate customer requirements into formal requirements and design documents.
• Involved in creating the design and technical specifications for the ETL process based on Functional specifications.
• Written Informatica mapping for dropping and recreating the indexes of database tables.
• Development of address cleansing Mapplet and mapping using First logic plug-in.
• Worked extensively with Extraction, Transformation and Loading of data from Multiple Sources (oracle, Netezza, Teradata, fixed width and delimited flat files) to Oracle usingInformatica.
• Worked on Scheduling workflows and sessions usingInformaticascheduler and have implemented decision task and email task for tracking the successful completion
• Handled the creation of tables, views, triggers, stored procedures, functions, sequences in the database using SQL and PL/SQL scripts.
• Experience in using Teradata tools like Fast Load, Multi Load, TPump, Fast Export, Teradata Parallel Transporter (TPT) and BTEQ.
• Extensively used T-SQL in creating Procedure.
• Worked extensively on schema (Star schema) creations in data warehouse.
• Implemented complex mapping such as Slowly Changing Dimensions (Type 2).
• Worked on various types of transformations like Expression, Joiner, update strategy, Aggregator, Filter and Lookup.
• Created UNIX scripts for parsing and modifying data and experience in using Autosys job scheduler for automation of UNIX shell scripts and batch scheduling.
• Facilitate end-user procedures development.

Environment: Informatica Power Center 9.0.1/8.6.1 (Power Center Designer, workflow manager, workflow monitor), Oracle 11g, DB2, Teradata, Netezza, XML, SQL Server 2012, UNIX, Toad, Autosys, Cognos.

Confidential, Philadelphia, PA

ETL/Informatica Developer

Responsibilities:

• Responsible for requirements gathering, analysis and end user Meetings.
• Design, development, deployment, and production support.
• Extracted Data from different source systems like Oracle, Flat files, Teradata, Netezza.
• Worked with PL/SQL to create complex queries and procedures.
• Worked with various transformations in Informatica power center like Filter, Aggregator, Joiner, Rank, Router, Sorter, Source qualifier, and Update Strategy transformations.
• Extensively used various Data Cleansing and Data Conversion functions like LTRIM, RTRIM, TO DATE, Decode, and IIF functions in Expression Transformation.
• Extensively worked with Joiner functions like normal join, full outer join, master outer join and detail outer join In the Joiner transformation.
• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD.
• Responsible for best practices like naming conventions, Performance tuning, and Error Handling
• Responsible for Performance Tuning at the Source level, Target level, Mapping Level and Session Level.
• Performance tuning was done at the functional level and map level. Used relational SQL wherever possible to minimize the data transfer over the network.
• Responsible for Unit testing and Integration testing of mappings and workflows.
• Effectively worked in Informatica version based environment and used deployment groups to migrate the objects.
• Reviewed and tested Informatica ETL code and wrote test plans.
• Responsible for 24/7 Informatica production support.
• Involved in various meetings, seminars, presentations and group discussions.
• Imported Informatica Data Quality (IDQ) plans as mapplets into Power Center to analyze, standardize and cleanse the source data.

Environment: Informatica Power Center 9.1, Oracle 11g, Pl/SQL, Perl, TOAD, Erwin, SQL Server, Shell Scripts.

Confidential, Berlin, CT

ETL/Informatica Developer

Responsibilities:

• Responsible for Business Analysis and Requirements Collection and involved in Designing Technical Specification.
• Transforming high-level design spec to simple ETL coding. Designing mappings according to the mapping standards, naming standards and warehouse standards for future application development.
• Used PL/SQL procedures for informatica mapping for truncating the data in target tables at runtime.
• Worked on Informatica PowerCenter 9.1 tool -Source Analyzer, Data warehousing designer, Mapping Designer & Mapplet, Transformations, Work Flow Manager (Task Developer, Worklets, and Work Flow Designer) and Work Flow Monitor.
• Extensively used Informatica PowerCenter to load data into different databases: SQL Server, Oracle, Teradata
• Created mappings using the transformations like Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy and Joiner transformations.
• Implemented effective date range mapping (slowly changing dimension type2) methodology for accessing the full history of accounts and transaction information.
• Worked with Variables and Parameters in the mappings.
• Worked in Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions. Migrated mappings from Development to Testing and performed Unit Testing and Integration Testing
• DevelopedUNIX Shell Scriptsfor scheduling the sessions in Informatica.
• Involved inPerformance tuningfor sources, targets, mappings and sessions.
• Used breakpoints and various test conditions with Debugger tool to test the logic and the validity of the data moving through the mappings.
• Created logical and physical data models and maintained relationships between tables using Erwin.
• Created deployment groups, migrated the code into different environments.
• Experience with Application ILM, Data Quality and Data Governance.
• Worked closely with reporting team to generate various reports.

Environment: Informatica PowerCenter 9.1, PL/Sql, Teradata, TOAD, Oracle 10g, SQL Server, Teredata, UNIX Shell Scripts, Erwin.

Confidential, Hartford, CT

ETL/Informatica Developer

Responsibilities:

• Extracted data from relational databases Oracle, Flat Files, and Teradata.
• Developed Complex transformations, Mapplets using Informatica to Extract, Transform and load data into Enterprise Data warehouse (EDW) and Operational Data store (ODS).
• Developed data Mappings, Transformations between source systems and warehouse
• Performed Type 2 mappings.
• Managed writing test cases and test scenarios from requirement for newly added features and executing test scripts.
• Performed Data Validations using Microsoft SQL Server Management Studio 2008.
• Worked closely with BA, and DBA team.
• Preparation of test cases/scenarios and execution.
• Recording, tracking and closing of defects/bugs in a systematic manner into a Defect Tracking System and preparation of bug report with bug severity and bug priority.
• Used debugger to test the mapping and fixed the bugs.
• Created sessions, sequential and concurrent sessions for proper execution of mappings in workflow manager.
• Used Power Center Data Masking Options (Random Masking, Blurring, SSN, Credit Card) in mappings.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Responsible to design, develop and test the software (Informatica, PL SQL, UNIX shell scripts) to maintain the data marts (Extract data, Transform data, Load data).
• Organized data in the report Inserting Filters, Sorting, Ranking and highlighting data.
• Included data from different sources like Oracle Stored Procedures and Personal data files in the same report.
• Responsible for daily verification that all scripts, downloads, and file copies were executed as planned, troubleshooting any steps that failed, and providing both immediate and long-term problem resolution.

Environment: Informatica Power Center 8.6.1, Oracle 10g, Access, Flat files, UNIX shell scripting, Windows XP, CA Autosys

Confidential, Phoenix, AZ

ETL/Informatica Developer

Responsibilities:

• Actively involved in gathering requirements from the end users.
• Involved in Data Extraction, Transformation and Loading from source systems
• Imported various Application Sources, created Targets and Transformations using Informatica Power Center 7.1.3 Designer (Source analyzer, Warehouse developer, Transformation developer, Mapplet designer, and Mapping designer).
• Designed and developed Informatica Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Used transformations like Joiner, Expression, Connected and Unconnected lookups, Filter, Aggregator, Rank, Update, Router and Sequence generator.
• Created reusable transformations and mapplets and used them in mappings.
• Developed and scheduled Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored the results in Workflow monitor.
• Did performance tuning at source, transformation, target, and workflow levels.
• Worked extensively with data migration between different versions.
• Experience in data migration in virtual environment

Environment: Informatica 7.1.3, Windows XP, TOAD, Oracle 9.2, Erwin, VSS, Putty, Business Objects 6.5.1, Test Director