Senior Data Engineer Resume

PROFESSIONAL PROFILE:

Senior - level Data Engineer / ETL Developer with extensive experience designing, coding, testing, deploying, supporting, and maintaining custom ETL applications using SQL, shell scripting, Python, and Informatica PowerCenter.
Key player in business-critical data transformation initiatives ensuring streamlined, efficient, and accurate data extraction, transformation, and loading.
Experienced across a wide variety of complex and highly-regulated industries, including government, finance, and retail/business products.
Adept at sourcing, documenting, and tracking complex business and technical requirements while applying subject area expertise and promoting adherence to strict policies, procedures, and deadlines.
Self-directed with high levels of initiative, works effectively in team and individual situation.
Promotes team building and learning through internal relationship building and effective communication.
Effective team leader with the ability to inspire others to achieve beyond expectation.

CORE COMPETENCIES / EXPERTISE:

TECHNICAL SKILLS:

Informatica PowerCenter (versions 8.x, 9.x, 10.x), DVO
Oracle SQL (DML, DDL, PL/SQL)
MySQL (DML, DDL, Stored Procedures)
Kimball Dimensional Modeling
UNIX / Linux Shell Scripting
Python 2.7, 3.5, Pandas
AWS / Amazon Redshift
TOAD, SQL Server Management Studio, SQL*Plus, Rally (Agile), MobaXterm, Autosys, Maestro, Remedy, Cherwell, Microsoft Office, Visio, Subversion, MySQL Workbench, Git, Github

EXPERIENCE:

Confidential

Senior Data Engineer

Responsibilities:

Develop, deploy, and maintain custom ETL and reporting applications for online gaming company using Agile development methodology, MySQL 5.7, Python 2.7 and 3.5, AWS / Redshift, and UNIX / Linux shell scripting.

Confidential, Denver, CO

Senior ETL Developer / Informatica Administrator

Responsibilities:

Developed, deployed, and supported enterprise data warehouse / ETL applications using Informatica PowerCenter (9.6, 9.1), and Oracle SQL (10g, 11g, 12c).
Served as Informatica Administrator for DW Support and Development teams, providing 24/7 support for DW operations.
Created and maintained dedicated testing environment - consisting of dedicated multiple Linux boxes for DW and OLTP test databases and six Informatica Power Center domains.

Confidential, Denver, CO

ETL Developer

Responsibilities:

Provided best practice data integration and reporting implementations at clients’ locations.
Designed, developed and implemented custom ETL and reporting solutions using Informatica 9.5.1, Microsoft SQL Server 2008 and 2012, and Cognos 10.2 BI tools (Framework Manager, Transformer, Report Studio, Analysis Studio).

Confidential, Broomfield, CO

ETL Developer

Responsibilities:

Designed, developed, implemented, and maintained custom ETL applications for enterprise data warehouse using Informatica 8.6 and Microsoft SQL Server 2008.

Confidential, Denver, CO

ETL Developer

Responsibilities:

As a contract employee, developed and maintained custom ETL applications using Informatica 8.6, Oracle 11g, and UNIX shell scripts.

Confidential, Louisville, CO

Oracle Analyst / Developer

Responsibilities:

Developed ETL applications for corporate data warehouse using PL/SQL procedures and packages; developed and maintained custom reports using Oracle 10g Reports and Oracle 10g Discoverer.

Confidential, Aurora, CO

Senior Data Warehouse Developer

Responsibilities:

Designed and developed ETL solutions for Federal Government Health Care contractor using Informatica 8.6, IBM DB2, and AIX UNIX shell scripting.

Confidential, Broomfield, CO

Data Warehouse Developer / Support Analyst

Responsibilities:

Developed, implemented, and supported custom ETL applications in a complex, heterogeneous environment using Ab Initio GDE and UNIX shell scripts.

Data Warehouse Data Quality Analyst

Confidential

Responsibilities:

Wrote test cases and performed comprehensive testing of ETL applications developed in-house.