SQL Server Data Warehouse Engineer in Washington, DC at General Dynamics Information Technology

Date Posted: 6/15/2020

Job Snapshot

Job Description

GDIT seeks an experienced SQL Server Data Warehouse engineer to support a large data warehouse that the government customer wants GDIT to migrate from Oracle to SQL Server. The engineer will take existing ETL written in PL/SQL and transform it to T/SQL so that the data warehouse in SQL Server provides identical results to the Oracle version. The engineer will work on a very small team that includes one data warehouse engineer with extensive Oracle experience but limited SQL Server knowledge. The GDIT team works in a Development environment where SQL Server runs on Windows servers. The team tests changes in the Development environment and promotes releases to TEST and UAT for validation before deploying the release to Production. The SQL Server engineer must possess solid hands-on knowledge and experience with SQL Server software and tools (T-SQL, SSMA, SSMS, SSDT); solid knowledge and experience with SSIS Packages, in particular, data migration of multiple tables, and ETL packages. Personal experience with migration of large Oracle systems to SQL Server will place the candidate above other candidates. Experience designing, developing and maintaining Data Warehouse using SQL Server tools (SSIS Packages in particular) is highly desired. This position is not for a SQL Server DBA. 

We are GDIT. The people supporting some of the most complex government, defense, and intelligence projects across the country. We deliver. Bringing the expertise needed to understand and advance critical missions. We transform. Shifting the ways clients invest in, integrate, and innovate technology solutions. We ensure today is safe and tomorrow is smarter. We are there. On the ground, beside our clients, in the lab, and everywhere in between. Offering the technology transformations, strategy, and mission services needed to get the job done.

GDIT is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status, or any other protected class.