Job Description :

Hope you’re doing great.

This is Shivangi with KPG99 Inc. . I have the following job opportunity of Senior ETL Data Warehouse Architect in Sterling, VA. Please see the job description below and let me know if you would be interested in it. You can either reply to this mail or call me at

ETL Data Warehouse Architect

Sterling, VA

6 to 1 year project

2 phone interview

6 to 1 year project


Job description:

This is a professional position responsible for designing, building, testing ETL (extract, transfer, and load) processes.  The ETL developer will be able to design and implement a plan for all types of data movement or modification approved by management.  The ETL developer will have full understanding of each step in the ETL Process and be able to write ETL programs with scripts, packages, and mappings.  The ETL developer will be responsible for the analysis, development, quality assurance, implementation, monitoring and administration of the ETL process.


Understand the data structure and meaning in both the source and target BI systems
Identify and assess data sources
Create source/target mappings
Apply business rules as transformations
Implement navigation methods/application
Design and specify source data detection and extraction processes
Design and develop transformation code/logic/programs for environment
Design and develop data transport and population processes for environment
Unit test source data detection and extraction processes for environment
Build and unit test data transformation processes for environment
Build and unit test source data transport and population processes for environment
Work with production data to monitor and report on data conditions and quality
Design data cleanup processes
Adapt ETL processes to accommodate changes in source systems and new business user requirements
Define and capture metadata and rules associated with ETL processes
Coordinate with program-level ETL architect to ensure compliance with standards and consistency with long-term infrastructure plans
Required Qualifications:
8+ years of ETL application development experience
Expert knowledge of the entire MS stack - SSIS, SSRS, SSAS, and SSMS
Multiple years of ETL design experience
Excellent knowledge of MS SQL, T-SQL, and stored procedures
Strong understanding of SDLC best practices with emphasis on BI practices
Good time management and organization skills
Curious, self-motivated, independent work skills
Excellent verbal and written communication skills with all levels of the organization
Proficient in coaching others
Proficient in estimating project effort and duration

Preferred Qualifications:

Bachelor’s Degree in Information Systems
SQL Server 2014 R2

Thanks and Regards,

Shivangi Singh | Team Lead | KPG99, INC

Certified Minority Business Enterprise (MBE)

Direct|  |