We provide IT Staff Augmentation Services!

Etl Consultant Resume

SUMMARY:

  • 12+ Years of experience in designing and developing DATAWAREHOUSE applications
  • 10+ Years of experience in Informatica development
  • 5+ years of experience in DATA Architecture on Oracle, Teradata, Sybase databases
  • Extensive knowledge on Human Resources, Investment Banking, Retail, Payments and product domains
  • Extensive knowledge on ERP, SFDC, ZUORA, Omniture systems
  • Experienced in data analysis for developing a Third Normal form, Multi - dimensional STAR SCHEMA with fact and dimension tables.
  • Experienced on query performance tuning on Teradata, Oracle and Sybase systems
  • Experienced in designing and developing data models using Erwin and SAP Power Designer
  • Experienced in using Informatica data Quality and Informatica Analyst for data profiling
  • Hands of Experience in Creating Oracle PL/SQL stored procedures, functions, Materialized views and packages.
  • Experience in Using Repository Manager, Designer Workflow Manger and Admin Console Tools in Informatica Power Center
  • Experience in administering Model Marts in Erwin and Power designer
  • Possess knowledge of HADOOP stack on HORTONWORKS distribution
  • Experienced in UNIX Shell scripting

TECHNICAL SKILLS:

ETL TOOLS: Informatica PowerCenter 9x

Data Profiling tools: Informatica IDQ, Informatica Analyst

Data Security TOOL: IBM Infosphere - Guardium 9.0

DATA MODELING TOOL: Power Designer 15, 16, SQL Datamodeler, Erwin

REPORTING TOOLS: Actuate, TABLEAU

OPERATING SYSTEM: Windows, MS-DOS

LANGUAGES: C, C++, PERL, PYTHON, SHELL scripting

RDBMS: Oracle,Teradata, Sybase.

SCHEDULERS: TIDAL, CNTRL-M

PROFESSIONAL EXPERIENCE:

Confidential

ETL CONSULTANT

Environment & Technologies:

Database Related: Teradata 14, Oracle 11g, ERWIN datamodeller

Operating System: Windows NT, UNIX

Responsibilities:

  • Liaised with Business stakeholders/Product owners/Project managers to understand project requirements on varied source systems like ERP, SFDC, ZUORA, ELOQUA, Omniture, Human Resources, Renewals, Entitlements, Marketing and campaign, Customer Feedback(website, estore, product and chat feedback), Telemetry, Product Information Framework, Customer Hierarchy management, etc,.
  • Consolidated multiple ERP system account receivables to ensure operations team gets a single view of customer credit, payment and receipt information in Enterprise Data Warehouse
  • Developed mappings, sessions and workflows on INFA 9x
  • Used Informatica IDQ, Informatica Analyst for data profiling
  • Collaborated with Data architecture team to ensure processes are maintained
  • Guided ETL, BI Reporting and QA teams on data model/objects with Source to target mapping
  • Created several SCD Type1 and SCD Type 2 data objects to store data for historical reporting
  • Participated in daily status calls to report task status on a daily basis
  • Maintained Model Mart repository to keep Logical and Physical models up to-date with enterprise data warehouse
  • Modelled over 400~ database objects to host data in enterprise data warehouse
  • Indexed, partitioned the database objects to enable optimum query performance
  • Co-ordinated with offshore counterparts to propagate requirements and tracked ETL development, QA and BI reporting activities

Confidential

DATA SPECIALIST

Environment & Technologies:

Database Related: Teradata 14, Oracle 11g

Operating System: Windows NT, UNIX

Responsibilities:

  • Created and managed CONCEPTUAL, LOGICAL, PHYSICAL data models for the enterprise data systems and provided assistance to Confidential developers in implementation of data models
  • Reverse Engineered existing databases to synchronize data models in the repository
  • Worked on IBM Data Security - Guardium 9.0
  • Created REGULAR expression for PII and PCI data according to Confidential standards
  • Created policies, processes to discover PII and PCI information in Oracle and Teradata databases
  • Created a repository for Confidential Site Data models/EDW Data models using Powerdesigner data modeler
  • Deployed powerdesigner tool on Confidential Cloud infrastructure
  • Deployed Powerdesigner portal with LDAP setup
  • Performed Metadata Management to create data flow diagram between multiple Database systems in Confidential .
  • Worked on BIG Data architecture to create data lake
  • Worked with data scientist group to understand data requirements

Data Analyst

Confidential, NA

