We provide IT Staff Augmentation Services!

Etl Consultant Resume

SUMMARY:

  • I’m a certified Teradata 14 technical specialist and certified data integration PowerCenter developer 9 specialist having 5+ years extensive experience with Informatica PowerCenter, 5+ years experience in designing, analyzing, developing and maintaining extract transform load processes and data integration systems such as data warehouse, master data management, capture data change and business intelligence.
  • I am an active, cheerful, self - motivated and positive thinking person.
  • I have good communications skills and ability to quickly learn new technologies and systems.
  • I like getting unusual and interesting challenges and finding different ways to solve them, I can work equally well and hard in a team or alone.

TECHNICAL SKILLS:

  • Data Warehouse (DWH) 6
  • Extract Transform Load (ETL) 6
  • Informatica PowerCenter 8.1.1, 8.6.1, 9.5.1 6
  • Oracle 10g, 11g 6
  • Teradata 14, 15 1
  • Oracle BI EE 10, 11 1
  • IBM Data Stage 8.7, 9.1 1
  • Informatica PowerCenter Mapping Architect for Visio 1
  • Informatica MDM 9.5.1 1
  • Teradata Mapping Manager
  • Informatica Data Replication
  • Informatica PowerExchange
  • ERWin, Sybase PowerDesigner, Data Modeling
  • Oracle XML DB
  • Oracle Utilities Customer Care and Billing ( &B)
  • Oracle Transportation Management, Oracle Inventory
  • Diasoft 5NT
  • Openway Way4 Cards

WORK EXPERIENCE:

ETL Consultant

Confidential

Responsibilities:

  • Analysing Enterprise Data Warehouse
  • Analysing and developing ETL processes
  • Analysing ETL incidents from customer
  • Searching for and removing ETL error causes
  • Developing patches for ETL processes
  • Simulating data errors and testing patches
  • Reviewing ETL code

Tools: Teradata 14 DB, Informatica PowerCenter 9.1.0

Confidential

Software Programmer/Analyst

Responsibilities:

  • Analyzed system of accounting document processing
  • Analyzed Teradata subsytem for storing transactional data
  • Calculated control performance indicators
  • Developed measures and dimensions
  • Refactoring ETL code
  • Analyzed and fixed ETL error causes
  • Analyzed and developed analyses and dashboards

Tools: Teradata 15 DB, Oracle BI EE 11

Confidential

Lead Consultant

Responsibilities:

  • Analyzed customer requirements
  • Designed ETL processes
  • Developed mapping templates using PowerCenter Mapping Architect For Visio
  • Generated multiple IPC mappings and IPC workflows
  • Analyzed sources
  • Mentored ETL developers

Tools: Oracle 11 DB, Informatica PowerCenter 9.5.1, PowerCenter Mapping Architect For Visio, Informatica Data Replication

Confidential

Software Programmer/Analyst

Responsibilities:

  • Analyzed FormIT system
  • Created FormIT templates
  • Developed Control Processes

Tools: Oracle 11 DB, Informatica PowerCenter 9.5.1, FormIT

Confidential

Software Programmer/Analyst

Responsibilities:

  • Led a team of 5 developers, 2 analysts and 1 tester
  • Analyzed Master Data Management system and ETL processes
  • Used Informatica MDM: Informatica MDM Data Director, Informatica MDM Hub Console
  • Developed IDD: Subject Area Group, Subject Area, Subject Area Child
  • Used MDM Hub Console: Metadata Manager, Schema, Schema Viewer, Queries, Packages, Cleanse Functions, Mappings, Hierarchies, Security Access Manager, Data Steward, Batch Group, Batch Viewer

Tools: Oracle 11 DB, Informatica PowerCenter 9.5.1, Informatica MDM

Confidential

Software Programmer/Analyst

