Saxon Global
SSIS Developer (hybrid)
Saxon Global, Austin, Texas, us, 78716
Deregulated Retail Energy (ERCOT, PJM, NYISO, NEPOOL) experience
Responsibilities
include but are not limited to the following:•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, and 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;•Architect and build highly scalable .NET applications through all phases of the development lifecycle (initial designs to production deployments);•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;•Maintain security-hardened baseline configurations and deploy security (patches), software maintenance (patches), and new software releases and supporting products infrastructure as directed;•Conduct Data flow performance testing and support system and acceptance testing including the development or refinement of test plans.
Responsibilities
include but are not limited to the following:•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, and 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;•Architect and build highly scalable .NET applications through all phases of the development lifecycle (initial designs to production deployments);•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;•Maintain security-hardened baseline configurations and deploy security (patches), software maintenance (patches), and new software releases and supporting products infrastructure as directed;•Conduct Data flow performance testing and support system and acceptance testing including the development or refinement of test plans.