Job
Description
Career Area: Technology, 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. As a Software Engineer you will contribute to development and deployment of Caterpillar’s state-of-the-art digital platform. Competent to perform all programming and development assignments without close supervision; normally assigned the more complex aspects of systems work. Works directly on complex application/technical problem identification and resolution, including responding to off-shift and weekend support calls. Works independently on complex systems or infrastructure components that may be used by one or more applications or systems. Drives application development focused around delivering business valuable features Maintains high standards of software quality within the team by establishing good practices and habits. Identifies and encourage areas for growth and improvement within the team. Mentors junior developers. Communicate with end users and internal customers to help direct development, debugging, and testing of application software for accuracy, integrity, interoperability, and completeness. Performs integrated testing and customer acceptance testing of components that requires careful planning and execution to ensure timely, quality results. The position manages the completion of its own work assignments and coordinates work with others. Based on past experiences and knowledge, the incumbent normally works independently with minimal management input and review of end results. Typical customers include Caterpillar customers, dealers, other external companies who purchase services offered by Caterpillar as well as internal business unit and/or service center groups. The position is challenged to quickly and correctly identify problems that may not be obvious. The incumbent solves problems by determining the best course of action, within departmental guidelines, from many existing solutions. The incumbent sets priorities and establishes a work plan in order to complete broadly defined assignments and achieve desired results. The position participates in brainstorming sessions focused on developing new approaches to meeting quality goals in the measure(s) stated. Job Description: Candidate should have at least 5+ years of experience as a Snowflake SQL developer. Write complex SQL queries to implement ETL(Extract, Transform, Load) processes and for Business Intelligence reporting. Deliver robust solutions through Query optimization ensuring Data Quality. Should have experience in writing Functions and Stored Procedures. Analyze & translate functional specifications /user stories into technical specifications. Good to have experience in Design/ Development in any ETL tool like DataStage and Snaplogic. Problem solving Skills Should communicate with business partners/client. Experience on developing both Paraller and sequencer jobs Strong experience in design & implementation of Data warehousing application processes using ETL tool Experience in SQL & UNIX scripting Experience with Data warehousing concepts Team Player with proven abilities in guiding team members and enabling knowledge sharing among the team Strong problem solving & technical skills coupled with confident decision making for enabling effective solutions leading to high customer satisfaction Strong understanding of the principles of Data Warehouse using Fact Tables, Dimension Tables, star and snowflake schema modeling Experience creating process using various operational sources like Snowflake, Oracle, SQLServer, Flat Files, Excel Files, into a staging area Expertise to use Data Stage Designer to develop processes for extracting, transforming, integrating, and loading data into data warehouse system (OLAP) Experience in integration of various data sources (DB2-UDB, SQL Server, Oracle and Flat files) into data staging area High experience creating tables and databases in Snowflake and SQL Server. Experience in developing Data stage mappings using transformations like Transformation, Lookup, Join, Merge, Filter, Funnel, Aggregator, Sort, Oracle connector etc. And Sequence Jobs. Prepare Technical Design Document based on Data Model understanding and S2T mapping requirement. Performance, defect and dependency analysis and Performance tuning in Data Stage jobs and SQL queries. Excellent skills in problem-solving and trouble-shooting capabilities, Quick Learner, highly motivated, result oriented and good team player Posting Dates: June 10, 2025 - June 16, 2025 Caterpillar is an Equal Opportunity Employer. Not ready to apply? Join our Talent Community. Show more Show less
