South Dakota Jobs

South Dakota Department of Labor & Regulation mobile logo

Job Information

Bancorp Bank Database Developer II in SIOUX FALLS, South Dakota

Database Developer II less thanb>Overviewless than/b>less thanp>less than/p>less thanp>less thanspan>Design, develop, and implement data integration packages for the organization. Perform a wide variety of database programming assignments and research/troubleshooting in T-SQL. Troubleshoot and maintain existing ETL packages. Become a subject matter expert in the organization's SSIS packages.less than/span>less than/p>less thanp>less thanb>Responsibilitiesless than/b>less than/p>less thanol>less thanli>less thanspan>Creates new Extraction, Transformation, and Loading (ETL) packages to achieve data integration between various source and destination systems including the Anti Money Laundering system Actimize.less than/span>less than/li>less thanli>less thanspan>Tests and debugs code using departmental standards and protocols prior to elevation.less than/span>less than/li>less thanli>less thanspan>Acts as a subject matter expert in the existing ETL packages used to load Actimize. Makes recommendations and implement improvements to the packages.less than/span>less than/li>less thanli>less thanspan>Reviews database design and code written by other database and application developers, identifies issues and discusses efficiencies to improve data integration code and/or controls.less than/span>less than/li>less thanli>less thanspan>Troubleshoots ETL issues as they arise by evaluating the ETL packages, source data and destination systems.less than/span>less than/li>less thanli>less thanspan>Develops, updates and maintains ETL specifications and documentation used to develop data migration mappings and transformations.less than/span>less than/li>less thanli>less thanspan>Performs other duties as assigned.less than/span>less than/li>less than/ol>less thanb>Qualificationsless than/b>less thanp>less than/p>less thanp>less thanspan>less thanstrong>Education/Experience Requirementsless than/strong>less than/span>less than/p>less thanul>less thanli>less thanspan>Undergraduate degree in a related field or an equivalent combination of training and experience.less than/span>less than/li>less thanli>less thanspan>Three years T-SQL and SQL Server Integration Services (SSIS) development experience.less than/span>less than/li>less than/ul>less thanp>less thanspan>less thanstrong>Preferred Requirementsless than/strong>less than/span>less than/p>less thanul>less thanli>less thanspan>Banking or financial services experience.less than/span>less than/li>less thanli>less thanspan>Working knowledge of Anti Money Laundering platforms and technologies such as Actimize.less than/span>less than/li>less thanli>less thanspan>Excellent verbal, written, and interpersonal communication skills.less than/span>less than/li>less thanli>less thanspan>Excellent analytical ability, judgement, and problem analysis techniques.less than/span>less than/li>less thanli>less thanspan>Ability to write and understand complex SQL queries.less than/span>less than/li>less thanli>less thanspan>Ability to take ownership of projects and be self-directed.less than/span>less than/li>less thanli>less thanspan>Ability to work effectively in a team fostered, multi-tasking environment.less than/span>less than/li>less than/ul>less thanp>less thanspan>Employment with The Bancorp includes successfully passing a background check including credit, criminal, OFAC, education and past employment.less than/span>less than/p>less thanp>less than/p>less thanp>less than/p>less thanp>less than/p>less thanp>less than/p>less thanbr>The Bancorp is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, religion, color, national origin, sex, sexual orientation, gender identity, age, status as a protected veteran, among other things, or status as a qualified individual with disability.less thanbr>less thanbr>The Bancorp is an Equal Opportunity Employerless thanbr>less thanbr>less thanbr>