IT Teradata/Google Migration (IA727642)

IT Teradata/Google Migration (IA727642)

Initially a 6 Month Contract

Required Skillset:

• Extensive experience with database administration, specialized knowledge of Teradata, ETL, and architecture.
• Knowledge and understanding of SQL and Teradata Utilities.
• Ability to integrate multiple system management processes and solve complex information technology system problems.
• 8-10 years of experience with database administration, or specialized knowledge of Teradata, ETL and architecture.
• Have knowledge and understanding of SQL and Teradata Utilities.
• Have the ability to integrate multiple system management processes and solve complex information technology system problems.

Teradata/Google Migration and Data Governance Activities

Project Description: Develop and provide Teradata documentation needed to initiate the migration to Google Enterprise Data Warehouse. Serve as primary contact for current Teradata Data Warehouse (DW) technical documentation, security, and flowcharts, including network and database details. Assist with migration tasks for the Enterprise Data Warehouse migration of databases, extraction, transformation, and load (ETL) processes and reporting. Find areas where the timeliness of current procedures can be reduced (to make the system more efficient).

Project Purpose-Business Case: Client does not currently have a staff person that knows and understands the technical side of the Teradata Data Warehouse. Duties would Include table updates, data growth metrics, flowcharts, security/network details, database information, etc. As DOM begins to migrate off the Teradata server, this position will assist in development of processes and stages of migration to a new Googe-based Enterprise Data Warehouse.

Project Purpose – Business Objective: Google data pipeline management (SFTP, transfers, account, files, scheduled jobs, etc.). Ensure technical documentation deliverables are completed as needed for data governance. Decrease the cost of hardware, software, and services by migrating to Google/Big Query. Increase the timeliness of current processes.

Project Deliverables: Documentation that provides business and technical information for the DW, including flowcharts, security/network details, database information, etc.; Lead migration efforts from DW to EDW (Teradata to Google/Big Query); Develop, execute, and manage the current and new data process for the DW and EDW migration efforts; Modify ETL scripts for the client's services data, reducing the time to process the data.

Apply directly at:

www.rmallcga.com

Job Types: Full-time, Contract, Temporary

Pay: $45.59 - $50.59 per hour

Schedule:

• 8 hour shift
• Monday to Friday

Application Question(s):

• What is your desired contract hourly rate?
• Can you work on a W2 or 1099?
• Are you authorize to work in the United States?

Experience:

• database administration: 8 years (Preferred)
• specialized knowledge of Teradata, ETL and architecture: 8 years (Preferred)
• knowledge and understanding of SQL and Teradata Utilities: 8 years (Preferred)

Ability to Relocate:

• Des Moines, IA 50309: Relocate before starting work (Required)

Work Location: In person