Biniam Endalew

Experience

1. Data Engineer Developer

   Rocket Mortgage

   Apr 2022 — Present

   Worked with Business Systems Analysts to fine tune specifications by ensuring that all database constraints are satisfied and perform impact analysis of changes.• Experienced in Analyzing and understanding the business requirements, definition and design of the data sourcing and data flows Involved in creating functional and technical specification documents after gathering requirements from business.• Created database objects like Tables, DML, DDL, Views, Stored Procedures, Functions, Joins, and Indexes in T-SQL based upon the functional specifications.• Developed complex T-SQL Queries and SQL Scripts for efficient data load based on complex business rules.• Designed complex ETL strategies to pull data from different sources, like SQL server, oracle, and flat files and load it to the destination database after using multiple transformations.• Worked on Snow SQL and Created Snow pipe for continuous data load.• Worked on Time Travel to access Historical Data and used that for Restoring Data-Related Objects (Tables, Schemas, and Databases) that may have been removed by accident or on purpose, Duplicating and Backing up Data from previous periods of time and Analyzing Data Manipulation and Consumption over a set period.• Created internal and external stage and transformed data during load.• Redesigned the Views in snowflake to increase the performance.• Unit tested the data between Redshift and Snowflake.• Created Talend Mappings to populate the data into dimensions and fact tables.• Wrote ETL jobs to read from web APIs using REST and HTTP calls and loaded into HDFS using java and Talend.• Used Talend big data components like Hadoop and S3 Buckets and AWS Services for redshift.• Validating the data from SQL Server to Snowflake to make sure it has Apple to Apple match.• Implemented Change Data Capture technology in Talend to load deltas to a Data Warehouse.