Data Engineering

Data Engineer Powered by TEKsystems

Atlanta

Close

Choose your location

This course is currently offered in select locations. Candidates must live within commutable distance of the Per Scholas location to be eligible.

This 14-week data engineering training prepares you for in-demand Data Engineer roles. Enhance your python programming knowledge with fundamental data engineering skills like Data Modeling, Data Warehousing, Data Analysis & Visualization, Distributed Data Processing, DevOps, and more. Currently offered online.

Get Started

  • Remote

No cost, no catch. Tuition-Free training and job connections.

Woman in tech on computer.

Offered in collaboration with:

Course level

Technical knowledge required ?

Schedule

  • Remote 9AM - 4PM
    Monday through Friday
    14 Weeks

Upcoming course dates

  • November 7th, 2022
    Application Due October 17th, 2022
  • Please note, this application process is very competitive and not all applicants will be accepted for our limited slots. Seats are offered on first come, first served basis.

Most CISCO IT Essentials certification holders move on to a job in IT support, like a help desk technician. Help desk technicians solve technical issues and work with people.

Most CISCO Network Essentials certification holders move on to a job in IT support, like a help desk technician. Help desk technicians solve technical issues and work with people.

The Salesforce Administrator Certification equips you with the knowledge you need to succeed as a Salesforce Administrator.

Most CompTIA A+ certification holders move on to a job in IT support, like a help desk technician. Help desk technicians solve technical issues and work with people.

CompTIA Network+ helps develop a career in IT infrastructure covering troubleshooting, configuring, and managing networks.

The CompTIA IT Fundamentals certification focuses on the knowledge and skills required to identify and explain the basics of computing, IT infrastructure, software development, and database use.

The Google IT Support Professional Certificate introduces learners to troubleshooting, customer service, networking, operating systems, system administration and security. No prior experience is required.

Applicants with all levels of experience in tech are encouraged to apply.

CompTIA Cybersecurity Analyst (CySA+) is an IT workforce certification that applies behavioral analytics to networks and devices to prevent, detect and combat cybersecurity threats through continuous security monitoring.

While anyone may apply for this course, some technical background may be helpful.

The Amazon Web Services Associate Level Certification equips you with the knowledge you need to succeed as a Systems Administrator.

While these courses may include either intermediate or advanced material, technical knowledge specified in these listings will be required as a prerequisite for applicants to be considered for admission.

Gain the knowledge and skills necessary to effectively demonstrate an overall understanding of the AWS Cloud and start a career in cloud computing.

This certification establishes the core knowledge required of any cybersecurity role and provides a springboard to intermediate-level cybersecurity jobs. CompTIA Security+ is a globally trusted, vendor-neutral certification that validates the baseline skills necessary to perform core security functions and pursue an IT security career.

As a response to COVID-19, Per Scholas courses have moved to a remote learning environment. As we return to training sites, upcoming courses may be moved to in-person classrooms. We will be in-touch with applicants after you have applied to provide updates on any changes to future courses.

This is the hybrid course tooltip lorem ipsum dolor sit amet, consectetur adipiscing.

?

Have questions?

We can help with course selection, and answer questions about eligibility requirements and special circumstances. Contact an admissions team member

Advance Your Skills to the Next Level

Utilize your existing Python knowledge to gain the specific skills necessary for Data Engineer openings in your community through live instructor-led training.


Cover Fundamental Skillsets

Learn how to work with Linux, Shell Scripting, Database Systems, SQL, SparkSQL, and master Python Programming.


Hands-On Understanding of Data Engineering with Python

Gain a strong knowledge of Big Data, Data Warehousing, and ETL - Learn fundamental concepts of data modeling, data warehousing, data lake, big data, and ETL process.


Hands-On Professional Development from a Tech Industry Leader

The curriculum and career development for this course was developed collaboratively with TEKsystems, one the world's largest IT talent services provider in the US.

What jobs can I get as a Data Engineer graduate?

As a Data Engineer graduate, you will enhance your fundamentals in data engineering, equipped with the knowledge to fulfill a wide range of technology jobs such as: 

  • Data Engineer
  • Programmer Analyst
  • Data Scientist

This program in partnership with TEKsystems is designed to meet specific local job demand at the end of the program. TEKsystems is committed to interviewing all graduates upon successful completion of the program. To support this, TEKsystems recruiters will play an active role in your career development throughout the class, including mock interviews and resume reviews. Per Scholas does not require candidates sign a contract with any employer partner. Learners are always free to their own future.

$80k the average salary Data Engineer graduates make at their first job

Strengthen your Professional Profile


Start your Tech Career Wherever you are in your career

Per Scholas will train you if you are new to tech or a seasoned veteran looking to upskill and remain competitive as the industry grows.

