DataStage ETL Engineer & Database Developer

Ariel Partners; New York (NY); On-site; USD 110,000 - 140,000; Full time

Job summary

Ariel Partners seeks a skilled ETL/Data Integration Developer in the United States to design and implement data systems using IBM Infosphere DataStage. The role covers data architecture, performance tuning, and deployment across DSS program areas.

You will work with SQL Server and Oracle, develop ETL jobs, and ensure data quality, security, and reliable reporting; collaboration with teams to meet complex data needs and deliver robust enterprise solutions.

Qualifications

• IBM Infosphere DataStage & Quality stage Developer Experience.
• Microsoft reporting products including SharePoint, SSAS, SSRS.
• Curam V6 Certified Developer Experience in architecture field.
• HTML, DHTML, JavaScript, open source Java framework (Struts/Springs), Ajax (JQuery, Dojo), SOA, and WebServices.

Responsibilities

• Develop system design specifications
• Analyze existing software or work to formulate logic for complex new systems and devise complex algorithms.
• Design, develop, modify and assist in deployment of software, including object-oriented programming concepts.
• Develop programming tools to follow software specifications
• Develop or advise detailed architecture for correspondence and printing, workflow, integration and migration, auditing and archiving.
• Perform system design and develop DataStage jobs
• Develop powerful Extract, Transform, Load (ETL) solutions using IBM Infosphere DataStage to support the collection; integration and transformation of large volumes of data, with data structures ranging from simple to highly complex
• Fine tune DataStage jobs and queries to achieve optimized performance benefits.
• Involved in performance tuning of DataStage jobs to ensure that they execute without warnings
• Develop database scripts for stored procedures and Functions using SQL Server and Oracle tools for application development
• Perform data quality and profiling activities, advise on data quality issues and provide analysis on data collection and integration
• Program in SQL Server to perform the data query by designing cubes and dashboards
• Providing programming assistance when needed

Skills

IBM Infosphere DataStage

QualityStage

SharePoint

SSAS

SSRS

Curam V6

HTML/JavaScript

JQuery/Dojo

Struts

Spring

SOA

WebServices

WebSphere

ESB

Delivery experience

Tools

JIRA

Oracle

SQL Server

Eclipse

Job description

Ariel Partners seeks a skilled ETL/Data Integration Developer in the United States to design and implement data systems using IBM Infosphere DataStage. The role covers data architecture, performance tuning, and deployment across DSS program areas.

You will work with SQL Server and Oracle, develop ETL jobs, and ensure data quality, security, and reliable reporting; collaboration with teams to meet complex data needs and deliver robust enterprise solutions.