Posted:1 week ago| Platform: Linkedin logo

Apply

Work Mode

On-site

Job Type

Full Time

Job Description

About The Opportunity

An established enterprise data analytics consultancy in the banking and financial services sector, we deliver high volume data warehousing and real time reporting solutions across global markets. Operating large scale Teradata ecosystems, we transform complex transactional data into reliable insights that drive regulatory compliance, risk management and revenue growth.Role & Responsibilities
  • Design, develop and optimize Teradata SQL scripts, BTEQ procedures and macros for batch and near real time workloads.
  • Build robust ETL processes to ingest, cleanse and harmonise multi source data using FastLoad, MultiLoad and Parallel Transporter.
  • Tune queries, indexes and partition strategies to achieve sub second performance on multi trillion row tables.
  • Implement data modelling standards for star, snowflake and FSLDM patterns ensuring data quality, lineage and governance.
  • Collaborate with business analysts to translate regulatory and analytics requirements into scalable data solutions.
  • Provide production support, root cause analysis and capacity planning for the onsite Teradata platform.

Skills & Qualifications

Must Have

  • 5 plus years dedicated Teradata development in large enterprise environments.
  • Expertise in Teradata utilities such as FastLoad, MultiLoad, TPT and BTEQ.
  • Advanced SQL, join optimisation and statistics collection techniques.
  • Hands on experience with Unix shell scripting and scheduling tools like Control M.
  • Solid understanding of data warehousing concepts, dimensional modelling and ETL best practices.

Preferred

  • Exposure to Hadoop, Spark or cloud data platforms.
  • Knowledge of performance monitoring tools Viewpoint and PMON.
  • Experience working in BFSI regulatory reporting projects.
Benefits & Culture Highlights
  • Onsite role with direct ownership of tier one data platforms used by global stakeholders.
  • Continuous learning budget covering Teradata certifications and cloud upskilling.
  • Collaborative delivery culture that values engineering excellence, knowledge sharing and work life balance.
Work Location: India, onsite at client premises. Only candidates with valid work authorization and immediate availability will be considered.
Skills: teradata,stored procedures,hadoop,fastload,data warehousing,multiload,dimensional modelling,sql,etl best practices,unix shell scripting,control m,cloud data platforms,bteq,etl,performance monitoring tools,data modeling,spark,parallel transporter

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now

RecommendedJobs for You

Mumbai, Maharashtra, India

Hyderabad, Chennai, Bengaluru

Chennai, Bengaluru, Mumbai (All Areas)