Github Repo Name:
ScientificProgrammer/PaylocityCodingChallenge
Creator:
Eric Milgram, PhD
Document Creation Date:
December 23, 2021
Date of Last Update:
2021-12-27 16:03:03
I created this Github repo was as part of candidate evaluation and interview process for Paylocity. As part of this process, Paylocity assesses a candidate’s skill with programming in Python for developing database applications and writing SQL, specifically for the PostgreSQL database server. Paylocity refers to these exercises as the Paylocity Coding Challenge.
EXPLAIN THE CONTENTS OF THIS REPO, WITH SPECIFIC EMPHASIS ON THE
FOLLOWING ITEMS.
- MY INTERPRETATION OF THE PAYLOCITY CODING CHALLENGE
-
THE STRUCTURE OF THE REPO: 3 key top level sub-directories
- code - All of my source code
- data - All data used for the *Paylocity Coding Challenge*
- output - Any output generated by my code
-
THE STRUCTURE OF THE code SUB-DIRECTORY
- Markdown
- Python
- R
- RMarkdown
- SQL
-
EXERCISE 1 OF 2: PROGRAMMING IN PYTHON
- LINK-NOT-IMPLEMENTED-YET
-
CONCISE EXPLANATION OF THE PROBLEM WITH A LINK TO MY INTERPRETATION OF THE PAYLOCITY CODING CHALLENGE
-
CONCISE EXPLANATION OF MY CODING STRATEGY
-
HIGH LEVEL SUMMARY OF MY INFRASTRUCTURE:
- VERSION OF PYTHON USED
- pgAdmin tool for DBA work
- AWS Infrastructure: 1) PG running on RDS, 2) VPC Configuration, 3) CloudWatch Monitoring
-
HIGHLIGHT PORTIONS OF MY PYTHON CODE IN THE EXPLANATION OF MY CODING SOLUTION
-
DESCRIPTION OF THE INPUT DATA FILE
-
DESCRIBE THE ‘CHALLENGE’ WITH THE INPUT DATA FILE AS IT WAS FURNISHED AND THE DATA MODEL
-
USE MY ERD TO ILLUSTRATE THE PROBLEM
-
-
EXERCISE 2 OF 2: SQL EXERCISES