Kforce Data Warehouse SSIS SQL Developer in Wilmington, Delaware

Kforce's client, one the world's largest financial institutions, is building an Agile Data Warehouse Data Analytics Team in Wilmington, Delaware (DE) and they are looking for a Data Warehouse SSIS SQL Developer. Overview: The Agile team member's primary responsibilities will be to review and recommend data modeling approaches, develop SSIS packages, ETL processes, and advanced SQL server stored procedures into automated / functional processes during sprints. You will work closely with our technology partners in Business, Development and Quality Assurance to ensure that what we build validates the business intent of the product. The successful candidate will possess a strong engineering background and a working knowledge of automated agile methodologies. The successful candidate will also possess skills necessary to ensure successful coding and maintenance of automated unit, acceptance and regression tests with a focus on early automation. Responsibilities:

  • Accountable resource in providing analytical data expertise based on application and process knowledge to recommend solutions that meet the business need

  • Defines and assists development with designing technology based solutions to meet business requests within established technology frameworks

  • Provides estimates based on work effort and application knowledge

  • 5 years of experience in database design and implementation

  • Strong experience working in Agile methodologies and Scrum execution

  • Experience in leading technical projects in Development team

  • Experience working with geographically diverse team and coordinating with developers at diverse locations

  • Experience in researching and resolving data process issues

  • SQL Server, advanced stored procedures and SSIS package development

  • Developing test strategies, test plans based on functional specifications, use cases, and business requirements

  • Estimation of work based on effort and complexity

  • Proficiency in Visio, MS Word, MS Excel, and MS PowerPoint is required

  • Documenting and analyzing workflows and use cases, business rules, prototyping, data mapping and data modeling

  • Domain knowledge in Banking and Finance Services

  • Good communication skills

Preferred Skills:

  • Experience with Agile SDLC methodology

  • Automation scheduling experience with Control-M

  • Technical skills in Oracle Databases, Teradata and Unix

  • ETL extraction using Ab Initio, Spark, Hadoop

  • Data Modeling using Erwin

  • Exposure to web technologies (e.g. HTTP, XML, REST, HTML, etc.)

Kforce is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.Compensation Type:HoursMinimum Compensation:0.00Maximum Compensation:0.00