ETL Data Architect Developer

Description

Required Skills Strong and handson TSQL development skills writing stored procedures, functions, views, synonyms, server and query performance tuning Strong and handson SSIS development skills (and/or other data integration methodologies Informatica, Dell Boomi) to design and development of packages and SQL orchestration Strong Architecture & Design skills (including solution concepts, processing tier diagrams, data flows, transaction path artifacts, and Knowledge Transition documentation) Provides contribution to a project/scrum team responsible for the design, development and implementation of enterprise business solutions Experienced in version control and deployment thru DEV/QA/Prod BI stacks following good industry practices in deploying and managing the MS Technology stack Design, develop, optimize enterprise level automation solutions, and trains/supports others as to reuse Experienced in defect tracking, release management, change management in Team Foundation Server (TFS) environment Ensure that the integrity of the production run environment is protected and that the correct components are released by actively interacting with Release Management and Change Control Board (CCB) Experienced in policies, procedures, and followthrough regarding Environment Management, project defect tracking, and release management processes as applied to project initiatives Experienced working through all phases of implementation and complete Development life cycle from requirements gathering thru golive Experienced in documentation all phases of development solutions right from requirements gathering thru go live/transition to Production Support, and knowledge transition/mentoring to proliferate domain knowledge Experienced and good understanding of agilescrum methodologies and sprint planning SSRS Experience practitioner of Development Best Practice Code Development, Unit Testing, Code Change Management, Release, and Deployment skills Experience with Common Design Patterns/ StagingConformLoad & Layered Architecture Proven Waterfall and Agile Scrum Development Life Cycle skills Experience with Work Estimating/ Sprint Task Pointing Proficiency with Visual Studio, SQL Management Studio, and TFS Experience with Data & Dimensional Modeling Bachelor's degree required in Computer Science or equivalent engineering degree with minimum 57 years overall work experience required. 57+ years experience in Microsoft SQL Server Db development utilizing TSQL, SSIS, Visual Studio, SQL Management Studio, Team Foundation Server (TFS), MS Viso, MS SQL Server, MS SharePoint and other technologies and productivity software tools Demonstrated lifecycle development skills (analytical, design, development, testing skills, and deployment), Data Profiling/Reporting/Migration/Transformation skills and ArchitectureDeveloper abilities(Analysis ConceptDesignDevelopment/PorotypeUnit TestingSIT&QA TestingPerformance Tuning) Production Support breakfix and Project/Sprint Test Debugging Knowledge Transition and documentation skills Advanced technical computer skills as required for technical support specific to functional areas and related systems