DataStage Systems Analyst

Veriipro; Portland (ME); On-site; USD 70,000 - 90,000; Full time

Job summary

Veriipro is looking for a DataStage Systems Analyst to join its Enterprise Integration Team in Portland, Maine. The role focuses on developing and supporting ETL processes using IBM DataStage, ensuring data quality and performance optimization across multiple database platforms.

You will collaborate with application tech leads, optimize ETL solutions, and validate integration outcomes. Strong communication, analytical skills, and proficiency in DataStage are essential. This position offers opportunities to work with cutting-edge technology and business requirements.

Qualifications

• High proficiency in IBM DataStage with strong development and design experience.
• Experience in production support and QA testing of ETL processes.
• Ability to work across multiple database platforms.

Responsibilities

• Develop and maintain ETL jobs using IBM DataStage.
• Monitor and tune ETL performance for production workloads.
• Collaborate with business partners to understand requirements.

Skills

IBM DataStage

Performance tuning

Production support

Analytical skills

Communication skills

Tools

IBM Information Governance tools

Job description

We are seeking a DataStage Systems Analyst to join our Enterprise Integration Team. The role involves working closely with Application and ETL Tech Leads to design, develop, and support ETL processes across multiple database platforms, ensuring performance, maintainability, and high-quality data integration solutions.

Key Responsibilities

• Develop and maintain ETL jobs using IBM DataStage (preferably version 11.x).

• Design reusable, efficient, and maintainable ETL solutions across multiple engagements and technologies.

• Monitor and tune ETL performance for production workloads.

• Support production ETL processes, ensuring restartability and ease of maintenance.

• Participate in QA testing of ETL processes and validate data integration outcomes.

• Access and integrate data from multiple DBMS platforms including Oracle, SQL Server, UDB DB2, and DB2Z.

• Collaborate with business partners to understand requirements and broker effective ETL solutions.

• Produce clear documentation and communicate effectively in English.

Required Skills

• High proficiency in IBM DataStage, with strong development and design experience.

• Performance tuning and process optimization experience.

• Experience in production support and QA testing of ETL processes.

• Ability to work across multiple database platforms.

• Strong analytical, communication, and documentation skills.

Preferred Skills

• Experience with IBM Information Governance tools (Information Governance Catalog, Information Analyzer, Business Glossary).

• Experience developing ETL solutions integrating with SAP.