Job Summary

Position: Data Engineer (Snowflake, Python AWS) - Mandatory.

Experience: 6-9 Years.

No of roles: 5.

Location: Hyderabad.

Employment Type: Full-time.

Interview Mode: Face-to-Face in Hyderabad.

Key Skills Required

- Snowflake (Data warehouse implementation, Fact/Dimension modelling)

- Python (automation, transformations)

- AWS cloud services

- Data Modeling (Star/Snowflake schemas, SCD 1/2, CDC)

- SQL (window functions, CTEs, optimization)

- Performance tuning across ETL pipelines and data warehouse

Request you to share suitable and available profiles at the earliest so we can schedule them for the drive.

Key Responsibilities

1.

Data Warehouse

Implementation

- Develop and maintain Star/Snowflake schema data models.

- Build and optimize Fact Dimension tables on Snowflake.

2. Data Modeling

- Solid understanding of Kimball/Inmon methodologies.

- Implement SCD Types 1 2, and CDC (Change Data Capture) frameworks.

- Design schemas that support enterprise-level reporting and BI.

3.





Data Quality

Mapping

- Create detailed Source-to-Target Mapping (STTM) documentation.

- Build automated validation frameworks to maintain a single source of truth.

4. Advanced SQL Development

- Write efficient SQL with complex joins, window functions, and CTEs.

- Perform SQL performance tuning for large datasets.

5.

Performance Tuning

Optimization

- Analyze and troubleshoot performance bottlenecks in pipelines and Snowflake.

- Optimize ETL/ELT jobs to reduce latency and Snowflake credit usage.

- Ensure all data pipelines meet strict performance SLAs.

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.

📌 Data Engineer (Snowflake, Python & AWS) (Hyderabad)
🏢 PSRTEK
📍 Hyderabad