ETL Business Analyst (Pentaho)

• Extensive Experience in ETL Tool – Pentaho
• Expert in creating data flows
• Modification of existing complex data flows leading to optimization
• Hands on experience of formulating, executing, and debugging SQL queries
• Knowledge of reading data for APIs
• Experience in creating data models

Additional skills:

• Extensive experience in Extract Transform Load methodology
• Knowledge of data sources, transform maps to push data to ServiceNow
• Prior experience of working in regulatory reporting / remediation / banking industry

Tasks:

The role involves 

• analysing the source data feeds,
• identifying gaps and inconsistencies in the data reporting, 
• provide detailed insights on how the source data is processed and reported, 
• coordinating with technology owners to analyse and implement the required changes in source feeds,
• and collaborating with the Patch management reporting teams to ensure seamless data integration and enhanced report quality.