JU. Johnson

🇦🇷
Data Engineer • 6 yrs of experience

Bio

I'm a Data Engineer with over 3,5 years of experience in Software and Data Engineering. I'm a Data passionate and enthusiast.
I'm comfortable with challenges and working side by side with interdisciplinary teams.
Background in a nutshell
  • Business Intelligence/Data Engineer
    5 years 9 months
    G************
  • .Net Developer
    11 months
    G******

Techstacks

Proficient in?
AWSApache SparkBashNoSQLPostgresqlPower BIPythonSQL
Experienced in?
Apache AirflowApache Avro

General information

Work experience

Business Intelligence/Data Engineer

G************Cordoba, Argentina
5 years 9 months
Sep. 2020 - Present

The company is an IT Consulting firm around the world.

I contributed to two main projects:

  • Internal BI Team project:

    • Working side by side with other Business Intelligence colleagues, Functional Analysts, and other departments.

    • Reducing complexity and performance of SQL Queries to speed up dashboard loading.

    • Creating PowerBI dashboard for the Purchase Management team to get insights about purchases around the world, their status, and delays.

    • Improving manual tasks to fully automate them via Power Automate. RPA (Robot Process Automation) helped me to achieve this milestone.

    • Creating ETLs to build Dimensional Modelling in the Data Warehouse to support Back-End Dashboards.

    • Refactoring ETLs/ELTs pipelines to meet performance and reusability specifications using Pentaho Data Integration and SQL to extract, transform and load into the Data Warehouse.

    • Giving workshops to the client to give guidance on how to build PowerBI dashboards using the Self-Service Principle.

  • Google Internal Project: Working on a Supply chain project for Google as part of their team:

    • Giving insights about errors in the system through SQL.

    • Creating a dashboard to explore and analyze data formats in columns to help the Google team to make decisions to improve validations rules.

    • Developing workflow to execute SQL Script and populate temporary tables to serve dashboards.

  • General information
    • Work experience
    • Personal projects
    • Education
  • Gemo assessments
    • Video Screening
    • Technical interview
    • Soft-skills interview
Apache Cassandra
Apache Kafka
C#
Docker
GCP
Familiar in?
AirbyteApache HiveAzureDatabricksJavaScript

Section overview

Work experience
2
Personal projects
1
Education
3

Languages

English 🇺🇸, Spanish 🇦🇷
©2026

.Net Developer

G******Cordoba, Argentina
11 months
Oct. 2019 - Sep. 2020

The company is an IT Consulting firm around the world.

My main achievements were:

  • Created a Back-End API using ASP.NET, and Patterns like MVC and Repository, alongside my team to meet client specifications.

  • Created Unit Tests to ensure the API is meeting the specifications and is working properly.

  • Fixed bugs or reported issues.

Personal projects

Immigration Data Modelling

1 month
Dec. 2021 - Dec. 2021

This is a Data Pipeline Project for my Data Engineering Nano-degree Program. The idea of this project was to look at the Form I-94 immigration process at the EEUU to get insights into how many immigrants came in 2016. Thanks to Dimensional Modelling we can find how many immigrants came and give more context: Country of origin, Gender, Airport, Temporary State Residence, etc.

AWSPythonApache Spark

Education

Data Engineeering Nano-Degree

UdacityCity, Country
1 month
Nov. 2021 - Dec. 2021

Data Engineer with Python - Career track

DataCampCity, Country
2 months
May. 2021 - Jul. 2021

System Engineering

Universidad Tecnologica Nacional (UTN)City, Country
Current
Jan. 2015 - Present

Gemography's Assessment

Our assessment processes starts with a quiz, to assess the candidate's knowledge and understanding of relevant technical concepts. Then, depending on their score, the following steps usually include a coding challenge, a phone interview, and an in-person interview. Below are comments on these touch points from the engineers responsible for each step.

Video Screening

🎥

What's the most challenging technical project or feature I've worked on recently?

Sorry, your browser doesn't support embedded videos.

Technical interview

YEH
Youssef El HassaniGemography's assessment team
Yes

Overall takeaway

He stood out as an avid self-learner. He likes challenging tasks and is currently looking for an opportunity to grow his skillset. He is mainly interested in working with AWS. Although he has some issues expressing himself fluidly, I think he can be valuable due to his tech level.

SkillsEvaluation
System Design

The candidate was given the "CSV file processing" below:

"Suppose we have a csv file in a location A (e.g SFTP server) and we want to move it to a location B (e.g internal AWS S3 bucket), while doing so, wanna change the file format from csv to parquet."

He proposed the following solution:

  • Access the CSV.

  • Use Spark to consume the data.

  • Access the S3 bucket.

  • Write down as parquet using SPARK ( Use AWS EMR).

  • Save file to S3.

  • Using Cron to schedule the jobs.

  • Using Hadoop and Spark to scale the infrastructure.

Dealing with loose data:

  • Save all the data sources without modification in a temporary bucket.

Solving dependencies conflicts

  • Not relevant in his solution

Yes
Database systems

  • Specialized in the creation of databases, and data warehouses

  • Familiar with Snowflake, AWS, Azure DB services

  • He created several data pipelines

  • His strongest skill is Pyspark

Soft-skills interview

KF
Kyle FitzPatrickGemography's assessment team
Strong yes

Overall takeaway

  • A really nice person, very positive, humble and self aware.

  • Great communication, adding a lot of details and examples to his answers.

  • Conversational English - currently preparing for the IETLS exam and understands that he needs to work on his pronunciation.

  • Clearly wants to learn and grow, not only in tech but as a person. Very open to others ideas and opinions. Asked about what the most important soft skills are, especially working with people from other cultures.

  • Although he doesn't have a lot of work experience, he seemed mature and professional.

  • Seems like someone that I would enjoy working with and could count on.

  • He understands his flaws and gave concrete examples of what he needs to work on: intercultural communication, work/life balance.

  • He is hard working and puts in a lot of extra effort. Currently spends 12 hours a day on work and developing his skills.

  • He seems to be a team player giving a concrete example of taking on extra work so that another employee could meet their deadline.

Yes
Version control

  • Familiar with pull requests

  • Participate in PR review sessions

  • Uses git extensively

Yes
Debugging errors

  • He uses logging library to see information for each executed line

Neutral
Networking (ex : HTTP protocol)

  • Worked extensively with REST APIs

  • Familiar with HTTP status code

Yes
Automated Testing

Yes
Build Automation

  • Basic knowledge of Docker and Kubernetes.

  • Experience with Terraform to manipulate automated deployment.

Yes
SkillsEvaluation
Clear communication and idea structure
Yes
Self-Awareness
Yes
English

English level with sufficient structural accuracy and vocabulary to effectively hold a conversation but with a strong accent.

Neutral
Startup mindset and product sense
No experience with a startup so far.
No
Humbleness and eagerness to learn
Strong yes
Remote Experience
Yes
Autonomy and ownership
Yes
Ability to stay positive
Strong yes