BI Data Engineer

The Company

Hitachi Vantara, a wholly-owned subsidiary of Hitachi, Ltd., guides our customers from what's now to what's next by solving their digital challenges. Working alongside each customer, we apply our unmatched industrial and digital capabilities to their data and applications to benefit both business and society. More than 80% of the Fortune 100 trust Hitachi Vantara to help them develop new revenue streams, unlock competitive advantages, lower costs, enhance customer experiences, and deliver social and environmental value.

Responsibilities: -

• Develop ETL jobs based on Requirements given.
• Self-Efficient to understand the existing ETL Jobs / Reports.
• Need to Write the SQL/Redshift Scripts to validate the data.
• Need to Support Daily Loads able to fix the issues within SLA.
• Discuss with the customers/end users and gather requirements. Build - Customize ETL/BI reports.
• Identify the Problematic Areas in ETL /Loads and need to fix by Performance Improvement.

Required Technical and Professional Expertise: -

• 5-6 years of overall experience - 5 years of experience in a ETL role.
• Hands on experience on ETL Tools Like Informatica/Pentaho.
• Have Solid Knowledge/understanding Data warehouse Concepts and Data Modelling - Star/Snow-flake schemas.
• Strong Hands-on Experience writing SQL Scripts to analyse and validate the Data.
• Hands on experience on Reporting tools like Microsoft Power BI, Oracle BI, Tableau etc.
• Should have expert knowledge in writing SQL commands, queries, and stored procedures
• Strong knowledge of DB and DW concepts. Early joining is preferred.
• Functional Knowledge/understanding on Finance, Customer service, Pricing modules etc.
• Maintain in-depth and current knowledge of the Cloud architecture, Data Lake, Data warehouse, BI platform, analytics models platforms and ETL tools
• Excellent SQL, PL/SQL, and Database Skills

Preferred Technical and Professional Expertise: -

• Technology Set: Informatica, Pentaho, AWS S3, AWS Lambda, AWS Glue, Athena, Redshift, Oracle, Reporting Tools like Power BI - OBIEE.
• Concepts Required: - ETL, Data Warehouse, Data Modelling, Data Lake, Data Visualization - Data Virtualization.

We are an equal opportunity employer. All applicants will be considered for employment without attention to age, race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability status.