ETL Developer

PSR Associates Inc

Lansing, MI

JOB DETAILS
SKILLS
Agile Programming Methodologies, Architectural Analysis, Automation, Cloud Computing, Consulting, Continuous Improvement, Data Analysis, Data Management, Data Processing, Data Quality, Database Extract Transform and Load (ETL), Documentation, File Management, File Systems, IBM WebSphere DataStage, Identify Issues, Information Technology & Information Systems, Information/Data Security (InfoSec), Linux Operating System, Maintain Compliance, Master Data Management (MDM), Multiplatform/Cross-Platform, Performance Management, Performance Tuning/Optimization, Python Programming/Scripting Language, Quality Management, Refactoring, Relational Databases (RDBMS), Root Cause Analysis, SQL (Structured Query Language), Systems Administration/Management, Unix Operating Systems, Unix Shell Programming, Validation Testing, XML (EXtensible Markup Language)
LOCATION
Lansing, MI
POSTED
1 day ago
PSR Associates is a consulting and talent solutions firm that connects qualified IT professionals with great opportunities. Whether you're looking for a contract or permanent position, we can help you find the right fit for your skills and experience. We have a team of experienced recruiters who know the IT industry inside and out, and we work with you every step of the way to ensure a smooth and successful transition. PSR Connecting Talent, Crafting Success.

ETL Developer

We are seeking an ETL Developer to join our team.The selected candidate will work a hybrid schedule consisting of two (2) days each week onsite (Mondays and Tuesdays. Lansing, MI and three (3) days each week remotely.

The ETL Developer is responsible for designing, developing, and maintaining high quality data integration solutions using IBM DataStage and related technologies. This role supports both on premise and cloud environments, contributes to enterprise data modernization efforts, and plays a key role in migrating DataStage workloads to IBM Cloud Pak for Data (CP4D). The developer will collaborate with technical and business teams to deliver reliable, scalable, and secure data pipelines aligned with organizational objectives.

Responsibilities and Technical Skills
  • Develop, enhance, and optimize ETL pipelines using IBM DataStage, including parallel and server jobs, job sequencing, and performance tuning.
  • Support the migration of on premise DataStage jobs to IBM Cloud Pak for Data (CP4D), including code refactoring, testing, validation, and workflow modernization.
  • Use Python and XML to automate processes, perform data transformations, and integrate automation into ETL workflows.
  • Work extensively in Linux/Unix environments to write shell scripts, manage file systems, monitor processes, and troubleshoot runtime issues.
  • Apply Master Data Management (MDM) principles to ensure data quality, governance, and consistency across enterprise systems.
  • Develop complex SQL queries for data extraction, transformation, validation, and performance improvement across relational database platforms.
  • Work within Agile teams to support sprint activities, deployments, documentation, and continuous improvement practices.
  • Collaborate with data architects, analysts, DBAs, and business users to ensure successful and accurate delivery of data solutions.
  • Troubleshoot ETL issues, perform root cause analysis, recommend improvements, and ensure adherence to data standards and security policies.
Required Skills
  • 5+ years of experience ETL (IBM DataStage) - Required
  • 1+ years of exposure to Cloud Pak for data - Required
  • 5+ years of experience with Unix/Linux
  • 3+ years of experience with Master Data Management
Desired Skills
  • Previous Government experience

*** Please note that any false information on your resume or application could lead to the offer being withdrawn or even termination after hire.***



About the Company

P

PSR Associates Inc