Duration : 3 months (Can be extended)
Availability : Immediate Only
Location: Remote (Offshore only)
Employment Type: Full-time / Contract (T&M Model Experience Preferred)
Experience: Minimum 6+ Years
Key Responsibilities:
1. Design, develop, and maintain scalable data pipelines and solutions using Snowflake Cloud Data Warehouse.
2. Implement ETL/ELT processes for ingestion, transformation, and loading of data from various sources into Snowflake.
3. Work on performance tuning, query optimization, and warehouse management in Snowflake.
4. Manage role-based security, user access, and governance within the Snowflake environment.
5. Collaborate with business stakeholders to gather requirements and deliver data solutions under the T&M model.
6. Ensure delivery within budgeted time and material constraints by proactively monitoring effort utilization.
7. Integrate Snowflake with external tools (ETL, BI, APIs) such as Informatica, Talend, DBT, Tableau, or Power BI.
8. Maintain best practices for data quality, scalability, and cost optimization in Snowflake.
Mandatory Skills:
1. Strong hands-on experience with Snowflake (SQL, SnowSQL, Snowpipe, Streams, Tasks, Stages, and Time Travel).
2. Proficiency in SQL, stored procedures, and query optimization.
3. Solid understanding of cloud ecosystems (AWS/Azure/GCP) integrated with Snowflake.
4. Expertise in ETL tools and data pipelines (Informatica, Talend, DBT, or similar).
5. Proven experience working in T&M projects (effort tracking, reporting, and client coordination).
6. Strong communication and stakeholder management skills.