Data Warehouse (DW) Developer – Teradata - 3 + years of Exp - Any UST Location

UST; Bengaluru; On-site; INR 800,000 - 1,200,000; Full time

Job summary

A leading company is seeking a Data Warehouse Developer with expertise in Teradata and ETL processes. The ideal candidate will have at least 3 years of experience in SQL and BTEQ scripting, along with proficiency in Teradata utilities. Responsibilities include designing and maintaining ETL jobs, analyzing data issues, and collaborating with cross-functional teams. This full-time position offers opportunities for growth in a dynamic IT environment.

Qualifications

• 3+ years of experience in ETL development with Teradata.
• Strong SQL and BTEQ scripting skills.

Responsibilities

• Design, develop, and maintain ETL jobs using Teradata.
• Write optimized SQL and BTEQ scripts for data operations.
• Collaborate with teams to gather requirements and optimize performance.

Skills

SQL

BTEQ scripting

ETL development

Data transformation

Tools

Teradata

Azure Cloud Data Platforms

Git

Job description

Data Warehouse (DW) Developer – Teradata - 3+ years of Experience - Any UST Location

Get AI-powered advice on this job and access more exclusive features.

Candidates ready to join immediately can share their details via email for quick processing.

Email: [e-mail]

Responsibilities:

1. Design, develop, and maintain ETL jobs using Teradata and related tools.
2. Write optimized and complex SQL and BTEQ scripts for data extraction, transformation, and loading.
3. Utilize Teradata utilities like FastLoad, MultiLoad, TPump, and TPT for bulk data operations.
4. Analyze data issues, perform data quality checks, and optimize performance.
5. Collaborate with business analysts, data architects, and QA teams to gather requirements.
6. Participate in code reviews, unit testing, and documentation of ETL processes.
7. Support existing ETL workflows and troubleshoot production issues.
8. Adhere to project timelines ensuring high-quality deliverables with minimal supervision.

Must-Have Skills:

• At least 3 years of experience in ETL development with Teradata.
• Strong SQL and BTEQ scripting skills.
• Proficiency in Teradata utilities (FastLoad, MultiLoad, TPump, TPT).
• Ability to analyze complex datasets and implement efficient data transformations.
• Experience in query and ETL process performance tuning.

Preferred Skills:

• Familiarity with Azure Cloud Data Platforms (e.g., Azure Data Factory, Azure Synapse).
• Knowledge of data modeling and dimensional modeling.
• Understanding of data governance and security practices.
• Experience with version control systems like Git.

Additional Details:

• Seniority level: Mid-Senior level
• Employment type: Full-time
• Job function: Information Technology
• Industries: IT Services and Consulting