Title: Technical Lead-Biz Intelligence
Area(s) of responsibility
Primary Skillset – SQL, Snowflake
- 6+ years of experience in DWH, 2-4 years of experience in implementing DWH on Snowflake
- Very good hands-on experience in writing medium-complex to complex SQLs
- Develop and Debug ETL programs primarily using Matillion Cloud.
- Develop and execute test plans to validate source v/s target data sets.
- Verify data integrity, identify quality issues, and collaborate with development teams to address them.
- Work closely with cross-functional teams, including business intelligence analysts and ETL developers.
- Test the integration of Snowflake with various data sources and third-party tools.
- Design test strategies to validate data extraction, transformation, and loading processes.
- Contribute to continuous improvement in testing and data quality processes.
- Strong understanding of basic Snowflake concepts.
- Experience working in Managed Services environment.
- Data validation & end to end testing of ETL Objects, Source data analysis and data profiling.
- Understand business requirements and convert them into detail technical specifications for Data models and ETL programs.
- Experience in Snowsql, Snow pipe will be added advantage.