We provide IT Staff Augmentation Services!

Etl Consultant Resume

New, JerseY

PROFESSIONAL SUMMARY:

  • Having 15 years of progressive experience in IT as a consultant in the areas of Business Analysis, Gap Analysis, Design, Development, Coding &Unit Testing. Experience in Retail, Pharma, Real estate, Manufacturing, Oil& Gas industries In Enterprise, CRM & Data warehouse applications.
  • 6 years Data Warehouse experience using Informatica Power Center / Power Mart (Source Analyzer, Repository Manager, Server Manager, Mapping Designer, Mapplet Designer, Transformation Designer) as ETL tool on Oracle Database.
  • Expertise in Dimensional data modeling (OLTP& OLAP), Star schema modeling, Snowflake modeling, Data Normalization. Experience in working with Erwin and TOAD.
  • Experience in developing interfaces to implement Informatica CDC &SCD data capture.
  • Experience in Data Analysis and managing data warehouse and data marts.
  • Experience in performance tuning of Informatica Sources, Targets, Mappings and Sessions. Highly proficient in processing tasks, scheduling sessions, import/export repositories, manage users, groups, associated privileges and folders.
  • Experience in Optimizing SQL & PL/SQL objects.
  • Used Erwin tool for data modeling and MS Visio to create the flow chart and to show the process flow.
  • Experience in Logical Data Modeling, Physical Data Modeling and creating ER diagrams.
  • Strong experience in coding using SQL, cursors, REF cursors, Parameterized cursors, Views, Materialized Views, PL/SQL Procedures/Functions, Triggers, Packages, PL/SQL collections and Analytical functions.
  • Hands on experience in Functional testing, Integration testing, System testing, Regression testing and End to End testing.
  • Experience in Data Validation, Cleansing & Standardization of data thru Informatica Data Quality (IDQ).
  • Experience in testing of Data Warehouse/ETL Applications developed in Informatica using SQL Server, Oracle. Ability to evaluate ETL/BI specifications and processes.
  • Worked on Processing & creation of XML files using XML transformations.
  • Experience in writing SQL scripts to validate target data with Transactional source system data.
  • Familiar in working with Quality Center to store Business Requirements, Test Cases, Bug Tracking, Test Runs and Test Results for every iteration and store defects and link them back to the requirements.
  • Functional expertise in JD edwards Distribution & Logistics modules including Sales Order Management (O2C), Purchase Order Management (P2P), Inventory, Warehouse Management, Electronic Data Interchange (EDI), Advance Pricing.
  • Good understanding of SDLC methodologies like Waterfall and Agile Scrum.

ERP - PROFESSIONAL & TECHNICAL SKILLS:

ERP: JD Edwards One World Xe, Enterprise One versions 8.0, 8.11, 9.0 & 9.1.

Domain Knowledge: Sales Order Management, Inventory, Procurement, Advance Pricing, Warehouse Management.

Tools: & Technologies: OMW, FDA, RDA, TC, EDI, UPK,BI Publisher, Create Form,BSSV, Salesforce(Sales cloud, CPQ), Informatica Power Center, Tableau

Languages: Java 2.0,VB Script, C, PL/SQL, UNIX Confidential Scripting.

Data Base: MS Access, MS SQL Server, Oracle,DB2/400,Netezza,S4 HANA

Testing Tools: Selenium, HP Quality Center, SOAPUI.

PROFESSIONAL EXPERIENCE:

Confidential, New Jersey

ETL consultant

