Teradata Developer

Greetings,We have immediate opportunity for Teradata Developer– 5 to 7 years Synechron– Mumbai, GoregaonJob Role:Teradata Developer Job Location:Mumbai, GoregaonAbout Company: At Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver industry-leading digital solutions. Synechron’s progressive technologies and optimization strategies span end-to-end Artificial Intelligence, Consulting, Digital, Cloud & DevOps, Data, and Software Engineering, servicing an array of noteworthy financial services and technology firms. Through research and development initiatives in our FinLabs we develop solutions for modernization, from Artificial Intelligence and Blockchain to Data Science models, Digital Underwriting, mobile-first applications and more. Over the last 20+ years, our company has been honoured with multiple employer awards, recognizing our commitment to our talented teams. With top clients to boast about, Synechron has a global workforce of 14,700+, and has 48 offices in 19 countries within key global markets. For more information on the company, please visit our website or LinkedIn community.Diversity, Equity, and Inclusion Diversity & Inclusion are fundamental to our culture, and Synechron is proud to be an equal opportunity workplace and an affirmative-action employer. Our Diversity, Equity, and Inclusion (DEI) initiative‘Same Difference’is committed to fostering an inclusive culture – promoting equality, diversity and an environment that is respectful to all. We strongly believe that a diverse workforce helps build stronger, successful businesses as a global company. We encourage applicants from across diverse backgrounds, race, ethnicities, religion, age, marital status, gender, sexual orientations, or disabilities to apply. We empower our global workforce by offering flexible workplace arrangements, mentoring, internal mobility, learning and development programs, and more. All employment decisions at Synechron are based on business needs, job requirements and individual qualifications, without regard to the applicant’s gender, gender identity, sexual orientation, race, ethnicity, disabled or veteran status, or any other characteristic protected by law.Job Description: Software Requirements Proven expertise in Teradata database systems, including installation, configuration, and optimization. Strong understanding of Teradata utilities, tools, and utilities such as BTEQ, FAST Load, MultiLoad, TPump, and Parallel Transport. Knowledge of SQL query tuning, indexing, and database performance optimization. Familiarity with data warehousing concepts and ETL processes. Experience with scripting languages (e.g., Python, Shell scripting) for automation tasks. Basic knowledge of other database systems like Oracle, SQL Server is a plus. Overall Responsibilities Develop, design, and optimize SQL scripts and queries for data extraction, transformation, and loading (ETL). Collaborate with business analysts and data engineers to understand data requirements and translate them into technical solutions. Monitor and troubleshoot database performance issues, ensuring high availability and efficiency. Implement best practices for data security, integrity, and compliance. Maintain detailed documentation of all technical developments and configurations. Participate in code reviews, team meetings, and project planning activities. Category-wise Technical Skills Database & SQL Skills: Extensive experience in Teradata SQL and query optimization. Proficient in stored procedures, macros, user-defined functions, and triggers. Knowledge of collect statistics, explain plan, and partitioning strategies. ETL & Data Integration: Hands-on experience with ETL tools like Informatica, Talend, or DataStage integrated with Teradata. Ability to design and implement efficient data pipelines and transformations. Scripting & Automation: Shell scripting, Python, or other scripting tools for automating repetitive tasks. Tools & Utilities: Teradata Utilities (FastLoad, MultiLoad, TPT, BTEQ). Database backup and recovery procedures. Version control tools like Git. Additional Technologies (Optional): Hadoop, Spark, or cloud data platforms like AWS/Azure (if applicable). Experience 5 to 7 years of hands-on experience as a Teradata Developer. Proven track record of working on large-scale data warehousing projects. Experience with both on-premise and cloud environments is a plus. Day-to-Day Activities Write and optimize SQL queries and stored procedures. Collaborate with cross-functional teams for data modeling and analysis. Monitor database health and performance metrics. Troubleshoot and resolve database-related issues. Automate routine tasks and reports. Participate in design discussions and provide technical guidance. Maintain documentation and best practices. Qualification Bachelor’s degree in Computer Science, Information Technology, or related fields. Certifications in Teradata or related data management technologies are a plus. Soft Skills Strong analytical and problem-solving skills. Excellent communication and interpersonal skills. Ability to work independently and as part of a team. Proactive attitude and willingness to learn new technologies. Attention to detail and commitment to quality deliverables.If you find this this opportunity interesting kindly share your updated profile on bansi.hindocha@synechron.comWith below details (Mandatory) Total Experience Experience in Teradata- Experience in SQL- Current CTC- Expected CTC- Notice period- Current Location- Ready to relocate to Mumbai-If you had gone through any interviews in Synechron before? If Yes whenRegards, Bansi Hindocha bansi.hindocha@synechron.com