Job Description :
Title: SQL Developer

Location: 6+ Months

Duration: Mountain, View, CA

Interview Mode: Face to Face



Job Description:

10+ Years’ experience.

Provides ongoing improvement of support processes. Ensures solutions align with vision, principles, architecture, and standards. Ensures information protection and security. Evaluates and recommends system upgrades and capacity adjustments

Designs data model and processes for new content and/or optimized performance of an analytical solution from ingestion to consumption by end user

Delivers viable relational and dimensional models that conform and integrate in the approved target architecture

Assess business requirements and data sources to determine the best design to ingest, transform, structure, and provide data for analytics tools

Works with the data foundation owner to validate design and integration of new content

Provides data design artifacts and documentation

Contributes to the application lifecycle management of including planning and implementing migration to the cloud



· MANDATORY SKILLS

· Experience in data architecture

· 5+ Experience in the following:

o experience in data modeling

o creating and implementing relational and dimensional data models

· Experience with analytics solution architecture and analytics solutions development

· Experience with creating and implementing data designs

· Experience with data integration between systems – ETL strategies, SSIS, SSRS

· Experience with traditional BI and/or big data ecosystems

· Experience working within Software Development Lifecycle is required - working with Agile methods is a plus

· Proficiency with Microsoft SQL Server, SQL and SQL Scripting, T-SQL, SQL Server Management Studio, SSIS, TFS (Team Foundation Server)

· Knowledge of data warehousing philosophies (Kimball/Inmon) to execute data management strategy

· Strong understanding of relational and dimensional modeling

· Understanding of SQL Server performance and ability to design to minimize performance issues and investigate and resolve

· Understanding of Data Governance and Data Quality and the application of these concepts to Data Architecture

· Education: Bachelor’s Degree in Computer Science, Computer Information Systems or equivalent

Soft skills

· Learning agility: can work productively in uncertain and fast changing environments. Finds opportunities in ambiguity; embraces and adapts to change; adept at learning by doing

· Strong analytical thinking and problem solving: Knowledge of techniques and tools that promote effective analysis, determine the root cause of problems and create alternative solutions to solve them in the best interest of the business

· Communication: Clear, concise communication capabilities tailored to audience; Effective in translating business requirements into technical specifications; Effective in explaining IT solution in business terms







Full Name (AS per Passport/SSN):


Contact Number [All]:


Email


Availability:


Expected Rate/Salary


Current Location:


Relocation Issues (If Any):


Visa Status & Validity:


Total Experience:


Relevant Experience:


Currently Working [Y/N]:


Any Offer or Interview in Pipeline:


Best Time to Call :


DOB


SSN


Skype ID


Educational Details:

Name of Degree (Highest Degree):


Specialization:


University:


LinkedIn