Senior DataStage & AWS ETL Engineer | Cloud Migrations

System Soft Technologies; Baltimore (MD); On-site; USD 90,000 - 130,000; Full time

Job summary

System Soft Technologies is seeking a senior ETL Specialist to develop and optimize DataStage jobs and migrate workloads to AWS. You will design scalable data pipelines, ensure data quality, and contribute to cloud-native or hybrid architectures across multiple data platforms.

The role requires deep hands-on experience with IBM DataStage and broad AWS service proficiency, along with collaboration with data architects and business stakeholders to meet data requirements.

Qualifications

• Strong hands-on experience with IBM DataStage and parallel jobs.
• Proficiency with AWS services including S3, Lambda, Glue, Redshift, RDS, EC2, EMR, CloudWatch, IAM and Step Functions.
• Develop, enhance, and DataStage ETL jobs for data extraction, transformation, and loading across multiple systems.
• Design and implement cloud-native or hybrid architectures using Lambda, Glue, EMR, Step Functions, Redshift and DynamoDB.

Responsibilities

• Migrate on-prem DataStage workloads to AWS cloud-native or hybrid architectures.
• Optimize ETL performance, troubleshoot job failures, and ensure data quality and integrity.
• Build CI/CD pipelines for ETL and AWS.
• Collaborate with data architects, analysts, and business stakeholders to understand data requirements.
• Implement security best practices including IAM roles, encryption, VPC networking, and compliance standards.
• Create technical documentation, data flow diagrams, and operational runbooks.
• Monitor and tune AWS resources for cost optimization and performance.

Skills

ETL development

Data integration

Performance tuning

Data quality

Tools

IBM DataStage

AWS S3

AWS Lambda

AWS Glue

Amazon Redshift

Amazon RDS

Amazon EC2

Amazon EMR

CloudWatch

IAM

Step Functions

Job description

System Soft Technologies is seeking a senior ETL Specialist to develop and optimize DataStage jobs and migrate workloads to AWS. You will design scalable data pipelines, ensure data quality, and contribute to cloud-native or hybrid architectures across multiple data platforms.

The role requires deep hands-on experience with IBM DataStage and broad AWS service proficiency, along with collaboration with data architects and business stakeholders to meet data requirements.