SSIS Developer

Title : SSISDeveloper with Energy domain exp.

Location Houston TX HYBRID

Visa NoH1B

Estimated Duration : 12 months with possibleextension (s)

Musthave skills : exp with ETL toolsand possesses (SSRS and SSIS); Microsoft SQL Server; ASP.NET ASP. NET MVC and C#; .NET Core;

ERCOT or PJM or NYISO orNEPOOL; Windows Services Web Services and APIdevelopment.

Requirements :

• Availability to work 3days per week at the Clients site in Houston TX (required);
• Experience with ETL tools andpossesses a deep understanding of SSRS and SSIS;
• Experience working with SSIS packages;
• Experience indatabase performance monitoring and tuning;
• Experienceperforming database consolidation projects and systems integrationdevelopment;
• Experience working as SQL Server DBA andSQL developer;
• Experience with handson development of.NET Corebased application in C# in medium to large environments aswell as with ADO.NET;
• Experience developing on Microsoftplatforms frameworks and tools (ASP.NET ASP. NET MVC) and MicrosoftSQL Server;
• Experience with JavaScriptjQuery;
• Experience with AJAX;
• Experience withCSS HTML;
• Experience with WCF;
• Experience increating integrations using REST API;
• Experience withcode versioning tools such as Git;

Experience withWindows Services Web Services and API development.

Preferred :

Deregulated Retail Energy (ERCOTPJM NYISO NEPOOL) experience.

Responsibilities include but are not limited tothe following :

• Designing and developing SSIS / SQL ETLsolutions to acquire and prepare data from numerous upstreamsystems for processing;
• Builds data transformations withSSIS including importing data from files and moving data from onedatabase platform to another;
• Design and develop SQLServer stored procedures functions views and triggers to be usedduring the ETL process;
• Architect and build highlyscalable .NET applications through all phases of the developmentlifecycle (initial designs to production deployments);
• Maintain uptodate documentation of all procedures infrastructurediagrams system configuration and baseline standards implementationplans system backout plans system recovery plans maintenance planssystem upgrades and all system changes;
• Maintainsecurityhardened baseline configurations and deploy security(patches) software maintenance (patches) and new software releasesand supporting products infrastructure as directed;

Conduct Data flow performance testing and support system andacceptance testing including the development or refinement of testplans.