Data Engineer – MS SQL & Snowflake

TekFriday Processing Solutions; Hyderabad; On-site; INR 900,000 - 1,200,000; Full time

Job summary

TekFriday Processing Solutions is seeking a detail-oriented Data Engineer in Hyderabad, India. The role focuses on developing and optimizing SQL-based data processes, managing complex datasets, and ensuring data integrity in a fast-paced FinTech environment.

Ideal candidates should possess strong experience in MS SQL Server and Snowflake, along with excellent problem-solving skills. Responsibilities include building ETL/ELT workflows, validating datasets, and troubleshooting data issues. A Bachelor's degree and 3–6 years of relevant experience are required.

Qualifications

• 3–6 years of experience in Data Engineering or related roles.
• Strong hands-on expertise in writing advanced queries.
• Experience working with large-scale structured datasets.

Responsibilities

• Develop and optimize MS SQL and Snowflake queries.
• Build and support ETL/ELT workflows for financial datasets.
• Troubleshoot and resolve data discrepancies and performance bottlenecks.

Skills

Advanced SQL queries

Snowflake

ETL/ELT processes

Data validation

Data quality checks

Education

Bachelor’s degree in Computer Science or related field

Tools

MS SQL Server

Snowflake

Airflow or Dagster

Job description

TekFriday Processing Solutions | Full time

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

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.

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.

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.

Requirements

Required Experience & Skills

Bachelor’s degree in Computer Science, Information Systems, or related technical discipline.

3–6 years of experience in Data Engineering, Database Development, ETL Development, or Data Operations roles.

Strong hands‑on expertise in writing advanced queries in MS SQL Server and Snowflake.

Extensive experience working with complex joins, stored procedures, functions, indexing, query optimization, CTEs, temporary tables, and performance tuning.

Strong experience in ETL/ELT processes, data transformation, and reconciliation workflows.

Experience working with large-scale structured financial or operational datasets.

Strong understanding of relational database concepts and data warehousing principles.

Experience handling data validation, data quality checks, and reconciliation processes.

Hands‑on experience with Snowflake data loading, transformations, and performance optimization.

Exposure to orchestration or workflow tools such as Airflow or Dagster is an advantage.

Experience integrating and processing API-based datasets is preferred.

Prior experience working in FinTech, Lending, Financial Services, or similar domains is highly preferred.

Strong analytical thinking and problem-solving capabilities.

Excellent communication and stakeholder management skills.

Ability to work in a fast‑paced, high‑performance environment with strong attention to detail.

Good to Have

Exposure to dbt-based transformation workflows

Understanding of AWS-based data environments

Experience with data reconciliation and operational reporting

Familiarity with financial, lending, or transactional datasets

Knowledge of production support and incident troubleshooting processes