Environment & Technologies:

Database Related: Teradata 14

Operating System: Windows NT

Responsibilities:

  • Developing weekly and monthly reports on Tableau for revenue, trade payment, volume and take rate
  • Automation of data exracts in Open Analytics platform
  • Developing reports in excel for top 2000 merchants using Tableau for various metrics such as NTPV, Take Rate, APV

Confidential

Senior Associate - Lead Developer

Environment & Technologies:

Database Related: Oracle 11x, PL/SQL, Toad, Informatica 9.5.1

Operating System: Windows NT, UNIX HP-UX (10.20)

Responsibilities:

  • Involved in POC’s based on requirement
  • Involved in Creating the dimensional logical and physical model with approximately 7 facts, 36 dimensions with 300+ attributes using Power Designer 15X
  • Implemented the Slowly changing dimension scheme (Type II) for most of the dimensions.
  • Implemented the standard naming conventions for the fact and dimension entities and attributes of logical and physical model.
  • Involved in datamodel updates
  • Involved in Estimation, analysis and designing of Informatica Workflows
  • Created and Developed Transformations, mapplets and mappings.
  • Created sessions, worklets and workflows.
  • Unit Testing, Data validation review of Dataloads.
  • Involved in User Acceptance Test
  • Load Data to Dimensional and Fact Tables using Informatica.
  • Involved in Low-level documentation (LLD).
  • Involved in production support.

Confidential, New York

Lead Analyst - Lead Developer

Environment & Technologies:

Database Related: Sybase, PL/SQL, Toad, Informatica 7.1.3/8.1.5 /9.1

Operating System: Windows NT, UNIX HP-UX (10.20)

Responsibilities:

  • Involved in allocating work to team members and helped driving it to completion
  • Involved in creating DASHBOARDS in MS EXCEL for POC’s
  • Involved in Creating the dimensional physical model based on logical model
  • Implemented the Slowly changing dimension scheme (Type II) for most of the dimensions.
  • Implemented the standard naming conventions for the fact and dimension entities and attributes of logical and physical model.
  • Involved in datamodel updates
  • Involved in Interaction with business users for data analysis and requirement gathering
  • Involved in Re architecture of Confidential Margin datawarehouse for maximum efficiency
  • Built dash boards for high level management
  • Involved in Estimation, analysis and designing of Informatica Workflows
  • Created and Developed Transformations, mapplets and mappings.
  • Created sessions, worklets and workflows.
  • Involved in unit Testing, Data validation and review of Dataloads.
  • Involved in User Acceptance Test
  • Load Data to Dimensional and Fact Tables using Informatica.
  • Involved in Low-level documentation (LLD).
  • Involved in production support.

Confidential

Associate - Sr Developer

Environment: Database Related: Teradata, DB2, Informatica 8.6

Operating System: Windows NT

Responsibilities:

  • Created and Developed Transformations, mapplets and mappings.
  • Created sessions, worklets and workflows.
  • Unit Testing, Data validation review of Dataloads.
  • Involved in User Acceptance Test
  • Load Data to Dimensional and Fact Tables using Informatica.
  • Involved in Low-level documentation (LLD).
  • Involved in production support.

Confidential, New York

Sr. Software Engineer

Environment: Database Related: Sybase, PL/SQL, Toad, Informatica 7.1.3/8.1.5

Operating System: Windows NT, UNIX HP-UX (10.20)

Responsibilities:

  • Involved in allocating work to team members and helped driving it to completion
  • Created and Developed Transformations, mapplets and mappings.
  • Created sessions, worklets and workflows.
  • Unit Testing, Data validation review of Dataloads.
  • Involved in User Acceptance Test
  • Load Data to Dimensional and Fact Tables using Informatica.
  • Involved in Low-level documentation (LLD).
  • Involved in production support.

Confidential

ETL Developer

Environment: Database Related: Oracle 9i, PL/SQL, Toad

Operating System: Windows NT, UNIX HP-UX (10.20)

Responsibilities:

  • Involved in developing POC’s and was in touch base with Design Team.
  • Data Cleansing and loading data to Staging Tables.
  • Created and Developed Transformations, mapplets and mappings.
  • Created sessions, worklets and workflows.
  • Unit Testing, Data validation.
  • Involved in User Acceptance Test
  • Load Data to Dimensional and Fact Tables using Informatica.
  • Involved in Low-level documentation (LLD).
  • Involved in production support.

Hire Now