Sr. Analyst, Data Engineering

Overview

Senior Analyst role in Data Engineering, participating in the incremental development of the Enterprise Data Warehouse (EDW) and the loading or extraction of data into the warehouse, across the project life cycle from planning to production implementation.

What you'll do

• Participate in the incremental development of the Enterprise Data Warehouse (EDW).
• Load or extract data into the warehouse.
• Participate throughout the project life cycle, from planning to production implementation, with emphasis on data analysis, data modeling, and follow through to production.
• Optimize design considering cost, quality, manufacturability, sustainability, and environmental requirements.

What you'll need

• 6 to 8 years of experience in ETL design, development, and populating data warehouses from heterogeneous OLTP sources such as Oracle R12 ERP system and other cloud technologies.
• At least 3 years of experience with Pentaho Data Integration and Snowflake.
• Extensive expertise on databases, data acquisition, ETL strategies and tools, and technologies using Pentaho DI and Snowflake.
• Experience designing complex ETLs extracting data through XML files, JSON, RDBMS, and flat file sources.
• Strong programming skills and relational database skills with expertise in Advanced SQL and PL/SQL Oracle DB, Snowflake, MySQL, NoSQL DBs, etc.
• Ability to analyze poorly performing queries/ETL mappings and provide suggestions to tune them.
• Exposure to standard support ticket management tools.
• Mastery in business intelligence and data warehousing concepts and methodologies.
• Extensive experience in data analysis and root cause analysis with proven problem-solving and analytical thinking capabilities.
• Understanding of software engineering principles and skills working on Unix/Linux/Windows operating systems, version control, and office software.
• Experience with scripting languages like Python, Shell, JavaScript, HTML5 is essential.
• Broad understanding of multiple existing and next-generation business intelligence tools and technologies.

Nice to have

• Experience with React.js and Node.js.

Details

• Location: Chennai, India.
• Flexible hybrid work model that supports productivity and connection from anywhere.