ETL Developer

Insight Global; Dallas (TX); On-site; USD 90,000 - 130,000; Full time

Job summary

A staffing and consulting firm is seeking an experienced developer for ETL projects in Dallas, Texas. The ideal candidate has over 5 years of experience in ETL development and database programming, particularly with tools like Python, AWS, and SQL. Responsibilities include designing and maintaining code, mentoring junior developers, and supporting projects in a collaborative team environment. The position offers competitive pay and opportunities for professional growth.

Qualifications

• 5+ years of experience in ETL development in a Data Warehouse.
• 5+ years of experience with database programming languages.
• 3+ years of hands-on experience with cloud infrastructure projects.

Responsibilities

• Design, develop, enhance and maintain code.
• Translate requirements to technical design and execute unit tests.
• Communicate status and support continuous improvement.

Skills

ETL development

Cloud infrastructure

Python/PySpark

SQL development

Database programming

Communication skills

Organization skills

Education

Bachelor’s degree in related field

Tools

IBM DataStage

AWS

Azure

Snowflake

Job description

• 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.
• Performs 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.