Responsibilities:

  • Design the batch schedules using Cisco Tidal Job scheduler, perform various Job handling, file handling and data validation tasks Unix/ Confidential Scripting, PLSQL and MFT (Managed file transfer).
  • Understand the granularity, business rules and the relationship between the data elements. Design the ER Model, create the sources, lookup s, views, synonyms, and target structures to support the desired relationship. Build and maintain the objects in compliance with SAP HANA Application Life Cycle Management Process.
  • Implement Informatica workflows to migrate billions of data between different databases like SQL Server 2014, Orcale 11i, Netezza and SAP Hana.
  • Creating the detail design and building the Informatica ETL mappings, sessions and workflows to transform the source data according to data warehouse/reporting requirements.
  • Apply multiple kind of transformations including but not limited to Source Qualifier, Aggregator, Filter, Router, Sequence Generator, look up, Rank, Joiner, Expression, Stored Procedure, SQL, Normalizer and update strategy, transaction control, Java, SQL, Web Services to meet business logic in the mappings and get the data to desired level of granularity.
  • Developed interfaces to capture data using web services thru HTTP & XML parser transformations.
  • Developed interfaces to capture Web traffic Using Google Analytic API's.
  • Written Unix scripts for file transfer, List file creation & Archiving files.
  • Implemented SCD 2 data capture.
  • Processed & Created XML files using XML transformation.

Environment: Informatica Power Center 10.2, SAP S4 HANA &CAR, MS SQL Server.

Confidential, Newyork

Offshore Lead

Responsibilities:

  • Actively involved in interacting with business users to record user requirements and Business Analysis.
  • Worked with other Data Architects, Enterprise Data Warehouse stake holders, Data Modelers, developers in understanding Physical and Logical data model, system design and identify the gaps in the current system and provide technical designs and approaches to bridge the gap.
  • Involved in Design of Dimension, Fact tables & Snowflake schema design.
  • Parsing high-level design spec to simple ETL coding and mapping standards.
  • Worked with Power Center Designer tools in developing mappings and Mapplets to extract and load the data from flat files and Oracle database.
  • Maintained warehouse metadata, naming standards and warehouse standards for future application development.
  • Created the design and technical specifications for the ETL process of the project.
  • Used Informatica as an ETL tool to create source/target definitions, mappings and sessions to extract, transform and load data into staging tables from various sources.
  • Responsible for mapping and transforming existing feeds into the new data structures and standards utilizing Router, Lookups Using Connected, Unconnected, Expression, Aggregator, Update strategy & stored procedure transformation.
  • Worked on Informatica Power center tool - Source Analyzer, Data Warehousing Designer, Mapping Designer & Mapplets, and Transformations.
  • Worked with slowly changing dimension Type1, Type2, and Type3.
  • Created Workflows containing command, email, session, decision and a wide variety of tasks.
  • Developed Parameter files for passing values to the mappings for each type of client.
  • Scheduled batch and sessions within Informatica using Informatica scheduler and also wrote Confidential scripts for job scheduling.
  • Understanding the entire functionality and major algorithms of the project and adhering to the company testing process.

Environment: Informatica Power Center 9.6.1, Oracle 11g, Flat Files, UNIX, MS SQL Server.

Confidential, CA

Offshore Lead

Responsibilities:

  • Involved in the requirements definition and analysis in support of Data Warehousing efforts.
  • Worked on Power Center tools like Designer, Workflow Manager and Workflow Monitor.
  • Participated in concept definition and requirement gathering sessions to discuss the business needs and the expectations from IT division.
  • Worked with slowly changing dimension Type1, Type2 to maintain customer and supplier info.
  • Created Logical and Physical OLAP DB Model (Star Schema) for Offers Data mart to store offer’s historical data for Data analysts
  • Collecting data from Oracle EBS & JD Edwards ERP. Developed complex mappings using transformations.
  • Involved in performance tuning and unit testing.
  • Used Pipeline partitioning and External Loader to improve Session performance.
  • Scheduled and ran Extraction and Load processes and monitored tasks and workflows.
  • Tuned the databases (stage, target) for better, faster and efficient loading and user query performance.

Environment: Informatica Power Center 9.6.1, Oracle 11g, Flat Files, UNIX, Oarcle EBS,JD edwards.

Confidential, Huntsville, AL

Offshore Lead

Responsibilities:

  • Involved in the requirements definition and analysis in support of Data Warehousing efforts.
  • Worked on Power Center tools like Designer, Workflow Manager and Workflow Monitor.
  • Used ETL to extract and load data from Oracle and flat files to Oracle.
  • Developed complex mappings using transformations.
  • Involved in designing the procedures for getting the data from all systems to Data Warehousing system. The data was standardized to store various Business Units info in tables.
  • Developed Mappings to load data in Slowly Changing Dimensions.
  • Created Informatica mappings with PL/SQL Procedures/Functions to build business rules to load data.
  • Involved in optimization & performance tuning of ETL process.

