We provide IT Staff Augmentation Services!

Etl Resume

New York, NY

SUMMARY

  • Over 6+ years of Experience in all the phases of the Data warehouse life cycle involving design, development & analysis and testing of Data warehouses using ETL.
  • Designed and developed different slowly changing dimension procedures for multiple data extracts based on business requirements.
  • Strong in DWH concepts, Dimensional Table, Fact Table, Dimensional Data Modeling, Star Schema and Snowflakes Schema methodologies.
  • Extensive knowledge in design of Extract, Transform, Load environment usingInformaticaPowerCenter9.1/8.x/7.x/6.x.
  • Extensively worked on ETL process consisting of data transformations, data sourcing, mapping, conversion and loading.
  • Extensive experience in implementation of Data Cleanup procedures, transformations, Scripts, Stored Procedures and execution of test plans for loading the data successfully into the targets.
  • Have RDBMS concepts experience in Oracle 11i/10g/9i/8i/7.x, WinSQL, SQL*Loader,Netezza
  • Extensively worked withNetezzadatabase to implement data cleanup, performance tuning techniques.
  • Experience in managing SSIS packages and DTS 2000 packages within SQL Server Management Studio(SSMS)
  • Expertise in creating reports using SQL Server Reporting Services (SSRS), Crystal Reports and Excel Spreadsheet.
  • Experienced in Performing Unit testing, system testing and system integration testing.
  • Have excellent written and oral communication skills with the ability to communicate appropriately in business and technical situations at all levels.
  • Have Experience in designing and developing UNIX shell scripts as part of the ETL process to compare control totals, automate the process of loading, pulling and pushing data from & too different servers.
  • Have ability to understand and interact with technically-oriented team members. Skilled in using MS Office applications for day to day activity, MS Visio for drawing flow diagrams.
  • An excellent team member with an ability to perform individually, good interpersonal relations, strong communication skills, hardworking and high level of motivation.

TECHNICAL SKILLS

Operating Systems: UNIX, Linux, Windows XP/2000/98/95
Databases :Netezza4.6.8, Oracle 10g/9i/8i/7.x,
ETL Tool:InformaticaPower Center 9.x/8.6/8.5/8.1, 7.1, 6.2/6.1
BI Tools: Business Objects, Micro Strategy 8x/9x
Office Tools: MS Excel, Access, Visio, PowerPoint, Word

Confidential, Manchester, NH May 2011-Present
Sr. ETL Developer

Responsibilities:

  • Expertise in of the Extract, Transform and Load process and development of transformation standards and processes usingInformaticabest practices.
  • Designed the architecture of customer master Project in team.
  • Usedinformaticapower center 9.0.1 to Extract, Transform and Load data into Netezza Data Warehouse from various sources likeOracle and flat files.
  • Used various transformations like Source Qualifier, Lookup, Router, Filter, Update, Expression, Aggregator, Sorter, Sequence Generator etc.
  • Used unconnected lookup where different expressions used the same lookup and had multiple targets, which use same logic executed and return one value.
  • Developed mappings of Customer, Specialty, State license number, Organization, Provider and Location dimensions implementing the ETL logic.
  • Loaded Data into target Data warehouse from 12 different sources.
  • Created and Configured Workflows, Worklets, and Sessions to transport the data to target warehouseNetezzatables usingInformaticaWorkflow Manager.
  • Used workflow monitor to see the work flows running and get the session properties and session log.
  • Developed all the mappings according to the design document and mapping specs provided and performed unit testing.
  • Created workflow documentation for each of the developed mapping.

Environment:Netezza4.x, Oracle 10g,InformaticaPower Center 9.0.1 , Flat Files, Unix Shell scripts, Windows XP.

Confidential, MI Jan’10 – Mar’11
Informatica Developer

Responsibilities:

  • Interacted with business users and gathered requirements based on the changing needs. Incorporated identified factors into Informatica mappings to build the DataMart.
  • Developed a standard ETL framework to enable the reusability of similar logic across the board. Involved in system documentation of dataflow and methodology.
  • Created technical design specification documents based on the functional design documents and the physical data model.
  • Responsible for design and developing of ETL (Extract, Transform and Load) processes usingInformatica PowerCenter8.6.1/8.5.1.
  • Extracted data from data Sources like Flat files, Relational Databases and Heterogeneous sources.
  • Maintained source and target mappings, transformation logic and processes to reflect the changing business environment over time.
  • Used transformations like Source Qualifier, Aggregator, Filter, Router, Sequence Generator, Lookup, Rank, Joiner, Expression and Update Strategy in the mappings to meet business needs.
  • Worked on Mapping parameters, Mapping variables and passing parameters between sessions.
  • Worked extensively on schema (Star schema) creations in data warehouse.
  • Created sessions, batches for incremental load into staging tables, and schedule them to run daily.
  • Involved in performance tuning in the ETL processes.
  • Worked on slowly changing dimensions(Type1 and 2)
  • Developed shell scripts, PL/SQL procedures, for creating/dropping of table and indexes of performance for pre and post session management.
  • Used SQL tools likeWinSQL to run SQL queries and validate the data in warehouse.

