Job Description: Analyze, design, code and test new or existing application programs. Support the Data Warehouse and Business Intelligence community. Manage, Maintain and Support Day-to-Day Operations of NAVAIR Depot Maintenance System (NDMS), SingleSite, OneNDMS, Data Convergence, Corporate Reporting System (CRS) and Other Initiatives. Support development, standardization, testing, and quality assurance and configuration management procedures. Support standardization and maintenance of data dictionary, data structures and data repositories. Specific Tasks: · Data modeling/architect: o Model in Kimball’s dimensional methodology using the Project Lead’s requirements. o Design/modify logical and physical dimensional models using Erwin to meet business' reporting requirements. o Prepare and document standards and procedures for dimensional data modeling and naming conventions. · Extract-Transformation, Load (ETL) Mapping Specifications: o Prepare high-level ETL mapping specifications. o Develop regression test scripts to validate ETL. · Development: o Develop stored procedures to populate new tables and columns. o Develop regression test scripts to validate stored procedures. · Troubleshooting: o Perform data analysis across multiple databases to identify source of data issues. o Determine best resolution for data issues and anomalies. o Revise ETL mapping specifications and/or stored procedures as required. o Revise associated regression tests as required. · Manage the overall Data Warehouse Data Architecture o Establish and maintain Virtual Private Database (VPD) security policies. o Ensure Data Architecture follows best practices and guidelines for Data Warehousing. Required Skills and Experience: · Active Secret Clearance. · Security+ (may be obtained) and Certified Business Intelligence Professional · Data modeling (Kimball’s or similar methodology preferred). · Bachelor's degree or postgraduate degree in computer science, information systems management, mathematics, operations research, statistics, or engineering or 8 eight years of combined education (at the undergraduate level in any academic field) and experience performing the foregoing functions. Employment Type: Full time
...IDR is seeking an Oracle ERP Business Analyst to join one of our top clients in Nashville, TN. This role is pivotal in supporting our client... ...or strong procurement experience in another ERP system (e.g., SAP, PeopleSoft). Proven functional and/or technical experience...
...Job Description KAG Food Products is currently hiring TEAMS Truck Drivers in your area! Join KAG today to take advantage of great pay, competitive benefits packages, supportive terminal managers and great equipment! Currently hiring CDL-A Truck Drivers! Text APPLY...
Microsoft Dynamics CRM Testing, QXNT, .Net Testing Full-timeSonsoft, Inc. is a USA-based corporation duly organized under the laws of the Commonwealth of Georgia. Sonsoft Inc. specializes in Software Development, Software Consultancy, and Information Technology Enabled...
...Qualifications: Bachelors degree preferred (or equivalent experience) Previous experience in an administrative or office support role Strong communication and organizational skills Proficiency in Microsoft Office Suite (Word, Excel, Outlook, PowerPoint)...
...Job Description Job Description & Skill Requirement: 4-6 years of experience in Off-Highway and Mining domain (Construction & Mining Domain) with expertise in SOLIDWORKS Experience in working with cross functional and different cultural teams across the globe...