Job ID :
41018
Company :
Internal Postings
Location :
Remote
Type :
Contract
Duration :
12 Months+
Salary :
DOE
Status :
Active
Openings :
1
Posted :
03 Jun 2024
Job Seekers, Please send resumes to resumes@hireitpeople.com

Must-have skills: Data architecture, integration, design and delivery exp; 5+ y of ETL and data mapping exp; 5+ y of exp in middleware technologies; SQL; data modeling and related tools (e.g., Erwin); SQL Server technologies; Oracle technologies (9i, 10g, 11g, RAC)

Requirements:

  • Proven experience in data architecture, integration, design and delivery;
  • Proven experience in designing data architectures for scalability and performance;
  • Proven experience with logical and physical data modeling and related tools (e.g., Erwin);
  • Proven experience in the development of plans and management of data migration on large-scale implementation projects;
  • ETL and data mapping experience (5+ years);
  • Experience in middleware technologies (5+ years);
  • Experience in creating dictionaries (5+ years);
  • Experience of meeting facilitation skills (5+ years);
  • Experience in data caching patterns and data access methodologies;
  • Advanced-level experience with SQL;
  • Experience with data integration methodologies;
  • Experience with SQL Server technologies;
  • Experience with Oracle technologies (9i, 10g, 11g, RAC)
  • Demonstrable experience with data replication across database instances including standby and high availability databases;
  • Experience designing/architecting databases;
  • Experience working with Master Data Management tools
  • Experience working with development teams
  • Experience working with web services

Preferred:

  • Knowledge and understanding of the basis EA concepts and EA theory
  • Experience working for a governmental agency

Responsibilities include but are not limited to the following:

  • Develop scalable, high-performance data architectures that meet organizational needs using proven experience in data architecture, integration, and design;
  • Create and manage logical and physical data models with tools like Erwin;
  • Oversee data migration plans for large-scale implementation projects;
  • Lead ETL processes and data mapping activities, ensuring efficient data flow and transformation;
  • Implement and manage middleware technologies to support seamless data integration and apply extensive experience in data integration methodologies;
  • Design and manage SQL Server and Oracle databases for optimal performance and scalability, leveraging advanced SQL skills and experience with Oracle technologies;
  • Develop and maintain data dictionaries and documentation, ensuring data consistency and quality through effective data access methodologies and caching patterns.