Responsibilities:
- Provide technical leadership for all aspects of environment management such as database lifecycle management monitoring support disaster recovery compliance and standards.
- Research new Snowflake features tools and technologies with an Enterprise perspective to meet customer needs while maintaining a secure Snowflake environment.
- Research benchmark and suggest improvements to database support processes customer experience (CX) improvements and compliance requirements.
- Provide 3rd and 4th level support for complex issues.
- Participate in and manage Snowflake related projects audits and compliance reviews and testing.
- Develop new and update existing Snowflake technology related documentation as needed.
- Coach and communicate information to Caterpillar s application support teams and peers across the enterprise on Snowflake technology changes new features key projects and customer experience improvements.
- Participate in customer driven and Division/department projects providing Database Management consultancy services.
Required Skillsets:
- Should have 8 years of relevant experience in relevant technologies.
- 4 to 6 years of experience in Snowflake Administration is a MUST.
- Detailed driven Strong analytical with excellent problemsolving skills.
- Strong understanding of data pipeline engineering and ETL / ELT tools is a MUST.
- Strong programming skills and working knowledge of Java script procedural SQL and Python is a MUST.
- Strong skills in database performance and SQL query tuning
- Database design and management experience
- Basic networking experience
- Knowledge of data warehousing principles is a MUST.
- Experience with Data Visualization tools (PowerBI Tableau ThoughtSpot)
- Strong verbal and written communication skills presentation analytical organizational and interpersonal skills.
Top Candidate Will Also Have:
- SnowPro Certification
- AWS and Azure experience
- Experience in implementing machine learning models for data analysis prediction and optimization.
- Familiarity with popular AI framework and libraries.
- Project Management skills.
- IT Service Management (ITSM) process and Root Cause Analysis (RCA)
- Work Timings 1:00PM to 10:00PM IST (Approx.)
ai framework,thoughtspot,powerbi,snowflake administration,tableau,java script,root cause analysis,database performance,machine learning models,javascript,aws,pl/sql,data visualization tools,snowflake,python,azure,procedural sql,it service management,database,etl / elt tools,sql query tuning