Datstage II

LTM; Chennai, Bengaluru; Hybrid; INR 900,000 - 1,500,000; Full time

Job summary

LTM requires a DataStage ETL Developer to design, build, and optimize data integration jobs across Datastage and related tools. The role involves collaborating with analysts and data architects to ensure accurate data delivery and system reliability.

You will troubleshoot jobs, document processes, and ensure data quality while maintaining adherence to SDLC and QA metrics. The position may require shift-based production support and knowledge of BI reporting tools.

Qualifications

• Strong DataStage and Netezza ETL experience with DB2 and SQL Server.
• Collaborate with business analysts and data architects to understand requirements.
• Design and develop ETL processes and jobs using IBM DataStage according to specifications.
• Optimize existing DataStage jobs for performance.
• Review job designs and code produced by other DataStage developers.
• Troubleshoot DataStage job failures and provide root-cause analysis.
• Maintain and support data integration systems.
• Document ETL processes and procedures.
• Ensure data quality and integrity through validation and testing.
• Stay updated with industry trends and best practices.
• Strong knowledge of SDLC, QA metrics, and software engineering principles.
• Exhibited analytical and reporting skills.

Responsibilities

• DataStage ETL development and maintenance.
• Adaptable to work with any ETL technology.
• Provide analysis, coding, and unit testing support.
• Communicate effectively with customers.
• Shift to provide production support when required.

Skills

Datastage

Netezza

Snowflake

SSIS

ControlM

ServiceNow

Azure DevOps

BI Reporting Tools

ITIL

Agile Methodologies

SDLC

QA Metrics

Analytical Communication

Tools

DB2

SQL Server

Datastage Design

Job description

Nov 5Location- Banglore and chennai
Experience - 3 - 5years
Shift- 2:30 pm to 12 am

Primary skill - Datastage and Netezza Secondary skill - Snowflake, SSIS

Must Have

• 1.Strong Experience in DataStage Netezza DB2 ETL Extract Transform Load processes SQL server
• 2.Collaborate with business analysts and data architects to understand requirements
• 3.Design and develop ETL processes jobs using IBM Datastage according to specifications
• 4.Optimize existing Datastage jobs for performance
• 5.Review job designs and code created by other Datastage developers
• 6.Troubleshoot Datastage job failures and provide root cause analysis
• 7.Maintain and support data integration systems
• 8.Document ETL processes and procedures
• 9.Ensure data quality and integrity through validation and testing
• 10.Stay updated with the latest industry trends and best practices
• 11.Strong knowledge on Software engineering Principles SDLC Process QA Metrics
• 12.Excellent Analytical Communication Reporting Skills

Good to Have

• 1.Experience in ControlM Service Now Azure DevOps SSIS
• 2.Domain Banking and ITIL Process
• 3.Process Experience working in Agile Methodologies
• 4.Experience in BI Reporting Tools

Roles Responsibility

• DataStage ETL Developer
• Adaptable to work in any ETL Technology
• Responsible for Support analysis coding and unit testing
• Excellent communication skill and should work directly with customer
• Need to work on Shift to Provide Support