Sr. ETL Developer (SSIS)

"SSIS ETL" "rapid agile" agile "data warehouse" "data load procedures" SCD "SCD packages" "Ad Hoc data" "data marts" Mappings" "DATA MATCHING" "INCREMENTING LOADS"
Full Time, Contract Corp-To-Corp, Contract Independent, Contract W2, C2H Corp-To-Corp, C2H Independent, C2H W2, Part Time, 6 Months
Telecommuting not available Travel not required

Job Description

Title: Sr. ETL Developer (SSIS)

Duration: Full time/Contract

Location: Washington DC.

Term: Full time/Contract

Experience required: 9+ Years

Pay Rate: $100K

ONLY GC's and USC are eligible for this requirement 



Note: No Informatica Developers please. Client is looking for Microsoft SSIS /SSRS Developer. We are mainly looking for the candidates who has good knowledge on SSIS , DATA MATCHING , INCREMENTING LOADS.

*For an EOE*

*Local candidates strongly preferred

U.S. Citizens and those authorized to work in the U.S. are encouraged to apply. We are unable to sponsor at this time.

Typical Education and Experience: 

Bachelors or Master’s degree from an accredited institution.


Role Description:

Need a Senior ETL Consultant to design, develop, test and maintain a data warehouse; build ETL solutions based on business requirements, utilize existing technical capabilities and services in the organization and align new solutions to integration standards in the organization.

Candidate will be responsible for the design, development, administration and support of components used to extract, stage, standardize, cleanse, transform and load data from various internal and external data sources into the Enterprise Data Warehouse using SSIS.

Required Skills:

  • Ability to multi task and deliver high quality solutions in rapid agile releases.
  • Experience analyzing source data sets and provide work estimates.
  • Need deep data analysis and profiling skills; excellent troubleshooting skills.
  • Ensure solution addresses reusability, availability, integrity, and changing business requirements.
  • Sound understanding of data warehouse principles, Data Warehouse design and best practices.
  • Must have strong experience on SSAS and SSRS.
  • Experience with creating incremental and repeatable high quality data load procedures.
  • Implement ETL standards, conventions and best practices.
  • Experience developing high quality SCD packages and procedures.
  • Ability to implement repeatable data cleansing and data standardization steps and procedures within ETL routines.
  • Provide technical expertise with data integration, collection and documentation of metadata Components and information delivery.
  • Experienced in design and creation of data marts from various heterogeneous data sources.
  • Perform data matching on various data sources to create, update and populate the golden Record representing the most accurate and updated version of the truth.
  • Respond to time sensitive Ad Hoc data requests with high quality.
  • Work with enterprise data warehouse team to provide inputs on conceptual, logical, and Physical data models for data warehouse and data marts.
  • Document, design, develop, optimize and maintain reliable, repeatable and scalable ETL Packages and solutions utilizing SSIS.
  • Test, deploy and create customized job schedules, packages and solutions.
  • Provide expertise; implement solutions for ETL version control, deployment, configuration Develop technical design documents and mapping specifications to build ETL Mappings to load data into target tables.
  • Create and maintain data dictionaries and related schemas/models.
  • Ability to interact with technical staff and management with a view to provide business solutions.

Must Have :

  • SSIS

 ** Interested candidates please call Jeet on 703-834-6070 or email us at **

Dice Id : 10113544
Position Id : JE982015ETL
Have a Job? Post it

Similar Positions

SQL/ETL Developer
  • International Software Systems, Inc
  • Mclean, VA
Senior SQL Server Developer (F2F Interview Required)
  • USM Business Systems
  • Herndon, VA
T-SQL Developer / SQL BI Developer
  • Reliable Software Resources
  • Reston, VA
BI Developer
  • Amick Brown
  • Arlington, VA
BI SQL Server (Only W2)
  • SLiQ Information Technologies
  • Washington, DC
Senior SQL Develop-DEA-CPTS
  • Chenega Corporation
  • Sterling, VA
SQl Developer
  • Infinity Consulting Solutions
  • Washington, DC
SQL Database Developer
  • xScion Solutions
  • Arlington, VA
Back End Test - PL/SQL/T-SQL Developer
  • TrustedQA
  • Washington, DC
ETL Informatica Developer
  • Synechron Inc.
  • Sterling, VA
SSIS Data Analyst
  • InScope International, Inc.
  • Mclean, VA
Database Developer
  • Repeat Consultants LLC
  • Arlington, VA
SQL Database Developer
  • Robert Half Technology
  • Linthicum, MD
Business Intelligence (BI) Developer
  • Futrend Technology, Inc
  • Mclean, VA
SQL Database Development
  • APN Consulting Inc
  • Arlington, VA