Role Overview:This role focuses on designing, developing, and maintaining robust ETL solutions primarily using IBM DataStage. The successful candidate will also be responsible for optimizing Teradata SQL, building Unix Shell scripts for automation, and supporting data warehouse development and modernization initiatives.
Key Responsibilities:- 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.
Required Skills:- Hands-on experience in IBM DataStage.
- Proficiency in Teradata SQL, BTEQ scripts, stored procedures, and utilities.
- Experience with Unix Shell scripting.
- Experience in DataStage connectivity migration.
- Knowledge of cloud data integration, Azure SQL/Synapse, ADLS, Azure Data Factory (ADF), and cloud modernization initiatives.
Qualifications:Preferred Skills:- 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 solutions.
