ETL/SSIS Developer

 
Location: Harrisburg, Pennsylvania
Posted On: 3/20/2017
Job Code: ETL_SSIS_PA
Print
ALL ALL ALL
 
Job Description
 
Title : ETL/SSIS Developer
Location : Harrisburg, PA
Duration : 6+ Months

Required skills and Experience
- Minimum 3 years of experience designing, developing, testing, and implementing ETL solutions using any enterprise ETL tools (SSIS).
- 3+ years of experience working with high volume data bases and/or big data.
- Bachelor's degree in information systems or business management.

Responsible for
- Develop, design, tune and maintain SSIS packages to perform the ETL process.
- Design and develop SQL Server stored procedures, functions, views and triggers to be used during the ETL process.
- Design and develop ETL solutions using data integration tools for interfacing between source application and the Enterprise Data Warehouse.
- Develops ETL technical specifications, designs, develops, tests, implements, and supports optimal data solutions.
- Documents ETL data mappings, data dictionaries, processes, programs and solutions as per established standards for data governance.
- Integrates ETL development with existing projects to maximize object reuse.
- Creates, executes, and documents unit test plans for ETL and data integration processes and programs.

Work with the data analysis team to assess and troubleshoot potential data quality issues at key intake points such as validating control totals at intake.
- Perform problem assessment, resolution and documentation in existing ETL packages, mapping and workflows in production
- Troubleshoot data issues and defects to determine root cause.
- Performance tuning of the ETL process and SQL queries, and recommend and implement ETL and query tuning techniques.
- Develop and create transformation queries, views, and stored procedures for ETL processes, and process automations.
Category:IT  code:new
 
 
Job Requirements
 
 
ETL, SSIS, Sql
 

Not Ready to Apply?
Contact Details
 
Recruiter
Gaurav Jadhav
 
Phone
 
E-mail Address
 
LinkedIn