<p><p><b>Shift :</b> 1 PM to 10 PM</p><p><br/></p><p><b>Key Responsibilities :</b><br/><br/></p><p>- Design, develop, and support scalable Snowflake-based data warehouse solutions.<br/><br/></p><p>- Translate high-level design (HLD) and application interface requirements into low-level design (LLD) and technical specifications.<br/><br/></p><p>- Develop, test, and deploy data ingestion pipelines and transformation processes.<br/><br/></p><p>- Analyze application issues and propose effective technical solutions.<br/><br/></p><p>- Provide Tier 2 production support, including participation in on-call rotations.<br/><br/></p><p>- Create and maintain comprehensive documentation for all development and support activities.<br/><br/></p><p>- Collaborate with cross-functional teams including data analysts, architects, and business & Qualifications : </b></p><p><br/></p><p>- Strong SQL skills for complex queries, data analysis, and performance tuning.</p><p><br/></p>- Advanced Unix/Linux Shell Scripting for automation and process control.<br/><br/></p><p>- In-depth knowledge of Snowflake architecture, storage, and optimization techniques.<br/><br/></p><p>- 4+ years of hands-on experience with:<br/><br/></p><p>1.
SnowSQL, COPY command, stored procedures<br/><br/></p><p>2.
Snowpipe, semi-structured data ingestion, and different table types<br/><br/></p><p>3.
Performance tuning in Snowflake environments<br/><br/></p><p>- Experience with file transfer protocols: NDM, SFTP, Data Router, etc.<br/><br/></p><p>- Familiarity with job schedulers like IBM TWS (Tivoli Workload Scheduler)<br/><br/></p><p>- Exposure to Python scripting (Good to have)<br/><br/></p><p>- Experience with AVRO, PARQUET, and other semi-structured file formats (Good to have)<br/><br/></p><p>- Knowledge of ETL tools such as Informatica (Good to have)</p><br/></p> (ref:hirist.tech)