Designing Kibana dashboard for tracking APIs error messages and response time.Developing ETL for batch processing application user events offloaded to CDH Data Lake storage using Apache Flume. Writing Hive scripts for data preparation. ETL orchestration using Apache Airflow.Designing Data Mart logical model using Erwin. Developing ETLs for Data Marts with Informatica Big Data Developer. Building SAP BO universes on top of Data Marts.Data analysis using Spark SQL in Jupyter Notebooks.Writing Apache Spark applications using Python (PySpark) for micro-batch processing streaming data from Apache Kafka and ingesting data to HDFS. Using Airflow to schedule Spark applications.Using Jira and Confluence for planning and tracking project development. Managing source code with GitLab.

Building batch ETL processes to synchronize data across multiple source data systems using Informatica Power Center integration tool. Designing and monitoring workflows to move data from many databases to the data warehouse.Developing Oracle PL/SQL stored procedures for data preparation and implementing reports with SQL Server Reporting Services.Monitoring ETL processes developed using IBM DataStage integration tool.Developing SAP Business Objects universes and creating reports with SAP Webi.Developing batch ETL processes with Informatica Big Data Developer for data migration on Cloudera CDH. Developing batch ETL processes with Informatica Power Center for application logs consumption and data extraction parsing XMLs. Building data model and business reports from application data.Implementing an Analysis Services Tabular Data Model. Creating dashboards and reports with Power BI using tabular data.