Position Title: SSIS Developer
Location: Lake Forest, CA (Remote)
Employment Type: W2
Duration: 7 to 12 months+
POSITION’S GENERAL DUTIES AND TASKS :
Duties
· Design, Development, Implementation of Data Migration and SSIS Application development projects and build across Development, QA and PROD environments.
· Works independently and follow the agile methodology and processes.
· Create and analyze Stored procedures.
· Work with SQL Database team on performance improvement and optimization of SQL server packages.
· Interacting with clients and handling their data analysis requests. Providing timely solution to the client’s queries and issues.
· Performing Root Cause analysis and resolving incidents to improve the performance of the system.
· Document ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, prepared test data for testing, error handling and analysis.
· Coordinating with various teams to minimize the impact on high – priority jobs during critical issues. Meet project deadlines and deliverables by following up on resolving dependencies on timely basis.
Requirement:
· Good experience of working in Agile methodologies
· Expertise in performance tuning of SSIS modules.
· Good knowledge in Data warehousing concepts