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:-

1. This is a Full-Time Permanent job opportunity for you.
2. Only US Citizen, Green Card Holder, TN Visa, GC-EAD, H4-EAD & L2-EAD can apply.
3. No OPT-EAD & H1B Consultants please.
   
4. Please mention your Visa Status in your email or resume.