Database Analyst

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

Deliverables:

• 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

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