We provide IT Staff Augmentation Services!

Data Warehouse Resume

3.00/5 (Submit Your Rating)

NJ

Hire Now

More than 7 years experience with proven ability in the area of Data Warehouse, Database Design, Data processing and Support mainly with Teradata, Oracle and Informatica technology on different platforms.
Expert level experience on SQL, PL/SQL that includes Partitioned Tables, Triggers, Materialized view , Table Indexing in SQLServer , Teradata as well as Oracle.
Extensive experience in Informatica data extraction from the following sources.
Flat Files (Delimited as well as Fixed width)
Mainframe files
VSAM files along with cobol copy books
Teradata Tables
Excel and .csv files
SQL Server Tables
Oracle Tables

  • Extensive experience in developing Informatica complex mappings and transformations (joiner, Normalizer, Aggretator and all ).
  • Extensive experience Informatica Workflow manager and performance tuning in Informatica .
  • Proficient in UNIX shell.
  • Extensive experience in Mainframe Copy books and file loading with Informatica.
  • Extensive experience in Complex SQL Queries, Dynamic SQL, Analytical function, SQL server, Oracle and Teradata Object etc.
  • Extensive experience in Teradata Utilities like Fastload, Multi load, Fast export and Bteq.
  • I have extensive experience in improving the performance of Query.
  • Expert in Query Optimization, Debugging and Tuning for improving performance of the applications using Explain Plan.
  • Working with job scheduler tools like WLM to schedule Job.
  • Handled large scale databases and high volumes (more than 1 Billion). Skillful problem solver with excellent analytical skills.
  • Knowledge on system development life cycle.
  • Proficient in using UNIX and Shell Scripting.
  • Strong interpersonal skills, ability to interact with people at all levels. Good communication and presentation skills.
  • I have an extensive experience in writing complex SQL queries.
  • Extensive knowledge in writing ETL Jobs in Teradata, Oracle as well as Informatica.
  • Experienced in all phases of the system development life cycle (SDLC) and Development methodologies/Guidelines.
  • Review and analyze the ETL requirements.
  • Design, develop, implement, and assist in validating ETL processes.
  • Troubleshoot, optimize, and tune ETL processes.
  • Maintain existing code and fix bugs as needed.
  • Loading and validating data.
  • Data analysis normalized data models.
  • Optimize SQL code Teradata and oracle.

Technical Proficiency:

Languages

SQL, PL/SQL, Unix Shell Script

RDBMS

Teradata, SQLServer 2008 , Oracle 11g/10g/9i

Other Tool

Informatica (8.1, 8.6.1, 9.1.0),Teradata SQL Assistant, TOAD, SQL Developer,PL-SQL DEVELOPER

Other Application

Microsoft Share Point, MS Excel, MS Office.

Operating Systems

Windows, Linux,UNIX

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship