Kidus tesfaye

ETL Developer (Extraction, Transformation, Loading)

Silver Spring

Followers

Following

Skilled SQL Developer and ETL developer on enterprise data warehouses development involving multiple industries with over 7+ years of hands-on experience  in Database Design ,Management and Optimization.

Expert Knowledge in building , managing and producing highly efficient and project-oriented T-SQL query statements and store procedures for relational databases using SQL Server Management Studio (SSMS) with Excellent knowledge of MS SQL Server Integration Service (SSIS) to perform ETL solutions for Data Migration, Data Conversion, Data Validation, Data Management, Reporting and supporting other analysis.

My career journey has been a purposeful voyage of continuous growth and learning. Moreover, my roles in various industries and organizations have enriched my adaptability and problem solving abilities, providing me with diverse toolkit for addressing the unique challenges of any environment.

Careers

SQL/SSIS Developer

MGM Resorts International

Full time contract10/2021 -

Gathered and documented project requirements from stakeholders and translated them into functional and non-functional specifications for BI reports and applications and transformed them into deliverable solutions.
Participated in data mapping process, figuring out and documenting meanings of columns and tables as well as relationships among them.
Responsible for extracting data from internal and external resources using T-SQL and PL/SQL based on business requirements such as Stored Procedures, User Defined Functions (UDFs) and Views
Tuned the performance of query statements by analyzing execution plans and logs/statistics in SQL Server Profiler/Database Engine Tuning Advisor
Designed and developed ETL packages to realize full loading and incremental loading to convert and migrate data, transform data using lookup, merge joins, derived columns, and built the target data warehouse and data marts based on Star Schema
Involved in designing ETL packages using breakpoints and analyzing progress to catch error information by SQL command in SSIS that sends an e-mail message when an error or a warning occurs or when a task fails
Developed reporting solutions for different stakeholders from mock-up demos till deployment to analyze different dimensions as claims, transactions, appointments, supply, assets, and properties both in SSRS and Tableau
Developed reporting solutions including tabular reports, matrix reports, using cascading parameters to achieve Drill-down Reports, Drill-through Reports, as well as Linked Reports for security concerns in SSRS for the front-end application usage.
Worked with QA team, clarified and solved the issues, delivered to the project manager for approval and feedback.
Optimized SSRS report performance by snapshots and indexes while writing query statements.
Optimized report performance by refining queries in T-SQL, removing redundancies, retrieving only essential data and using SQL methods efficiently.
Environment: SQL Server 2008/2012/2016/2019/2022, SQL Server Management Studio (SSMS), Oracle, MS BI Suite (SSIS/SSRS), SQL Server Data Tools (SSDT), Visual Studio 2010, MS Office Suite (Excel, PowerPoint, Word), Tableau, Agile/Scrum, JIRA, Microsoft Visio

Education

ADDIS ABABA UNIVERSITY

CIVIL ENGINEERING

01/2024 - 01/2024Bachelor's DegreeClass of 2024

Welcome to Outdefine

A free tokenized community dedicated to connecting global tech talent with remote job opportunities. Our platform is designed to help you connect, learn, and earn in the tech industry while providing the chance to collect DEF tokens. Join our vibrant community today and explore a world of possibilities for your tech career!

Join for free

Skills

ETLSQLSQL Query OptimizationData warehousingDatabase systems

Experience5-8 years

Hourly rate$60/hr

Open to

remote