Etl Developer Resume
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.