Asmamaw Ali
SQL Report Developer | ETL Developer
- Role
- Sql Developer Etl Developer at Peraton
- Location
- Washington, DC, US
- LinkedIn followers
- 500 followers
About Asmamaw Ali
Over 6 years of experience in SQL Development, ETL processes, and Business Intelligence…
Experience
Sql Developer Etl Developer
Nov 2023 — Present · Sterling, VA, US
Collaborated with project managers, developers, and stakeholders to translate requirements into technical solutions.• Designed and optimized database objects including stored procedures, functions, tables, indexes, and views.• Created and executed DDL/DML scripts for schema changes, constraints, data migrations, and transformations.• Created Entity Relationship Diagrams (ERDs) and physical data models to design dimension and fact tables for the enterprise data warehouse.• Built and maintained staging, dimension, and fact tables in Amazon Redshift and PostgreSQL, ensuring scalability and referential integrity.• Developed and tuned complex SQL queries, subqueries, and CTEs, applying indexing strategies and query optimization techniques to improve performance.• Designed and implemented ETL processes using AWS Glue, SSIS, SQL, and Python, including source-to-target mappings, transformations, validations, and aggregations.• Built and deployed SSIS packages with error handling, logging, and scheduling to integrate data from cloud and on-premises sources into Redshift and SQL Server.• Engineered workflows to process large datasets, improving data accuracy, consistency, and availability across environments.• Delivered SSRS reports (parameterized and drill-down) and built Power BI/Tableau dashboards, providing stakeholders with actionable insights into KPIs and trends.• Supported ad-hoc reporting and analysis through advanced SQL queries and custom visual reports for decision-making.• Conducted unit, integration, and regression testing of SQL queries, SSIS packages, ETL pipelines, and BI reports.• Monitored and optimized execution plans, indexes, and partitioning strategies, reducing query run times and improving overall performance.• Comprehensive documentation of database objects, ERDs, ETL workflows, test cases, and reporting solutions.
Education
University of Maryland Global Campus
Bachelor's degree, Accounting and Finance
University of Maryland Global Campus
Master's degree, Information Technology
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.