Data Engineer at CENTAUR BILLING IT SOLUTIONS (2018-02 – 2026-07)
Project 1 - May Bank (Banking Domain)
- Implemented Snowpipe for continuous data ingestion from AWS S3 into Snowflake, enabling near real-time analytics and reporting.
- Migrated data from Oracle to Snowflake using flat files as part of cloud modernization initiatives.
- Created and managed Snowflake objects including warehouses, schemas, tables, views, stages, pipes, and materialized views.
- Developed complex SQL queries and transformation logic to support business reporting and analytics requirements.
- Processed semi-structured data using VARIANT columns, FLATTEN functions, and Parquet file formats.
- Developed reusable dbt models and implemented data quality tests to ensure scalable and reliable transformations.
- Designed and orchestrated automated ELT workflows using Apache Airflow for scheduling, monitoring, and dependency management.
- Integrated Airflow with DBT, implementing alerts and retry mechanisms for reliable pipeline execution.
Data Engineer at CENTAUR BILLING IT SOLUTIONS (2018-02 – 2026-07)
Project 2 - Commercial bank of Ethiopia (Banking Domain)
- Developed PL/SQL packages, procedures, functions for data extraction, validation, transformation, and migration.
- Developed complex SQL queries and analytical functions based on business requirements.
- Implemented Snowpipe for continuous data ingestion from ADLS into Snowflake.
- Created Snowflake Streams and Tasks to capture DML changes and maintain audit/backup data.
- Built secure and materialized views in Snowflake for controlled data sharing and optimized reporting.
- Designed and managed Azure Data Factory (ADF) pipelines for ELT workflows across ADLS and Snowflake.
- Configured ADF triggers, Copy Activities, and monitoring features for automated, reliable, and scalable data integration.
Data Engineer at CENTAUR BILLING IT SOLUTIONS (2018-02 – 2026-07)
Project 3 - Sampath bank (Banking Domain)
- Developed complex SQL queries and analytical functions to support reporting and business requirements.
- Performed unit testing and data validation to ensure data quality, consistency, and source-to-target reconciliation.
- Created secure and materialized views in Snowflake for governed and efficient data sharing.
- Utilized Snowflake cloning features for backup, replication, and testing activities.
- Troubleshot and resolved SQL and Snowflake issues to improve database performance and system reliability.
- Maintained technical documentation, test cases, and migration reports in Confluence for audit and compliance purposes.
- Processed semi-structured data using VARIANT data types, FLATTEN functions, and Parquet file formats.
- Developed Snowflake procedures, functions, UDTFs, and external tables to support advanced transformations and secure AWS S3 data access.
- Implemented IICS to build and manage cloud-native ETL pipelines for scalable and secure data integration.
