Data Engineer – MS SQL & Snowflake

TekFriday Processing Solutions Pvt Ltd; Hyderabad; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

TekFriday Processing Solutions Pvt Ltd is seeking a highly detail-oriented Data Engineer to support large-scale data transformation, reconciliation, validation, and pipeline operations in a fast-paced FinTech environment. The role focuses on developing and optimizing SQL-based data processes, transforming and validating financial datasets, and maintaining data integrity across systems.

You will work on end-to-end ETL/ELT workflows and data quality initiatives, ensuring scalable, reliable data

Qualifications

• Experience handling complex datasets and writing advanced SQL queries.
• Strong experience with MS SQL Server and Snowflake architectures.

Responsibilities

• Develop, optimize, and maintain MS SQL and Snowflake queries for data extraction, transformation, reconciliation and validation.
• Build and support ETL/ELT workflows for large-scale financial and operational datasets.
• Perform data cleansing, standardization, transformation, and aggregation across multiple sources.
• Design and maintain data processing pipelines to support reporting and operations.
• Troubleshoot data discrepancies, transformation failures, and performance bottlenecks.

Skills

MS SQL

Snowflake

SQL Proficiency

ETL/ELT

Data transformation

Data validation

Data reconciliation

Troubleshooting

Performance tuning

Tools

MS SQL Server

Snowflake

SSMS

Job description

We are looking for a highly detail-oriented Data Engineer with strong expertise in MS SQL and Snowflake to support large-scale data transformation, reconciliation, validation, and data pipeline operations within a fast-paced FinTech/Lending environment.

This role will primarily focus on developing and optimizing SQL-based data processes, transforming and validating financial datasets, maintaining data integrity across systems, and supporting operational reporting requirements.

The ideal candidate should possess strong experience handling complex datasets, writing advanced SQL queries, troubleshooting data inconsistencies, and supporting end-to-end ETL/ELT workflows.

This is a hands-on engineering role with strong emphasis on data processing, operational efficiency, and data quality rather than Data Science, Machine Learning, or advanced Analytics.

Key Responsibilities

Data Engineering & Transformation

• Develop, optimize, and maintain complex MS SQL and Snowflake queries for data extraction, transformation, reconciliation, and validation processes.
• Build and support ETL/ELT workflows for ingesting and transforming large-scale financial and operational datasets.
• Perform data cleansing, standardization, transformation, and aggregation activities across multiple data sources.
• Design and maintain efficient data processing pipelines to support business operations and reporting requirements.
• Troubleshoot and resolve data discrepancies, transformation failures, and performance bottlenecks.

Snowflake & Database Operations

• Work extensively with Snowflake for data transformation, staging, data loading, and query optimization activities.
• Develop and optimize stored procedures, views, CTEs, temporary tables, and complex joins in MS SQL Server and Snowflake.
• Support data migration and synchronization processes between multiple systems and databases.
• Monitor query performance and recommend improvements for efficient data processing and storage optimization.

Data Validation & Reconciliation

• Validate transformed datasets against source systems and business reports to ensure data accuracy and completeness.
• Perform reconciliation activities on loan-level, transactional, operational, and financial datasets.
• Investigate data mismatches, inconsistencies, and anomalies and coordinate resolution with internal teams.
• Ensure adherence to internal data quality standards and governance processes.

Process Improvement & Automation

• Identify opportunities to automate repetitive manual data processes and improve operational efficiency.
• Collaborate with Engineering, Operations, Credit, Finance, and Product teams to streamline data workflows.
• Support continuous improvement initiatives related to data architecture, query performance, and transformation logic.

Documentation & Collaboration

• Maintain documentation for data flows, transformation logic, reconciliation procedures, and database objects.
• Communicate technical issues, dependencies, and resolutions effectively to both technical and non-technical stakeholders.
• Work closely with cross-functional teams to understand operational data requirements and implement scalable solutions.