Senior Data Engineer Resume
5.00/5 (Submit Your Rating)
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:
- Data Warehousing
- Data Extraction
- OLAP / OLTP Database Design
- Database Development
- ETL Development
- Job Scheduling
- Requirements Gathering
- Relational Databases
- Integration and Unit Testing
- Technical Troubleshooting
- Production Support
- Team Leadership & Mentoring
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.