US Citizen
Green Card
EAD (OPT/CPT/GC/H4)
H1B Work Permit
Corp-Corp
W2-Permanent
W2-Contract
Contract to Hire
Consulting/Contract
UG :- - Not Required
PG :- - Not Required
No of position :- ( 1 )
Post :- 31st Jan 2024
Responsibilities:* Designing and developing SSIS/SQL ETL solutions to acquire and prepare data from numerous upstream systems for processing* Builds data transformations with SSIS including importing data from files, moving data from one database platform to another* Design and develop SQL Server stored procedures, functions, views, and triggers to be used during the ETL process; Test and prepare ETL processes for deployment to production and non-production environments* Design, implement and maintain database objects (tables, views, indexes) and database security* Conduct Data flow performance testing and support system and acceptance testing including the development or refinement of test plans* Support resolution of incidents and execution of approved change requests; Conduct problem root cause analysis and isolate system problems utilizing diagnostic and system management tools (i.e. system dumps and system/component traces, monitoring tools, vendor problem databases)* Maintain security hardened baseline configurations and deploy security (patches), software maintenance (patches) and new software releases and supporting products infrastructure as directed* Support the engineering, integration, implementation, and operation of a virtualization strategy to include Database server consolidation, storage consolidation, and automation; Automation includes seamless Database provisioning, and non-disruptive workflow/application/data migrations* Maintain up-to-date documentation of all procedures, infrastructure diagrams, system configuration and baseline standards, implementation plans, system back out plans, system recovery plans, maintenance plans, system upgrades, and all system changes