We provide IT Staff Augmentation Services!

Etl Consultant Resume

Atlanta, GA

Summary:

  • 8 years of IT experience in the Design, Development, Implementation, Testing and Support of Enterprise Data warehouse and Data mart applications for Sales, Finance, Manufacturing using Informatica Power Center.
  • Extensive experience in migration of data from legacy systems and also involved in Data Warehouse Development and Data Mart Life Cycle development.
  • Strong experience in ETL (Extraction, Transformation and Loading) process using different tools like Informatica Power Center (8.1.1/8.6.1/9.1 ).
  • Performed ETL process to load data from different sources into data warehouse using Informatica Power Center (Repository Manager, Designer, Workflow Manager and Workflow Monitor).
  • Experience in integration of various data source databases like Oracle, DB2, Fixed Width Flat Files, Delimited Flat Files, Access and XML Files into staging area. And also involved in migration of data from different source DB to oracle DB.
  • Experienced in Star-Schema data modeling, Data Cleansing, Logical and Physical data model design process.
  • Extensively worked on Dimensional modeling, Data migration, Data cleansing and Data Staging of operational sources using ETL processes.
  • Actively involved in Performance Tuning, Error handling support on various Platforms.
  • Experience in implementing update strategies, incremental loads and Change Data Capture (CDC).
  • Extracted client information data and history from SQL server, Oracle E-Biz ERP applications to Business Objects which is OLAP tool.
  • Designed and developed complex mappings and transformation logics using transformations like connected and unconnected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more. Experience in execution of Sessions, workflows and worklets.
  • Strong Oracle skills that include build/maintain tables and indexes, PL/SQL scripts, Stored Procedures, Triggers, Packages, Functions and performance tuning of SQL queries
  • Possess excellent communication, interpersonal skills and ability to work in a team as well as individually.

ETL Tools

Informatica Power Center (8.1.1/8.6.1/9.1 ),Oracle Data Integrator 10.1.3.5

Databases

Oracle 11g/10g/9i, SQL Server 2000, DB2 8.1, MS Access 7.0/97/2000.

OLAP Tools

Business Objects XI 3.1/4.1

Database Modelling

Erwin 3.5.2/4.0/4.3

Query Tools

Toad, SQL Navigator, SQL Assistant.

Languages

SQL, PL/SQL, Embedded SQL, UNIX Shell Scripting, .Net.

Scheduling Tools

BMC Control-M, Informatica Scheduler.

SCCM Tools

MS Visual SourceSafe, PVCS.

Methodologies

Ralph Kimball, Bill Inmon.

Professional Experience

Confidential, Atlanta, GA Role: ETL Consultant.

Responsibilities:

  • Participated in requirement meetings with Business Analysts to understand analytical content needs, assisted in documenting these requirements, resolving ambiguities, conflicts, and ensuring requirements are complete.
  • Identified data sources to work with source system developers and business owners for defining data extraction methodologies.
  • Ensures proper configuration of the Power Center Domain components. Experience in nodes, Repository services, Integration services, and Reporting Services.
  • Worked with Data / Data Warehouse Architect on logical and physical model designs.
  • Worked with DBA to set up development, test and production environments.
  • Performed impact analysis for systems and database modifications.
  • Analyzed data values, relationships from legacy systems, relational databases, non-relational databases, ERP systems, file formats to check compliance with existing standards and business rules.
  • Extracted data from different sources such as SQL Server 2000, DB2, Oracle, Fixed width and Delimited Flat files to load into Operational Data Store (staging area).
  • Developed mappings and mapplets extensively using Informatica Designer tools - Source Analyzer, Target designer, Mapping designer, Mapplet Designer, Transformation Developer.
  • Developed complex mappings using transformations such as the Source qualifier, Aggregator, Expression, Static Lookup, Dynamic Lookup, Filter, Router, Rank, Union, Normalizer, Sequence Generator, Update Strategy, and Joiner.
  • Created Mapplets with the help of Mapplet Designer and used those Mapplets in the Mappings. Created reusable transformations and mapplets by using Lookup, Aggregator, Normalizer, Update strategy, Expression, Joiner, Rank, Router, Filter, and Sequence Generator etc. in the Transformation Developer and Mapplet Designer, respectively.
  • Developed pre and post session Stored procedures to drop, recreate the indexes and keys of source and target tables.
  • Optimized performance by tuning the Informatica ETL code as well as SQL.
  • Developed Informatica workflows and sessions associated with the mappings using Workflow Manager.
  • Developed shell scripts, which will invoke the Informatica Power Center workflows passing all the variables for the job to execute like user id, password.
  • Involved in migration of data files from WHI and Nuevo Laredo item information to oracle staging area, in this process data files will be on their local servers these data files will FTP to local INFA server and from there data files are processed to staging and dimension tables.
  • Developed, executed, documented Unit test plans, Integration test plans, System test plans validating the results with Business Analyst and End User.
  • Performed migration of mappings and workflows from Development to Test and to Production Servers.
  • Running and monitoring daily scheduled jobs by using Work Load manager for supporting EDW (Enterprise Data Warehouse) loads for History as well as incremental data.
  • Investigating failed jobs and writing SQL to debug data load issues in Production
  • Involved in the Onsite and Offshore Coordination in completing the work and Delivering to the Client.
  • Used Autosys to schedule Informatica workflows and UNIX scripts to automate jobs.

