Data Developer

Sr. ETL Database Developer for its direct client. (Minneapolis, MN)

Date: 2012-09-26, 12:19PM CDT

*****.******@*****.***

ocation: Minneapolis, MN

Duration : 6 Months

Description:

Sr ETL/Database developer will be responsible for analysis, design specifications, development, implementation and maintenance of SSIS packages that are require migrating data from source systems to warehouse systems in a BI environment.

Develop cross validation rules to ensure mapping accuracy.

Work closely with Data Architect to enable data governance strategy and overall Business Intelligence vision and strategy.

Create ETL that supports the logical data model in Microsoft Business Intelligence environment and/or SAP Business Objects environment.

Work with business users, other IT team members (Source system SMEs and managers) and management to ensure delivery of quality ETL in a timely basis

Conduct root cause analysis and resolve production problems and data issues as necessary.

Participate in requirement gathering meetings to understand the business problem and help data architect with data modeling.

Educate the Business Intelligence team with best practices and develop optimization plan for ETL.

POSITION REQUIREMENTS - SKILLS AND EXPERIENCE:

BA/BS degree (CS or MIS preferred) or equivalent experience

Strong SQL Server (2008) skills (2+yrs).

Transact-SQL, replication, DTS/SSIS packages, SQL Agent jobs, SQL Reporting Services, and ActiveX scripting(3+ yrs).

Experience in data modeling using, CA ERwin, or, Sparx EA, Embarcadero or other data modeling tools (3+yrs).

Other software the applicant should be familiar with include, Visual Studio

.NET, Microsoft Office Suite (Word, Access, and Excel), Windows Operating

Systems, Windows Server Applications (IIS, Cluster Administrator, Terminal

Services).

Preferred

Working knowledge and successful use of Agile methodology

Experience developing simple ASP.NET web applications. (4+ yrs).

Contact this candidate