Company : SCA Technologies LLC
Location : Gurgaon
Experience : 3 – 6 yrs.
Database Team at SCA works with Client Data startingcollection phase, validation phase up to final integration of this data with our system. Database team also works very closely with development team to providethe database related support in product development including writing complex SPs, managing Database schema and supporting in SSRS as well. Database team work directly on client data and also on product development environmentthey provide the expert support fordata related activities including migration, integration, and high level of validation. Our typical client projects/product development cycle lasts 6 to 12 weeks. The team often has specialistsdifferent disciplines with defined deliverablesthe respective areas. Database professional works on multiple activities including initial data receiptclient, uploading the data into system, performing data validation and supporting development team with SPs or other Database objects.
Accountabilities / Responsibilities
Deliver on milestones for project.
Take complete ownership of maintenance and sustenance issues of product.
Use best practices and knowledge of internal or external business issues to improve product or services, takes new perspectives.
Develops recommendation for clients, provides informal guidance to junior
Works independently, with guidance in only most complex situations.
Adhere to the standard software development guidelines and coding standards
Take review/feedbackTeam lead and manager for the analysis/design, coding, unit testing of the assigned task.
Report time and task status consistently and reliably.
Communicate and function efficiently within a team environment. Establish external communication with other stakeholders.
Be available on job, as and when required for any critical delivery
Take responsibility for quality and timeline of the work performed and takes ownership ofassigned activities and milestones.
Suggests and implements improvements to Module’s processes and products
Accountable for efficient, high-quality and timely delivery of work products
Develops and communicates the Module’s schedules, plans, and risks
Needs to provide quick solutions to problems and taking a feature /component through the entire life cycle, improve the space – time performance, and improve on usability / reliability.
Design, write, test, and debug database stored procedures and complex queries to extract, calculate or manipulate information using SQL-Server 2000 /2005/2008 database
Adhere to the time-lines set for delivery items, for different Product release and Customer releases.
Design and implement SSIS packages, to fulfill different Product Requirement.
Design and execute migration and integration of data and DB Objectslegacy systems to new applications and new technologies.
Take the ownership of activities assigned to them.
Working in a team environment to process and analyze large data sets
Take responsibility for the accuracy and quality of the work performed and takes ownership ofassigned projects
Documentthe Database related processes and activities, which are assigned to him
BE/MCA with reputed institute, with Computer Science/Mechanical/ Mathematics/Chemical as preferable engineering background
Minimum 3 to 6 years experience in working with large data sets preferably in ERP/ MRP manufacturing and/or distribution environment
Experience to work with large data sets i.e. ERP/SCM/Manufacturing/distribution environment
Expert in Design, write, test, and debug database stored procedures and complex queries to extract, calculate or manipulate information using SQL-Server 2000 /2005/2008 database (MUST)
Expert in migration and integration of data and DB Objectslegacy systems to new applications and new technologies.
Good hand on Experience with optimizing data queries for improving performance
Good hand on Experience with ETL tools (SSIS)
Experience in conducting analytics with SQL and Excel
Develop conceptual data models and relational data structures
Strong analytical capabilities
Some exposure to writing macros in Excel
Expert in use of SQL toolsProfiler / Activity Monitor
Ability to stay organized in a dynamic work environment.
Possess a positive attitude.
Ability to “think outside the box”.
Self motivated showing an attention to detail and focus on task completion
Designs communication framework
Influences immediate team
Reference : fresherstask.com