Database Architect

Job Summary:

• A client of ours in Albany, NY is looking for a Database Architect for a Contract on W2 opportunity.

• Work in conjunction with the project data migration lead to conduct data analysis of both current and to-be WIC systems, in order to maintain an understanding of current and future needs.
• Collaborate with customers, vendors, and technical workgroups to identify and document data and reporting requirements, reporting processes, gap analysis, and prioritization of reporting needs.
• Create documents describing business flow and function using flow charts and data/process models describing these business functions.
• Develop ETL mappings for migration of data from SYBASE, MS Access to Oracle.
• Create report and dashboard prototypes.
• Participate in development of solutions to meet end user reporting requirements.
• Develop data test protocols, including test plans, creation and execution of test scripts, scenarios, and test plans that validate initial business requirements. Test report accuracy and document test results.
• Evaluate implementation strategies and document issues requiring resolution.
• Schedule, facilitate, and record report development meetings as needed.

• Special Supplemental Nutrition Program for Women, Infants, and Child (WIC)
• Determines database structural requirements by analyzing client operations, applications, and programming; reviews objectives with clients; evaluates current systems; provides database support by coding utilities, responding to user questions, and resolving problems.

• 7 Years Experience using Informatica 10.x or higher in a data warehouse environment including warehousing concepts, design and development of complex mappings, and merging data from multiple source systems including but not limited to Oracle and flat files.
• 4 Years Experience with Informatica Data Quality processes, approaches, measurement techniques and business cases for data profiling, data cleaning, standardization, match and merge with IDQ 8.x or higher.
• 6 Years Work experience implementing Fine Grain Access Control Audit (FGACA) and Virtual Private Database (VPD) to protect Health Care data such as Medicaid, Pharmacy, and HIPAA Protected Health Information (PHI).
• 6 Years Experience leading the ETL team in shaping and enhancing the overall ETL architecture using Informatica.
• 6 Years Experience writing complex UNIX scripts to validate and FTP files, and for calling Informatica workflows.
• 6 Years Experience converting complex SQL, PL/SQL (stored procedures/functions), as well as SAS code with Oracle 10g or higher, to Informatica mappings.
• 6 Years Experience in Dimensional Data Modeling for creating logical and physical data models using Erwin.
• 6 Years Experience specifying and conducting system testing (e.g. unit, integration, regression, load, performance) and user acceptance testing.

• Experience level: Experienced
• Minimum 10 years of Database Architect Experience.
• Education: Bachelors (required)