IT Analyst Applications (Matillion ETL/ELT Developer – Snowflake Data Engineering)

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. Your Work Shapes the World at Caterpillar Inc Whether it be groundbreaking products, best in class solutions or creating a lifelong career, you can do the work that matters at Caterpillar. With a 95-year legacy of quality and innovation and 150 locations in countries around the world, your impact spans the globe. When you join Caterpillar, you are joining a team of makers, innovators, and doers. We are the people who roll up our sleeves and do the work to build a better world. We don’t just talk about progress and innovation. We make it happen. And we are proud of that because it helps our customers build and power the world we live in – the roads, hospitals, homes and infrastructure. Without a dedicated workforce Caterpillar could not effectively meet our customer’s needs. Join us.

We are seeking a skilled IT Analyst Applications (Matillion ETL/ELT Developer – Snowflake Data Engineering) To join Applications Development & Intelligence Automation -CAT IT Division We are seeking a Matillion ETL/ELT Developer to build, optimize, and support scalable data pipelines in Snowflake, enabling reliable and performant data delivery for analytics, AI experiences, and downstream business consumption. This role sits within the Cat Financial Insurance Services (CFIS) BI, Data, and AI team and plays a critical part in both maintaining our day-to-day data warehouse operations and advancing our strategic vision for governed self-service analytics. The preference for this role is to be based out of Whitefield PSN Office, Bangalore, India What you will do ETL/ELT Pipeline Development : Design, develop, and maintain Matillion orchestration and transformation jobs to ingest, cleanse, and deliver data from diverse source systems (e.g., insurance policy administration, claims, Salesforce, warranty/quality feeds) into Snowflake. Implement incremental and full-load patterns appropriate to each data domain. Snowflake Best Practices : Leverage strong SQL and Snowflake engineering practices including warehouse sizing and auto-suspend configuration, clustering and partitioning strategies where applicable, query performance tuning, and cost-aware execution to ensure pipelines are efficient, scalable, and financially responsible. Business-Friendly Semantic Views & Certified Data Sources : Collaborate with data modelers and architects to build and maintain governed, business-friendly semantic layers on top of the Snowflake data warehouse. These certified data sources serve as the single source of truth for downstream consumption — including Power BI dashboards, Snowflake Semantic Views, Polaris AI (Snowflake Intelligence), and Streamlit applications. The role requires understanding how curated, well-defined data models enable natural language querying, AI agent consumption, and self-service analytics at scale. Data Quality & Governance : Implement robust data validation checks, error handling, and logging within ETL workflows to ensure data accuracy, completeness, and traceability. Support data governance standards including consistent naming conventions, field-level definitions, and alignment with enterprise compliance requirements.  Deployment & Operations : Promote repeatable, reliable deployment practices including version control (Git), environment management (dev/test/prod), job scheduling (ActiveBatch), and on-call support as needed. Troubleshoot pipeline failures, rerun/restart