IT Analyst - Data Engineer - Returnship

What You Will Do:

• Ability to create Data pipelines using Snaplogic having at least 5 years of experience in implementing complex pipelines along with performance tuning.
• Follow support processes, with focus on ITSM incident management to resolve P1/P2/P3/P4 tickets and actively communicating business partners on issues, impact, and resolutions on concerns raised.
• Need to have thorough understanding on Snowflake Data Warehouse features and at least 3 years of hands-on work experience writing SQL queries and procedures.
• Follow End to End Change Request Management Tasks. (Requirement gathering from business, create and review functional requirement documents, perform manual unit testing and integration testing of new functionality, ensure 100% SOX compliance, etc.,).
• Collaborate with functional expert groups to derive the insights from data extracted into Snowflake.
• Minimum 3+ years of experience in Data integration using Snaplogic / Any ETL Tool and Data warehousing domain.
• Minimum 3+ years of experience on Snowflake Cloud / Any other Cloud Database platform.
• Good knowledge on 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 on 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.
• With sparsely growing technical ecosystem, should be open to learn and adopt new technologies.
• Good to have:
• Other Cloud Database/ Integration tool Knowledge is an added advantage.
• Candidate should be flexible to work in rotational shifts including night shifts.
• Client/Business partner facing skills, ability to run workshops.
• Experience in Leading the Team in the Data Warehousing projects.
• 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 India which can be found through our employment website at www.caterpillar.com/careers.
• Final Details:
• Please frequently check the email associated with your application, including the junk/spam folder, as this is the primary correspondence method. If you wish to know the status of your application – please use the candidate log-in on our career website as it will reflect any updates to your status.
• If you are interested in joining our team, please apply using an English version of your CV. We look forward to meeting you!
• This Job Description is intended as a general guide to the job duties for this position and is intended for the purpose of establishing the specific salary grade. It is not designed to contain or be interpreted as an exhaustive summary of all responsibilities, duties and effort required of employees assigned to this job. At the discretion of management, this description may be changed at any time to address the evolving needs of the organization.

What You Have:

• Minimum 3+ years of experience in Data integration using Snaplogic / Any ETL Tool and Data warehousing domain.
• Minimum 3+ years of experience on Snowflake Cloud / Any other Cloud Database platform.
• Good knowledge on 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 on 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.
• With sparsely growing technical ecosystem, should be open to learn and adopt new technologies.
• Good to have:
• Other Cloud Database/ Integration tool Knowledge is an added advantage.
• Candidate should be flexible to work in rotational shifts including night shifts.
• Client/Business partner facing skills, ability to run workshops.
• Experience in Leading the Team in the Data Warehousing projects.
• 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 India which can be found through our employment website at www.caterpillar.com/careers.
• Final Details:
• Please frequently check the email associated with your application, including the junk/spam folder, as this is the primary correspondence method. If you wish to know the status of your application – please use the candidate log-in on our career website as it will reflect any updates to your status.
• If you are interested in joining our team, please apply using an English version of your CV. We look forward to meeting you!
• This Job Description is intended as a general guide to the job duties for this position and is intended for the purpose of establishing the specific salary grade. It is not designed to contain or be interpreted as an exhaustive summary of all responsibilities, duties and effort required of employees assigned to this job. At the discretion of management, this description may be changed at any time to address the evolving needs of the organization.

About Caterpillar