IT Analyst Applications
Caterpillar
- Location
- Bangalore, Karnataka
- Work model
- On-Site
- Level
- Mid
- H-1B history
- 106 approvals (FY2023)
- Posted
- 18h ago
Skills
About this role
Career Area: Technology, Digital and Data Job Description: Your Work Shapes the World at Caterpillar Inc. When you join Caterpillar, you're joining a global team who cares not just about the work we do – but also about each other. We are the makers, problem solvers, and future world builders who are creating stronger, more sustainable communities. We don't just talk about progress and innovation here – we make it happen, with our customers, where we work and live. Together, we are building a better world, so we can all enjoy living in it. About Caterpillar Caterpillar Inc. is the world’s leading manufacturer of construction and mining equipment, off-highway diesel and natural gas engines, industrial gas turbines and diesel-electric locomotives. For nearly 100 years, we’ve been helping customers build a better, more sustainable world and are committed to and contributing to a reduced-carbon future. Our innovative products and services, backed by our global dealer network, provide exceptional value that helps customers succeed.
Your Impact
Shapes the World at Caterpillar Inc When you join Caterpillar, you're joining a global team who cares not just about the work we do – but also about each other. We are the makers, problem solvers and future world builders who are creating stronger, more sustainable communities. We don't just talk about progress and innovation here – we make it happen, with our customers, where we work and live. Together, we are building a better world, so we can all enjoy living in it.
Job Summary
We are seeking a skilled IT Analyst Applications to join India CoE-Integration & Engg CAT IT Division Purpose of this role would be Design, operate, automate, and optimize enterprise Snowflake data platform services for India GCC – Enterprise Distributed Database Services. The role focuses on secure, scalable, reliable, and cost-efficient database operations using Snowflake ecosystem capabilities, Python automation, ServiceNow integration, and analytics/visualization solutions. The preference for this role is to be based out of Bangalore – Caterpillar PSN What you will do Implement Snowflake security controls including RBAC, data masking policies, MFA, and secure access frameworks. Build Python-based automation for Snowflake monitoring, operational workflows, alerting, and ServiceNow incident integration. Develop and maintain Snowflake objects including stored procedures, streams, tasks, views, and dynamic tables. Design efficient ingestion and transformation pipelines, including patterns that reduce dependency on traditional ETL. Tune query performance using dynamic tables, query acceleration services, workload balancing, query rewriting, and data model optimization. Implement resilience through Time Travel, Fail-safe, secure data sharing, backup/recovery support, and disaster recovery participation. Create dashboards, utilization analytics, and Streamlit/self-service tools to improve visibility of warehouse performance, query usage, and operational efficiency. Troubleshoot platform incidents, validate database changes, support performance/recovery testing, and drive continuous improvement What you will have Snowflake ecosystem: dynamic tables, streams, tasks, secure data sharing, Time Travel, Fail-safe, scalable warehouse architecture. Performance optimization: query analysis, acceleration techniques, warehouse sizing, storage optimization, high availability, reliability. Data engineering: advanced SQL, procedural programming, stored procedures, views, transformations, ingestion pipelines, Customer 360/data initiatives. Security & governance: RBAC, masking policies, MFA, compliance alignment, access risk identification, stakeholder collaboration. Automation: Python scripting, automated metrics collection, operational utilities, ServiceNow alerting/incident workflows. Monitoring & cost: resource monitors, warehouse utilization thresholds, usage trend analysis, cost control