Database Architecture with SQL Server Database Modeling

Company Description Sonsoft , Inc. is a USA based corporation duly organized under the laws of the Commonwealth of Georgia. Sonsoft Inc. is growing at a steady pace specializing in the fields of Software Development, Software Consultancy and Information Technology Enabled Services.

Job Description

Preferred:

• Experience with SQL Server features like store indexes/partitioning, in live projects
• Good experience on SSRS
• Data warehousing knowledge and background
• Asp.net or MVC experience
• Experience with design and implementation of ETL/ELT framework for complex warehouses/marts
• Hands-on development mentality, with a willingness to troubleshoot and solve complex problems
• Ability to work in team in diverse/ multiple stakeholder environment
• Experience in Finance domain
• Strong analytical skills
• High impact communication
• Ability to ramp up in new technologies
• Experience and desire to work in a Global delivery environment.

Qualifications

Qualifications

Basic:

• Bachelor’s degree or foreign equivalent required from an accredited institution. Will also consider one year of relevant work experience in lieu of every year of education.
• At least 7 years of working experience with SQL Server and MSBI suite, especially SSIS.
• At least 5 years of experience working with SQL.
• Strong Knowledge of Dimensional Modelling, DW architecture, ETL Frameworks, Design and Development using MSBI Suite
• At least 4 years of hands on experience in Development & Build activities in MSBI - MUST.
• Experience in performance tuning for MSBI jobs especially SSIS – MUST.
• Must have experience in analyzing existing ETL and BI processes, suggesting and implementing performance improvement measures.
• Experience in conducting code reviews and providing guidance to development team
• Very good understanding of SQL Server is MUST and good knowledge on other major RDBM systems, i.e., DB2, Oracle. Additional Information ** U.S. citizens and those authorized to work in the U.S. are encouraged to apply. We are unable to sponsor at this time. Note:-
• This is a Full-Time Permanent job opportunity for you.
• Only US Citizen, Green Card Holder, TN Visa, GC-EAD, H4-EAD & L2-EAD can apply.
• No OPT-EAD & H1B Consultants please.
• Please mention your Visa Status in your email or resume.