Urgent Need Database Analyst

Duration:6-12 Months

Responsibilities

• 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