Database Analyst

USM Business Systems Inc. is a quickly developing worldwide System Integrator, Software and Product Development, IT Outsourcing and Technology assistance supplier headquartered in Chantilly, VA. We offer world-class ability in giving most astounding quality and administrations through industry best practices planned to convey remarkable worth to our customers.

Utilizing our industry knowledge, administration service offering expertise and innovation abilities, we distinguish new business and innovation slants and create answers for help customers around the globe, giving top of the line solid and practical IT benefits which are cost effective services.

Established in 1999, the organization has corner qualities in building and dealing with a Business Oriented IT environment with rich involvement in technology innovation, ERP and CRM counselling, Product Engineering, Business Intelligence, Data Management, SOA, BPM, Data Warehousing, SharePoint Consulting and IT Infrastructure. Our other offerings include modified solutions and administrations in ERP, CRM, Enterprise architecture, offshore advisory services and e-commerce.

Position: Database Analyst

Location: Tallahassee, FL

Duration: 6-12 Months

• Maintains the implemented Informatica Data Quality and Data Cleansing software and infrastructure.
• Administers project team access to Informatica Data Analysis, Data Quality and Data Cleansing environments.
• Maintains and elaborates existing data profiling and cleansing plans and strategy.
• Maintains and elaborates existing Informatica data source repository and its update/refresh processes.
• Maintains and elaborates existing and new Informatica data profiling configurations, scheduled processes, programs and scripts.
• Documents, maintains and elaborates data cleansing inventory based on data profiling results.
• Maintains and elaborates existing documented FDLE CCH data dictionary artifacts.
• Performs ad‑hoc data profiling of CCH data sources utilizing Informatica Data Quality software.
• Maintains and elaborates existing data‑related business rules and requirements.
• Analyzes data requirements, application and processing architectures, data dictionaries, and database schema(s).
• Maintains and elaborates existing logical and physical data models of CCH data using Erwin or Visio modeling tools.
• Provides consultant assistance to contracted vendor data conversion/migration planning.
• Reviews and provides feedback on data conversion/migration artifacts such as data conversion/migration plan and implementation plan.
• Writes and reviews test cases.
• Reviews and verifies vendor data conversion/migration test strategy, plans and subsequent test results.
• Performs data conversion/migration testing and documents findings.
• Serves as the FDLE project team’s central point of contact regarding CCH database planning.
• Assists FDLE UAT testers during data conversion/migration testing, verification, and data validation.
• Assists in defect management and resolution planning.
• Creates and updates documentation as required by project team.
• Reviews and provides feedback on project artifacts and deliverables as required by project team.
• Participates in team meetings.
• Supports the project team.
• Develops data profiling strategy for CCH data.
• Creates data profile plan, activities and artifacts.
• Creates data cleansing strategy and detailed data cleansing processes/routines/programs/scripts.
• Maintains comprehensive inventory of all CCH data sources.
• Maintains comprehensive data dictionary of all metadata for each CCH data source.
• Maintains comprehensive logical and physical data model of all CCH data.

• Minimum of 3 years of recent experience performing Data Analysis, Data Profiling, Data Quality Assessment utilizing Informatica Data Quality software.
• Minimum of 2 years of recent experience installing, configuring and maintaining Informatica Data Quality software in a Unix or Linux operating system environment.
• Minimum of 5 years of experience performing Data Administration tasks (Data Analysis, Data Profiling, Data Quality Assessment, Data Cleansing) utilizing any tool or software.
• Minimum of 5 years of…