Senior DataStage ETL Engineer — Hybrid, Automation Focus

Persistent Systems Limited; San Jose (CA); Hybrid; USD 140,000 - 180,000; Full time

Benefits offered by this job

Competitive salary

Education support

Cutting-edge technologies

Flexible work hours

Insurance coverage

Job summary

Persistent is seeking a highly skilled Senior ETL Developer with a strong IBM DataStage background to join our data engineering team in San Jose. You will lead ETL development and automation, work with Unix shell scripts, and optimize SQL queries to enhance data integration and performance.

You will collaborate with onshore and offshore teams in an Agile environment, using JIRA and CI/CD, while adhering to ITSM processes and SLAs to ensure reliable data operations.

Qualifications

• 6+ years of proven experience in ETL development and administration using IBM DataStage.
• Strong knowledge of Unix shell scripting and Cron jobs.
• Proficient in SQL for database querying and automation.
• Experience in leading automation initiatives and developing frameworks.
• Familiarity with Agile delivery models and tools such as JIRA.
• Excellent analytical and problem-solving skills.
• Strong communication skills with experience in an onshore-offshore model.

Responsibilities

• Develop and maintain ETL processes using IBM DataStage to ensure efficient data integration and transformation.
• Utilize Unix shell scripts and Cron jobs for automation and scheduling of data workflows.
• Write and optimize SQL queries to enhance platform performance and automate processes.
• Lead initiatives to create utilities and frameworks that automate functionality and environment checks.
• Collaborate with cross-functional teams in an Agile environment, utilizing tools like JIRA and CI/CD pipelines.
• Ensure adherence to ITSM processes and SLA expectations.
• Communicate effectively with both onshore and offshore teams to facilitate project delivery.

Skills

ETL development

Unix shell scripting

Cron jobs

SQL

Agile delivery

Onshore-offshore collaboration

Communication

Tools

JIRA

CI/CD pipelines

Job description

Persistent is seeking a highly skilled Senior ETL Developer with a strong IBM DataStage background to join our data engineering team in San Jose. You will lead ETL development and automation, work with Unix shell scripts, and optimize SQL queries to enhance data integration and performance.

You will collaborate with onshore and offshore teams in an Agile environment, using JIRA and CI/CD, while adhering to ITSM processes and SLAs to ensure reliable data operations.