We provide IT Staff Augmentation Services!

Etl Developer Resume

4.00/5 (Submit Your Rating)

PROFESSIONAL EXPERIENCE

Confidential

ETL Developer

Responsibilities:

  • Revising existing systems and procedures to correct deficiencies and maintain more effective data handling, conversion, input/output requirements, and storage
  • Designing documentation deliverables including: data models, data flow diagrams, and entity - relationship diagrams
  • Modeling processes, work-flows, and structures
  • Analyzing and developing complex database designs, logical data models, and relationship modeling
  • Identifying and resolving information flow and content issues
  • Eliminating data redundancy and providing single sources of data while maintaining an enterprise-wide perspective
  • Prototyping elements, processes, and systems
  • Developing documentation of database properties, metadata information, methods, procedures, tasks, and standards.
  • Developing, testing, and deploying functions, stored procedures, and other database software components
  • Design and implement ETL solutions using native database utilities
  • Tune individual SQL statements, functions, & procedures
  • Research application performance issues to identify and provide solutions
  • Troubleshoot errors or problems in program code
  • Write and maintain UNIX shell scripts for file brokering and data loading
  • Provide technical leadership on projects as needed
  • Maintain thorough knowledge of current technology trends and advancements through self learning or scheduled professional training

TECHNICAL SKILLS

RDBMS: Access, Adabas, Datacom, DB/2, DB2/UDB, DBase III+/IV, DMS, Focus, IDMS, IMS DB/DC, Oracle, SQL Server, SYBASE, Teradata Certified Master, Total/TOTL, VSAM.

Software: ABAP/4, Abend-Aid, Activex, Ada, ADSO, Advantage GEN, AIX, APS, ASP, AutoCAD, BAPI, BASIC, BMS, Brio, Business Objects, C/C++, C Sharp .NET, CBD, CICS, CLIST, COBOL I/II/III, COBOL/370, COBOL/400, Cognos, CONSTRUCT, Cool Gen, Crystal Reports, Delphi, DL/I, DYL-280 II, Easytrieve Plus, Excel, Focus, FORTRAN, HTML, IDEAL, IEF, Impromptu, Informatica, NQuire, Java/J2EE, Lotus Notes, MapInfo, MathCAD, MicroFocus Cobol, MS Office, MS Project, Natural/Natural 2, Omni/SQL, Oracle Forms, Oracle Reports, PASCAL, Platinum ERWin ERX, PL/1, PL/SQL, PowerBuilder, PowerConnect, PowerPlay, PowerPoint, Process Designer, QBE, QMF, QUIKJOB, REXX, RPG III/IV, SAPScript, SAS (BASE), SAS/Connect, SAS/GRAPH, SAS Macro, SAS/SQL, SAS/STAT, SCOBOL, SPUFI, SQL, SQL*Plus, TOAD, Transact SQL, VB (Visual Basic 6), VB.NET, VBA, Visio, Visual Studio.NET, XML.

We'd love your feedback!