Summary
Overview
Work History
Skills
Software
Timeline
SeniorSoftwareEngineer

James Taylor

Experienced ETL/SQL Developer
Highlands Ranch,CO

Summary

Detail-oriented ETL/SQL Developer looking for new challenges in a non-lead role. Accustomed to working with numerous toolsets and possessing strong analytical and problem-solving skills.

Overview

23
23
years of professional experience

Work History

Set Up Associate (Temporary - Est. End 5/8)

Walmart
01.2024 - Current
  • Temporary associate installing new signage, stocking, and ad hoc activities as part of remodel of Walmart Store location.

Warehouse Associate (Seasonal)

Amazon.com Services LLC
11.2023 - 01.2024
  • Warehouse associate assisting in stowing and movement of 60K+ daily packages through processing.

Data Engineer

Unison Systems
10.2020 - 07.2023

Client: Newmont Mining

  • Developed and implemented structures for Google Cloud BigQuery using DBT SQL-first integration.
  • Built subject area tables used in Tableau dashboards and SQL queries.
  • Redesigned established Teradata SQL logic to work within Google Cloud BigQuery to transition between platforms.
  • Utilized Google Cloud features to investigate/troubleshoot ingestion of delimited source text files loaded to Cloud Storage.
  • Built SAP Data Services ETL jobs to extract data from database tables.

ETL Developer

Empower Retirement
06.2018 - 09.2020
  • Agile (Scrum) team member producing and enhancing SAP Data Services ETL jobs to transform and load data into Oracle tables.
  • Created ETL jobs for new data file feeds for clients.
  • Completed enhancement and defect resolution tasks for existing Warehouse/Mart processes as assigned.
  • Identified bottlenecks in batch processing and pursued enhancements to improve completion time.
  • Engaged in design and development initiatives for Data Warehouse/Mart projects.

Data Integration Consultant

Datasource Consulting
08.2015 - 05.2018

Client: Kaiser Permanente

  • ETL development using Informatica Power Center, Linux and Oracle.
  • Produced ETL objects for proof-of-concept tracking IT Assets.

Client: Home Advisor

  • ETL development using Informatica Power Center, Linux and Oracle.
  • Completion of workflows to populate Stage, Base and Presentation layers for new Data Warehouse, as per source to target documents.

Client: Sports Authority

  • ETL development using Informatica Power Center, Linux and Teradata.
  • Developed and maintained workflows to load database tables in Stage and Base Data Warehouse layers.

BI Developer

Catholic Health Initiatives, Inc
05.2013 - 08.2015
  • Produced and enhanced Informatica ETL jobs for Clinical Quality initiatives.
  • Delivered processing to extract hospital facility data and calculate patient scores used in predicting hospital readmissions (LACE).
  • Developed installation scripts and held peer reviews with Product, Test and Operations Teams prior to code implementations.

ETL Developer/Tester

Comcast
08.2001 - 01.2013
  • Senior ETL Developer (2006 – 2013) – Development using Ab Initio and Pentaho ETL tools to update Oracle databases. Responsible for designing and writing projects using several ETL tools and UNIX scripting.
  • Data Warehouse Tester (2001 – 2006) – Functional, integration, and automation testing for ETL code using Oracle databases.

Skills

ETL/ELT Development

undefined

Software

PLATFORMS: Google Cloud, Azure, Salesforce, UNIX/Linux, Windows

DATABASES: Oracle, SQL Server, Postgres, Teradata

ETL/SQL: DBT, SAP Data Services, Informatica PowerCenter, Pentaho, Ab Initio

REPORTING: Tableau, Microsoft Power BI, SAP Business Objects

COLLABORATION: JIRA, Confluence, Office 365, MS Teams, Pivotal, Git/GitHub

IDEs: PyCharm, Visual Studio Code, DBeaver, SQL Developer

Timeline

Set Up Associate (Temporary - Est. End 5/8)

Walmart
01.2024 - Current

Warehouse Associate (Seasonal)

Amazon.com Services LLC
11.2023 - 01.2024

Data Engineer

Unison Systems
10.2020 - 07.2023

ETL Developer

Empower Retirement
06.2018 - 09.2020

Data Integration Consultant

Datasource Consulting
08.2015 - 05.2018

BI Developer

Catholic Health Initiatives, Inc
05.2013 - 08.2015

ETL Developer/Tester

Comcast
08.2001 - 01.2013
James TaylorExperienced ETL/SQL Developer