Job Summary
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.
Shift Timing : 01:00-10:00PM IST
Key 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.
Required Skills
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.
Preferred Skills
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.
Qualifications
Bachelor's degree in Computer Science, Information Technology, Engineering, or related field.
Snowflake certification is preferred.
Strong analytical, communication, and problem-solving skills.
Skill Descriptors
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 Basic Understanding
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.
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 Basic Understanding
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.
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 Basic Understanding
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.
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 Basic Understanding
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.
System and Technology Integration: Knowledge of the features and facilities of systems; ability to integrate and communicate among applications, databases and technology platforms.
Level Basic Understanding
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.
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 Basic Understanding
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.
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
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.
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.
