Software Architect - Senior
Software Architect - Senior
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Data Warehouse Engineer
Albany NY
30 Months
HBITS/ OASAS
1. Analyze and Create/Update the data model using ER Studio Data Architect 17.1.0.
2. Analyze the source system data stores.
3. Design the ETL as per standard.
4. Create data lineage documents.
5. Create high level ETL design documents as per standard.
6. Create low level ETL design documents as per standard.
7. Create Informatica 10.2.0 ETL mapping as per standard.
8. Create Informatica 10.2.0 Sessions as per standard.
9. Create Informatica 10.2.0 Workflow as per standard.
10. Create Unix/Linux shell scripting as needed
11. Create complex PL/SQL package procedure and function as needed.
12. Create documentation for all work.
13. Migrate the ETL mappings from Oracle Warehouse Builder (OWB) 11.2.0.4.0 to Informatica 10.2.0.
14. Migrate and change the PL/SQL packages procedures and functions from existing to new data warehouse.
15. Migrate and change the data from the existing to new data warehouse as needed.
16. Migrate and change the Views and Materialized views from the existing to new data warehouse as needed.
17. Migrate and change the data sharing extraction scripts as needed.
18. Monitor and tune the performance of Informatica 10.2.0 ETL
19. Monitor data anomalies between source system and data warehouse.
20. Ensure the data quality of the data warehouse.
21. Maintain and troubleshoot ETL processes.
Title : Location : Duration : Client : Requirements :
Employment Type
Full-time
