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