SUMMARY:

• Data Warehousing Developer with more than 8 years of experience with
• Data Analysis, ETL, Data Modeling, Development, Testing and documentation.
• Modeling
• Mapping
• Data Quality
• File Debugger
• Transformations
• Data Loading
• Data Analysis
• Technical Writing
• Batch Scheduling
• Prioritization
• Best Practices
• Problem Resolution

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.1/8.6 Designer, Work - flow Manager, Work-flow Monitor

Databases: Oracle 11g/10g, SQL Server, DB2, Teradata

Data Modeling: Erwin

Database GUI Tool: TOAD

Languages: UNIX Shell Scripting, PL/SQL

Batch Scheduling: Control-M

Microsoft: Excel, Word, PowerPoint

WORK EXPERIENCE:

Confidential ~ Philadelphia, PA

ETL Developer

Responsibilities:

• Involved in Business Users Meetings to understand their requirements.
• Converted business requirements into technical documents
• Developed Data Flow diagrams to create Mappings and Test plans.
• The Data flow diagrams ranged from OLTP systems to staging to Data warehouse.
• Developed Test plan to verify the logic of every Mapping in a Session. The test plans included countsverification, look up hits, transformation of each element of data, filters, and aggregation and target counts.
• Developed complexInformaticamappings using various transformations- Source Qualifier, Normalizer, Filter,Connected Lookup, Unconnected Lookup, Update strategy, Router, Aggregator, Sequence Generator, Reusablesequence generator transformation.
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once
• Monitored Workflows and Sessions using Workflow Monitor.
• Performed Unit testing, Integration testing and System testing ofInformaticamappings.

Confidential ~ Philadelphia, PA

ETL Developer

Responsibilities:

• Develop ETL process usingInformaticato load Dimension and Fact tables.
• Analyze the existing PL/SQL codes and create the mapping logics for data migration.
• To build error handling based on the data quality requirements.
• Prepare deployment process and code migration from dev to QA, QA to Production.
• Create Source to Target mappings document, design documents, configuration and support documents.
• Maintain coding standard and reusability in the objects created ininformatica.
• Working with DBA to improve the performance of the ETL Process.

Confidential . ~ Minneapolis, MN

ETL Developer

Responsibilities:

• Requirement Analysis and Design, Logical and physical database design.
• Determination of required changes to database and application code.
• Worked with various transformations in Informatica Power Center.
• Used ETL Data Warehousing using Informatica Client Tools (Designer, Workflow Manager, Workflow Monitor, Repository Manager and Repository Administration Console).
• Worked extensively with all Informatica Designer tools including Source Analyzer, Target/Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Designed and developed complex and dynamic Informatica Slowly Changing Dimensions to apply various commissioning business rules.
• Analysis of star schema in dimensional modeling and Identifying suitable dimensions and facts for schema defining relationship within & between groups of data.
• Documented data conversion, integration, load and verification specifications.
• Scheduled batch and sessions within Informatica using Informatica scheduler and also wrote shell scripts for job scheduling.
• Maintained Development, Test and Production mapping migration Using Repository Manager.
• Created test cases and run the cases using Mercury Quality Center.
• Used debugger to test the mapping and fixed the bugs.

Confidential ~ Minneapolis, MN

ETL Developer

Responsibilities:

• Responsible to analyze functional requirement. Created design specification and technical specifications based on functional requirements
• Extensively worked on developingInformaticaMapplets, Mappings, Sessions, Worklets and

  Workflows for data loading.

• Worked on transformations such as Lookup, Aggregator, Expression, Joiner, Filter, Rank, Sorter, Router, Sequence Generator, XML transformation etc.
• Created mappings of initial load for all source systems, cleansed data and load it into staging area.
• Extensively used ETL to load data from wide range of sources such as relational database, XML, flat files (fixed-width or delimited) etc.
• Expertise in writing Pre & Post SQLs and overrides SQLs as per the requirement.
• Extensively worked on using the PDO (Push down optimization), CDC (Change data capture) mechanism
• Extensively used the capabilities of Power Center such as File List, PMCMD, Target Load Order, Constraint Based Loading, Concurrent Lookup Caches etc.
• Responsibilities included designing and developing complexInformaticamappings including Type-II slowly changing dimensions.
• Identifies, researches, and resolves ETL root cause of production issues or system problems.
• Worked with Pre-Session and Post-Session UNIX scripts for automation of ETL jobs using CONTROL-M schedulers and involved in migration/deployment of ETL codes from development to production environment.
• Knowledge on STAR Schemas and Snowflake Schema.
• Responsible for creating the parameter files in order to connect to the right environment and data base.
• Responsible for monitoring sessions. Debugged mapping of the failed session.

Confidential ~ Minneapolis, MN

ETL Developer

Responsibilities:

• Worked with Business Users in requirements gathering and creating requirements Specification documents.
• Created Technical System Design documents, Low Level Design documents.
• Worked extensively onInformaticaclient tools such as Designer, Workflow manager, Workflow Monitor.
• Worked onInformaticatransformations such as Source Qualifier, Filter, Update Strategy, Union, Sorter, Expression, Aggregator, Joiner, Connected & Unconnected Lookup transformation, Sequence Generator, Transaction Control etc.
• DevelopedInformaticamappings/sessions/workflows - Extensively used Dynamic/Persistent Lookup cache techniques for minimizing the load window.
• Developed re-usable transformations, Mapplets following theInformaticabest practices.
• Involved in designing ETL data load strategy for SCD type 2, Dimensions and Fact tables, ETL reject handling, ETL restart recovery logic.
• Extracted source data from Flat Files, XML, Oracle and a relational warehouse.
• Involved in client interaction, analyzing issues with the existing requirements, proposing solutions and implementing the same.
• Involved in performance tuning SQL andInformaticamappings/sessions by session partitioning techniques.
• MigratedInformaticaobjects (mappings/sessions/work lets/workflows) from the Dev to QA, Perf and Production Environments.
• Created Unit & QA test case templates (standardized formats).
• Involved in doing the effort analysis for new work requests/enhancements.
• Interfacing with various Technology and Business groups.
• Involved in the SIT, UAT and production rollout.