Role: Senior Pentaho ETL and Reporting Developer for Data warehouse
Location: Sunnyvale, California, USA.
Emp Type: Permanent Job
Interview: Phone/Skype
6-8 years
• Experience on OLTP and OLAP operations.
• Development, QA and deployment experience on Pentaho Suite (ETL tools with expertise on Pentaho Data Integration and Pentaho Report).
• Running shell scripts to query, ensure data integrity across system and within HR Data warehouse
• Hands on experience in database tools like Postgres and in not in Oracle.
• Experience in handling complex queries and performance tuning
• Facilitate the technical design to improve the efficiency of the job monitoring
• Install necessary/requested software and tools in Linux
• Server Administration - Monitor servers, databases and other infrastructure’s performance and provide notifications and alerts when there is a service degradation
Informatica and ETL Tools like Pentaho
• Monitor jobs by running status reports and scripts
• Monitor job notifications from internal system or external vendors
• Perform preliminary information gathering and create tickets/cases in case of failure and track status to ensure remediation is in place.
• Keep all software up to date
• Good leadership skills with excellent familiarity with project lifecycle approaches phases and tools
• Monitor individual job status if it is not included in the status report
• Maintain the run book documentation in form of internal wiki and review with team before the end of each quarter