Innovations technological

Phone/skype Hire

Location: Des Moines, IA

Duration: 12+ months

Rate: Open

The successful candidate will spend a good portion of their time working with source system data owners and analytics developers to design and develop dimensional databases and associated ETL packages.   While working on projects, the candidate is expected to propose, design, and develop solutions in concert with the other staff to fulfill the request.  The candidate will also be responsible for system testing and working with the business users during acceptance testing.  The successful candidate will be required to follow standard practices for migrating changes to the test and production environments and provide post production support.  When not working on enhancement requests or problem reports, the candidate would concentrate on performance tuning.

Skills Needed:

Experience in working with SQL Server 2005 and 2008 R2, Familiarity with SQL 2012           Required             5              Years

Expert knowledge of T-SQL         Required             5              Years

Experience in developing and optimizing complex stored procedures     Required             5              Years

Experience developing data extract (SSIS) packages from source normalized databases.                Required             5                Years

Database modeling and design, specifically dimensional database modeling/STAR Schema’s        Required             5                Years

Knowledge of SQL best practices              Required             5              Years

Knowledge of SQL best practices in regards Data Warehousing and Decision Support       Required             5              Years

Experience in building ETL processes using SQL Server Integration Services(SSIS)               Required             5              Years

Excellent problem solving skills (for debugging problem reports)               Required             5              Years

Experience in working with big databases ( over 100 GB)               Required             5              Years

Experience in working closely with Analytics developers                Required             5              Years

Knowledge of Business Intelligence Tools (e.g. OBIEE, Business Objects)               Required             5              Years

Experience with SDLC and Agile development practices Required             5              Years

Thanks

Sandeep

Sandeep Jain

Software People Inc.

www.softwarepeople.us

sandeep.jain@softwarepeople.us

Ph: 631-863-0299, 631-410-4741, 631-921-2111 ©

Fax: 631-574-3122

Certifications: SBA 8a/SDB, NY MWBE, VA SWaM, DE OMWBE, MA MWBE