Design, develop, and maintain ETL solutions using IBM DataStage.
Develop and optimize Teradata SQL, BTEQ scripts, stored procedures, and utilities.
Build and maintain Unix Shell scripts for ETL orchestration, automation, and scheduling.
Analyze source systems and business requirements to design scalable data integration solutions.
Perform performance tuning and optimization of DataStage jobs and Teradata queries.
Support data warehouse development, enhancements, and production issue resolution.
Develop reusable ETL frameworks, error handling, and monitoring mechanisms.
Conduct unit testing, integration testing, and data validation activities.
Collaborate with business analysts, architects, and cross-functional teams to deliver solutions.
Participate in code reviews and ensure adherence to development standards and best practices.
Hands-on experience in DataStage connectivity migration, cloud data integration, Azure SQL/Synapse, ADLS, Azure Data Factory (ADF), and cloud modernization initiatives is highly preferred.
Nice to Have
Migration expertise from RDBMS (Teradata, DB2, Oracle) to Cloud Technologies (Databricks, Snowflake) using IBM DataStage
Exposure to cloud-based ETL modernization, data lake architectures, and hybrid data integration solution
