MSBI SSIS Consultant

Sonsoft Inc

Apply to this job
Atlanta, GA, us on site Until 8/22/2026 H-1B sponsor history First posted February 25, 2026 Last posted February 25, 2026
Job 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.

  • At least 4+ years of experience in software development life cycle
  • At least 4+ years of experience in DW/BI/Reporting and related technologies and tools - MUST
  • At least 4+ years of experience in Project life cycle activities on DW/BI/Reporting development and maintenance projects
  • At least 3+ years of experience in Design and Architecture review, understanding of Data Modeling concepts
  • At least 3+ years of hands on experience in Design, Development & Build activities in SSIS Suite Projects
  • Knowledge of SSIS Architecture, Data integration design and DB concepts, working experience in other tools preferred
  • Creating packages to perform data integration including CDC, snapshots
  • Creating of standard filters, calculations, lookups and conditions.
  • Proactively keep abreast of new techniques and practices utilizing the SSIS toolset
  • Knowledge Best Practices in SSIS, Performance improvements including scheduling and job monitoring
  • Understanding of Unix/Linux system, file systems, shell scripting
  • 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 Financial domain
  • Strong analytical skills
  • Bachelor’s degree or foreign equivalent required from an accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education.
  • At least 4 years of experience in IT industry.

** 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-EADH4-EAD & L2-EAD can apply.
  3. No OPT-EAD & H1B Consultants please.
  4. Please mention your Visa Status in your email or resume.
About this role

Summary

Develop and maintain data integration solutions using SSIS in a BI/warehouse environment.

Job title

MSBI SSIS Consultant

Experience level

4+ years

Industry

software

Location requirements

Atlanta, GA, USA; no remote work allowed

Salary

Not specified

Visa sponsorship

H-1B sponsor history

Management role

No

Skills & keywords

Required skills

software development life cycleDW/BI/ReportingSSISData ModelingETL/ELTUnix/Linuxshell scriptingperformance tuning

Preferred skills

Data integration designproject cycle activitiesfinancial domaindata architecture

Specializations

MSBISSISETLData warehousingBI
Locations

Structured locations inferred from the posting.

Atlanta, GA, USA

On-site City