Snowflake json query8/12/2023 ![]() ![]() ![]() Not ready to apply? Submit your information to our Talent Network here. Data visualization tools (Power BI, Cognos, Tableau, ThoughtSpot)Ĭaterpillar is an Equal Opportunity Employer (EEO).Fluent speaking and writing in German and English.Superior organizational skills, with a disciplined approach to implementation, support and documentation.Understanding of Change Data Capture (CDC) and data streaming.Experience with replication tools like Qlik Replicate.Experience with programming languages (Python, Java).3- 5+ years of in-depth experience with SQL (SNOWFLAKE, MS SQL, Oracle).Bachelor’s Degree in Computer Science or other related field of study OR any combination of relevant equivalent experience, education and training.The requirements are representative of the knowledge, skill, and/or ability required. To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. ![]() Actively participates in projects that require any kind of analytics.Crafts and executes queries upon request for data.Assists developers with complex query tuning and schema refinement.Improves performance and extends functionality.If you have primarily worked with relational data models in the past, this would be a great new skill to add to your toolkit. Presents and gathers feedback on the finished product This hands-on tutorial will teach you how to load JSON and XML data into Snowflake and query it with ANSI-standard SQL.Maintains and documents all developed technical objects.Manages data flows and movements within the Snowflake environment.Identifies and queries data sources to get required data.Creates and manages Snowflake database objects, including tables, views, tasks, and streams.Designs, creates and deploy data models.Data Engineers will also support, manage, and otherwise trouble-shoot the daily population and performance of the Data Warehouse. The candidate will build database tables, views, and scripts to populate the Caterpillar Medium Speed Engine business Data Warehouse on Snowflake. They typically have knowledge of database technologies, programming, cloud computing, and Big Data tools. They ensure that data is collected, stored and processed in an efficient and scalable manner. This position requires that the candidate understands database technologies, the creation of database objects, programming, cloud computing, Big Data, data replication tools, and management of a modern-day data warehouse.ĭata Engineers are responsible for developing, maintaining and optimizing the data infrastructure and pipelines. ![]() This role will be working with the Caterpillar Medium Speed Engine business, Information Technology, and Database Administration teams to assist in the development of our Enterprise Data Warehouse. Career Area: Information Technology Job Description: ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |