Job Detail

Client Name : Confidential     Website
Job Duration : 4 (months)
Job NO : Confidential201905174
Job Location : Confidential, Austin TX 78731
Job Closing Date : 06/21/2019
Job Description :

Data Manager - 4 Month W2/Onsite Contract -= Austin, TX 78731

ob Description: 
DataManager to provides technical expertise in identification, data modeling, data movement and transformation mapping (source to target), automation and contribute in data testing strategies. Translating business needs into technical solutions with adherence to established data guidelines and approaches from a business unit or project perspective. Understands and leverages best fit technologies (e.g., traditional star schema structures, cloud) and approaches to address business and environmental challenges. 
Actively participates with other consultants in problem solving and approach development. 

Job Responsibilities 
• Understand the business need and derive the data flow, conceptual, logical, and physical data models based on those needs 
• Perform data analysis to validate data models and to confirm ability to meet business needs. 
• Design and structure Database according to the business needs and refactor existing Database where required. 
• Help migrate and cleanse data from existing systems to new systems 
• Collaborate with team to bring up optimized SQL statements 
• Ensure performance, security, and availability of databases using SQL Server 
• Assist in the preparation of designs and technical and/or functional specifications. 
• Perform code reviews and work with teammates in accordance with company coding standards and best practices. 
• Perform data related activities with data management tools like master data management, data governance and metadata management 

Minimum Skills Requirement in years
Years Skills/Experience
5 Enterprise Application Architecture
8 Data architecture, data modelling, and DB development experience
Strong • Master of database structuring and querying having first-hand experience in designing complex database systems.
Strong • Thorough experience with MS SQL Server - designing, developing, administrating. Including latest version and different flavors.
Yes • Preferred experience in working with a CRM database.
Strong • Thorough with T-SQL semantics, stored procedures, and database connectivity libraries
Yes • Knowledge of OLTP and OLAP Databases
Yes • Ability to communicate complex technical ideas, regardless of the technical capacity of the audience
Yes • Understanding of modern database capabilities (SQL + NoSQL) and technologies such as real-time, cloud, Big Data.
Yes • Experience with Agile Development Practices, particularly Scrum.
Strong • Very strong proficiency with SQL . Skilled at optimizing large complicated SQL statements
Yes • Capable of troubleshooting and solving database issues
Yes • Understanding Disaster Recovery Concepts and High Availability concepts
Strong • Advanced knowledge and hands on experience of key technical concepts, such as: logical and physical data modeling, performance tuning, code reviews process, data normalization processes, data integration methods,
Strong • Proficient understanding of code versioning tools, such as VSTS
Yes • Experience with VSTS and deploying Scripts
Yes • PCI experience
Yes • Powershell script experience