Role: Database Architect Expert
Location: Menands, NY 12204 – 50% Remote
Job description:
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.
Day-to-day tasks include, but are not limited to:
1. Working with large and complex Oracle data warehouses, data marts and OLTP databases.
2. Overseeing the creation/modification of Oracle database tables of the appropriate type for the situation.
3. Writing/executing SQL for querying various Oracle databases as well as the Informatica Metadata Repository for validating unit and QA testing, monitoring, and for investigating integrity issues.
4. Guiding the ETL team in the development and monitoring of ETL processes and test plans using Informatica Power Center and Rhapsody.
5. Guiding the ETL team in shaping, enhancing and recommending best practices to the overall ETL (Informatica/Rhapsody) architecture
6. Investigating and resolving difficult design and build issues, data loading and data integrity issues.
7. Performance tuning Informatica/Rhapsody workflows.
8. Using Informatica/Rhapsody to develop ETL mappings and workflows including the use of mapplets, reusable transformations and worklets.
Must-have skills
Job Types: Full-time, Contract
Pay: $117,267.10 - $140,000.00 per year
Experience level:
Application Question(s):
Experience:
Ability to Commute:
Work Location: In person
Clear All
0 Database Analyst jobs found in Nassau, NY area