Provide a short description of the Position: Staff augmentation to perform Data Warehouse ETL related Tasks such as ETL Analysis, ETL Design, ETL Mapping, ETL testing, Workflow creation, Migration, ETL Administration and Data Modeling.
Provide a list of the day-to-day tasks to be performed by the Selected Candidate: 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) (phone number removed) 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.
Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of – Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans.