Database Analyst

USM; Tallahassee (FL); On-site; USD 70,000 - 90,000; Full time

Job summary

A leading global IT solutions provider is seeking a Database Analyst in Tallahassee, FL. The candidate will maintain and administer Informatica Data Quality software, perform data profiling, and assist in data cleansing. Responsibilities include executing data conversion/migration plans, supporting the project team, and ensuring data quality through documented processes. Required qualifications include significant experience with data analysis, profiling, and a strong knowledge of Unix/Linux environments. The position is full-time with long-term duration.

Qualifications

• Minimum 3 years of experience with Informatica Data Quality software.
• 2 years of experience in a Unix/Linux environment.
• 5 years of performing Data Administration tasks.
• Strong experience in Data Design and Data Modeling.

Responsibilities

• Maintain Informatica Data Quality and Data Cleansing software.
• Administer project team access to data environments.
• Perform data profiling and cleansing.
• Document and maintain data-related business rules.
• Assists in defect management and resolution planning.

Skills

Informatica Data Quality

Data Analysis

Data Profiling

Data Quality Assessment

Shell scripting

Data Design

Data Modeling

Unix/Linux environment

Tools

ErWin

Visio

Oracle

Job description

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.

USM, a US ensured Minority Business Enterprise (MBE) is perceived as one of the fastest developing IT Systems Integrator in the Washington, DC zone. Most as of late, USM was positioned #9 on the rundown of the Top administrations organizations in the DC Metro Area - Washington Business Journal (2011). We are a project-driven firm that reliably meets the IT needs of our State and Government customers through development and business keenness.

Job Description

Hi Friends,

Hope you are doing great,

I have an urgent requirement from one of my esteem client, I will appreciate if you can have an eye on the below requirement and send me your consultant updated profile ASAP.

Title: Database Analyst

Location: Tallahassee FL

Duration: Long Term

• Maintains the implemented Informatica Data Quality and Data Cleansing software and infrastructure
• Administers project team access to the 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
• Maintains and elaborates existing Informatica data source repository 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
• Provide consultant assistance to contracted vendor data conversion/migration planning providing required information when needed
• Reviews and provides feedback on data conversion/migration artifacts such as data conversion/migration plan and data conversion/migration 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

• Data profiling strategy for CCH data
• Data profile plan, activities and artifacts
• Data cleansing strategy
• Detailed data cleansing processes/routines/programs/scripts

SOW 16-17-045 Page 3

• Comprehensive inventory of all CCH data sources
• Comprehensive data dictionary of all metadata for each CCH data source
• Comprehensive logical and physical data model of all CCH data

Mandatory Knowledge, Skills and Abilities:

• 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 experience working in a Unix or Linux OS environment performing shell scripting with bash or ksh
• Minimum of 5 years of experience performing Data Design and Data Modeling utilizing toolsets (ErWin, Visio, Oracle Designer)
• Skill utilizing and applying software engineering methods and techniques for the design, definition, development, evaluation, integration, and/or support of IT solutions
• Ability to work independently or cooperatively with software developers
• Ability and experience functioning as a technical consultant or researcher
• Experience performing analysis, troubleshooting and resolving system defects and issues.
• Skill with using defined procedures to configure, test and debug software
• Skill with investigating, analyzing and resolving problems on software products
• Ability to work with minimal supervision from more senior resources; to accomplish assigned projects; including, services/products/technology solution evaluation/modification, data development, analysis, drafting written communications and client interaction
• Experience evaluating client capabilities and gathering business needs
• Experience assisting with services/products/technology solution architecture design and installation

Preferred Experience:

• 8 years of experience working with Oracle RDBMS software and databases (version 11g or more recent)
• 8 years of experience developing SQL, PL/SQL scripts, procedures, functions and packages
• 5 years of experience planning, developing and executing data conversion/migration plans, processes and programs
• Experience facilitating analysis sessions with business clients
• Experience presenting technical subject matter reviews or seminars to business clients
• Experience designing and executing quality control and test procedures

Additional Information

If my requirement matches your resume, then please do reply on my email id alih(at) usmsystems(dot)comand contact no is 703-955-3955