Snowflake Developer

About Us We are a decision science organization assisting clients to leverage their under-utilized data in making complex business decisions successfully. We comprise of Data Enthusiasts (engineers, scientists visualizers), Business Consultants, and Sales Managers with a core focus to address your business growth via data. The most unique aspect of Data would be containing unique problems/opportunities even for organizations in the same sector. Since Marktine’s inception, we have worked with several sectors across Industries. We are still growing and consistently striving to improve to deliver world-class Data Assessment & Management Services. We do not follow a complex process rather strive to make complex data terminologies as simple as possible for our clients. From the team’s perspective, we adhere to complete industry standards following proper work-life balance among employees and provide the knowledge space for improvement. We encourage team building and follow a culture of innovation, transparency, and integrity. We are always open for the right enthusiasts to join our team. Job Description This is a remote position. Responsibilities: Snowflake SQL Writing SQL queries against Snowflake Developing scripts Unix, Python, etc. to do Extract, Load, and Transform data Hands-on experience with Snowflake utilities such as SnowSQL, SnowPipe, Python, Tasks, Streams, Time travel, Optimizer, Metadata Manager, data sharing, and stored procedures. In-depth understanding of Data Warehouse/ODS, ETL concept and modeling structure principles Experience in Data warehousing - OLTP, OLAP, Dimensions, Facts, and Data modeling. Experience gathering and analyzing system requirements Good working knowledge of any ETL tool (Informatics or SSIS) Good to have familiarity with data visualization tools (Tableau/Power BI) Ability to effectively function in a cross-team’s environment Good to have exposure to AWS / Azure Data ecosystem Requirements Skills Required: Well versed in Snowflake architecture concepts - Cloud Services, Virtual Warehouse, Storage etc. Good exposure to performance tuning, cost optimization on snowflake. Exposure to snowflake system hierarchy and schemas/Tables/Views/Stages Good knowledge of data modelling concepts like dimensional modelling and DWH concepts like change data capture (CDC) Must have ETL E2E experience in documentation, development, testing & deployment to Production Ability to provide production support for Data Warehouse issues such data load problems, transformation/translation problems etc. Worked in Offshore / Onsite Engagements and collaborated across time zones