We provide IT Staff Augmentation Services!

Data Warehouse Developer Resume

0/5 (Submit Your Rating)
Hire Now

SUMMARY:

  • Experience in full project lifecycle especially professional experience of Agile methodologies using
  • UNIX, oracle, informatica, mainframe and autosys
  • Extensive experience in Data Warehouse applications using Informatica, Oracle, DB2, MS SQLServer on Windows, IBM and UNIX platforms.
  • Experience in Oracle and MS SQL Server environments using Stored Procedures, Functions, Triggers, functions, SQL, T - SQL and PL/SQL in SQL Server 2000/2005, Oracle 11g/10g/9i/8i and DB2.
  • Skilled in Unix Shell Scripting and experience on different UNIX platforms.
  • Proficient in COBOL, DB2, JCL, VSAM, MVS, Easytrieve, IBM Mainframe utilities: TSO/ ISPF, Endevor, XPEDITOR, FILE-AID SPUFI, SYNCSORT, CHANGEMAN, CA-7, ESP and Exposure to CICS, REXX
  • Experience in using ETL tool - Informatica, scheduling tools - Windows scheduler, control - M, crontab.
  • Involved in Performance/ Query tuning. Generation /interpretation of explain plans and tuning SQL to improve performance, maintaining and monitoring of Business Intelligence solutions in staging, populating
  • Operational Data Store (ODS), Enterprise Data Warehouse (EDW), Data Marts / Decision Support Systems
  • Experience in Design, Development, testing, bug fixes and exposure to L2/L3 model of production support across retail and finance domains.
  • Experience in working in an onsite-offshore structure model and with cross functional teams.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, Perl, UNIX shell Scripting COBOL, JCL, Eazytrieve, CICS, Autosys, JIL

Database: Oracle,SQL server, MS Access, DB2, Informix, IMS, Teradata,Sybase

Operating Systems: Unix,Linux,Z/series, Z/OS, MVS, Windows and DOS

Tools: (DB, ETL and Scheduling): TOAD, SQL Plus, SQL Loader, SQL Navigator, SQL Developer, Informatica power center, Control M, Crontab, Autosys, ACC, WCC, CA-7

Other Tools: Microsoft Visio 2005/2007, Clear Case, VSS

Other Utilities: WinSCP, Putty, FTP, VI editor, Forte, MS Office,Textpad

Domain Expertise: Retail, CPG, logistics, Supply chain management, Distribution, Finance

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship