|Location||New Brunswick, NJ|
|Salary/Pay Rate||$50-$60/Hr. W2 DOE|
- Data Architect - II (Infrastructure Projects)
? Troubleshoot requests ( Ex: Research / Analyze data / report issues )
? Database design, build & maintenance (Ex: ETL)
? Responding to source data systems changes (Ex: JCT / CompNav / TalNav, etc.,)
? Report maintenance (Ex: Cognos FM / Reports)
? Create scripts for date extractions (Ex: VP initial load data to WorkDay)
? Adhoc requests for report data (Ex: Duplicate wwids for prior employees)
? Migration of existing environments (Ex: Cognos 10 to Oracle 11)
? Gather user business requirements.
? Prepare functional specifications. (FRS)
? Prepare detailed design documents. (TRS)
? Create complex Oracle dataviews to enable effective reporting.
? Design & code reports via Cognos BI tools.
? Report maintenance (Cognos 10).
? Develop & run test scripts for report development & Oracle upgrades.
? Training / user education / documentation (Ex: Talent Dashboard data load process)
? Legacy system infrastructure support
? Develop processes for integration of data from multiple HR systems.
? PL/SQL procedure & UNIX scripts - design & coding.
? HR Analytics Job execution and monitorig (Ex: Talnav/CompNav Maestro jobs, SAP interface) ? daily schedule
? Authoritative Source Load ? daily ETL
? SAP data load to Reporting database ? weekly ETL
? Load Transactional system data (JCT/GJC/Bravo/SAP) to Reporting database ? monthly ETL
? Reporting Authoritative Source History load ? monthly ETL
? Talent Dossier - requirements/design/build/ETL
? Talent Dashboard - requirements/design/build/ETL
? GDW (Global Data Warehouse)
o Legacy data load
o FRS ?Functional requirements specifications
o TDS ?Technical design specifications
? Assist in new user setup
? General system support
General Technical skills needed.
? Unix scripting
? Cognos 10
? MS Office (excel, word, visio, powerpoint)