Senior Data Warehouse Developer Resume

SUMMARY

Offering over 20 years of in - depth Information Technology (IT) experience, with 9 years proficiency in data warehouse development.
Strong ETL experience using Informatica PowerCenter Client tools (10.x, 9.x, 8.x) paired with multiple relational database management systems (MS SQL Server, Oracle, Teradata and DB2).
Current project is with a Financial Services company creating ETL processes using Informatica Powercenter workflows/mappings and MS SQL Server databases.
Extensive experience in both Agile and Waterfall software development processes.
Current Agile project has 2 week sprints with daily stand up, end of sprint review/retrospective, start of sprint planning and backlog grooming.
Previous experience in the health care, financial, communications and real estate industries.

TECHNICAL SKILLS

Cloud Platforms: Amazon Web Services (AWS)

Databases: MS SQL Server 2012 / 2016, Oracle 11g, Teradata 12, DB2

ETL Tools: Informatica 10.1.x, 9.1.x, 8.6.x, Talend 7 (classes only)

Languages: T-SQL, Powershell, COBOL II, JCL, Easytrieve, Basic

Operating Systems: Windows, IBM 30XX, Unix

Software/Tools: Informatica PowerCenter, MS SQL Server Management Studio, MS Visual Studio/Git, Bitbucket, Bamboo, JIRA, Confluence, Microsoft Powershell, UNIX Scripts, Remedy, Talend, Toad, TSO/ISPF, VSAM, CA7/Jobtrac, Fileaid, Filemanager, Expediter / Intertest / Debug, OS/MVS, Windows, Microsoft Office Suite, Viso, SharePoint, Onenote

PROFESSIONAL EXPERIENCE

Confidential

Senior Data Warehouse Developer

Responsibilities:

ETL development project using Informatica Powercenter 10.1 and MS SQL Server 2016.
Visual Studio/Git, Bitbucket and Bamboo used for source code management and CI/CD.
SQL Agent jobs, Powershell scripts and UNIX scripts used to schedule / execute ETL processes.
Member of Agile development team responsible for new development, conversions (SSIS to Informatica), maintenance/enhancements and production support..

Confidential

Business Intelligence Developer

Responsibilities:

Conversion project from Informatica Powercenter to Talend in an AWS Cloud platform.
ETL Team completed Udemy and Talend training courses (Talend Open Studio, 7.0 DI Basics and 7.0 DI Advanced) along with edX AWS Cloud Practitioner course. Conversion to Talend jobs loading into S3 Data Lakes and then to Snowflake tables.
Design, develop, test and support Informatica 10.1 ETL processes with MS SQL Server 2012 tables / flat file sources loaded to MS SQL Server data warehouse.
Part of two person conversion team that developed 500+ Informatica ETL conversion processes to transfer Enterprise Resource Planning system MS SQL Server table data into new ERP SQL Server tables.
Assisted in upgrading Informatica from 9.1 to 9.5 to 10.1.
Converted from contractor to full-time employee.

Confidential

Data Warehouse Developer

Responsibilities:

Member of Agile ETL developed team sourcing data from Claims, Providers, Pharmaceutical and Membership Electronic Medical Records system to load regional data warehouse.
Data loaded from Oracle, Teradata, DB2 and flat files sources to Oracle 11g data warehouse.
2 week Sprints included daily stand up, planning, task estimation/selection, development/testing/code review, sprint review and retrospective.
Before converting from contractor to full-time data warehouse developer, worked as Programmer Analyst on Benefits subsystem (IBM Mainframe using COBOL II and DB2).

Confidential

Programmer Analyst

Responsibilities:

Coded, tested and supported enhancements and bug fixes to Tour Reservation system running Micro Focus COBOL with Oracle batch and online processes on an HP UNIX midserver.
Designed, coded, tested and supported enhancements to Corporate Credit Card Payment System running on IBM mainframe and UNIX midserver utilizing COBOL II and DB2 processes.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship