ETL AWS Developer

Robotics Prcocess Automation, LLC; Jersey City (NJ); On-site; USD 90,000 - 120,000; Full time

Job summary

A leading Automation Company in Jersey City, NJ is seeking an ETL AWS Developer to design and implement scalable ETL pipelines. The ideal candidate will leverage AWS services including Glue, Lambda, and S3 to integrate data from diverse sources. Responsibilities include monitoring workflows, ensuring data quality, and optimizing overall performance. A collaborative approach is essential to support analytics needs within the team. This position offers an equal opportunity work environment.

Qualifications

• Experience in designing ETL pipelines using AWS services.
• Proficiency in implementing data transformations using PySpark, Python, or SQL.
• Familiarity with optimizing ETL performance and enforcing security best practices.

Responsibilities

• Design and develop scalable ETL pipelines using AWS services.
• Monitor and orchestrate ETL workflows ensuring data quality.
• Document ETL processes and data architecture.

Skills

AWS Glue

Python

SQL

PySpark

AWS Lambda

Data Warehousing

Job description

Job Title: ETL AWS Developer
Location: Jersey City, NJ

Requirements

• Design and develop scalable ETL pipelines using AWS services such as:
• AWS Glue for serverless data integration, AWS Lambda for lightweight transformations, Amazon S3 for data lake storage, Amazon Redshift or RDS for data warehousing. Integrate data from diverse sources including APIs, databases, and flat files into AWS-based data platforms.
• Implement data transformation logic using PySpark, Python, or SQL within AWS Glue or Lambda.
• Monitor, schedule, and orchestrate ETL workflows using AWS Step Functions, Glue Workflows, or Apache Airflow on Amazon MWAA. Ensure data quality, consistency, and lineage using AWS Glue Data Catalog and AWS Lake Formation.
• Optimize ETL performance and cost-efficiency through partitioning, parallelism, and resource tuning.
• Implement security best practices including encryption, IAM roles, and VPC configurations.
• Collaborate with data engineers, analysts, and DevOps teams to support analytics and reporting needs.
• Document ETL processes, data flows, and architecture using tools like AWS Architecture Diagrams or Confluence.

ROBOTIC PROCESS AUTOMATION LLC is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. ROBOTIC PROCESS AUTOMATION LLC will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will ROBOTIC PROCESS AUTOMATION LLC require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract.