ETL developer/Programmer/Analyst/Engineer

SIDRAM TECHNOLOGIES; Indiana (PA); On-site; USD 100,000 - 130,000; Full time

Job summary

A technology solutions firm is seeking a Data Engineer with expertise in AWS and Python for ETL projects. Responsibilities include designing and maintaining ETL code, translating data requirements to technical designs, and mentoring junior developers. Candidates should have at least 5 years of ETL development experience, a Bachelor’s degree in Computer Science, and experience with cloud infrastructure, particularly AWS. The role requires onsite work 4 days a week.

Qualifications

• 5+ years of experience in ETL development and data warehousing best practices.
• 5+ years experience programming in Python, SQL, with IBM DataStage.
• 3+ years experience in cloud infrastructure projects, specifically AWS.

Responsibilities

• Design, develop, enhance and maintain ETL code following best practices.
• Translate requirements to technical designs and execute unit test plans.
• Mentor junior developers and lead specific projects as needed.

Skills

AWS

Python

ETL

SQL

Data Warehouse

Database Programming

Cloud Infrastructure

Security Practices

Education

Bachelor’s degree in Computer Science or related field

Tools

IBM DataStage

PySpark

Job description

Location: Columbus, OH; Dallas, TX; Minneapolis, MN; Tupelo, MS. Must be onsite 4 days a week.

Contract: To hire

Client – HNB

UPDATE ON SKILL NEED: We are trying to sunset Datastage in EDW. So focus is on AWS/Python with the ETL. Look for Data Engineer with AWS and Python coming from an ETL project.

Responsibilities

• Design, develop, enhance and maintain code following best practices and standards.
• Translate requirements and data mapping documents to a technical design.
• Create and execute unit test plans. Support regression and system testing efforts.
• Debug and problem solve issues found during testing and/or production.
• Communicate status, issues and blockers with project team.
• Support continuous improvement by identifying and solving opportunities.
• Maintain and demonstrate knowledge of technical industry trends.
• Mentor and train junior level developers on team.
• Serve as project leader for specific projects.
• Perform other duties as assigned.

Basic Qualifications

• Bachelor’s degree in related field (preferably Computer Science)
• 5+ years of experience in ETL development in a Data Warehouse, including understanding of enterprise data warehousing best practices and standards.
• 5+ years of experience with database programming languages and advanced analytics.
• 5+ years of experience with Python/PySpark, IBM DataStage and SQL development.
• 3+ years of experience in cloud infrastructure projects with hands‑on migration expertise on public clouds such as AWS and Azure, preferably Snowflake.

Preferred Qualifications

• Excellent communication and interpersonal skills.
• Excellent organization skills and the ability to work independently as well as with a team.
• AWS Certified Solutions Architect – Associate, AWS Certified DevOps Engineer – Professional and/or AWS Certified Solutions Architect – Professional.
• Knowledge of cybersecurity organization practices, operations, risk management processes, principles, architectural requirements, engineering and threats and vulnerabilities, including incident response methodologies.
• Experience defining future state roadmaps for data warehouse applications.
• Experience leading teams of developers within a project.
• Experience in financial services (banking) industry.

Rachael
Email: [e-mail]