Trinus Corporation
Snowflake Developer
Trinus Corporation, San Diego, California, United States, 92189
DeliverablesNew SnapLogic pipeline and Snowflake views for:
External Data InsightsSnapLogic ETL processes for all Finance dimensions and factsFinance Data Warehouse in SnowflakeDimensions and Fact views in SnowflakePerformance enhancements and tuning on the SnapLogic ETL processesResponsibilities
Understand the client’s current HANA ETL processes defined by the client’s Finance Performance Management team.Develop and architect new SnapLogic pipelines in SnapLogic Web IDE to perform ETL from HANA to Snowflake database.Build data warehouse in Snowflake with dimensions, fact, and underlying calculation views and ensure standards and best practices are used.Perform internal Quality Assurance and testing and document the technical details of the model and knowledge transfer to the client.Deliver the SnapLogic pipeline and Snowflake views to the client team in a Non-Prod environment for review and approval.Document the technical details of the new SnapLogic pipeline and Snowflake views.Work in San Diego, CA hours.Provide weekly status reports and hours consumed.Use own laptop and connect to the client via Amazon Workspaces.Skills
Extensive Snowflake development skillsetStrong analytical knowledgeTeam playerProficiency in the English language for both written and verbal communication
#J-18808-Ljbffr
External Data InsightsSnapLogic ETL processes for all Finance dimensions and factsFinance Data Warehouse in SnowflakeDimensions and Fact views in SnowflakePerformance enhancements and tuning on the SnapLogic ETL processesResponsibilities
Understand the client’s current HANA ETL processes defined by the client’s Finance Performance Management team.Develop and architect new SnapLogic pipelines in SnapLogic Web IDE to perform ETL from HANA to Snowflake database.Build data warehouse in Snowflake with dimensions, fact, and underlying calculation views and ensure standards and best practices are used.Perform internal Quality Assurance and testing and document the technical details of the model and knowledge transfer to the client.Deliver the SnapLogic pipeline and Snowflake views to the client team in a Non-Prod environment for review and approval.Document the technical details of the new SnapLogic pipeline and Snowflake views.Work in San Diego, CA hours.Provide weekly status reports and hours consumed.Use own laptop and connect to the client via Amazon Workspaces.Skills
Extensive Snowflake development skillsetStrong analytical knowledgeTeam playerProficiency in the English language for both written and verbal communication
#J-18808-Ljbffr