Hamza Ayub Email & Phone Number

Riyadh, Sa

Ohio, United States

● Data Pipeline Development: Design, develop, and implement robust and scalable data pipelines to ingest, process, and transform datafrom various sources (such as databases, APIs, files) into usable formats for analysis and consumption.● Data Integration: Integrate data from disparate sources, ensuring data consistency, integrity, and quality throughout the process. Thisinvolved data cleansing, normalization, and standardization.● Data Modeling and Architecture: Design and implement data models and architectures that support the storage, processing, and retrievalof large volumes of structured and unstructured data efficiently. This included designing data warehouses, data lakes, and dimensionalmodels.● Data Transformation and ETL: Develop and maintain Extract, Transform, Load (ETL) processes to move and transform data betweensystems and repositories. Optimize ETL workflows for performance, scalability, and reliability.● Data Governance and Security: Implement data governance policies and procedures to ensure data privacy, security, and compliance withregulations (such as GDPR, HIPAA). Manage access controls, encryption, and data masking techniques as needed.● Data Quality Assurance: Establish data quality standards and processes to monitor, validate, and improve data quality across theorganization. Implement data profiling, cleansing, and validation techniques to detect and rectify data anomalies and inconsistencies.

Dubai, United Arab Emirates

● Analyze and cleanse raw data using HiveQL.● Experience in data transformations using Map-reduce and HIVE.● Created HIVE tables as per requirements, external or internal tables defined with appropriate static and dynamic partitions, intended forefficiency.● Involved in converting HIVE/SQL queries into transformations using python.● Performed complex joins on tables in hive with various optimization techniques.● Worked extensively with HIVE DDLS and HIVE Query language (HQL).● Manage and understand Hadoop log files.● Involved in loading data from edge node to HDFS using shell scripting.● Manage Hadoop infrastructure with Cloudera manager.● Created and maintained technical documentation for launching Hadoop cluster and for executing HIVE queries. Extensive work ininformatica cloud.● Built integration between applications primarily salesforce. I worked with flat files. Loading them into on-site applications and retrievedata from applications to files. Worked with WSDL, SOAP UI for APIs. I also developed informatica cloud real time processes.● I verified data consistency between systems. Identify and validate data between source and target applications. Prepare TDD’s, Test casedocuments.● Worked on complex SQL Queries, PL/SQL procedures and convert them to ETL tasks.

Master'S Degree, Information Systems, A

Activities and Societies: Gaming, Soccer, Basketball, Ping pong, Hiking and anything fun.

Bachelor'S Degree, Information Technology