IT Analyst - Data Engineer - Returnship

Caterpillar Returnship is a 24-week company paid , office -based program designed to enable a soft launch for experienced professionals on a career break. This initiative includes, networking sessions, coaching, trainings and a project / work scope assignment. Eligibility to apply Career break of minimum 6 months.

What You Will Do:

Job Duties/Responsibilities may include but are not limited to:

1. Ability to create Data pipelines using Snaplogic in implementing complex pipelines along with performance tuning.

2. 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.

3. Need to have thorough understanding on Snowflake Data Warehouse features and hands-on work experience writing SQL queries and procedures.

4. 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.,).

5. Collaborate with functional expert groups to derive the insights from data extracted into Snowflake.

6. This position requires working onsite five days a week

Required Qualifications:

Must have:

1. Experience in Data integration using Snaplogic / Any ETL Tool and Data warehousing domain.
2. Experience on Snowflake Cloud / Any other Cloud Database platform.
3. Good knowledge on Unix commands and scripting.
4. Proficient in writing complex SQL scripts and Stored Procedures.
5. Proficient in Performance tuning of integration jobs developed in Snaplogic and SQL queries in Snowflake.
6. Good knowledge on Data Modelling and Data Warehousing concepts.
7. Bachelors degree in engineering - BE / B.Tech
8. Excellent communication (written and oral) and interpersonal skills.
9. Good understanding and work experience in Agile Methodology.
10. With sparsely growing technical ecosystem, should be open to learn and adopt new technologies.

Good to have:

1. Other Cloud Database/ Integration tool Knowledge is an added advantage.
2. Candidate should be flexible to work in rotational shifts including night shifts.
3. Client/Business partner facing skills, ability to run workshops.
4. Experience in Leading the Team in the Data Warehousing projects.

What You Have:

Business Acumen: Knowledge of business concepts, tools, and processes that are needed for making sound decisions in the context of the company's business; ability to apply this knowledge appropriately to diverse situations.

Level Working Knowledge:

• Comments on the organization's business model and financial goals.
• Communicates key considerations for business decision making process.
• Cites examples of types of information needed to make sound business decisions.
• Participates in business task to get things done in own unit or area.
• Caters to key stakeholders and their priorities.

Standard Operating Procedures: Knowledge of established standard operating procedures (SOP); ability to design, implement and evaluate standard operating procedures affecting daily and strategic business operations in order to increase operational efficiency.

Level Basic Understanding:

• Compiles current research relevant to standard operating procedures.
• Explains usage of standard operating procedures in business operations.
• Describes main issues and considerations when using standard operating procedures.
• Identifies key features and functions of standard operating procedures.

Effective Communications: Understanding of effective communication concepts, tools, and techniques; ability to effectively transmit, receive, and accurately interpret ideas, information, and needs through the application of appropriate communication behaviors.

Level Extensive Experience:

• Reviews others' writing or presentations and provides feedback and coaching.
• Adapts documents and presentations for the intended audience.
• Demonstrates both empathy and assertiveness when communicating a need or defending a position.
• Communicates well downward, upward, and outward.
• Employs appropriate methods of persuasion when soliciting agreement.
• Maintains focus on the topic at hand.

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 Extensive Experience:

• Ensures capture of lessons to be learned from a problem-solving effort.
• Organizes potential problem solvers and leads problem resolution efforts.
• Uses varying problem-solving approaches and techniques as appropriate.
• Contributes to standard practices for problem-solving approaches, tools, and processes.
• Analyzes and synthesizes information and devises alternative resolution strategies.
• Develops successful resolutions to critical or wide-impact problems.

Decision Making and Critical Thinking:

1. Knowledge of the decision-making process and associated tools and techniques; ability to accurately analyse situations and reach productive decisions based on informed judgment.
2. Level Working Knowledge:
3. Applies an assigned technique for critical thinking in a decision-making process.
4. Identifies, obtains, and organizes relevant data and ideas.