Environment: Informatica Power Center 8.6.1/8.5.1, Oracle 10G/9I, WinSQL, Windows XP/2008, Microsoft Office 2007, Unix Shell Scripting.

Confidential, New York, NY Jul’08 – Dec’09
Role:ETL Consultant

Responsibilities:

  • Analyzed the source data coming from Oracle, Flatfile . Worked with Data Warehouse team in developing Dimensional Model.
  • UsedInformaticaDesigner to create mappings using different transformations to move data to a Data Warehouse. Developed complex mappings inInformaticato load the data from various sources into the Data Warehouse, using different transformations like Source Qualifier, Expression, Lookup, Aggregator, Update Strategy, Joiner, and Rank.
  • Responsible for creating different sessions and workflows to load the data to Data Warehouse usingInformaticaWorkflow Manager.
  • Involved in identifying the bottlenecks in Sources, Targets & Mappings and accordingly optimized them.
  • Worked with NZLoad to load flat file data intoNetezzatables.
  • Good understanding aboutNetezzaarchitecture.
  • Assist DBA and Architect to identify proper distribution keys forNetezzatables.
  • Created mappings using pushdown optimization to achieve good performance in loading data intoNetezza.
  • Created and Configured Workflows, Worklets, and Sessions to transport the data to target warehouseNetezzatables usingInformaticaWorkflow Manager.

Environment:InformaticaPower Center (Designer 7.x, Repository Manager 7.x, Workflow Manager 7.x), Flat files,Netezza4x, UNIX, WinSQLand Shell Scripting

Confidential, NY July 07 - Jun’08
Informatica Developer

Responsibilities

  • Worked closely with the Data Modelers for Designing and customizing data models for Data warehouse, supporting data from multiple sources in real time.
  • Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
  • Created mapping documents to outline data flow from sources to targets.
  • Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
  • Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, and Union to develop robust mappings in the Informatica Designer.
  • Developed Mapping parameters and Variables to support SQL override.
  • Created Mapplets to use them in different mappings.
  • Developed mappings to load into staging tables and then to Dimensions and Facts.
  • Used existing ETL standards to develop these mappings.
  • Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, Worklets, Assignment, Timer and scheduling of the workflow.
  • Created sessions, configured workflows to extract data from various sources, transformed data, and loaded into data warehouse.
  • Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
  • Involved in performance tuning for sources, targets, mappings and sessions.
  • Involved in preparing the migration document to move the mappings from development to testing and then to production repositories.

Environment: Informatica Power Center 7.1.4/7.1.1, Oracle 9i, SQL Plus, Windows 2005/XP, Microsoft Office 2003, Shell Scripting.

Confidential, Los Angeles, CA March 06 - July 07
Role: ETL Developer

Responsibilities

  • Worked with business analysts to identify appropriate sources for Data warehouse and to document business needs for decision support data.
  • Designed the ETL processes usingInformaticato load data from Flat Files to target Oracle Data Warehouse database.
  • Performed data manipulations using variousInformaticaTransformations like Joiner, Expression, Lookup, Aggregate, Filter, Update Strategy, and Sequence Generator etc.
  • Involved in creating logical and physical data modeling with STAR and SNOWFLAKE schema techniques using Erwin in Data warehouse as well as in Data Mart.
  • Written SQL overrides in source Qualifier according to business requirements.
  • Written pre session and post session scripts in mappings.
  • Created sessions and workflow for designed mappings.
  • Redesigned some of the existing mappings in the system to meet new functionality.
  • Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions and scheduling them to run at specified time with required frequency.
  • Extensively worked in the performance tuning of the programs, ETL Procedures and processes.
    Developed PL/SQL procedures for processing business logic in the database.
  • Migrated the mapping to the testing and production department and introduced the concepts ofInformaticato the people in testing department.
  • Produced documentation as per the company standards and SDLC.

Environment:Informatica6.x,Netezza, ORACLE9i ,UNIX, Windows NT, UNIX Shell Programming.

Hire Now