Skip to main content

Data Engineer

Technology
Plano, United States1 week ago
Service contract

Job description

This team

Payments stream, money movement or transaction data. Get from different source systems and different products (checking, credit cards, mortgage payment, bill pay services). Not on application side, not loading data operationally. They are back office operations in the OLAP space, more into reporting and creating/trying to find a competitive edge through data. Used for business intelligence not operational processes.

Need to work somewhat independently.

Must have

Understanding the differences between ETL and ELT

SQL - Optimization troubleshooting

OLAP vs OLTP - Understand the differences

Columnar database knowledge star vs snowflake schemas understand concepts

UNIX or Python Scripting, able to automate processes and parse files

How to analyze data, what's the best way to model the data

Understanding of MPP (massively parallel processing ) (Netezza, Redshift architecture) in databases

Required Skills : Database Design Data Warehousing SQL

Basic Qualification :

Additional Skills :

Background Check :Yes

Drug Screen :Yes

Notes

Selling points for candidate :

Project Verification Info

Exclusive to Apex :Yes

Face to face interview required :No

Candidate must be local :No

Candidate must be authorized to work without sponsorship ::No

Interview times set :Yes

Type of project :Development/Engineering

Master Job Title :Dev: Other

Branch Code :Dallas

Interested in this role?