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.