SQL Server Data Architect
Austin, TX, United States On-site
Salary not listedJobFig found this opening at its original source and checks that it remains available.
About the role
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 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 .
What you'll bring
- 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.
- Experience with SQL Server features like store indexes/partitioning, in live projects
- Good experience on SSRS