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