Autumn Truong, Per Scholas graduate, in a sweater and professional attire.
I was able to connect with amazing individuals. All the learners were so talented and inspired me to do better myself. I learned a lot of things, and I feel like I was able to grow, not just professionally, but as a person.

Meet Autumn Truong


CUSTOMIZED PROFESSIONAL DEVELOPMENT AND NETWORKING

Regular Career Development like resume reviews, mock interviews, and "Meet the Employer" sessions will familiarize you with our employer partners, meet with other IT professionals and help prepare you for the job search.

Learn more about our partnership with:


DIRECT JOB PLACEMENT SUPPORT

Graduates will receive job placement support from the employer partner and identify career opportunities leveraging their new and existing skills. If TEKsystems doesn't work out, Per Scholas staff will continue to provide connections with other employer partners.

I worked 12 hours straight nearly every day, weekends included, and missed out on the lives of my friends and family. Per Scholas helped me to discover both a career path and how to have a work-life balance so that I could spend time with my loved ones.

Meet Matt Yamarino

What You'll Learn


Master critical Data Engineering skillset

Build ETL/ELT data pipeline, grasp data processing with Spark, and expertise in Data Analysis and Visualization techniques using Python and Tableau.


Excel at Data Engineering Concepts

Develop an understanding of big data, Spark, Tableau and best practices for data management.


Process Large Scale Data for Analytics and Machine Learning

Identify big data strategies that can support new insights and predictable outcomes for businesses and industries alike.

Curriculum

Hands-on training along with career development and guest speakers

Linux, Version Control with Github

Intro to Linux

  • Basic commands & Linux environment etc.
  • Sudo (super user do)
  • How to use Nano and VI editors
  • How to use regular expressions: Grep, ^, [], ”, Siignals: Kill -l, trap signals: trap (for clean up temp files or to ignore signals)
  • Console log, files, file paths & directories, mkdir, touch, echo, man, variables, setting permissions with chmod, pipe, grep, sort and
  • Secure shell with SSH

 

Intro to Github + Version Control

  • Git Basics, Setting up Git, Github
  • Working directory, staging area, local repo (Head), remote repo, Origin(Master/Main)
  • Git Commands – Git add, git commit, git push, git fetch, git merge, git pull, git status
  • Git branch, git fork, git config, .gitignore, git remote, git checkout
SQL

Introduction to SQL

  • Atomicity, Normalization, How to transform Logical into Physical Model, Data Models, Dimension Table and fact table, Schema, Data modeling approaches, Database Terminology, DDL, DML, Constrains, Data Integrity, Filtering Data, SQL Data Integrity, SQL Joins, Provided with a schema representation of a database which they have to code and make every relationship between table illustrated in the schema.
  • How to extract aggregate data using predefined function, how to write their own custom function to automate some of the actions necessary when selecting, deleting, updating, adding to a table, the importance of transaction and how it is used.

Overview to Database Security

SQL with Postgres

Intro to PostgreSQL

  • Installation, Schema, Transactions
  • Constrains, Data Integrity, Filtering Data, Managing Tables Import & Export Data
  • PostgreSQL Administration
  • Roles & Privileges
  • Backup & Restore Databases
Intro to Data Warehousing + ETL

Data Warehousing and Data Mart

  • Data Mart concepts and Architecture, Data lake and the Data Mart types and Data pipeline
  • Data Warehouse from Operational Systems, Define the Operational Data Store and Analytical Store
  • Data Warehouse using Inmons’s Approach and Kimball’s Approach, Data vault modeling
  • Data warehousing principles and architectures to enable business intelligence and the ETL solution (Extraction, Transportation-Transformation, and loading) and the differences between transaction and analysis workloads. Also they will understand the limitation scope (functional area) of a Data Mart.

Intro to Big Data + ETL

  • Big data characteristics, 7 Vs of Big Data (Volume, Velocity, Variety, Veracity, Variability, Value.),- Big Data Life Cycle (Ingesting, Persisting, Computing and Analyzing, and Visualizing).
  • Clustered Computing (Resource Pooling, High Availability, Easy Scalability
  • How to recognize Structured (Defined Data) Vs Unstructured (Something else) with: Characteristics, Location, Generation, Typical Applications and Samples.
  • ETL Process

Data Warehouse

  • Database vs Data Warehouse, Data Warehouse Architecture, Data Warehouse Project Lifecycle, Key Characteristics of a Data Warehouse, Data Warehouse Development, Inmons’s Approach and Kimball’s Approach and Data lake

Data Mart Styles

  • Why use Data Mart?,Designing Data Marts, Operational Data Stores, OLTP and OLAP, OLTP vs OLAP
Python and Database integration with python

Python & Database Integration

  • Install Python IDE
  • Types in Python, modules, data type, variables, conditionals, operators and operator precedence, loops, etc
  • Functions, passing function arguments
  • Create a class, construct an object, and knowledge on class methods, object data
  • Raise, throw and exception and handle exceptions appropriately.
  • Module and create module
  • The set, tuple, array, list, dictionary
  • Have good understanding of different data structure and operations on those data structure and list comprehensions
  • Have ability to use various string methods and file handling – FILE I/O methods built in Python –
  • Have deeper understanding of Lambda function
  • Have ability to use statement, indentation and comment in Python
  • Have ability to use namespaces and scope in Python
  • Lambda functions
  • Iterators
  • Closures
  • Decorators
  • Processing JSON Data using Python for data pipeline
  • Processing XLS Data using Python for data pipeline
  • Processing Relational Databases using Python for Data Pipeline
  • To write Python program to interact with database and perform basic database operation.
  • Data wrangling using python for Data Pipeline
Data Analytics with Python

Intro to Statistics and Measure of Variability

  • Introduction to data analysis and visualization, Conceptualizing Data Analysis as a Process, Types of Data Analysis and Chart Types
  • Jupyter notebook and Anaconda

Data Analysis

  • NumPy – Ndarray Object, numpy.arange, Array Slicing, Joining Array and etc
  • Pandas – Data Structure, Dataframe slicing, Selecting, Extracting, Imputation
  • Convert a dictionary to Pandas Dataframe
  • Reading data from CSVs ,Json, using Pandas
  • Python -Data aggregation using Pandas and Numpy libraries.
  • Add a new columns to existing Dataframe in Pandas

Data Visualization

  • Matplotlib – Pyplot and Plotting and Cover at least 5 to 6 Charts
  • Processing Structure and Unstructured data
  • Measuring central tendency
  • To apply industry best coding practices & tools
Overview to Spark and Spark SQL

Apache Spark

  • Fundamentals of Apache Spark, Role of Driver in Spark Architecture
  • Set up a full environment for developing Spark applications, Spark Shell and PySpark
  • Fundamentals of RDD, Loading data into RDD, Transformations, and Actions
  • Fundamentals of DataFrame and Spark SQL
  • Spark SQL performance optimization, Libraries of Spark SQL
  • Manipulating the Data with Spark SQL, Loading data into DataFrame, Basic operation with PySpark
Tableau

What is Data Analytics, Types of Data Analysis, Chart Types:

  • Learn to create an executive-level data analysis through visual analytics dashboards using charts, dates, table calculations, mapping, groups, sets, animations, and cover only available features in trial version

Overview of Tableau

  • Connecting to data from difference sources
  • Organizing your data
  • Simplifying, grouping and sorting data
  • Slicing your data by date
  • Using multiple measures in a view
  • Showing the relationship between numerical values
  • Mapping data geographicallyViewing specific values
  • Making your views available
  • Data filtering
  • Data Visualization
  • Chart ( Bar Chart, Line Chart, Pie Chart scatter plot ,Highlighting, Bullet Chart, gantt chart, heat map, )
  • Graphics
  • Overview of Dashboard
Intro to DevOps

Intro to DevOps

  • DevOps lifecycle
  • DevOps Work flow
  • Who is a DevOps Engineer?
  • Overview to CI and CD, What are the Popular tools for DevOps?

Container and Dockers

  • Intro to Containers and Virtualization
  • Container vs Virtual Machine (VM)
  • Introduction to Docker:? What is Docker?
  • Docker Architecture: Client, Containers, Images, Registry, Daemon, Host
  • Docker for Deployment and Set up your Docker Environment
  • Docker operations: start, stop, commit, rm, rmi, ps, images, exec
  • Vocab: Images, Containers, Docker Daemon, Docker Client, Docker Hub, Nginx, Dockerfile

Curriculum

Hands-on training along with career development and guest speakers

View

Sample Schedule

  • Morning lecture and hands-on learning activities
  • Break for lunch
  • Afternoon lecture and hands-on learning activities
  • Career development
  • Open lab

Learn to Think Like An IT Professional

Prepare to handle real workplace demands by challenging your understanding of course material and setting you up for professional success.


Participate in Hands-on Labs

To provide an innovative, hands-on learning experience, Per Scholas provides learners with a tech kit based on their training track and delivery model, whether in person or remote. These kits are designed to enhance the learning experience and will be utilized in labs throughout the course.


Professional Training with Employer Partners

Strengthen your tech professional resume and practice your interviewing skills with current employer partner employees and recruiters.

Rachel Powe, Per Scholas Graduate, Headhshot

Meet Our Graduates

During my training at Per Scholas there was a ton of support, especially from the other women and other non-traditional learners that also had the same thoughts I had. They told me it’s not too late to go into doing what you really want to do.

Meet Rachel Powe

How to Be Considered

Learner Profile

You may qualify to become a Per Scholas Learner if you:

  • Are aged 18 or older
  • Have a High School diploma, equivalent, or higher
  • Are authorized to work in the U.S.
  • Have existing knowledge of Python Programming
  • Live within commutable distance of the advertised Per Scholas Site
  • Can read, write and speak in English
  • Can attend classes full-time for the entire duration of the course
  • Are able to start a full-time job after course completion
  • Ready to make an important commitment to building your future
  • Are fully vaccinated In-person courses only

*Women, youth, unemployed, underemployed and U.S. Veterans strongly encouraged to apply

Technical Assessment Prep
Admissions Process

1. Submit an Eligibility Form

2. Admissions Overview: Once you submit an Eligibility Form, you’ll be directed to our Admissions Overview registration page. During this virtual webinar, you’ll learn more about our admissions process and next steps.

3. Assessments: This training requires a technical assessment based on your knowledge of Python. 

4. Interview: Individuals who meet the assessment score requirements will be invited to attend a behavioral interview.

5. Background Check: Per Scholas believes technology can create opportunities and is committed to ensuring applicants are set up to succeed beyond the training program. Using a fair and efficient platform through Checkr, applicants will receive a secure link, provide the necessary virtual consents and complete the required screening information. Background check results will be provided to both the applicant and Per Scholas.

6. Offer Letter and Onboarding: The Admissions team will review assessment scores and interview results and offer seats to eligible candidates. The learner onboarding process mirrors Employment Onboarding.

 

Please note, this application process is very competitive and not all applicants will be accepted for our limited slots.

More than a Technical Training

Technical and professional development resources available at no additional cost to help you develop the skills you need for the job you want.


Modern Facilities

In-Person courses offer each trainee their own lab-based computer workstation for the entire course. Breakout spaces to socialize and study are also available with strict safety protocols like social distancing, mask policies and air purification systems.


A Community of Support

Partner with your classmates to form study groups and create a community dedicated to everyone’s personal and professional success. Learner support resources such as financial coaching and case management are offered to all learners.


Alumni Advancement

Complimentary upskilling opportunities extended to alumni up to two years post graduation to help them match in demand employer hiring profiles and continue their career growth.

Frequently Asked Questions

What kinds of jobs can I get after completing this training?

This course opens doors to careers in Data Engineering, Programming,  and more.

How can the course be free? Are there hidden fees?

Most people who learn about us think: “Too good to be true.” We know it seems that way, but it’s true. Our services are provided at no cost to you, using funds we raise from foundations, corporations, government and generous individuals.

The costs you can prepare for include transportation or childcare—expenses that take care of you so you can focus on your studies.

What are the safety measures for in-person learning during the COVID-19 pandemic?

In 2020, Per Scholas safely transitioned all of our learners to a remote instruction and learning environment. You can read about our transition to virtual instruction here.

 

In 2021, as local situations allowed, we began to transition select courses back on-site for in-person learning, following safety protocols that include but are not limited to:

  • All learners and staff complete confidential wellness screenings prior to arrival daily. 
  • Temperature screening at entry. Mandatory mask policies.
  • Reduced class sizes to accommodate for social distancing.
  • Disposal PPE and sanitation items available to all campuses.
  • Regular professional cleaning of campuses.
  • Air purification systems to assist with airflow.

 

In 2022, we adopted a new vaccination policy that requires all staff and in-person learners to be fully vaccinated, pursuant to local, state and federal guidelines. Per Scholas will continue to offer fully remote courses for individuals who prefer this learning environment or who are unvaccinated. 

What if I don’t have a Laptop? What are the computer requirements?

Computer requirements are determined by each specific curriculum track. During the onboarding process, we will review each learner’s needs on a case-by-case basis. If you have any concerns about your situation, please elevate to the admissions team during the admissions process.

I receive unemployment insurance benefits or other benefits that require me to spend time working or looking for work. Can I still enroll?

Yes. Generally, Per Scholas courses are approved for people receiving unemployment insurance, as well as other benefits that would ordinarily require them to spend time working or looking for work. Your benefits should not be affected. If you have questions or concerns about your situation, please contact us.

I meet other requirements, but I am not a U.S. citizen and haven’t received my work authorization yet. Can I still apply?

Unfortunately, we cannot process your application until you have received clearance to work in the U.S. However, if you are experiencing problems, we may be able to refer you to other organizations that may be able to help.

I have childcare responsibilities. Can you accommodate me?

We have onsite staff available to help students navigate childcare options. Ask to speak with the Childcare Navigator when you attend an info session.

I have a disability. Can you accommodate me?

We comply fully with the Americans with Disabilities Act and other relevant laws and regulations. Please contact an Admissions team member to discuss your specific situation and needs.

Does Per Scholas have a Non-Discrimination policy?

We’re proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to age, race, color, religion, sex, sexual orientation, gender identity or national origin. See our full EEO statement here.