Senior IBM DataStage Developer

UPS; Thiruvallur District; On-site; INR 800,000 - 1,200,000; Full time

Job summary

UPS is seeking an experienced IBM DataStage Developer to design, develop, and maintain robust ETL solutions in Chennai. You will work on DataStage jobs, workflows, and SQL queries to ensure timely, accurate data delivery for BI initiatives.

The role requires 3–5 years of hands-on DataStage experience, strong ETL knowledge, and familiarity with Oracle databases. A Bachelor’s degree in CS or equivalent is needed, with exposure to BI tools and Linux preferred.

Qualifications

• Minimum 3 to 5 years of hands-on experience in designing, developing, and implementing ETL solutions using IBM InfoSphere DataStage.
• Strong understanding of ETL concepts, methodologies, and best practices.
• Proficiency in writing complex SQL queries and working with relational databases, preferably Oracle.
• Experience with data modeling concepts (e.g., dimensional modeling, star schema, snowflake schema).
• Familiarity with Linux operating systems and basic Linux commands is a plus.
• Exposure to OBIEE (Oracle BI) or other BI tools is a plus.
• Excellent written and verbal communication skills, with the ability to effectively communicate technical concepts to both technical and non-technical audiences.
• Excellent analytical skills and technical skills, with a strong attention to detail and problem-solving abilities.
• Bachelor's degree in Computer Science or equivalent in education and work experience.

Responsibilities

• Design, develop, and implement ETL processes using IBM InfoSphere DataStage to extract data from various source systems, transform it according to business rules, and load it into target data warehouses and data marts.
• Develop and maintain DataStage jobs, sequences, and workflows, ensuring optimal performance and scalability.
• Troubleshoot and resolve data integration issues, working closely with data analysts and other stakeholders.
• Write and execute complex SQL queries to analyze data, profile data sources, and validate ETL processes.
• Collaborate with business analysts and data architects to understand data requirements and translate them into technical specifications.
• Participate in the full software development lifecycle, including requirements gathering, design, development, testing, deployment, and documentation.
• Ensure adherence to data governance policies and standards.
• Monitor ETL processes and proactively identify and address potential performance bottlenecks.
• Contribute to the development and maintenance of technical documentation, including design specifications, mapping documents, and operational procedures.

Skills

ETL concepts

SQL queries

Data modeling

Analytical skills

Communication skills

Problem solving

Education

Bachelor's degree in Computer Science or equivalent

Tools

IBM InfoSphere DataStage

Oracle

Linux

OBIEE

Shell scripting

Python

Job description

Job Description:

Before you apply to a job, select your language preference from the options available at the top right of this page.

Explore your next opportunity at a Fortune Global 500 organization. Envision innovative possibilities, experience our rewarding culture, and work with talented teams that help you become better every day. We know what it takes to lead UPS into tomorrow—people with a unique combination of skill + passion. If you have the qualities and drive to lead yourself or teams, there are roles ready to cultivate your skills and take you to the next level.

Job Description:

Job Title:Intermediate / Senior IBM DataStage Developer

Location:Chennai, India

Job Summary:

We are seeking a highly motivated and skilled IBM DataStage Developer to join our dynamic team. In this role, you will be responsible for designing, developing, implementing, and maintainingrobust ETL (Extract, Transform, Load) solutions using IBM InfoSphere DataStage. You will play a crucial role in ensuring the quality, integrity, and timely delivery of data to support our business intelligence and analytics initiatives.

Responsibilities:

• Design, develop, and implement ETL processes using IBM InfoSphere DataStage to extract data from various source systems, transform it according to business rules, and load it into target data warehousesand data marts.
• Develop and maintain DataStage jobs, sequences, and workflows, ensuring optimal performance and scalability.
• Troubleshoot and resolve data integration issues, working closely with data analysts and other stakeholders.
• Write and execute complex SQL queries to analyze data, profile data sources, and validate ETL processes.
• Collaborate with business analysts and data architects to understand data requirements and translate them into technical specifications.
• Participate in the full software development lifecycle, including requirements gathering, design, development, testing, deployment,and documentation.
• Ensure adherence to data governance policies and standards.
• Monitor ETL processes and proactively identify and address potential performance bottlenecks.
• Contribute to the development and maintenance of technical documentation, including design specifications, mapping documents, and operational procedures.

Required Skills and Experience:

• Minimum of 3 to 5 years of hands-on experience in designing, developing, and implementing ETL solutions using IBM InfoSphere DataStage.
• Strong understanding of ETL concepts, methodologies, and best practices.
• Proficiency in writing complex SQL queries and working with relational databases, preferably Oracle.
• Experience with data modeling concepts (e.g., dimensional modeling, star schema, snowflake schema).
• Familiarity with Linux operating systems and basic Linux commands is a plus.
• Exposure to OBIEE (Oracle Business Intelligence Enterprise Edition) or other business intelligence tools is a plus.
• Excellent written and verbal communication skills, with the ability to effectively communicate technical concepts to both technical and non-technicalaudiences.
• Excellent analytical skills and technical skills, with a strong attention to detail and problem-solving abilities.
• Bachelors degree in Computer Science or equivalent in education and work experience.

Preferred Skills:

• Preferred Certifications
  • IBM Certified Solution Developer - InfoSphere DataStage
• Experience with other ETL tools or data integration technologies.
• Knowledge of scripting languages such as Shell scripting or Python.
• Experience with cloud-based data warehousing solutions (e.g., Google BigQuery, Azure Synapse).
• Familiarity with data quality tools and processes.

Permanent

UPS is committed to providing a workplace free of discrimination, harassment, and retaliation.

Requirements: