Job Seekers, Please send resumes to resumes@hireitpeople.com Mandatory skills:Heavy Stored ProceduresCursorsData Validation skillsData Profiling skills
Detailed job description:SQL Stored Procedures dev for data warehouse product used by educational institutions for student and teacher analytics. Client is landing several new customers (new school districts) each month.  Need to integrated each client's data with the district, state and local educational data to provide metrics and trend analytics to improve student test scores and improve teacher performance.   
Responsibilities :Involve in complete Software Development Life Cycle, project Architecture definition, business object and design.Interfacing with business client for requirement gathering.Assist all business partners, business analysts, business relationship managers to analyze changes in requirements and provide solutions for enhancements to all applications.Use a combination of process modeling, data modeling, data analysis, information engineering and sampling to ensure concise and comprehensive requirements.Perform Data analysis, mapping, cleansing and profiling.Write complex SQL stored procedures, functions and cursors to manipulate data.Developing and implementing data collection systems, data analytics and other strategies that optimize efficiency and quality.Acquiring data from primary and secondary sources and mapping of dataDefine best fit implementation methodology based on best practices.Maintain working knowledge of current state software development tools and methods, software testing methodologies, and research emerging trends in application product development space.Mentoring System Analysts and others on the project team.Work with all stakeholders being impacted by business system and/or business process changes, where applicable, to ensure all changes are managed back into the business in a way that minimizes impact to the customer.In the spirit of continuous improvement, challenge the status quo and challenge others to rethink current processes, structures, policies, methodologies, and assumptions related to role of ETL Developer.Participate in stand-ups on daily design and development effort.
Education:Bachelor’s degree or equivalent in Computer Science, Information Systems, or closely related field with relevant experience.