DataStage Developer

Tata Consultancy Services; Chennai District, Bengaluru; On-site; INR 1,500,000 - 2,100,000; Full time

Job summary

Tata Consultancy Services in India is seeking an ETL Developer with 5–10 years of hands-on experience in designing, developing, and implementing ETL solutions using IBM DataStage across Bengaluru, Chennai, and Hyderabad.

You will collaborate with data analysts and architects, optimize ETL performance, maintain data quality, and produce technical documentation while applying agile practices and Jira for tracking.

Qualifications

• 5–10 years of ETL experience with DataStage design and implementation.
• Strong SQL and UNIX scripting skills with data warehousing knowledge.
• Hands-on experience in ETL testing, migration and performance tuning.
• Experience collaborating with analysts and data architects on business requirements.
• Familiarity with Agile processes and Jira for defect tracking and change requests.

Responsibilities

• Design, develop, and implement ETL processes using IBM DataStage.
• Optimize and troubleshoot ETL workflows for performance improvements.
• Ensure data quality and data integrity across multiple sources.
• Collaborate with data analysts and data architects on requirements.
• Create and maintain technical documentation for ETL processes.
• Work in Agile environments and participate in code reviews.

Skills

ETL Development

IBM DataStage

UNIX

SQL

Data Warehousing

Agile

JIRA

Troubleshooting

Data Quality

Mapping Design

Tools

DataStage

Job description

Experience - 5 -10 YearsLocation - Bengaluru , Chennai and Hyderabad

• 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.