Gabriel Corral

BIG DATA ENGINEER

Phone: 414-***-****

Email: adtn0l@r.postjobfree.com

Professional Profile

IT Professional with 8 years of Experience in Big Data Development along with Data administration; Passionate about Big Data technologies and the delivery of effective solutions through creative problem solving with a track record of building large-scale systems using Big Data technologies.

Excellent academic credentials with Bachelor of Mechatronics Engineering from Mexico along with working proficiency in using Hadoop clusters, Hadoop HDFS, Hadoop tools and Spark, Kafka, and Hive

Experienced with Big Data link technologies such as Amazon Warehouse Services (AWS), Microsoft Azure, cloud services (Amazon S3, EMR, EC2, Glue, SNS, Cloud watch), Cassandra, HIVE, No-SQL databases (like HBase, MongoDB), SQL databases (like Oracle, SQL, Postgres SQL, My SQL server, Snowflake).

Familiar with Software Development Life Cycle with experience in preparing and executing Unit Test Plan and Unit Test Cases after software development

Knowledge of performance-tuning data-heavy dashboards and reports for optimization using various options such as Extracts, Context filters, writing efficient calculations, Data source filters, Indexing, and Partitioning in the data source.

Brilliant in providing clear and effective testing procedures and systems to ensure an efficient and effective process. Clearly documents big data systems, procedures, governance and policies.

Skills:

Data Ingestion

Distributed Processing

Data Migration

Data Processing

Cloud Data Pipelines

Data Analysis

Technical Skills

OS: Microsoft Windows, Microsoft Windows Server, Linux, Mac

Programming & Scripting: Spark, Python, Java, Scala, Hive, Kafka, SQL, HTML, CSS, JavaScript

Database Skills: Database partitioning, database optimization, building communication channels between structured and unstructured databases.

Data Stores: Data Lake, Data Warehouse, SQL Database, RDBMS, NoSQL Database, Amazon Redshift, Apache Cassandra, MongoDB, SQL, MySQL, Oracle

Data Pipelines/ETL: Flume, Apache Storm, Apache Spark, Nifi, Apache Kafka

Databases: Cassandra, Hbase, Redshift, DynamoDB, MongoDB, MS Access, SQL, MySQL, Oracle, PL/SQL, Postgres SQL, RDBMS

HADOOP DISTRIBUTIONS: Apache Hadoop, Cloudera Hadoop, Hortonworks Hadoop

CLOUD PLATFORMS: Amazon AWS - EC2, SQS, S3, Elastic Cloud, Microsoft Azure, GCP

IDE: Jupyter Notebooks (formerly iPython Notebooks), Eclipse, IntelliJ, PyCharm

AWS: AWS Lambda, AWS S3, AWS RDS, AWS EMR, AWS Redshift, AWS Kinesis, AWS ELK, AWS

Professional Experience

ROCKWELL AUTOMATION, Milwaukee, WI January 2020 – Current

AWS Data Engineer

Working on many projects involving predictive maintenance in different industries such as pharmaceutical, automotive, and mass consumer products. Also helping other countries with their projects such as Colombia, Brazil, USA, and Europe.

Worked with a Big Data dev team that created a solution to allow you to join 2 or more tables from a trusted bucket and save the result in a new table into an enhanced-trusted bucket, query it using Dremio or RapidSQL, and save the data lineage in Collibra.

Implemented AWS EMR Spark using PySpark/Scala and utilized DataFrames and SparkSQL API for faster processing of data.

Registered datasets to AWS Glue using AWS Glue crawlers and the Glue data catalog.

Used AWS API Gateway to Trigger Lambda functions.

Queried with Athena on data residing in AWS S3 bucket.

Utilized AWS Step function to run a data pipelines in AWS.

Used DynamoDB to store metadata and logs.

Monitored and managed services with AWS CloudWatch.

Performed transformations using Apache SparkSQL in AWS Glue.

Wrote Spark applications for data validation, cleansing, transformation, and customed aggregation in Scala.

