Job Description :

Hope you are doing well.

Please find the job description below and let me know your interest.

Position: ETL Data Warehouse Architect

Location: Sterling, VA

Duration: 6+ months

Mode of Interview: phone

Job Description:

Experienced SSIS architect with strong ETL skills in SQL Server / SSIS packages.

Very strong data warehouse experience in SQLServer, SSIS, Transact SQL and other dialects.

Demonstrated experience in leading data integration requirements, design, development and unit / integrated testing inat least one large data warehousing initiative.

Deep experience in integrating with a wide range of data sources and types.

Strong experience in SSIS environment sizing,installation, configuration required.

Strong experience in agile development andchange management practices.

Experience in enterprise scheduler integration inside and outside of Microsoft platforms.

Experience in both full (batch) and incremental(trickle) ETL design patterns.

Experience in data modeling and specifically dimensional modeling concepts.

Experience in SSIS workload characterization,performance tuning and optimization.

Experience in designing and implementing metadata management systems.

Experience in both on-premise and cloud implementations a real plus.

Familiarity with core information management principles and concepts.

Excellent communication skills, both written and spoken are a must.

Demonstrated ability to collaborate with other architects and lead resources.

Familiarity with financial services products and systems a plus.