IT Analyst - Data Engineer - Returnship

Overview

Data Engineer role in Caterpillar's IT organisation, building and supporting data pipelines and Snowflake-based data warehousing solutions, with responsibility for end-to-end change requests and production support. This is a returnship position.

What you'll do

• Create data pipelines using Snaplogic, including implementing complex pipelines and performance tuning.
• Follow support processes with a focus on ITSM incident management to resolve P1/P2/P3/P4 tickets.
• Actively communicate with business partners on issues, impact, and resolutions on concerns raised.
• Follow end-to-end change request management tasks, including requirement gathering from business, creating and reviewing functional requirement documents, performing manual unit and integration testing of new functionality, and ensuring 100% SOX compliance.
• Collaborate with functional expert groups to derive insights from data extracted into Snowflake.

What you'll need

• At least 5 years of experience implementing complex Snaplogic pipelines along with performance tuning.
• Thorough understanding of Snowflake Data Warehouse features.
• At least 3 years of hands-on experience writing SQL queries and procedures.
• Minimum 3+ years of experience in data integration using Snaplogic or any ETL tool and data warehousing domain.
• Minimum 3+ years of experience on Snowflake Cloud or any other cloud database platform.
• Good knowledge of Unix commands and scripting.
• Proficient in writing complex SQL scripts and stored procedures.
• Proficient in performance tuning of integration jobs developed in Snaplogic and SQL queries in Snowflake.
• Good knowledge of data modelling and data warehousing concepts.
• Bachelor's degree in engineering (BE / B.Tech).
• Excellent communication (written and oral) and interpersonal skills.
• Good understanding and work experience in Agile methodology.
• Openness to learn and adopt new technologies in a growing technical ecosystem.

Nice to have

• Knowledge of other cloud database or integration tools.
• Client or business partner facing skills, including ability to run workshops.
• Experience leading a team in data warehousing projects.

Details

• Location: Bangalore, Karnataka, India.
• Works onsite five days a week.
• Flexible to work in rotational shifts, including night shifts.
• Visa sponsorship is not available for this position.