Job Detail
MS SQL TSQL Programmer Analyst who can also do QA Testing. Contract.
Responsible for development in custom systems used for data analysis and reporting.
This position also involves a significant amount of data analysis, problem resolution, and processing. The candidate must also be comfortable in an IT Operational role of setting up systems with data to drive applications and processes. In addition, the candidate should be able to provide technical support to the QA team.
MSSQL Server T-SQL development skills are required.
Development Duties include, but are not limited to the following:? Design stored procedures for data warehouse and customer reporting.
? Develop and test program components in accordance with adopted standards.
? Ensure the quality of the source code and conducts source code peer review.
? Provide task estimates to project manager and the development team.
? Work closely with DBA/Architect to identify areas for optimization.
? Work closely with assigned leads on projects to accomplish tasks, either .NET related or DB related
? Work closely with application developers to implement database code paired with an application
? Work closely with the QA team to create, optimize and execute code to verify data and reports.
? Participate in requirements, design and code reviews.
? Utilize established standards, guidelines, and procedures in development
Analysis duties include, but are not limited to the following:? Troubleshoot and design fixes for data related problems.
? Analyze integrity of data imported from external sources.
? Identify and fix data that does not conform to business rules
? Develop ad-hoc queries as needed to resolve problems/questions
? Ability to analyze and understand current application structures and apply new functionality within prescribed frameworks
? Contribute to defining a test approach/strategy
Processing duties include, but are not limited to the following:
? Develop processing code and procedures
? Execute procedures to process live-data during production times
? Develop ad-hoc queries as needed by internal groups
Requirements:
? Experience in developing MS SQL Server stored procedures and UDF’s.
? High-level knowledge of database design.
? Experience in Data Warehouse and Data Processing environment.
? Experience with Microsoft .NET environment.
? Experience with Visual Studio 2003/2005/2008/2010 a plus.
? Experience with Crystal Reports, ActiveReports and/or other reporting tools.
? Experience writing highly scalable database code a must
? Experience and applied knowledge of Quality Assurance and Testing best practices
? Understanding and working knowledge of different types of testing
Contact UsSubmit Resume