DataStage BOA D&A

Tata Consultancy Services Limited; Hyderabad, Chennai, Bengaluru; On-site; INR 900,000 - 1,500,000; Full time

Job summary

Tata Consultancy Services Limited is seeking a Datastage Developer with 5–7 years of experience to design, develop, and optimize ETL processes. The role requires working across Hyderabad, Chennai, and Bangalore locations and collaborating with data analysts and architects.

Responsibilities include building DataStage jobs, validating data quality, and ensuring efficient migration and integration of data from Oracle, SQL Server, and flat files. Strong UNIX and SQL skills are expected.

Qualifications

• 5–7 years of experience in ETL/DataStage environments.
• Experience in ETL development, testing, and migration using DataStage.
• Strong understanding of data warehousing concepts and Oracle/SQL Server sources.

Responsibilities

• Design, develop, and implement ETL processes using IBM DataStage.
• Collaborate with data analysts and data architects to understand business requirements.
• Optimize and troubleshoot ETL processes for performance and data quality.
• Create and maintain technical documentation for ETL workflows.
• Participate in code reviews and adhere to ETL best practices.

Skills

ETL development

SQL

Data warehousing concepts

UNIX scripting

Jira / agile

Tools

IBM DataStage

Oracle

SQL Server

UNIX

Job description

Role & responsibilities

Years of experience 5 to 7 years

Location Hyderabad, Chennai, Bangalore

TCS is searching for experienced candidates for the position of Datastage Developer.

Preferred candidate profile

• Design, develop, and implement ETL processes using IBM DataStage.
• Experience in ETL Development, Testing, and Migration by using Data Stage also experience in Database & Data Warehousing Concepts.
• Good exposure to different phases of project life cycle with significant contribution in low level design, development, review, testing and implementation of ETL projects.
• Designed parallel jobs using various stages like Copy, Join, Merge, Lookup, Funnel, Filter, Sort, Remove Duplicates, Sequential file, Data set, Lookup file set, Aggregator, Change Capture and Transformer.
• Created jobs in DataStage to import data from heterogeneous data sources like Oracle 9i, Text files and SQL Server.
• Good experience on UNIX and SQL.
• Collaborate with data analysts and data architects to understand business requirements
• Optimize and troubleshoot existing ETL processes for performance improvements
• Ensure data quality and data integrity across multiple sources
• Create and maintain technical documentation for ETL processes
• Involved in designing the mapping with multiple files loading using file repository and good knowledge about data ware housing concepts.
• Participate in code reviews and ensure ETL best practices are followed
• Worked in Agile project and on JIRA to keep track of defect logs and change request.
• Demonstrated aptitude for troubleshooting technical issues
• Understand the varying demands across stakeholders, appreciation of operations support as a critical component of business delivery