Environment: Informatica Power Center 9.1, Business Objects XI 4.1, Oracle11i, Oracle E-Business Suite 12.1.1, DB2, I-series, sql developer, PL/SQL, SQL Server 2000, Flat files, Windows NT, Oracle Linux v5, Autosys.

Confidential, MI. Role: Informatica ETL developer.

Responsibilities:

  • Involved in business requirements, created data mapping documents.
  • Used Informatica Power Center for Extraction, Transformation and Loading to Target.
  • Extracted client information data and history from JD Edwards, SQL server, DB2 transformed and loaded into oracle database.
  • Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Developer.
  • Designed and developed mappings with optimal performance using Aggregator, Java, Joiner, Normalizer, Rank, Sequence Generator, SQL, Transaction Control ,Un-Cached & various kinds of Cached Lookup, pre and post load Stored Procedure Transformations, Update Strategy , Union, XML Transformations ,etc.
  • Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
  • Used Normalizer Transformation to normalize data from COBOL sources and used Aggregators to De-normalize records to create one record.
  • Created Reusable Transformations, Mapplets and Mappings using Designer.
  • Extensively used pre-session and post-session variable assignment for simulating multithreading scenarios for Load balancing and performance improvement.
  • Used pre-session and post-session variable assignment to transport variable (flags and counters) values across sessions and work-lets.
  • Used Constraint Based loading & target load ordering to efficiently load tables with PK-FK relation in the same mapping.
  • Edited different kinds of Partition points and Created partitions to improve performance by activating multiple Transformation Threads for optimal use of system resources.
  • Created sessions and workflows to help schedule nightly loads and process data from all source terminal Data Collection points.
  • Implemented SCD methodology including Type 1, Type 2 changes to keep track of historical data.
  • Wrote shell scripts and Stored Procedures for regular Maintenance and Production Support to load the warehouse in regular intervals and to perform Pre/Post Session Actions.
  • Used reusable look-up transformations, across the folders.
  • Used Incremental Aggregation technique to load data into Aggregation tables for improved performance.
  • Extensively used Parameter file to override mapping parameter, mapping Variables, Workflow Variables, Session Parameters, Ftp Session Parameters and Source-Target Application Connection parameters.
  • Involved in scheduling the workflows through Autosys and Job scheduler using UNIX scripts.
  • Monitored the jobs daily and involved in production support.

Environment: Informatica 8.5.1, Power exchange, Business Objects XI 3.1, Oracle10g, DB2, SQL Server, PL/SQL, Flat files, Windows NT.

Confidential, IN.

Role: ETL Developer/ Analyst

Responsibilities:

  • Extensive interaction with users to understand their requirements, coordination with other project teams to arrive at synergy and unified development plan.
  • Identified data sources to work with source system developers and business owners for defining data extraction methodologies.
  • Developed mappings and mapplets extensively using Informatica Designer tools - Source Analyzer, Target designer, Mapping designer, Mapplet Designer, Transformation Developer.
  • Developed complex mappings using transformations such as the Source qualifier, Aggregator, Expression, Static Lookup, Dynamic Lookup, Filter, Router, Rank, Union, Normalizer, Sequence Generator, Update Strategy, and Joiner.
  • Developed sessions using Workflow Manager for loading data into target Database.
  • Worked on Performance Tuning of various mappings and sessions to identify and remove Bottle Necks. Designing of Error Handling Strategies.
  • Supported users with word processing, spreadsheets, databases and presentation software.
  • Data modeling and design of data warehouse and data marts in Snowflake and Star schema methodology with confirmed and granular Dimensions and FACT tables
  • Designing of Physical and Logical Data Model using the Erwin tool.
  • Maintaining the Metadata of the Data Model
  • Keeping track of the changes and various version of Data Model intact.
  • Developed, executed, documented Unit test plans, Integration test plans, System test plans validating the results with Business Analyst and Customer.
  • Performed migration of mappings and workflows from Development to Test and to Production Servers.
  • Scheduled walkthroughs of design documents, specifications, code, test plans etc. as appropriate throughout project lifecycle.
  • Worked with DBA to set up development, test and production environments.
  • Writing UAT test cases and UAT Support.
  • Involved in analyzing database schema using Erwin. Performed impact analysis for systems and database modifications.

Environment: Informatica Power Center 8.1.1(Designer, Workflow Manager),DB2 UDB v8.1, Oracle 9i, SQL Server 2000, MS Access, Windows XP, Linux, Unix Shell Scripting, Toad.

Confidential, Louisiana.

Role: ETL Developer

Responsibilities:

  • Widely used Informatica client tools -- Source Analyzer, Target designer, Mapping designer, Transformation Developer and Informatica Work Flow Manager.
  • Coordinating with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance.
  • Designed Informatica mappings by translating the business requirements.
  • Developed many complex Initial/Incremental Informatica Objects (Workflows / Sessions, Mappings/ mapplets with various transformations i.e., expressions, aggregators, filters, lookup, stored procedures transformations, join, normalize, filter, router, sorter and update strategy)
  • Extensively worked on the performance tuning of the Mappings as well as the sessions.
  • Implemented caching and aggregate table techniques to improve the performance.
  • Knowledge of extracting heterogeneous and homogeneous sources.
  • Involved in Customization and development of various Pl/Sql procedures to take care of migration activities.
  • Developed procedures/shell scripts/external tables/SQL* Loader scripts to load the data from plain text files/csv files into database tables.
  • Monitor Informatica jobs which will load the data from OLTP to OLAP.
  • Analyze, Design, and Develop OBIEE Metadata repository (RPD) that consists of Physical Layer, Business Mapping and Model Layer, and Presentation Layer
  • Customized and developed the OBIEE Business Model and Mapping layer, Implemented logical column measures and calculations.
  • Developed and debugged many Dashboards using different Analytics Views (Pivot Table, Pie/Bar Chart, and View/Column Selector, Narrative View), Dynamic / Interactive dashboards with drill-down capabilities using global and local Filters.
  • Effectively managed ODBC connections and imported the Physical tables, keys and foreign keys.

Environment: Informatica Power Center 8.1.1, OBIEE, Pl/Sql, SQL, UNIX Scripting, Sybase, Oracle, Teradata.

Confidential,Role: ETL Developer

Responsibilities:

  • Translated business requirements into Informatica mappings/workflows.
  • Used Source Analyzer and Target designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.
  • Used Informatica Designer to create complex mappings using different transformations like filter, Router, lookups, stored procedure, joiner, update strategy, expressions and aggregator transformations to pipeline data to Data Warehouse/Data Marts.
  • Extensively worked in the performance tuning of the programs, ETL Procedures and processes and applying CDC /Bulk load.
  • Designed and developed number of complex mappings, mapplets and reusable objects for the GLIMS to facilitate daily and monthly load of data.
  • Developed various Reports for Samples and Packages of Batch system using Business Objects.
  • Involved in fixing invalid Mappings, Unit and Integration Testing of Informatica Sessions, Batches and the Target Data.
  • Created UNIX shell scripts for Informatica pre/post session operations.
  • Worked with mapping variables, Mapping parameters and variable functions like set variable, Count Variable, set min-variable and set max-variable.
  • Involved in designing target database for the Data marts.
  • Wrote SQL Queries, Triggers and PL/SQL Procedures to apply and maintain the Business Rules.
  • Extracted the data from Oracle, Flat files, SAP and load into Data Mart.

Environment: Informatica PowerCenter8.1.1 Oracle 9i, PL/SQL, Toad, Windows NT, UNIX, Business objects 6.5, Microsoft VSS.

Confidential, ROLE: ETL Developer.

Responsibilities:

  • Conducted client system surveys, analyzed business requirements and processes. Assisted in Creating Logical and Physical Data Modeling by using Erwin data modeling tool.
  • Translated user requirements to configure and implement the clarify Data mart.
  • Creating the Design and Technical specifications for the ETL process of the project.
  • Extensively used Informatica power center for extraction, transformation and loading process.
  • Extracted data from various sources like Oracle, flat files and SQL Server.
  • Worked extensively on Source Analyzer, Mapping Designer, Mapplet designer and Target designer and Transformation Developer.
  • Designed and developed Informatica Mappings and sessions based on Business rules.
  • Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
  • Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
  • Used workflow manager for session management, database connection management and scheduling of jobs.
  • Written UNIX shell scripts for scheduling the sessions and workflows.
  • Created Reusable Transformations, Mapplets and Mappings using Designer.
  • Used the Workflow Manager, to create the session, workflows. Monitoring the cubes and workflows.

Environment: Informatica Power Center 8.1.1, ORACLE 9i, UNIX, Windows 2000, Erwin 3.5, SQL PLUS.

Confidential,
ROLE: ETL Developer.

Total Inventory Management System Project has been executed to get the complete ERP solutions that included production Accounting and Payroll. Total Inventory consists of Inventory, Purchase, Sales and Marketing.

Responsibilities:

  • Understanding existing business model and customer requirements.
  • Preparation of Detailed Functional Specifications and Detailed Implementation Specification.
  • Enforcing Business Rules using Database Triggers. Development of Pl/SQL Procedures, Functions and Packages.
  • Development of various master data entry screens using Developer 2000 (Forms 6i).
  • Development of various reports using Report Builder – Tabular Reports, Group Reports, and Matrix Reports.
  • Development of backend process in pl/sql for data retrieval.
  • Worked with the Data processing team in creating the database tables and objects.

Environment: Oracle 9i (SQL*Plus & PL/SQL), Forms, Reports.

Hire Now