ETL / AWS Software Engineer (F2F Interview)

Chicago, IL, US • Posted 5 hours ago • Updated 26 minutes ago

Contract W2

Contract Independent

Contract Corp To Corp

On-site

Fitment

Dice Job Match Score™

🤯 Applying directly to the forehead...

Job Details

Skills

Video
Migration
Data Validation
Data Quality
Business Rules
Korn Shell
Unix
Linux
PySpark
Business Analysis
Decision-making
Software Development
Collaboration
Reporting
Scalability
Production Support
Data Integrity
Documentation
Data Flow
Impact Analysis
Software Security
Regulatory Compliance
Data Security
Computer Science
Information Technology
Extract
Transform
Load
Data Integration
Scripting
IBM InfoSphere DataStage
Datastage
Informatica
Shell Scripting
Perl
API
SOAP
Cloud Computing
Step-Functions
Amazon S3
Amazon EC2
SQL
Relational Databases
IBM DB2
IBM AIX
Database
Amazon RDS
PostgreSQL
Amazon Redshift
Version Control
Git
Bitbucket
Jenkins
Continuous Integration
Continuous Delivery
Data Analysis
Microsoft Excel
Python
Tableau
Amazon Web Services
Artificial Intelligence
Machine Learning (ML)
Data Warehouse
Agile
Oracle UCM
OM
WebKit
SANS
IMG

Summary

TITLE - ETL / AWS Software Engineer (F2F Interview)

Location: Hybrid - Chicago, Illinois (few days in office)

Interview: Video (final in person)

Type: contract

Any visa except OPT & H1B

Software Development Engineer with ETL and AWS Background

Job Description

Client is seeking a highly experienced Software Development Engineer to lead and support the migration of ETL jobs and databases from on-premises environments to the AWS Cloud. This position requires a hands-on developer who can build new ETL solutions if necessary, thoroughly understand all existing on-premises ETL jobs, and serve as an expert to guide the team. Key responsibilities include job execution, data validation, ensuring data quality, and adherence to data compliance and business rules. The role also encompasses understanding AWS infrastructure-as-code, developing ETL solutions to replicate on-premises processes in the cloud, orchestrating and validating jobs, and providing comprehensive production support. Candidates must possess technical development expertise and a strong background in data analytics.

Responsibilities

Leverage development experience with DataStage or Informatica, Korn Shell, Python, and Perl scripting on Unix/Linux platforms.

Be able to design, develop, and implement ETL Glue PySpark processes to extract, transform, and load data from various sources into AWS cloud-based data warehouses and data lakes, specifically Redshift and Aurora PostgreSQL.

Be able to develop scalable and efficient full-stack applications, including both front-end and back-end components or APIs, as required.

Conduct business analysis and perform data analysis/ validation to minimize errors and inconsistencies, extract meaningful insights, and support business decision-making throughout the software development lifecycle.

Collaborate closely with data analysts, data architects, and other team members to analyze source data, enhance data accuracy and integrity, implement data reporting, and understand data and application requirements to deliver effective solutions.

Automate and orchestrate ETL processes, applications, and APIs to optimize performance and scalability across both on-premises and cloud environments.

Proactively provide production support, including monitoring, troubleshooting, and resolving issues for ETL processes, configurations, and data integrity.

Develop comprehensive documentation covering overall processes, data mappings, data flows, APIs, application code, and support procedures.

Perform impact analysis and effectively communicate technical processes and concepts to larger audiences.

Ensure data and application security and compliance with all relevant data protection regulations.

Participate in code reviews, adhere to best practices, and provide constructive feedback to peers.

Stay up to date with the latest industry trends and best practices in the areas of ETL development, full-stack development, data analysis, and cloud technologies.

Qualifications

Bachelor's degree in Computer Science, Information Technology, or a related field.

More than 8 years of experience in ETL development, data warehousing, AWS cloud services, and API development.

Comprehensive proficiency in all AWS services with a strong understanding of data integration, transformation, and loading processes.

Expertise in scripting languages, including DataStage or Informatica, Shell scripting, Perl, and Python.

Experience with API development and frameworks such as REST and SOAP.

Advanced skills utilizing the AWS cloud platform and services, including AWS Glue, Step Functions, Airflow DAGS, Lambda, S3, EC2, and others.

Proficiency in SQL with both on-premises relational databases (such as DB2 on AIX) and AWS databases (such as Amazon RDS, Amazon Aurora PostgreSQL, and Redshift).

Experience with version control tools like Git or Bitbucket.

Familiarity with implementing Jenkins pipelines and CI/CD processes.

Demonstrated experience in data analysis/ validation, utilizing tools such as Excel, Python, and Tableau.

AWS certifications and expertise in AI/ML are advantageous.

Familiarity with automotive industry knowledge, data warehousing concepts, and adherence to developer best practices.

Experience working within Agile development methodologies.

Navnish kumar

Sr. IT Technical Recruiter

Stellent IT Phone:

Email: navnish
Gtalk: navnishom

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Dice Id: 91022079
Position Id: 2026-46323
Posted 5 hours ago

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.

ETL / AWS Software Engineer (F2F Interview)

Dice Job Match Score™

Job Details

Skills

Summary

Similar Jobs