Aweke Bayuh
Data Engineer @Generational Equity, LLC
Signup · Get unlimited contacts
WORK HISTORY
Data Engineer @Generational Equity, LLC
Richardson, TX, US
Used T-SQL to develop DDL, DML, and dynamic SQL daily. • Maintaining code version in the repository with TFS/VSTS, TORTOISE SVN, and GIT. • Designed complex database and data warehouse system architecture and created schemas. • Designed components and performed complex coding/programming, debugging, and testing within a data warehouse system and documents data warehouse system. • Reviewed data extraction, loading, cleansing, and data modeling for data warehouses. • Developed, deployed, and monitored SSIS Packages. • Defined unit testing and system integration best practices. • Enhancing, developing, and deploying SSIS packages across different environments. • Experience in agile software development paradigm (e.g, Scrum, Kanban). • Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases. • Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard, and SQL Query Analyzer in MS SQL. •Extracted data from heterogeneous sources (OLTP, Flat Files, Microsoft Excel) and transferred to OLAP using SQL Server Integration Services (SSIS). •Identified the data sources and created sources to target mapping documents to be used by the packages in SQL Server Integration Services (SSIS). • Maintaining code version in the repository with TFS/VSTS. • Used various transformations in the ETL packages while transferring the data from the OLTP source to the destination using SSIS 2008/2016. • Developed complex stored procedures to be used in SSIS 2008 packages to audit the information about the data flow from one stage to another. • Involved with the full development cycle of a Data Warehouse, including requirements gathering, design, implementation, and maintenance. • Wrote complex stored procedures, and views using TSQL in Management Studio.
EDUCATION
Universty of Gondar
Bachelor's degree, Economics
ABOUT AWEKE BAYUH
Created ETL packages using heterogeneous data sources SQL Server, Flat Files, Excel source files, XML files etc. and then loaded the data into destination tables. Develop SSRS reports (Parameterized, Drilldown, Drill through, Sub-reports, Linked & Ad-hoc reports) and configure SSIS Subscriptions as per Specifications Provided by Internal and External Clients. Designed and implemented complex SSIS package to migrate data from multiple data sources and Power BI. Azure Data Factories and Azure SQL databases. Involved into updating procedures, functions, triggers, and packages based on the change request.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.