PepsiCo | Hiring | Lead Engineer – 1, Data Engineer (Teradata) | BigDataKB.com | 08-04-2022

Job Location: Hyderฤbฤd

Auto req ID: 270360BR


Job Description


Purpose:

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 also drive innovation related activities

  • 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.
  • Good understanding of Teradata architecture (Staging, foundation and reporting)
  • Understanding various indexes and using appropriately in the queries
  • Experiencing in End to End implementation of data-warehousing projects
  • Advanced SQL skills, including use of derived tables, unions, multi-table inner/outer joins.
  • Experienced in writing scripts to write wrapper scripts to call ETL Jobs
  • Experience in developing solution using Azure Data lake, ADF would be added advantage.


Accountabilities;

  • 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


Qualifications/Requirements


Years of Exp:

  • 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


Mandatory Technical Skills:

  • Technology skill should include :
  • 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.
  • Good understanding of Teradata architecture (Staging, foundation and reporting)
  • Understanding various indexes and using appropriately in the queries
  • Experiencing in End to End implementation of data-warehousing projects
  • Advanced SQL skills, including use of derived tables, unions, multi-table inner/outer joins.
  • Experienced in writing scripts to write wrapper scripts to call ETL Jobs
  • 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 modeling or database experience; experience with ER/Studio and/or Erwin modeling tools
  • Experience in Data, BI or Analytics projects


Mandatory Non-Technical Skills:

  • Excellent remote collaboration skills
  • Experience working in a matrix organization with diverse priorities


Differentiating Skills:

  • 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


Relocation Eligible:
Eligible for Standard Relocation
Job Type: Regular

Apply Here

Submit CV To All Data Science Job Consultants Across India For Free

๐Ÿ” Explore All Related ITSM Jobs Below! ๐Ÿš€ โœ… Select your preferred “Job Category” in the Job Category Filter ๐ŸŽฏ ๐Ÿ”Ž Hit “Search” to find matching jobs ๐Ÿ”ฅ โž• Click the “+” icon that appears just before the company name to see the Job Detail & Apply Link ๐Ÿ“๐Ÿ’ผ

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *