Carrer

Required:

6+ years of SQL Server 2008,2012. Preferably 2+ years in SQL server 2012 experience

2-4+ years of experience using SSIS ETL Tool– preferably in SSIS 2012.

Desired:

Collections and Recoveries Domain Expertise in a large organization

Experience with large enterprise class Collections Applications (CR Software's Titanium ORE preferred but others considered ie CUBS)

Job Description

The ETL developer will manage the development of a range of interfaces to be built around the new application to various other strategic component of the new solution.  Other responsibilities include, but are not limited to:

Analyzing the existing DB structure, file system, or any other source of data

Develop procedures in SQL Server. Have extensive knowledge of SQL Server database development concepts such as common table expressions, nested sub queries, indexed views, table partitioning, windowed functions, and aggregate functions.

Writing ETL to load from flat file to database with complex transformation and business rules and vice versa

Worked in SDLC life cycle with Agile delivery method

Design, Develop, Test and Deploy ETL mappings using SSIS 

Perform gap analysis of disparate systems, and develop conforming dimensions, members, hierarchies, business calculations, elements, attributes based on business requirements.

Liaising with the other application teams

Use ad-hoc queries to investigate data issues in relational source systems

Complete quality delivery on time

Analyze current and potential systems for conversions and product integration scenarios.

Writing complex SQL queries and strong sql query knowledge

Experience in creating job design documents, unit test and migration documents.

Good communication and writing skills

Qualifications and Education Requirements:

Bachelor or Master degree in computer Science or relevant

Certification in SQL Server and SSIS