Environment: Informatica Power Center 9.6.1, Oracle 11g, Flat Files, UNIX, MS SQL Server.

Confidential, Houston,TX

Offshore Lead

Responsibilities:

  • Involved in the requirements definition and analysis in support of Data Warehousing efforts.
  • Worked on Power Center tools like Designer, Workflow Manager and Workflow Monitor.
  • Used ETL to extract and load data from Oracle and flat files to Oracle.
  • Developed complex mappings using transformations.
  • Involved in designing the procedures for getting the data from all systems to Data Warehousing system. The data was standardized to store various Business Units info in tables.
  • Created Informatica mappings with PL/SQL Procedures/Functions to build business rules to load data.
  • Written the PL/SQL program units for data extracting, transforming and loading.
  • Created and ran Sessions & Workflows using Server Manager to load the data into the Data warehouse components.
  • Optimizing Complex queries/Stored Procedures.

Environment: Informatica Power Center 9.5.1, Oracle 10g, UNIX, MS SQL Server.

Confidential, Newyork

Offshore Lead

Responsibilities:

  • Involved in gathering business requirements, logical modeling, physical database design, data sourcing and data transformation, data loading, SQL, and performance tuning.
  • Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
  • Involved in designing logical and physical database designing using ERWIN tool.
  • Developed Test Cases for Data loading & Data Validation.
  • Involved in creating the mapping documents with the transformation logic for implementing few enhancements to the existing system.
  • Used Transformations like Filter, Router, Expression, Source Qualifier, Connected and Unconnected Look up to develop mappings in the DEV using Informatica PowerCenter Designer
  • Developed stored procedures and triggers to facilitate consistent data entry into the database. Written stored Procedures using PL/SQL and functions and procedure for common utilities.
  • Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages. Created programming code using advanced concepts of Records, Collections and Dynamic SQL.
  • Developed Database Triggers for audit and validation purpose.
  • Extensively worked on writing complex SQL queries (cursors, ref cursors, sub queries, correlated sub queries).

Confidential

Project Manager

Responsibilities:

  • Involved in Analyzing the ESU Impact on Standard Objects, providing technical solutions and reviewing Technical designs.
  • Providing the estimates and conducting code reviews. Assisting in Retrofitting Standard and Custom Objects.
  • Conducting weekly status meeting and sending Status report to all Stake holders.
  • Analyzing the ESU Impact on Standard Objects.
  • Reviewing the estimates and conducting code reviews.

Confidential

Project Lead

Responsibilities:

  • Analyzing the ESU Impact on Standard Objects.
  • Retrofitting Standard and Custom Objects.
  • Providing technical solutions and reviewing Technical designs. Reviewing the estimates and conducting code reviews.
  • Developed Custom Applications & Interfaces.

Confidential

Project Lead

Responsibilities:

  • Customized existing application created new applications, reports to meet business requirements.
  • Used BI Publisher for report generation.
  • Interacting with Business process leads for better understanding requirements. Providing technical solutions and reviewing Technical designs.
  • Conducting weekly status meeting and sending Status report to all Stake holders.
  • Motivating team and helping them in developing their technical skills
  • Coordinating with team members to maintain the high quality & development standards along with documentation.
  • Worked extensively in Sales and advance price modules.

Confidential

Onsite Lead

Responsibilities:

  • Confidential has a complex JDE implementation and this is a maintenance project involving of supporting various business interfaces resolving day to day business issues by interacting with end users and business focal.
  • Applications are running both in World soft & one world. Resolving day to day issues in Sales, Inventory & EDI process.
  • Helping team members in resolving issues to meet SLA’s. Preparing Weekly status reports.

Confidential

Onsite Lead

Responsibilities:

  • This is an implementation & migration project from World soft to JDE 8.12.
  • Developing new reports and customizing applications. Debugging complex Business functions and fixing the bugs.
  • Requirement gathering from the Business users and designing the solutions.
  • Conducting code reviews & Provide estimates for the various development phases. Managing offshore team.

Hire Now