ETL QA

Tekskills Inc.; Hyderabad; Hybrid; INR 900,000 - 1,500,000; Full time

Job summary

Tekskills Inc. is seeking a data engineering specialist to strengthen data warehousing and ETL foundations. You will work on data extraction, transformation, loading, and data quality checks within batch and real-time data integration contexts.

The role emphasizes advanced SQL, Python scripting for data manipulation, and familiarity with cloud ETL tools and big data ecosystems.

Qualifications

• Strong understanding of data warehousing.
• Expertise in ETL/ELT processes, including data extraction, transformation, loading, and data quality checks.
• Familiarity with data integration methodologies (batch processing, real-time processing, data streaming).
• Proficiency in SQL (including advanced SQL, window functions, subqueries).
• Expertise in Python for data manipulation and automation.

Skills

Data warehousing fundamentals

ETL/ELT processes

Data integration methodologies

SQL

Python

Other languages (Scala/Java)

Tools

Informatica PowerCenter

Talend

Apache NiFi

AWS Glue

Azure Data Factory

Google Cloud Dataflow

Job description

Data Warehousing & ETL Fundamentals:

• Strong understanding of data warehousing
• Expertise in ETL/ELT processes, including data extraction, transformation, loading, and data quality checks
• Familiarity with data integration methodologies (batch processing, real-time processing, data streaming)
• Programming & Scripting:
• Proficiency in SQL (including advanced SQL, window functions, subqueries)
• Expertise in at least one scripting language (Python - Preferred) for data manipulation and automation
• Knowledge of other relevant languages (Scala, Java) is a plus
• Data Modelling & Design:
• Ability to analyse business requirements and translate them into effective data models
• Experience with data modelling tools is a plus
• Data Integration Tools:
• Proficiency in at least one ETL/ELT tool (e.g., Informatica PowerCenter, Talend, Apache NiFi, AWS Glue, Azure Data Factory)
• Experience with cloud-based data integration services (AWS Glue, Azure Data Factory, Google Cloud Dataflow) is a plus
• Cloud Technologies:
• Familiarity with cloud platforms (AWS/Azure) and their data services (e.g., cloud storage, data lakes, data warehouses)
• Big Data Technologies:
• Experience with big data technologies (Hadoop, Spark, Hive, HDFS) is a plus
• Familiarity with NoSQL databases (e.g., MongoDB, Cassandra) is a plus