SUMMARY:

• Over 5+ years of experience in data warehouse using Informatica power center mainly ETL Tool, OLAP and OLTP, Database Design, Development, Testing and Production Environments
• Experience in dealing with various Data sources like Oracle, SQL Server, Teradata, MS - Access, MS - Excel, EDI files and Flat files.
• Experience in working with indexes, complex queries, stored procedures, views, triggers, user defined functions, complex joins, packages, Cursors using PL/SQL, loops T-SQL using MS SQL Server.
• Experience in design and developing complex mapping to extract data from various sources including Flat files, RDBMS tables, Legacy system files, XML files, Application, COBOL sources.
• Strong working knowledge in RDBMS, Normalization and De Normalization Concepts.
• Experience working with configuring SSIS packages using package logging, breakpoints, Checkpoints and Event handler to fix the errors.
• Strong knowledge of Dimensional Data Modeling using Star Schema and Snow-Flake Schema.
• Experience working with Sales Force connections in Informatica Power Center, configuring Informatica Power Exchange add on for SAP (Power Connect) and IDQ.
• Experience working with Informatica Designer, workflow manager, workflow monitor to create, schedule and control workflows, tasks, and sessions.
• Designed and written the scripts required to extract, transform, load (ETL), clean, and move data and metadata so it can be loaded into a data warehouse, data mart, or data store .
• Experience in Task Automation using UNIX Shell Scripts, Job scheduling (AUTOSYS) with Server using pmcmd.
• Excellent communication skills and a great team player.

TECHNICAL SKILLS:

ETL: Informatics Power center 9.5.1/ 9.6.1/10.1

Databases: Oracle 11g/10g, Oracle EBS 11g, Ms SQL server 2012/2008, MySQL Server 5.1, MS Access

Operating systems: Windows, UNIX (Sun-Solaris, HP/UX), Linux

Scripting languages: Understanding Shell Scripting.

Scheduling Tool: Autosys

Packages: SQL* PLUS, Toad 7.x, SQL Navigator 4.

PROFESSIONAL EXPERIENCE:

Confidential, Dayton,OH

ETL Developer

Responsibilities:

• Developed several VBA macros, delivered file in various file formatting system (ex. Excel file, Tab delimited text, Coma separated text, Pipe delimited text etc.)
• Developed inline view queries and complex SQL queries and improved the query performance for the same.
• Did extensive work with ETL testing including Data Completeness, Data Transformation & Data Quality for various data feeds coming from source.
• Identify issues, information and behaviors during the adoption of a proprietary information management system.
• Analyzed the Business Requirement Documents (BRD) and laid out the steps for the data extraction, business logic implementation & loading into targets.
• Used Informatica as ETL tool to pull data from source systems/ files, cleanse, transform and load data into the Teradata Utilities.
• Worked on Informatica- Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet, and Transformation D eveloper .
• Used most of the transformations such as the Source Qualifier, Expression, Aggregator, Filter, Connected and Unconnected Lookups, Joiner, update strategy and stored procedure.
• Developed mappings to load Fact and Dimension tables, SCD Type 1 and SCD Type 2 dimensions and Incremental loading and unit tested the mappings.
• Involved in Initial loads, Incremental loads and Daily loads to ensure that the data is loaded in the tables in a timely and appropriate manner.
• Created Reusable transformations, Mapplet, Worklet using Transformation Developer, Mapplet Designer and Worklet Designer.
• Integrated the data into centralized location. Used migration, redesign and Evaluation approaches.
• Responsible for Unit Testing, Integration Testing and helped with User Acceptance Testing.
• Develop code necessary to introduce additional reports, reverse engineer data models to the business meaning, and instruct users on the account management and implementation process advantages derived from the system.
• Performed Input Validations, User Interface Validations, Browser Compatibility testing and Navigation testing.
• Defect Reporting, Analyzing, Tracking and Report Generation using Mercury Quality Center.

Confidential, San Francisco, CA

ETL DEVELOPER

Responsibilities:

• Requirements gathering, analyze, design, code, test highly efficient and highly scalable integration solutions using Informatica PowerCenter 9.6.1 and Power Exchange, Oracle, SQL, Source systems viz.
• Performed the data profiling and analysis making use of Informatica Data Explorer (IDE) and Informatica Data Quality (IDQ)
• Implemented SCD I, II to the extracts based on the business requirement and client expectations.
• There were two kinds of data loading processes (Daily and Weekly) depending on the frequency of source data.
• Imported data from various sources transformed and loaded into Data Warehouse Targets using Informatica.
• Worked on Informatica - Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet, and Transformation Developer.
• Fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and Target Data.
• Extensively used Transformations like Router, Aggregator, Source Qualifier, Joiner, Expression, Aggregator and Sequence generator.
• Scheduled Sessions and Batches on the Informatica Server using Informatica Server Manager/Workflow Manager.
• Worked with different sources such as Oracle, SQL and flat files.
• Knowledge of slowly changing dimension tables and fact tables.
• Optimizing the mappings by changing the logic to reduce run time.

