Job Description

Career Area: Business Technologies, Digital and Data

:

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.

About Caterpillar

Caterpillar Inc . is the world\'s leading manufacturer of construction and mining equipment, off-highway diesel and natural gas engines, industrial gas turbines and diesel-electric locomotives.

For nearly 100 years, we\'ve been helping customers build a better, more sustainable world and are committed and contributing to a reduced-carbon future. Our innovative products and services, backed by our global dealer network, provide exceptional value that helps customers succeed.

Position Title: IT Analyst Applications ( ETL - SSIS Developer)

Location: Bangalore, KA-India

Experience: Overall 8+ years of experience in IT

Responsibilities:

• Working closely with business & IT stakeholders and understand ETL requirements and build end to end ETL migration processes using SSIS and SQL Server
• Designing and building scalable ETL solutions and Data Modelling
• Writing complex SQL queries, Unix shell commands and Java Script
• Testing and troubleshooting problems in ETL system designs and processes
• Analysing and improving existing ETL approaches and solutions
• Providing Architectural Guidelines
• Experience and expertise other ETL tools, preferably Snaplogic and DataStage
• Expected to be part of the ideation, design, and deployment of ETL solutions

Required Skillsets:

• Minimum 2 to 3 years of relevant experience, should be able understand and develop complete ETL migration process
• Strong business analysis and requirement definition background in the areas of data integration (ETL) using SQL Server Integration services (SSIS)
• Excellent hands-on knowledge in SSIS packages and developing complex ETL jobs
• Good working knowledge experience in Snowflake and SQL Server
• Good knowledge in Python scripting will be a plus
• Development knowledge in visualization tools like Power BI will be a plus
• ETL development experience with SSIS with a focus on connecting with REST & SOAP API\'s for Inbound/Outbound integrations
• Experience with JDBC, Snowflake, Azure, Salesforce, Redshift, Zuora, S3 Snaps will be a plus
• Experience with scheduling tools like Tidal, Autosys/Control-M will be a plus
• Experience in using processing snaps like mapper, unique, Aggregate, sort and join
• Experienced with implementation methodologies and best practices (e.g. Waterfall, Agile)
• Experience in establishing criteria for data use/test cases
• Experience defining and implementing error and exception handling strategies
• Ability to balance multiple projects and work both independently and as part of a team
• Strong verbal and written communication skills, presentation, analytical, organizational and interpersonal skills
• Strong troubleshooting, problem solving and conceptualization skills
• Ability to work independently as well as being a collaborative team member
• Able to manage own duties including setting priorities
• The ability to work within a multidisciplinary team
• Experience in Cloud Migration Projects & Reverse Engineering
• Good Understanding of Cloud Concepts
• Having good knowledge of Caterpillar policies, standards and procedures, with broad understanding of Caterpillar\'s organization is a plus

Work Timings : 1:00PM to 10:00PM IST (Approx.)

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

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.

Posting Dates: February 2, 2024 - February 8, 2024

Caterpillar is an Equal Opportunity Employer (EEO).

Not ready to apply? Join our .

Caterpillar