Developed Spark code using Python/Scala and Spark-SQL for faster testing and data processing.

Tuned Spark to increase job's performance.

Used Athena to query data from AWS S3.

Used Dremio as Query engine for faster Joins and complex queries over AWS S3 bucket using Dremio data reflections.

Wrote and upgraded Lambda function written in Python2 to Python3.

Conducted testing using PyCharm and PyTest functions upgraded from Python2 to Python3.

Loaded data into AWS Snowflake as Data warehouse.

Worked on POCs to ETL with S3, EMR(Spark) and Snowflake.

Worked as part of the Big Data Engineering team and worked on pipeline creation activities in the Azure environment.

Used Apache Airflow to schedule jobs and monitor.

Used Talend to transfer dataset to S3 bucket as POC.

Used Datasync to move data from NAS(EC2) storage to S3 bucket.

FORD MOTOR COMPANY, Dearborn, MI Jan 2019 – Dec 2019

Data Engineer

Creating a Pipeline from a Rest API and Store the data into MySQL Database.

Ingesting Data using Apache Flume and Store the data into HDFS as JSON format.

Configured Flume Agent with Rest API Keys to ingest data

Used Apache Spark, spark-streaming to perform transformations

Configured a JDBC driver in PySpark to connect MySQL Database

Wrote incremental imports into Hive tables.

Created Dataframe to store the processed results in a tabular format.

Installed Airflow engine to run multiple spark Jobs.

Wrote Spark SQL queries and optimized the Spark queries with Spark SQL.

ETL to Hadoop file system (HDFS) and wrote Spark UDFs.

Established data consumption from information stored on Google Cloud.

Experienced in importing real-time logs to HDFS using Flume.

Created UNIX shell scripts to automate build process, and perform regular jobs like file transfers.

Hortonworks used for installation of Hortonwork Cluster and performance monitoring.

Made incremental imports to Hive with Sqoop.

Managed Hadoop clusters and check the status of clusters using Ambari.

Moved Relational Database data using Sqoop into Hive Dynamic partition tables using staging tables.

Initiated data migration from/to traditional RDBMS with Apache Sqoop.

Developed scripts to automate the workflow processes and generate reports

SERVIPERF S.A. C.V. / ATLANTA INTERNATIONAL AIRPORT, REMOTE MAR 2017 – DEC 2018

Data Engineer

Created UNIX shell scripts to automate the build process, and to perform regular jobs like file transfers.

Wrote shell scripts to automate workflows to pull data from various databases into FS.

Loaded data into a shared file system using terminal.

Performed upgrades, patches and bug fixes in Hadoop in a cluster environment.

Wrote shell scripts for automating the process of data loading

Created test cases during two-week sprints using agile methodology

Designed data visualization to present current impact and growth using Power BI

Developed a Java program to clean up data streams from server logs

Worked with a Java Messaging system to deliver logs

Monitored multiple SQL servers to improve query performance

Experience in configuring, installing and managing Hadoop binaries (PoC).

HADOOP DEVELOPER / METLIFE INSURANCE COMPANY, NEW YORK, NY MAR 2015 – FEB 2017

Hadoop Data Engineer

Worked with technology and business groups for Hadoop migration strategy.

Created map-reduce jobs for data processing using JAVA as a programming language.

Research and recommend suitable technology stack for Hadoop migration considering current enterprise architecture.

Used and validated Hadoop Infrastructure and data center planning considering data growth.

Transferred data to and from clusters, using Sqoop and various storage media such as flat files.

Developed MapReduce programs and Hive queries to analyze sales pattern and customer satisfaction index over the data present in various relational database tables.

Orchestrated hundreds of Sqoop scripts, Pig scripts, Hive queries using Oozie workflows and sub-workflows

Worked extensively in performance optimization by adopting/deriving at appropriate design patterns of the MapReduce jobs by analyzing the I/O latency, map time, combiner time, reduce time etc.

Followed Agile methodology for the entire project.

Education

Bachelor of Mechatronic Engineering

Mexico

Contact this candidate