Louis Schwartz
Sr ETL Developer at Standard Technology, Inc- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Experience
-
Standard Technology, Inc
-
Washington DC-Baltimore Area
-
Sr ETL Developer
-
Aug 2021 - Present
Work with a small team of professionals to produce and deliver data to both OLTP and DW/BI Systems. Use T-SQL and SSIS together to deliver quality ETL System components that balance throughput performance with process transparency. Accept input data from partially structured input sources (e.g. databases and Excel/CSV files) and define fundamental data properties (e.g. entity integrity) for these inputs. Stage data into well-constrained tables in ETL System database to ensure entity and domain integrity rules are enforced in all data we deliver. Assist data providers and consumers to better understand the data we exchange with them. Collaborate in a team environment, at once following established ETL processing methods and also presenting new ideas to extend the environment as it grows. Enhance existing systems by adding functionality. Maintain existing systems by identifying and correcting defects. Investigate and develop skills in new technologies. Create/amend design documents including database schema, procedure flow and business logic. Create new and extend existing operational documentation. Improve and document development lifecycle processes.
-
-
-
DIGITALSPEC, LLC. (SBA 8a Certified Company Dec 2019)
-
Falls Church, Virginia
-
Senior Database Subject Matter Expert
-
Nov 2018 - Aug 2021
-
-
-
-
Senior Manager of Data Operations
-
Jun 2008 - Jun 2018
-
-
-
-
ETL Manager
-
Apr 2006 - Jun 2008
-
-
-
-
Senior Systems Analyst
-
Aug 1997 - Jan 2006
-
-
Education
-
University of Maryland
BS, Mechanical Engineering