Dear Partners/Job Seekers
One of our JobPencil’s
customer has direct client opening for Front End Developer requirement, if
you have matching candidates please submit their profiles to
ad...@jobpencil.com or contact JobPencil service team for more details.
*Sr. SQL DEVELOPER*
*12 Months*
*Columbia SC*
*Telephonic*
*CLIENT: STATE OF SC*
*Req Id : 5685*
*Job Description:*
Candidates must be experienced developers having performed SQL Development
(Stored Procedures, Functions, etc.) and data conversion and integration
(SSIS) on multiple projects during their employment history. The SQL
Developer will be responsible for developing applications and integrations
using the Microsoft SQL Server platform. This will include reports, vendor
exports, data warehousing tasks and other data related tasks. This position
requires excellent communication, technical and project management skills.
*Job Duties:*
Take initiative in performance, working independently and with groups to
effectively accomplish project objectives and engage in the following:
• Identifying, extracting and transforming required data based on business
requirements and following data governance standards
• Manually migrating required data from the legacy system data by analyzing
and mapping existing data to a new solution
• Working closely with legacy data teams and the SI/vendor teams to ensure
the right data is migrated
• Performing detailed data analysis and data profiling supporting the
development and implementation of data cleanse/create processes and other
strategies that optimize data quality
• Understanding performance, quality, and schedule considerations
• Interpreting complex data and communicate it in an effective manner,
leveraging advanced reporting techniques
• Recognizing data patterns, quantify potential issues, and identify
solutions
• Standardizing, harmonizing, cleaning, preparing, and using data for
datasets development, reporting, and analysis
• Providing support to the project team in terms of technical specification
and build of Interface and Conversion objects
• Developing and maintaining enterprise data authoritative ownership and
stewardship metadata
• Communicating and supporting the implementation of corporate policies,
standards, and procedures that provide effective architecture, governance,
and management of the organization’s information/data assets
• Developing and maintaining effective and efficient information
architecture and data ownership awareness and training programs
• Monitoring regulatory and compliance guidelines (such as data retention
and audit requirements) to determine impact on enterprise information
architecture.
*Required Qualifications:*
• BE or BS Degree in one of the following subject areas: Computer Science,
Business Administration, Information Technology or related field preferred.
• 8+ years Microsoft SQL Server experience; must demonstrated direct
experience in the use of MS SQL 2005, 2008, 2008 R2, SSIS, SSRS, SSAS, and
ErWin Data Modeler.
• 8+ years IT operation with strong understanding of database structures,
theories, principles, and practices.
• Understanding of, and experience with, server-client computing and
relational database environments.
• Experience with data management and data processing flowcharting
techniques.
• Knowledge of reporting and query tools and practices.
• Good understanding of the organizations goals and objectives.
• Good interpersonal, written, and oral communication skills
• Technical documentation skills.
• Ability to present ideas in user-friendly language.
• Self-motivated and directed, with keen attention to detail.
• Able to prioritize and execute tasks in a high-pressure environment.
• Experience working in a team-oriented, collaborative environment.
*Required - Environments and Tools:*
• MS Server 2008 enterprise server, MS SQL 2008 R2 enterprise server and MS
SQL 2008 enterprise server Reporting Services
• TFS (Team Foundation Server)
• Microsoft Visual Studio 2010, 2012 Ultimate
• C#, .ASP.net, .NET
• SubVersion (Source Control)
• Java Script
• SSRS
• NHibernate, CA-ErWin data model
*Desired Qualifications:*
• Preference will be given to experience related to Child Support
Enforcement system design and developed and/or knowledge of the Child
Support Enforcement program's mission and objectives
• Experience with Agile software development is a plus.
Skill Matrix:
Skills
Required
Actual years of Experince
MS SQL Server 2008 enterprise server
Yes
MS SQL Server 2008 R2
Yes
SQL Server Reporting Services (SSRS)
Yes
Team Foundation Server (TFS) 2012
Yes
Agile
No
CA ERwin Data Modeler (ERwin)
Yes
SubVersion (Source Control)
Yes
MS VISUAL STUDIO 2012
Yes
.Net
Yes
ASP.NET <http://asp.net/>
Yes
C#
Yes
JavaScript
Yes
Visual Stuidio (VS) 2010
Yes
NHibernate
Yes
Child Support Enforcement System (CSES)
No
Regards,
JobPencil Service Team
Web: www.JobPencil.com
Phone: 614-656-1943
Fax: 614-388-5556
Email: ad...@jobpencil.com
--
You received this message because you are subscribed to the Google Groups
"MCMS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to mcms+unsubscr...@googlegroups.com.
To post to this group, send email to mcms@googlegroups.com.
Visit this group at http://groups.google.com/group/mcms.
For more options, visit https://groups.google.com/d/optout.
