PepsiCo Looking for Sector IT Assoc Analyst at Hyderabad, Telangana Full Time

Position Overview

Primary focus would be to build Data solutions for key projects. This would include work on Enterprise Data

Warehouse (EDW) using the below technologies and ensuring on time and on budget development/delivery.

Satisfying project requirements while adhering to enterprise architecture standards. Role will drive key data

and digital projects and drive innovation related activities

1.In-depth knowledge of core TERADATA concepts/architecture, load utilities (BTEQ, MLOAD, FASTLOAD),

OLAP functions, SQL writing, performance tuning techniques, identifying in the eliminating spool spaces

skewness issues etc.

2.Good understanding of Teradata architecture (Staging, foundation, and reporting)

3.Understanding various indexes and using appropriately in the queries

4.Experiencing in End-to-End implementation of data-warehousing projects

5.Advanced SQL skills, including use of derived tables, unions, multi-table inner/outer joins.

6.Experienced in writing scripts to write wrapper scripts to call ETL Jobs

7.Experience in developing solution using Azure Data Lake, ADF would be added advantage.

Checklist of Experience Required for this Position:
We’ll be upfront with you: We will only consider candidates with the following experience. For a candidate

to be considered for this role, she or he will absolutely need to have:

• Bachelor’s degree in Computer Science, MIS, Business Management, or related field
• 5-6 years’ experience in Information Technology
• Good written and verbal communication skills along with collaboration and listening skills
• Experience dealing with multiple vendors as necessary

Technology skill should include:
1.In-depth knowledge of core TERADATA concepts/architecture, load utilities (BTEQ, MLOAD, FASTLOAD)

OLAP functions, SQL writing, performance tuning techniques, identifying in the eliminating spool spaces,

skewness issues etc.

2.Good understanding of Teradata architecture (Staging, foundation, and reporting)

3.Understanding various indexes and using appropriately in the queries

4.Experiencing in End-to-End implementation of data-warehousing projects

5.Advanced SQL skills, including use of derived tables, unions, multi-table inner/outer joins.

6.Experienced in writing scripts to write wrapper scripts to call ETL Jobs

7.Experience in developing solution using Azure Data Lake, ADF would be added advantage.

Overall experience should include:

• Solutions Delivery experience – system development lifecycle, integration, and sustainability
• Data modelling or database experience; experience with ER/Studio and/or Erwin modelling tools
• Experience in Data, BI or Analytics projects
• Excellent remote collaboration skills
• Experience working in a matrix organization with diverse priorities

Qualifications

Skills and Experience Required

• Strong database skills
• Ability to work with virtual teams (remote work locations); within team of technical resources (employees

and contractors) based in multiple global locations

• Participate in technical discussions, driving clarity of complex issues/requirements to build robust solutions
• Strong communication skills to meet with delivery teams and business-facing teams, understand sometimes

ambiguous, needs, and translate to clear, aligned requirements

The Role

Execute delivery of key projects within time and budget

• Develop solution design and build to ensure scalability, performance and reuse
• Ensure on time and on budget delivery which satisfies project requirements, while adhering to enterprise architecture standards.
• Facilitate work intake, prioritization and release timing; balancing demand and available resources. Ensure tactical initiatives are aligned with the strategic vision and business needs