Database Architect (Expert) NYWIC (New York Women, Infants, and Children) system

automate file validation, secure file transfers (FTP/SFTP), organizing batch jobs, and integration with ETL workflows, ensuring consistent, repeatable, and error-free. 3. 3.Design and maintain enterprise data architecture, including conceptual, logical, and physical data models, while performing ongoing data modeling and schema.

HBITS: HBITS-08-14927

Database Architect
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.

Expert
84+ months: Candidate is able to provide guidance to large teams and/or
has extensive industry experience and is considered at the top of his/her
field.

30 month contract

Interview: Virtual Interview

Work model: 50% telecommuting, 50% Office per week

--- Project Description ---
This is primarily a ETL Developer position focused on design and development of
complex mappings, and integration of data from multiple heterogeneous source
systems. In addition, the resource will serve as backup support for OBIEE and Data
modeling processes, assisting with troubleshooting, production support, and issue
resolution as needed.

--- Day-to-Day Tasks ---
1. 1.Perform data analysis of current and future WIC systems, including system
comparison, to support ongoing and future data needs.
2. 2.Collaborate with customers, vendors, and technical teams to gather
requirements, perform gap analysis, and prioritize reporting needs.
3. 3.Design and maintain enterprise data architecture, including conceptual, logical,
and physical data models, while performing ongoing data modeling and schema
design.
4. 4.Define and enforce data standards, naming conventions, governance practices,
and ensure data quality, integrity, and consistency across all environments.
5. 5.Develop and maintain documentation of business processes, workflows, and
data flows using modeling techniques and flowcharts.
6. 6.Develop, review, and optimize ETL processes and mappings for data migration
(Sybase, MS Access to Oracle), improving performance and efficiency.
7. 7.Design and support reporting solutions, including dashboards and prototypes,
aligned with end-user requirements.
8. 8.Develop and execute test plans, scripts, and validation scenarios to ensure data
accuracy and compliance with business requirements.
9. 9.Monitor and optimize database performance through query tuning, indexing,
partitioning, and overall system optimization.
10. 10.Implement and maintain database security, access controls, auditing, and
compliance with organizational and state data privacy requirements.

--- Required Qualifications ---
• 84 Months experience using Informatica 10.x or higher in enterprise data
warehouse environments, including advanced warehousing concepts, design and
development of mappings, and integration of data from multiple heterogeneous
source systems such as Oracle databases and flat files.
• 72 Months experience leading ETL teams and designing enterprise data integration
architecture using Informatica, including establishing data standards, best
practices, and governance policies for data warehouse and reporting
environments, and mentoring team members.
• 72 Months experience working with Oracle databases, includes translating large
SQL, PL/SQL (stored procedures/functions), and SAS code into optimized
Informatica mappings and performing query optimization and performance tuning
for data warehouse systems.
• 72 Months experience developing complex UNIX shell scripting solutions to
automate file validation, secure file transfers (FTP/SFTP), organizing batch jobs,
and integration with ETL workflows, ensuring consistent, repeatable, and error-free
data processing.
• 72 Months experience implementing Informatica Data Quality (IDQ) solutions,
including data profiling, data cleansing, standardization, matching, and merging,
along with defining business rules, metrics, and processes to ensure accurate and
reliable data for reporting and analytics.
• 48 Months experience designing and maintaining dimensional and enterprise data
models for Datamart and data warehouses, including conceptual, logical, and
physical modeling using tools such as Erwin, ensuring optimal storage, query
performance, and alignment with business requirements.
• 36 Months experience specifying and conducting system testing (unit, integration,
regression, load, performance, and UAT) and supporting code migration and
releases across DEV, QA, and PROD environments.
• 24 Months experience designing and implementing enterprise OBIEE dashboards
and reports, including repository (RPD) development, metadata modeling, and
performance tuning for high-volume Datamart data.
• 24 Months experience establishing and enforcing data governance, lineage, and
quality frameworks across enterprise Datamart and reporting environments,
collaborating with Program team to ensure data integrity, compliance, and
actionable reporting.
• 72 Months experience implementing enterprise database security and data
protection controls, including Fine Grained Access Control Audit (FGACA) and
Virtual Private Database (VPD), ensuring compliance with HIPAA and protection of
sensitive healthcare data including Medicaid and Pharmacy information.

MVP Consulting Plus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected by law. Reasonable accommodations are available for qualified individuals with disabilities during the application process.