• 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 :- 9th Feb 2024

Deregulated Retail Energy (ERCOT, PJM, NYISO, NEPOOL) experience strongly preferred. Min 3 days on-site in Houston Office (non-negotiable).

Experience in C#, .Net CORE, .NET MVC framework, Web Form, JAVASCRIPT, AJAX, CSS, HTML, JQUERY, WCF, ADO.NET and client-side framework
Experience to create integrations using REST API
Experience with Windows Services, Web Services and API development
Proficient understanding of code versioning tools such as Git

Description: Responsible for the development and integration of new or existing applications into the technical infrastructure and existing business processes. Provides technical or functional guidance to project or work teams as needed within a specific discipline. Collaborates on an on-going basis with the Business Systems Analyst. Analyzes designs develops tests debugs implements maintains and/or enhances existing or new systems that are reliable and efficient. No Value

Qualifications:
•              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.
•              Working with other teams to consolidate database instances and storage using capacity and performance analysis tools to identify underutilized instances, duplicate copies of data and identify associated server, network and storage resources that can be “right sized”
•              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.
•              Architect and build highly scalable .NET applications through all phases of the development lifecycle (initial designs to production deployments)
•              .NET technical expert in analysis, design, coding, testing, and debugging new software or significant enhancements to existing software that are built using Microsoft technologies

Required Skills: 8+
•              Proficient with ETL tools and possesses deep understanding of SSRS and SSIS as well as experience working with SSIS packages.
•              Strong experience in database performance monitoring and tuning
•              Experience performing database consolidation projects and systems integration development
•              Knowledge and experience of all other standard SQL Server DBA and SQL developer qualifications
•              Experience with hands on development .NET Core-based application in C# in a medium to large environments
•              Must possess knowledge and proficiency developing on Microsoft platforms, frameworks, and tools (ASP.NET, ASP. NET MVC, and C#) and Microsoft SQL Server
•              Experience with Windows Services, Web Services and API development