Paylocity Coding Challenge: README

Eric Milgram, PhD

ScientificProgrammer/PaylocityCodingChallenge

Created: December 15, 2021

Last Updated: 2022-01-19 06:36:35

Overview

What is the purpose of this Github repo?

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.

What does this Github repo contain?

EXPLAIN THE CONTENTS OF THIS REPO, WITH SPECIFIC EMPHASIS ON THE FOLLOWING ITEMS.

1. MY INTERPRETATION OF THE PAYLOCITY CODING CHALLENGE

   • The broad overview
   • Detailed instructions for Problem 1: Writing a Python program.
   • Detailed instructions for Problem 2: Live SQL Walk-through Exercise.

2. THE STRUCTURE OF THE REPO: 3 key top level sub-directories

   1. code - All of my source code
   2. data - All data used for the *Paylocity Coding Challenge*
   3. output - Any output generated by my code

3. THE STRUCTURE OF THE code SUB-DIRECTORY

   1. Markdown
   2. Python
   3. R
   4. RMarkdown
   5. SQL

4. EXERCISE 1 OF 2: PROGRAMMING IN PYTHON

   1. CONCISE EXPLANATION OF THE PROBLEM WITH A LINK TO MY INTERPRETATION OF THE PAYLOCITY CODING CHALLENGE

   2. CONCISE EXPLANATION OF MY CODING STRATEGY

   3. HIGH LEVEL SUMMARY OF MY INFRASTRUCTURE: See my Infrastructure Summary Page

      • VERSIONS OF PYTHON USED:

        • MS Windows: 3.10.1 (tags/v3.10.1:2cd268a, Dec 6 2021, 19:10:37) \[MSC v.1929 64 bit (AMD64)\]
        • Debian Linux - WSL 3.7.3 (default, Jan 22 2021, 20:04:44) \[GCC 8.3.0\]
      • pgAdmin tool for DBA work
      • AWS Infrastructure: 1) PG running on RDS (see 100_PCC_PostgreSQL_AWS_RDS_description.json), 2) VPC Configuration, 3) CloudWatch Monitoring

   4. 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

5. EXERCISE 2 OF 2: SQL EXERCISES

   1. LINK-NOT-IMPLEMENTED-YET

---