Solutions Consultant
CurrentDriving a crucial on-site project at Tahakom Riyadh, I actively engage in meetings with business users to thoroughly analyze their requirements. In this capacity, I seamlessly integrate various data sources (Mssql, PostgreSQL, Oracle, OData Sap, CSV, Excels) into the data lake, overseeing end-to-end ETL processes and crafting tables and views to enhance data accessibility. Furthermore, I meticulously prepare data on Impala, ensuring the delivery of high-quality insights that align with evolving business needs.Contributed to an ODI 12c project, where my role involved extracting data from Oracle databases and loading it into another Oracle target database with distinct schemas and specific business rules.Contributed on project on Talend Open Studio to extract files from SFTP and load them into SQL Server. Implemented an iterative process to extract metadata from files, inserting it into corresponding tables. Data from these files was loaded into different tables, with incremental logic capturing only new data based on file metadata. Additionally, I possess proficiency in reading data, calling APIs to decrypt PGP files, transforming them into text files, and applying the same comprehensive process.