Confidential, Deerfield Beach, FL

ETL DEVELOPER

Responsibilities:

• Interacted actively with Business Analysts and Data Modelers on Mapping documents and Design process for various Sources and Targets
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Analyzing, designing and implementing complex SQL stored procedures, ETL processes and Informatica mappings.
• Implemented SCD1, SCD2 type maps to capture new changes and to maintain the historic data
• Providing technical assistance during production phase of project development
• Defined and developed technical standards for data movement and transformation as well as review all designs to ensure those standards are met.
• Handled extraction of various types of source files Flat files, XML standard source data of different transactions and loading to staging area.
• Designed and written the scripts required to extract, transform, load (ETL), clean, and move data and metadata so it can be loaded into a data warehouse, data mart, or data store.
• Created new mappings and enhancements to the old mappings according to changes or additions to the Business logic.
• Created scripts using Fast Load, Multi-Load to load data into the Teradata data warehouse.
• Updated numerous Bteq / Sql scripts, making appropriate DDL changes and completed unit and system test
• Worked extensively on Unit Testing the ETL mappings and preparing efficient unit test documentation for the developed code to make sure the test results match with the client requirement.
• Provided enterprise data warehousing solutions, including design and development of ETL processes, mappings and workflows using Informatica Power Center.
• Participated in design workshops, providing technical insight and knowledge.

Confidential, San Diego, CA

ETL Developer

Responsibilities:

• Worked with Informatica Power Mart client tools like Source Analyzer, Warehouse Designer, and Mapping.
• Worked on Informatica tools like Source Analyzer, Target Designer, Mapping Designer, Workflow Manager, and Workflow Monitor.
• Extracted data from Flat files loaded them into EDW.
• Worked on multiple inbound ASN files to create XML, created a list file with the entire Inbound ASN files list on UNIX and use indirect loading and transforming methods in Informatica
• Handled extraction of various types of source files Flat files, XML standard source data of different transactions and loading to staging area.
• Wrote Data loading stored procedures, functions using PL/SQL from Source systems into operational data storage.
• Involved and Worked with DBA to build Dimension Tables and Fact Tables.
• Created Complex Mapping for generating the parameter files.
• Created source and target mappings, transformation logic and processes to reflect the changing business environment over time.
• Designed and developed SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
• Utilized SSIS (SQL Server Integration Services) to produce a Data Warehouse for reporting.
• Mainly involved in developing Star Schema (Facts and dimensions based on future requirements).
• Developed source to target mappings and scheduling Informatica sessions.

Confidential, Los Angeles, CA

ETL Developer

Responsibilities:

• Documenting user requirements, Translate requirements into system solutions and developed implementation plan and schedule.
• Involved in Data Analysis of the OLTP system to identify sources data elements.
• Prepared Source to Target ETL mapping Documents.
• Loaded staging database from source as Flat Files, XML, Oracle, and SQL Server & My SQL
• Worked in Hadoop environment to analyze the existing Hive QL and converted them to Informatica.
• Created different mappings for loading the data into targets using various transformations such as Source Qualifier, Joiner transformation, Router, Update Strategy, Lookup transformation, Expression, Aggregator, and Sequence generator.
• Developed and designed Informatica Workflows or sessions to load the data into target Data Mart.
• Involved in implementing CDC & SCD (Type 1 & Type2).
• Participated in Code migration to different Repositories.
• Coordinated with DBA's and Informatica Admin to fix the issues.
• Designed and developed Informatica Mappings, Reusable Sessions, Worklets, Workflows, Dynamic Parameter files.
• Provided solutions for various performance bottle necks in Informatica Mappings.
• Coding UNIX scripts and ParmFiles for implementing business rules.
• Designed mappings for populating Tables for one time load and incremental loads.
• D eveloped different brand level Reports, Filters, and Prompts using Oracle BI.
• Created Batch jobs, scheduling and testing the reports.
• Designed and Developed Autosys to Schedule Informatica workflows.
• Worked on Business Objects Data Services, Designer, Repository, Job Server, Cleansing Packages,
• Involved in Unit testing, System Integration testing, User Acceptance Testing.