Career Area:
Business Technologies, Digital and Data
Job Description:
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.
ETL Engineer
As an ETL engineer you will be responsible for extracting, transforming, and loading data from various sources into a Business oriented Snowflake database. You will use and maintain the ETL package developed by the team in Python and ensure that ETL jobs run correctly and efficiently. You will also troubleshoot and resolve any issues with the ETL jobs or the data sources and communicate with the data owners and stakeholders. You will also create and configure new ETL jobs as needed and perform basic Windows server administration tasks to manage the ETL server.
What You Do:
Use and maintain the ETL package developed by the team in Python.
Ensure that ETL jobs run correctly and efficiently and monitor their performance and status.
Troubleshoot and resolve any issues with the ETL jobs or the data sources and communicate with the data owners and stakeholders.
Create and configure new ETL jobs as needed, and document their specifications and requirements.
Create and manage Snowflake objects such as tables, views, schemas, roles, and warehouses to ensure that the data is correctly loaded into the Snowflake database.
Perform basic Windows server administration tasks to manage the ETL server.
What You Have:
Bachelor's degree in computer science, information systems, or related field, or equivalent work experience
At least 3 years of experience in ETL development, preferably using Python.
Strong knowledge of SQL and relational databases, preferably Snowflake
Experience with data modeling, data quality, and data governance concepts and practices
Ability to work independently and collaboratively with a team.
Excellent communication, problem-solving, and analytical skills
Experience with Windows server administration
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 Working Knowledge:
Helps create contingency plans to mitigate impact of disruption on core applications.
Identifies key players, criticalities, roles, and responsibilities.
Investigates application-related issues with both business and IT professionals.
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.
Develops alternative techniques for assessing accuracy and relevance of information.
Helps to analyze risks and benefits of alternative approaches and obtain decision on resolution.
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 Extensive Experience:
Facilitates in application design reviews and walkthroughs.
Creates and evaluates technical alternatives for complex applications.
Interprets application services such as API; integrates them with technical design.
Develops various, distinct, and multiple technical application designs.
Prepares technical design documents and blueprints for applications.
Explores and evaluates application design considerations for multiple technologies.
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.
Drafts application software usage for the department's needs.
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, 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 serious issues and considerations for successful system integration.
Works with existing interfaces as well as integration and migration plans within own area.
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.
Additional Info:
The primary location for this position is Peoria, IL.
Sponsorship is not available.
Relocation is NOT available.
What You Will Get:
Our goal at Caterpillar is for you to have a rewarding career. Our teams are critical to the success of our customers who build a better world.
Here you earn more than just a salary because we value your performance. We offer a total rewards package that provides benefits on day one (medical, dental, vision, RX, and 401K) along with the potential of an annual bonus. Additional benefits include paid vacation days and paid holidays.
All qualified individuals - Including minorities, females, veterans, and individuals with disabilities - are encouraged to apply.
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 one hundred years, we have 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.
Posting Dates:
September 19, 2024 - October 3, 2024
Any offer of employment is conditioned upon the successful completion of a drug screen.
EEO/AA Employer. All qualified individuals - Including minorities, females, veterans and individuals with disabilities - are encouraged to apply.
Not ready to apply? Join our Talent Community (http://flows.beamery.com/caterpillarinc/talcom) .
