Application Programmer III

Artech LLC

Plano, TX

JOB DETAILS
SKILLS
Agile Programming Methodologies, Application Programming Interface (API), Business Analysis, Business Support, Channel Strategies, Communication Skills, Continuous Deployment/Delivery, Continuous Integration, Cross-Functional, Data Management, Data Processing, Data Quality, Data Warehousing, Database Design, Database Extract Transform and Load (ETL), Database Technology, Delivery Driving, Dimensional Modeling, Enterprise Data Integration, Git, IBM WebSphere DataStage, Identify Issues, Kanban, Mentoring, Microsoft SQL Server, Oracle Database, Performance Tuning/Optimization, Problem Solving Skills, Process Flow, Process Improvement, Quality Assurance, Relational Databases (RDBMS), SQL (Structured Query Language), Scrum Project Management and Software Development, Software Engineering, Source Code/Configuration Management (SCM), Sprint Planning, Sprint Retrospective, Standup Meetings, Team Player, Technical Writing
LOCATION
Plano, TX
POSTED
4 days ago

Location:

Plano, TX

Salary Range:

Competitive Salary Based on Experience

Introduction

We are seeking a highly skilled professional to design, develop, and maintain ETL solutions using IBM DataStage. The ideal candidate will have strong expertise in data integration, database design, and Agile development practices. This role involves collaborating with cross-functional teams to deliver high-quality data solutions that support business objectives.

Required Skills & Qualifications

  • 8 years of experience with IBM DataStage (parallel and server jobs)
  • Strong SQL skills and experience with relational databases (Oracle, SQL Server)
  • Proficiency in database design principles (normalization, indexing, partitioning)
  • Hands-on experience with Agile frameworks (Scrum, Kanban)
  • Familiarity with CI/CD pipelines and version control (Git)

Preferred Skills & Qualifications

  • Knowledge of data warehousing concepts and dimensional modeling
  • Experience with performance tuning and troubleshooting ETL jobs
  • Excellent communication and collaboration skills
  • Ability to work independently and mentor junior developers
  • Applicants must be able to work directly for Artech on W2

Day-to-Day Responsibilities

  • Design, develop, and optimize ETL processes using IBM DataStage for data extraction, transformation, and loading
  • Create and maintain logical and physical database models; ensure data integrity and performance optimization
  • Participate in Agile ceremonies (daily stand-ups, sprint planning, retrospectives) and deliver incremental value
  • Work with multiple data sources (relational, flat files, APIs) and integrate them into enterprise data warehouses
  • Optimize ETL jobs and database queries for scalability and efficiency
  • Maintain technical documentation for ETL processes, data flows, and database schemas
  • Partner with business analysts, data architects, and QA teams to ensure requirements are met and solutions are tested thoroughly
  • Diagnose and resolve issues in ETL workflows and data pipelines

Company Benefits & Culture

  • Inclusive and diverse work environment
  • Opportunities for professional growth and development
  • Flexible work arrangements

For immediate consideration please click APPLY to begin the screening process.

About the Company

A

Artech LLC