Epic SSIS Developer 6211270

Accenture•Dallas, TX

37d•$54 - $58•Onsite

About The Position

Accenture Flex offers you the flexibility of local fixed-duration project-based work powered by Accenture, a leading global professional services company. Accenture is consistently recognized on FORTUNE's 100 Best Companies to Work For and Diversity Inc's Top 50 Companies For Diversity lists. As an Accenture Flex employee, you will apply your skills and experience to help drive business transformation for leading organizations and communities. In addition to delivering innovative solutions for Accenture's clients, you will work with a highly skilled, diverse network of people across Accenture businesses who are using the latest emerging technologies to address today's biggest business challenges. You will receive competitive rewards and access to benefits programs and world-class learning resources. Accenture Flex employees work in their local metro area onsite at the project, significantly reducing and/or eliminating the demands to travel. Job Description: Design and develop SQL Server stored procedures, functions, views and triggers to be used during the ETL process Designing and developing SSIS / SQL ETL solutions to acquire and prepare data from numerous upstream systems for processing by QRM Builds data transformations with SSIS including importing data from files, moving data from one database platform to another Debug and tune SSIS or other ETL processes to ensure accurate and efficient movement of data Design, implement and maintain database objects (tables, views, indexes, ) and database security Experience working with SSIS packages Proficient with ETL tools such as Microsoft SSIS Analyze and develop strategies and approaches to import and transfer data between source, staging, and ODS/Data Warehouse destinations Test and prepare ETL processes for deployment to production and non-production environments Support system and acceptance testing including the development or refinement of test plans

Requirements

2 years experience in SSIS build
1 year experience with Epic Reporting e.g., Clarity
High school diploma or GED
Experience working with SSIS packages
Proficient with ETL tools such as Microsoft SSIS

Nice To Haves

Experience with onshore and offshore work
Management experience

Responsibilities

Design and develop SQL Server stored procedures, functions, views and triggers to be used during the ETL process
Designing and developing SSIS / SQL ETL solutions to acquire and prepare data from numerous upstream systems for processing by QRM
Builds data transformations with SSIS including importing data from files, moving data from one database platform to another
Debug and tune SSIS or other ETL processes to ensure accurate and efficient movement of data
Design, implement and maintain database objects (tables, views, indexes, ) and database security
Analyze and develop strategies and approaches to import and transfer data between source, staging, and ODS/Data Warehouse destinations
Test and prepare ETL processes for deployment to production and non-production environments
Support system and acceptance testing including the development or refinement of test plans