Job Description
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: -
8-10 years of overall experience 6 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.
Job Classification
Industry: Consumer Electronics & Appliances
Functional Area: Engineering - Software & QA,
Role Category: DBA / Data warehousing
Role: DBA / Data warehousing
Employement Type: Full time
Education
Under Graduation: Any Graduate
Post Graduation: Any Postgraduate
Contact Details:
Company: Hitachi
Location(s): Hyderabad
Keyskills:
Telecom
Healthcare
Informatica
Stored procedures
Customer service
microsoft
Virtualization
Japanese
Pentaho
Analytics