IT Analyst Applications (Snowflake Developer)
Caterpillar Inc.
Turn this role into an interview — a resume and cover letter built around what this employer wants.
Benefits offered by this job
Job summary
Caterpillar Inc. in Bengaluru is seeking an IT Analyst Applications (Snowflake Developer) with 3–5 years of experience to design and build scalable data pipelines for Procurement data platforms.
The role includes optimizing Snowflake data models, enabling analytics with Power BI readiness, and collaborating with analysts and data consumers in an Agile environment.
Qualifications
- Bachelor's degree in CS/IT/Engineering or related field.
- Snowflake certification is preferred.
- Strong analytical, communication, and problem‑solving skills.
Responsibilities
- Design, develop, and maintain data pipelines and ETL/ELT processes using Snowflake and cloud-based data technologies.
- Build and optimize Snowflake databases, schemas, tables, views, stored procedures, tasks, and streams.
- Develop data integration solutions to ingest data from ERP, procurement, supplier, and supply chain systems into enterprise data platforms.
- Support Procurement analytics, supplier management, sourcing, item master data, and spend analytics initiatives.
- Collaborate with business analysts, product owners, and data consumers to gather requirements and deliver data solutions.
- Monitor data quality, troubleshoot performance issues, and implement optimization strategies.
- Develop reusable data models and ensure adherence to enterprise data governance and security standards.
- Support reporting and analytics teams by enabling data access for Power BI and other BI solutions.
- Participate in Agile ceremonies, code reviews, testing, and deployment activities.
Skills
Education
Tools
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.
Technology, Digital and Data
We are seeking a skilled IT Analyst Applications (Snowflake Developer) to join Order Fulfillment & Procureme - Cat IT Division team. With 3 to 5 years of experience in designing, developing, and supporting enterprise data solutions within Procurement applications in RI IT. The candidate will be responsible for building scalable data pipelines, optimizing Snowflake data models, and enabling analytics solutions across Procurement Data Platforms such as EPDP and SCDP. The preference for this role is to be based out of Bangalore - Caterpillar PSN. This position requires candidate to work a 5-day -a -week schedule.
01:00-10:00PM IST
- Design, develop, and maintain data pipelines and ETL/ELT processes using Snowflake and cloud-based data technologies.
- Build and optimize Snowflake databases, schemas, tables, views, stored procedures, tasks, and streams.
- Develop data integration solutions to ingest data from ERP, procurement, supplier, and supply chain systems into enterprise data platforms.
- Support Procurement analytics, supplier management, sourcing, item master data, and spend analytics initiatives.
- Collaborate with business analysts, product owners, and data consumers to gather requirements and deliver data solutions.
- Monitor data quality, troubleshoot performance issues, and implement optimization strategies.
- Develop reusable data models and ensure adherence to enterprise data governance and security standards.
- Support reporting and analytics teams by enabling data access for Power BI and other BI solutions.
- Participate in Agile ceremonies, code reviews, testing, and deployment activities.
- 3 to 5 years of experience in Data Warehousing and Data Engineering.
- Strong hands-on experience with Snowflake.
- Proficiency in SQL, Python, data modeling, and performance tuning.
- Knowledge of cloud platforms such as AWS.
- Understanding of Supply Chain, Procurement, or Manufacturing business processes.
- Experience working with large-scale enterprise datasets and analytical solutions.
- Familiarity with CI/CD practices and Git-based version control.
- Knowledge with Power BI and analytics reporting.
- Exposure to procurement systems, supplier management, sourcing, and master data domains.
- Knowledge of Python or scripting languages for automation.
- Experience working in Agile/Scrum environments.
- Bachelor's degree in Computer Science, Information Technology, Engineering, or related field.
- Snowflake certification is preferred.
- Strong analytical, communication, and problem‑solving skills.
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.
- 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.
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.
- Explains the value of a disciplined approach to problem solving.
- Describes problem reporting and escalation practices.
- Utilizes accepted procedures for problem analysis and resolution.
- Identifies key aspects of problem‑solving techniques used in own area.
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.
- Describes the role of design patterns and principles in application design and architecture.
- Identifies the basic components of an application design.
- Lists common application architecture styles, such as monolithic, microservices, and event‑driven architecture.
- Explains the importance of scalability, security, and performance in application design and architecture.
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).
- Cites specific types of application software and their usage within an organization.
- Identifies problems commonly associated with application implementation.
- Lists main application software and vendors in the market place.
- Describes the general processes and policies of application implementation.
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.
- Cites examples of functional and non‑functional requirements.
- Describes basic concepts and major activities associated with requirements analysis.
- Explains the life cycle context and scope of requirements analysis.
- Explains the structure and components of effective requirements analysis documents.
Knowledge of the features and facilities of systems; ability to integrate and communicate among applications, databases and technology platforms.
- Describes the basic concepts and issues of system and technology integration.
- Illustrates the risks and benefits of technology integration projects.
- Discusses major software, hardware or application integration initiatives and plans.
- Explains system integration initiatives in own environment.
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.
- Describes major components of system testing used by the organization.
- Documents the standard processes and procedures involved in system testing.
- Explains the importance of thorough system testing prior to implementation.
- Identifies common errors that occur in standard system testing activities.
- Work Life Harmony
- Earned and medical leave.
- Relocation assistance
- Personal and professional development through Caterpillar 's employee resource groups across the globe
- Career developments opportunities with global prospects
- Medical coverage -Medical, life and personal accident coverage
- Employee mental wellness assistance program
- Employee investment plan
- Pay for performance -Annual incentive Bonus plan.
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
Caterpillar is an Equal Opportunity Employer (EEO)
EEO/AA Employer. All qualified individuals, including minorities, females, veterans and individuals with disabilities - are encouraged to apply.
This position requires working onsite five days a week.
Visa Sponsorship is not available for this position.
Caterpillar is an Equal Opportunity Employer. Qualified applicants of any age are encouraged to apply
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
