
Teradata with DataStage Developer
3 weeks ago
Tiruppur, Tamil Nadu, India
Prophecy Technologies
Full time
Job Description:
We are looking for a skilled Teradata with DataStage Developer with expertise in ETL development and data warehousing concepts. The ideal candidate will have hands-on experience in designing, building, and optimizing data pipelines using IBM DataStage, along with strong SQL skills (Teradata). Exposure to cloud platforms and orchestration tools like Apache Airflow is a plus.
Key Responsibilities:
- Design, develop, and maintain ETL jobs using IBM DataStage.
- Write optimized SQL queries ( Teradata) for data extraction, transformation, and validation.
- Collaborate with data analysts and business users to implement integration solutions.
- Perform manual and automated data validation and reconciliation.
- Conduct root cause analysis for data discrepancies and ETL failures.
- Develop reusable DataStage job components and follow data modeling best practices.
- Monitor ETL jobs and manage dependencies via Job Sequencers or Airflow.
- Document workflows, mappings, and data dictionaries.
- Support cloud migration and integration initiatives.
Must Have:
IBM DataStage, Teradata, SQL, Oracle
Nice to Have:
Python, Shell Scripting, Unix/Linux, Apache Airflow, Cloud Platforms, Agile, CI/CD