Teradata Developer.
This mandate is run by SYMPHONI HR, a Mumbai-based executive search firm, est. 2003. Applications are email-verified and reach the search team running the role — confidentially, always.
About the organisation.
A leading global technology and analytics services provider serving enterprises across multiple industries. The organization is known for its data-driven, fast-growing software and services culture, with a strong focus on innovation, modernization and delivering scalable enterprise data solutions.
About the role.
We are looking for an experienced Teradata Developer to design, develop and optimize enterprise-scale data warehouse solutions. You will work closely with business and technical stakeholders in Agile teams to build reliable data pipelines, tune database performance and support modernization initiatives. This is a Pan India, hybrid role.
What you will do.
- Design, develop and maintain enterprise data warehouse solutions using Teradata.
- Develop complex SQL queries, BTEQ scripts, stored procedures, macros and views to meet business requirements.
- Perform physical and logical data modelling and database design.
- Build and optimize ETL/ELT processes for data extraction, transformation and loading.
- Analyse source systems and perform data mapping, profiling and validation.
- Monitor and tune query performance, workload management and database utilization.
- Support database upgrades, migrations and modernization initiatives.
- Troubleshoot production issues, participate in code reviews and maintain technical and data lineage documentation.
What you bring.
- 6+ years of hands-on Teradata development experience with strong BTEQ scripting and complex joins.
- Working knowledge of Teradata utilities: MLoad, FastLoad, TPump, FastExport, BTEQ and TPT.
- In-depth understanding of Teradata architecture, including PE, BYNET, AMPs and VProcs.
- Ability to select appropriate indexes (UPI, NUPI, USI, NUSI) for optimal load and extract performance.
- Experience with performance tuning: Collect Statistics, PPI, join indexes and avoiding full table scans.
- Knowledge of spool space management, AMP skew and hot-AMP resolution.
- Bachelor's degree in a relevant discipline with 7 to 12 years of overall IT experience.
- Strong database concepts, analytical ability and problem-solving skills.
Other open roles.
MPM Associate — Mumbai · Hybrid
AWS Cloud Operations Engineer — Hyderabad · On-site
Site Reliability Engineer — Bengaluru · Hybrid