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

Opis

Career Area:

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.

Job Summary

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 job schedules, and manage support tickets in a timely manner.
• Self-Service Analytics Enablement: Support the team's strategic shift toward publishing certified, governed data products that business users, analytics platforms, and AI experiences can consume directly — reducing IT bottlenecks and accelerating time-to-insight. This includes preparing data layers that feed Snowflake Semantic Views, ensuring the data is curated, well-documented, and optimized for natural language interaction.
• Collaboration & Knowledge Sharing: Work closely with onshore team leads, data modelers, BI developers, business analysts, and project managers to align transformations with governed business definitions and deliver trusted datasets on time. Participate in knowledge-sharing sessions, maintain technical documentation, and support onboarding of new team members.

What you will have

• 5+ years of experience in data engineering, ETL/ELT development, or cloud data integration
• 2+ years hands-on experience with Matillion (ETL or Data Productivity Cloud)
• 2+ years hands-on experience with Snowflake (SQL scripting, stored procedures, streams, tasks, views, performance tuning)
• Strong SQL proficiency for data extraction, transformation, validation, and troubleshooting
• Experience integrating data from diverse source systems into a cloud data warehouse
• Familiarity with version control (Git), environment management, and CI/CD concepts for data pipelines
• Excellent communication and collaboration skills; ability to work effectively in a distributed, global team
• This position requires candidate to work a 5-day -a -week schedule in the office.
• Shift Timing: 01:00Noon -10:00PM IST

Preferred:

• Experience building or maintaining semantic/business-value layers (semantic views, curated data marts, or governed reporting layers)
• Exposure to Snowflake Cortex AI, Snowflake Intelligence, or AI-ready data preparation
• Familiarity with Streamlit, Power BI, or other downstream consumption tools
• Snowflake certifications (SnowPro Core or Data Engineer)
• Experience in insurance, financial services, or regulated industries
• Familiarity with ActiveBatch or similar enterprise scheduling tools

Skills desired:

Core Application Systems: Knowledge of major production application systems used for delivery of services to internal and external clients; ability to leverage major production application systems in diverse situations.
Level Basic Understanding:
• Describes basic elements and benefits of core applications supported by own area.
• Names the organization's core application systems.
• Names major business functions and services supported by core applications.
• Locates and uses relevant documentation for core applications.

Problem Solving: Knowledge of approaches, tools, techniques for recognizing, anticipating, and resolving organizational, operational or process problems; ability to apply knowledge of problem solving appropriately to diverse situations.
Level Working Knowledge:
• Identifies and documents specific problems and resolution alternatives.
• Examines a specific problem and understands the perspective of each involved stakeholder.
• Develops alternative techniques for assessing accuracy and relevance of information.
• Helps to analyze risks and benefits of alternative approaches and obtain decision on resolution.
• Uses fact-finding techniques and diagnostic tools to identify problems.

Application Design, Architecture: Knowledge of application design and architecture principles and practices; ability to utilize application design methodologies, tools, and techniques to convert business requirements and logical models into a technical application design.
Level Working Knowledge:
• Creates a basic architecture diagram, including component interactions and data flows.
• Identifies and prioritizes application design and architecture tasks, such as refactoring and technical debt reduction.
• Selects and presents design alternatives for applications of small to medium complexity.
• Uses design tools and technologies to develop prototypes and proof of concepts.
• Documents design decisions and rationale for future reference and review.

Implementation: Knowledge of how to run applications for organizations; ability to implement application software within an organization and help end-users perform specific tasks (ex: accounting or graphic design).
Level Working Knowledge:
• Tracks problems associated with the quality and effectiveness of application software.
• Researches the benefits and drawbacks of an organization's application software.
• Drafts application software usage for the department's needs.
• Provides instant support for end users of application software.
• Implements a specific application software under the supervision of management.

Requirements Analysis: Knowledge of tools, methods, and techniques of requirement analysis; ability to elicit, analyze and record required business functionality and non-functionality requirements to ensure the success of a system or software development project.
Level Working Knowledge:
• Follows policies, practices and standards for determining functional and informational requirements.
• Confirms deliverables associated with requirements analysis.
• Communicates with customers and users to elicit and gather client requirements.
• Participates in the preparation of detailed documentation and requirements.
• Utilizes specific organizational methods, tools and techniques for requirements analysis.

System and Technology Integration: Knowledge of the features and facilities of systems; ability to integrate and communicate among applications, databases and technology platforms.
Level Working Knowledge:
• Assists with current and planned integration initiatives.
• Explores major issues and considerations for successful system integration.
• Works with applications, data, technology bridges and a variety of platforms.
• Works with existing interfaces as well as integration and migration plans within own area.
• Plays an active role in local integration efforts.

System Testing: Knowledge of system and software testing; ability to design, plan and execute system testing strategies and tactics to ensure the quality of software at all stages of the system life cycle.
Level Working Knowledge:
• Supports the project leader in developing and executing system test plans.
• Evaluates system documentation and user manuals for usability, accuracy and completeness.
• Executes test cases, analyzes test results and reports on findings regularly.
• Tests system components for compliance with functional requirements.
• Participates in the testing of a system's ability to recover from hardware or software failures.

What you will get:

• Work Life Harmony
• Earned and medical leave.
• Relocation assistance

Holistic Development

• Personal and professional development through Caterpillar ‘s employee resource groups across the globe
• Career developments opportunities with global prospects

Health and Wellness

• Medical coverage -Medical, life and personal accident coverage
• Employee mental wellness assistance program

Financial Wellness

• Employee investment plan
• Pay for performance -Annual incentive Bonus plan.

Additional Information:

Caterpillar is not currently hiring individuals for this position who now or in the future require sponsorship for employment visa status; however, as a global company, Caterpillar offers many job opportunities outside of the U.S. which can be found through our employment website at www.caterpillar.com/careers

Posting Dates:

Caterpillar is an Equal Opportunity Employer. Qualified applicants of any age are encouraged to apply

Not ready to apply? Join our Talent Community.