Note :: Please look for experience into both MS SQL and Singlestore DB Knowledge (Formerly Memsql) mandatory for this role.
MSSQL and SSIS Responsibilities :(6-8 Yrs )
- 6+ years of experience with SSIS ETL designing, developing and implementing SSIS using Microsoft Solutions (.Net)
- Experience using SSIS for ETL handling file loads ,email task, map drive , script task etc.
- SQL agent Jobs.
- 7+ years of experience with Strong technical skills using SQL Server and TSQL.
- Knowledge in MSSQL metadata querying.
- Responsible for data profiling SQL and database objects tuning / optimization.
Singlestore (Former MEMSQL):
- 3+ Working experience in MEMSQL as a developer .
- Experience is using Toad .
- Should be well versed with SQL Objects ,querying ,debugging and data profiling in MemSQL.
Others:
- Demonstrated experience working with client.
- Experience in guiding team member technically.
- Experience is gathering requirements ,provide solutioning and efforts estimates(SDLC).
- Good understanding on data pipe lines .
- Experience in working with distributed development teams.
- .Net C# programming Knowledge awareness.
Good to have not mandatory:
- Powershell , Shell script.
- Service now incident and change management.
- Understanding of Tivoli scheduling .Roles and Responsibilities
Desired Candidate Profile
Perks and Benefits