ETL role.

Hi,

Please find the below job opportunities and let me know if you have any suitable consultant for it. 

Role: ETL

Location: Miami, FL

6+ months contract

All visa (Except H1B)

Phone and Skype

 

Position Responsibilities:

For each EDW schema to Archive, archive associate rows in ODS...

 

1.Develop Data Lineage Map for all EDW schemas to archive and place in ER/Studio Lineage for schema.

2. Reverse Engineer Schemas in ER/Studio; confirm table relationships

3. Identify related source files to delete

4.Build Aggregate tables and develop ETL where necessary

5.Map ODS tables to the CCL Document Retention policy for associated EDW Schemas

6.Develop Archive Projection scripts

7. Develop scrips for deletion of rows in ODS and provide to the IDA Development specialist

8.Create a develop ETL for any aggregate Tables necessary

Tools they should be proficient in ....

1. ER/Studio Data Architect

2. Informatica ETL

3. Informatica Data Archive 

4. Informatica Data Analyst (Data Profiling)

5. Informatica EDC (Data Lineage)

6. Unix Shell scripting

 

 

Regards,

Abhishek Saurav

Exarca Inc.

Phone: +1(469) 436-3528             

Email: asaurav@exarcainc.com

 

 

To unsubscribe from future emails or to update your email preferences click here .

Comments

Popular Posts