Required Skills

ETL Developer

Work Authorization

  • US Citizen

  • Green Card

  • EAD (OPT/CPT/GC/H4)

  • H1B Work Permit

Preferred Employment

  • Corp-Corp

  • W2-Permanent

  • W2-Contract

  • Contract to Hire

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 31st Jan 2024

JOB DETAIL

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

Company Information