Associate III - Data Engineering

UST

Bengaluru

On-site

INR 1,400,000 - 2,000,000

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Job summary

UST is seeking an experienced SQL ETL Developer to design, develop, and optimize enterprise data pipelines using Microsoft SQL Server. You will handle ETL/ELT processes, data migration, and data validation to support BI and analytics initiatives.

The role emphasizes performance tuning, data modeling, and secure file transfers (FTP/SFTP), in a fast-paced Agile environment. Collaboration with analysts, architects, and QA teams is essential.

Qualifications

Experience with Microsoft SQL Server and deep T-SQL knowledge (procedures, functions, triggers, views).
Proven ability to design and develop ETL/ELT solutions and handle data migration/integration.
Strong data modeling, warehousing concepts, and data quality checks.

Responsibilities

Design and develop data integration solutions and enterprise data pipelines.
Migrate and integrate data from legacy systems to modern platforms.
Optimize ETL workflows and SQL performance for large data volumes.

Skills

Microsoft SQL Server

T-SQL

ETL/ELT design

Data migration

Data integration

Data modeling

SQL performance tuning

FTP/SFTP

Agile

Documentation

Education

Bachelor's or Master's in CS/IT/Engineering/Data Engineering

Tools

SSIS

Azure Data Factory

Informatica

Talend

Power BI

Job description

Who we are

At UST, we help the world's best organizations grow and succeed through transformation. Bringing together the right talent, tools, and ideas, we work with our clients to co-create lasting change. Together, with over 30,000 employees in 30+ countries, we build for boundless impact—touching billions of lives in the process. Visit us at UST.com.

Role Description

Summary

UST is looking for an experienced SQL ETL Developer with strong expertise in Microsoft SQL Server, ETL/ELT development, T-SQL, and data integration. The ideal candidate will be responsible for designing, developing, and optimizing enterprise data pipelines, data migration solutions, and ETL processes to support business intelligence and analytics initiatives. This role requires hands‑on experience in SQL performance tuning, data modeling, file transfer automation, and modern data engineering best practices.

The Opportunity

Design and develop general and detailed technical design specifications for moderate to complex data integration solutions.
Assist in migrating and integrating data and business processes from legacy systems to modern applications and platforms.
Develop, maintain, and optimize Microsoft SQL Server objects, including:
- SQL Scripts
- Stored Procedures
- Functions
- Triggers
- Views
Build scalable ETL/ELT solutions for data ingestion, transformation, cleansing, validation, and distribution.
Design and implement enterprise data pipelines following data engineering and analytics best practices.
Develop data models and support near real-time data processing solutions.
Perform data validation, reconciliation, exception handling, and quality checks during data load processes.
Optimize ETL package execution and SQL query performance for large-scale data processing.
Design ETL workflows involving:
- File Transfers
- FTP/SFTP Integration
- Secure Data Exchange
Import and export files using FTP and SFTP protocols.
Debug, troubleshoot, and tune ETL processes to ensure efficient, reliable, and accurate data movement.
Collaborate with Business Analysts, Data Architects, Developers, and QA teams to deliver high-quality data solutions.
Prepare technical documentation, deployment guides, and support documents for ETL processes.
Participate in Agile ceremonies, code reviews, and continuous improvement initiatives.

What You Need

Required Skills

Strong hands‑on experience with Microsoft SQL Server.
Advanced knowledge of T‑SQL, including:
- Stored Procedures
- Triggers
- Views
- Functions
- Complex SQL Queries
Strong experience in designing and developing ETL/ELT solutions.
Experience with data migration, data integration, and legacy system modernization.
Strong understanding of data modeling, data warehousing, and ETL best practices.
Experience implementing data validation, reconciliation, and error‑handling processes.
Strong SQL performance tuning and query optimization skills.
Experience working with FTP and SFTP for secure file transfers.
Experience designing automated data exchange workflows.
Strong analytical, debugging, and troubleshooting skills.
Experience working in Agile software development environments.
Excellent communication and documentation skills.

Desired Skills

Experience with SSIS, Azure Data Factory, Informatica, Talend, or other ETL tools.
Knowledge of cloud‑based data platforms such as Azure, AWS, or Google Cloud Platform (GCP).
Experience with data warehousing concepts and dimensional modeling.
Familiarity with CI/CD pipelines and DevOps practices.
Experience with Power BI, Tableau, or other Business Intelligence tools.
Exposure to real‑time or streaming data technologies.
Knowledge of version control tools such as Git.

Qualification

Bachelor's or Master's degree in Computer Science, Information Technology, Engineering, Data Engineering, or a related technical discipline.
Experience in enterprise data integration and SQL development projects is preferred.

Experience

5+ years of experience in SQL Development, ETL/ELT, and enterprise data integration.
Proven experience developing scalable data pipelines and optimizing SQL Server‑based applications.
Experience supporting enterprise reporting, analytics, and data migration initiatives.

What We Believe

We're proud to embrace the same values that have shaped UST since the beginning. Since day one, we've been building enduring relationships and a culture of integrity. Today, those same values inspire us to encourage innovation, champion diversity and inclusion, and place people at the center of everything we do.

Humility

We will listen, learn, be empathetic, and help selflessly in our interactions with everyone.

Humanity

Through business, we will better the lives of those less fortunate than ourselves.

Integrity

We honor our commitments and act with responsibility in all our relationships.

Equal Employment Opportunity Statement

UST is an Equal Opportunity Employer. We believe that no one should be discriminated against because of their differences, such as age, disability, ethnicity, gender, gender identity and expression, religion, or sexual orientation.

All employment decisions shall be made without regard to age, race, creed, color, religion, sex, national origin, ancestry, disability status, veteran status, citizenship status, or any other basis protected by applicable federal, state, or local law.

UST reserves the right to periodically redefine your roles and responsibilities based on the requirements of the organization and/or your performance.