The Role
Design, develop and maintain SSIS ETL packages for DW/BI/reporting projects. Perform data integration (CDC, snapshots), data modeling, performance tuning, scheduling/job monitoring, and collaborate with stakeholders in financial domain to troubleshoot and implement ETL/ELT frameworks.
Summary Generated by Built In
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.
- 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:-
- 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.
Skills Required
- 4+ years experience in software development life cycle
- 4+ years experience in DW/BI/Reporting and related technologies and tools
- 4+ years experience in project lifecycle activities for DW/BI/reporting development and maintenance
- 3+ years experience in design and architecture review; understanding of data modeling concepts
- 3+ years hands-on experience in design, development and build activities in SSIS projects
- Knowledge of SSIS architecture, data integration design and database concepts
- Working experience in other BI/ETL tools (preferred)
- Creating SSIS packages for data integration including CDC and snapshots
- Creating standard filters, calculations, lookups and conditions
- Adopt and apply SSIS best practices and performance improvements including scheduling and job monitoring
- Understanding of Unix/Linux systems, file systems and shell scripting
- Design and implementation experience of ETL/ELT frameworks for complex warehouses/marts
- Hands-on development mentality and troubleshooting skills
- Ability to work in a team with diverse/multiple stakeholders
- Experience in Financial domain
- Strong analytical skills
- Bachelor's degree or foreign equivalent (or equivalent progressive experience)
- At least 4 years of experience in the IT industry
- Authorization to work in the U.S. (US Citizen, Green Card, TN, GC-EAD, H4-EAD, or L2-EAD); employer cannot sponsor visas
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
SonSoft Inc. is a global consulting and IT services firm specializing in software development, software consultancy, and Information Technology Enabled Services (ITES). The company provides a range of expertise including business consulting, systems integration, application development, and product engineering, helping clients re-engineer and re-invent their businesses to compete in a changing marketplace.
