Sun Technologies - Senior Snowflake Data Engineer - Python/ETL (2-20 yrs)

2:00PM-11:00PM - shift timings(free cab facility-drop)+food

Please Note : WFO-Work From Office ( No hybrid or Work From Home)

Mandatory skills : Snowflake, SQL, ETL, Data Ingestion, Data Modeling, Data Warehouse,Python, Matillion, AWS S3, EC2

Preferred skills : SSIR, SSIS, Informatica, Shell Scripting

Key Responsibilities :

- Data Modeling : Design and implement normalized and denormalized data models in Snowflake based on business and technical requirements.

- Requirement Gathering : Collaborate with Business Analysts/Technical Analysts to understand data needs and ensure proper documentation of requirements.

- Data Mapping : Develop source-to-target mapping documents to facilitate accurate data transformations.

- Data Engineering : Work on data ingestion, transformation, and integration pipelines using SQL and cloud-based tools.

- Performance Optimization : Optimize Snowflake queries, schema designs, and indexing for better performance.

- Collaboration & Documentation : Maintain clear documentation of data models, mappings, and data flow processes.

- Data Governance & Quality : Ensure data accuracy, consistency, and compliance with best practices.

Required Skills & Qualifications :

- 3-20 years of experience in Data Modeling, Data Engineering, or related roles.

- Strong understanding of data modeling concepts (OLTP, OLAP, Star Schema, Snowflake Schema).

- Hands-on experience in Snowflake (schema design, query optimization).

- Ability to create source-to-target mapping documents.

- Experience with SQL-based data transformations and queries.

- Exposure to ETL tools (Matillion is a plus but not mandatory).

- Strong problem-solving and analytical skills.

- Good communication skills to collaborate with cross-functional teams.

Preferred Qualifications :

- Experience working in cloud-based data environments (AWS, Azure, or GCP).

- Hands-on exposure to Matillion or other ETL tools.

- Understanding of data governance and security best practices.

- Familiarity with Agile methodologies.