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.