Experience- 6 – 11 years

Job description-

• Must have 2+ years of working experience in designing ETL flows with Pentaho
• Data Integration
• Develop ETL jobs based on Requirements given.
• Self-Efficient to understand the existing ETL Jobs / Reports.
• Analyses data from various sources, including databases and flat files.
• 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.
• Must have 3+ years of experience in developing and tuning complex SQL queries
• using Oracle, PostgreSQL or other leading DBMS.
• Need to Write the SQL Scripts to validate the data.
• Need to Support Daily Loads able to fix the issues within SLA.
• Hands on data migration
• Able to setup reporting for a new client
• Able to write Linux script
• Provide production support
• Create Source to Target (Mapping) Documents
• Required Technical and Professional Expertise: –
• Hands on experience on ETL Tools Like Pentaho.
• Hands on experience on any one Reporting tools like Pentaho BI, Microsoft Power
• BI, Oracle BI, Tableau etc.
• Experience in a data warehousing role with a solid understanding of data
• warehousing approaches and best practices.
• Strong Hands-on Experience writing SQL Scripts to analyse and validate the Data.
• Should have expert knowledge in writing SQL commands, queries, and stored procedures
• Strong knowledge of DB and DW concepts.
• Functional Knowledge/understanding on Finance, reconciliation, Customer service,
• Pricing modules etc.
• Excellent SQL, PL/SQL, XML, JSON and Database Skills
• Good to have some experience with Python or Javascript
• Good to have some knowledge on Kubernetes, Ansible
• Good to have some knowledge on Linux script