*Send your Consultant Profiles to [email protected] <[email protected]>*
Hello, Hope you’re doing great, We have a below requirement with our Direct Client please check through the requirement and let us know you’re comfort levels on the requirement, Waiting for your response ASAP. *Sr. ETL Architect. * *Duration : 6months to very longterm* *Location : Columbus OH* The Senior Architect is responsible for designing, developing, and implementing application infrastructure for the Ohio Human Services Data Warehouse to meet the Ohio Housing Finance Agency's objectives and requirements. The HEARTH Act codifies in law the Continuum of Care planning process and certain data collection requirements and requires HUD to ensure operation of and consistent participation by recipients and sub-recipients of programs authorized by Title IV of the McKinney- Vento Act in HMIS. The purpose of HMIS is to record and store client-level information about the numbers, characteristics and needs of persons who use homeless housing and supportive services and about persons who receive assistance for persons at risk of homelessness over time, to produce an unduplicated count of homeless persons for each Continuum of Care; to understand the extent and nature of homelessness locally, regionally and nationally; and to understand patterns of service use and measure the effectiveness of programs. HUD envisions that by implementing an HMIS system within each Continuum of Care, homeless individuals, agency directors and program managers, as well as public policy makers will all benefit. The OHSDW project intends to leverage the core continuum-level systems to provide a richer, fuller picture of the homeless population and the services they receive, better enabling agencies to collaborate across continuum and jurisdictional boundaries, and allowing public policy makers to address homelessness issues on a statewide basis. The Senior Architect is responsible for designing, developing, and implementing application infrastructure to provide highly-complex, reliable, and scalable applications and systems to meet the organization’s objectives and requirements. Senior Architects are familiar with a variety of the application technologies, environments, concepts, methodologies, practices, and procedures and rely on experience and judgment to plan and accomplish goals. Senior Architects are able to perform a variety of complicated tasks with minimal or no direct supervision. They have proven experience defining systems and application architecture and provide vision, problem anticipation, and problem solving ability to organization. They consult with the client to define needs or problems, conduct research, perform studies and surveys to obtain data, and analyze problems to advise on or recommend solutions, utilizing knowledge of theory, principles, or technology of specific discipline or field of specialization. SAR1 Years of Relevant Experience: 5 years software development, testing, and project management Preferred Education: 4 year college degree in computer science or related field with advanced study preferred. Role Description: •Manages, organizes, and administers systems analysis and preparation of applications and operating systems programming to process data and solve problems by use of computers. •Establishes priorities and schedules, and oversees and reviews work of systems analysis personnel and programming personnel. •Reviews feasibility studies and time and cost estimates of new or revised systems. •Assists in the development of standards, procedures, and operating systems applications. •A combination of directly-related technical training and hands-on experience. •Works with stakeholders and management to ensure projects are completed on time and according to organization standards. •Consults with personnel in other information systems groups to coordinate activities. •Consults with management to clarify systems and programs intent, identify problems, suggest changes, and determine extent of application systems changes required. •Participates in developing a project plan and schedule with key milestones, contingency plans, workflow charts or diagrams, considering factors, such as resource requirements, computer storage capacity and speed, extent of peripheral equipment, and intended use of output data. •Manages conversion of workflow charts to language that can be processed by computer and entering of program codes and test data into computer. •Analyzes test runs on computer and supervises correction of coded program and input data. •Manages the revision of existing programs to increase operating efficiency or adapt to new requirements. •Compiles documentation of program development and subsequent revisions. •Trains subordinates in systems analysis, feasibility studies, programming, and program coding. •Prescribes standards for terms and symbols used to simplify interpretation of programs. •Collaborates with computer manufacturers and other users to develop new programming methods. •Prepares records and reports. Expert in Data Warehouse design and construction, ETL (extract-transform-load), performance tuning, and front-end tools Required 8 Years Expert in Data Warehouse design techniques to support business intelligence (BI) Required 8 Years Expert in SQL Server 2012 Enterprise Edition with knowledge of its Data Warehousing features Required 8 Years Experience in analyzing referential integrity of Data Warehouse data and developing means to correct problems Required 8 Years Skilled in configurating the hardware and network infrastructure necessary to support a Data Warehouse Required 6 Years Responsible for structuring and maintaining the Data Dictionary for the Data Warehouse Required 6 Years Understands Data Warehouse physical platform and multi-tier architecture Required 6 Years Understands Data Warehouse technology and can perform as a Data Modeller or Database Administrator Required 8 Years Understands data acquisition tools and processes Required 10 Years Skilled in project management activities including time management, risk assessment, maintaining project scope, and communication of status updates to Required 6 Years Excellent team player able to work with cross functional teams Required 8 Years Excellent spoken and written communication as well as receptive listening skills, with ability to present complex ideas in a clear, concise fashion to Required 8 Years Ability to work with domain experts from multiple external agencies and coordinate efforts among them Required 8 Years Familiar with the leading data warehouse/data mart data models such as star schema or snowflake schema Required 8 Years Experience in supporting programs to aid homeless populations or other charities Highly desired 4 Years Experience conducting user acceptance testing and knowledge transfer activities Desired 4 Years Skilled in creating and deploying SQL Server Reporting Services (SSRS) reports Desired 5 Years Understands and is able to resolve application interface problems Desired *Thanks* *Chris* *[email protected] <[email protected]>* -- You received this message because you are subscribed to the Google Groups "US_IT.Groups" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/us_itgroups. For more options, visit https://groups.google.com/d/optout.