Responsibilities:

  • Gathered ETL design requirements
  • Designed ETL processes
  • Developed ETL processes
  • Created 2500+ IPC mappings, 1300+ IPC workflows with a team of 3 ETL consultants in 3 months (8 sources, 434 tables)
  • Analyzed PowerCenter Mapping Architect For Visio
  • Designed mapping templates using PowerCenter Mapping Architect For Visio and generated multiple IPC mappings
  • Generated multiple IPC workflows using XML and VBS scripts
  • Tuned IPC mappings and workflows performance
  • Generated multiple file parameters using VBS scripts
  • Imported multiple IPC objects using pmrep
  • Created dynamic SQL and shared IPC mapping for referential integrity checking
  • Extracted database objects metadata using SQL scripts
  • Created document for generating IPC mappings using PowerCenter Mapping Architect For Visio
  • Mentored bank ETL developers
  • Used Informatica PowerCenter Versioning

Tools: Informatica PowerCenter 9.5.1, PowerCenter Mapping Architect For Visio, Oracle 11 DB

Confidential

Software Programmer/Analyst

Responsibilities:

  • Analyzed S2T (Source To Target)
  • Analyzed sources
  • Developed ETL processes
  • Analyzed Neoflex Summary Report system
  • Completed Neoflex Summary Report system conversion
  • Developed Summary Report ETL processes
  • Tuned IPC mappings and workflows performance
  • Analyzed Data Warehouse
  • Analyzed ETL processes
  • Extracted IPC objects metadata using SQL scripts for IPC repository DB
  • Wrote document «Data Warehouse technical description»
  • Wrote document «Administrator guide»
  • Used Informatica PowerCenter Versioning

Sources: Openway Way4 Cards, CFT-Bank, Summary Report Forms (Excel files)

Tools: Informatica PowerCenter 9.5.1, Oracle 11 DB

Confidential

Software Programmer/Analyst

Responsibilities:

  • Communicated with client
  • Designed generic architecture
  • Created data migration methodology description

Confidential

Software Programmer/Analyst

Responsibilities:

  • Analyzed ETL processes
  • Reviewed code
  • Tested individual person account statement formation

Tools: T-SQL

Confidential

Software Programmer/Analyst

Responsibilities:

  • Communicated with client
  • Estimated scope of work

Confidential

Software Programmer/Analyst

Responsibilities:

  • Communicated with client
  • Estimated scope of work
  • Analyzed current Data Warehouse

Confidential

Software Programmer/Analyst

Responsibilities:

  • Analyzed sources
  • Created S2T (Source To Target) for source systems
  • Developed ETL processes
  • Created Loan Portfolio Data Mart
  • Maintained new and old ETL processes
  • Tuned IPC mappings and workflows performance

Sources: Diasoft 5NT, FIS Profile, Openway Way4 Cards, FICO Capstone Decision Accelerator

Tools: Informatica PowerCenter 8.1.1, Oracle 10 DB

Confidential

Data Warehouse maintenance

Responsibilities:

  • Analyzed and maintained ETL processes using PL/SQL
  • Made conversions for ETL processes using PL/SQL
  • Analyzed and corrected data in Data Warehouse using PL/SQL
  • Analyzed data in Data Mart using Oracle BI EE
  • Processed business user’s requests
  • Analyzed and maintained Reference Data Management Module

Sources: XML files from branches

Tools: Oracle XML DB, Oracle 11 DB, PL SQL, Oracle BI EE 10g

Confidential

Data Warehouse implementation

Responsibilities:

  • Analyzed and maintained ETL processes
  • Analyzed and corrected data in Data Warehouse and Data Mart
  • Tested and installed releases, datafixes and hotfixes
  • Processed business user’s requests
  • Wrote usercases
  • Used Informatica PowerCenter
  • Developed IPC mappings and workflows
  • Tuned Oracle BI EE
  • Designed repository
  • Tuned web-interface
  • Developed Answers
  • Developed Dashboards

Tools: Oracle 10 DB, Oracle BI EE 10g

Hire Now