Data Engineer (IT Analyst Applications)

Career Area:

Job Description:

Your Work Shapes the World at Caterpillar Inc.

When you join Caterpillar yourejoining 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 dontjust 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.

Your Impact Shapes the World at Caterpillar Inc

When you join Caterpillar youre 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 dont 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.

Why Join Us

• Drive innovation in customer experience and enterprise communications.
• Lead impactful projects that deliver measurable business results.
• Collaborate with a forward-thinking team in a dynamic growth-oriented environment.

Job Summary

Caterpillar is seeking a Data Engineer (IT Analyst Applications ) to join Applications Development & Intelligence Automation -CAT IT Division.

The incumbent would be supporting Matillion ETL pipelines and other data engineering activities including data warehousing to support and enhance Caterpillar Insurances data warehouse and other data needs

The preference for this role is to be based out of Bangalore Caterpillar PSN

What you will do

• Matillion/Active Batch/SQL

• Design and optimize Matillion ETL and ELT jobs to various target systems including Snowflake and Salesforce
• Assists in scheduling jobs in Active Batch troubleshooting issues and rerunning/restarting job schedules as needed
• Works with customers to understand data requests analyze existing code base and make needed changes to meet changes to business rules
• Use SQL to diagnose data issues and adjust code to solve them
• Assist in testing and peer review to ensure quality
• On call responsibilities as needed including testing connectivity providing front line support and managing tickets as needed
• Assist in preparing technical and procedural documentation and training team members

What you will have

• 5 years experience in data engineering tools (Matillion SQL Active Batch Snowflake)
• Excellent communication leadership and critical thinking skills
• Snowflake certifications are a plus.
• This position requires candidate to work a 5-day -a -week schedule in the office
• Shift Timing:01:00PM -10:00PM IST

Additional Details:

• Relocation is not available.
• This role may require occasional On-Call support and the ability to work flexible hours to address urgent issues.
• 10% travel may be required.

Skills desired:

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 organizations 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 Working Knowledge:
Identifies and documents specific problems and resolution alternatives.
Examines a specific problem and understands the perspective of each involved stakeholder.
Develops alternative techniques for assessing accuracy and relevance of information.
Helps to analyze risks and benefits of alternative approaches and obtain decision on resolution.
Uses fact-finding techniques and diagnostic tools to identify problems.

Application Design Architecture: Knowledge of basic activities and deliverables of application design; ability to utilize application design methodologies tools and techniques to convert business requirements and logical models into a technical application design.
Level Working Knowledge:
Works with specific development platforms system and program design tools.
Participates in the technical design of a specific application.
Selects and presents design alternatives for applications of small to medium complexity.
Defines tasks activities deliverables and key concerns of technical design.
Assists in reviewing and documenting technical application designs.

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 Working Knowledge:
Tracks problems associated with the quality and effectiveness of application software.
Researches the benefits and drawbacks of an organizations application software.
Drafts application software usage for the departments needs.
Provides instant support for end users of application software.
Implements a specific application software under the supervision of management.

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 Working Knowledge:
Follows policies practices and standards for determining functional and informational requirements.
Confirms deliverables associated with requirements analysis.
Communicates with customers and users to elicit and gather client requirements.
Participates in the preparation of detailed documentation and requirements.
Utilizes specific organizational methods tools and techniques for requirements analysis.

System and Technology Integration: Knowledge of the features and facilities of systems; ability to integrate and communicate among applications databases and technology platforms.
Level Working Knowledge:
Assists with current and planned integration initiatives.
Explores major issues and considerations for successful system integration.
Works with applications data technology bridges and a variety of platforms.
Works with existing interfaces as well as integration and migration plans within own area.
Plays an active role in local integration efforts.

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 Working Knowledge:
Supports the project leader in developing and executing system test plans.
Evaluates system documentation and user manuals for usability accuracy and completeness.
Executes test cases analyzes test results and reports on findings regularly.
Tests system components for compliance with functional requirements.
Participates in the testing of a systems ability to recover from hardware or software failures.

What you will get:

• Work Life Harmony
• Earned and medical leave.

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 Dates:

Caterpillar is an Equal Opportunity Employer. Qualified applicants of any age are encouraged to apply

Not ready to apply Join our Talent Community.