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?
