Previous Job
Previous
ETL Developer - 18-01247
Ref No.: 18-01247
Location: Woburn, Massachusetts
Position Type:Contract
Start Date / End Date: 05/28/2018 to 12/31/2018
Our client is seeking an ETL Developer.

The ETL Developer provides expertise in data mapping from transactional application to data warehouse and creation of Extract, Transform and Load ( "ETL”) software programs.
The incumbent will be responsible for designing, developing, testing and documenting ETL programs.
The incumbent will be responsible for creating and maintaining logical and physical data models using established enterprise tools and best practices.
The incumbent is expected to have solid understanding of database design principles as well as database administration methods and techniques.

RESPONSIBILITIES:
  • Develop and maintain ETL processes that meet project-specific business and technical requirements and those of the overall enterprise data warehouse data integration portfolio
  • Document all processes and support source code control using standard tools and processes
  • Perform transactional applications (source) to data warehouse (target) data mapping
  • Maintain current knowledge of the technology industry, including leading tools and best practices
  • Perform data integrity checks and data validations
  • Assist with ensuring the integrity and performance of data structures
  • Set standards for technical documentation
REQUIREMENTS:
  • Experience with SQL Server Integration Services (SSIS).
  • Experience with SQL Server 2012/2014.
  • Experience in writing moderate SQL, Views, stored procedures in MS SQL Server o Responsibilities
  • Maintain reports developed in SSRS and implement changes as needed.
  • Provide technical support for all SSRS internal clients.
  • Function as the Subject Matter Expert regarding SSRS related matters.
  • Design, troubleshoot and optimize SSIS and ETL packages to meet business needs
  • Design, troubleshoot and optimize SSRS reports to meet business needs
  • Performance tuning, ongoing maintenance, security, production support, migration.
  • Troubleshoot data issues, validate results sets, and perform unit testing
  • Recommend and implement process improvements • Track and provide development estimates on projects and tasks