18 days old
2018-06-272018-07-27

ETL Lead Consultant

Teradata Operations, Inc
Miamisburg, Ohio
Apply Now
  • Job Code
    201531
  • Job Type
    Employee
  • Job Status
    Full Time

ETL Lead Consultant, Teradata Operations, Inc., Miamisburg, OH (Company Headquarters):

Analyze data processing problems to implement and improve computer systems. Advise customers on quality assurance and production systems, and how to effectively architect, maintain, troubleshoot and operate the Teradata platform and database environment. Align customer business requirements to the Teradata Travel and Transportation Logical Data Model (LDM) and configure Extract Transform and Load (ETL) transformation rules using IBM Datastage, design ETL framework using Datastage for Historical Data Migration from heterogeneous data sources to Teradata Data Warehouse. Provide ETL development, maintenance, and operational support to the clients. Mentor team members on new and existing ETL frameworks used at different customer locations, fulfilling any customer change requests and other maintenance activities. Ensure compliance with quality control aspects of Teradata Warehouse implementation. Design, develop, implement, support and troubleshoot mission critical, high volume, terabyte-sized production system environments, ensuring that the production systems are working efficiently and reliably at all times. Travel required up to 100% at various unanticipated locations based on business and client need.

Minimum Requirements:
Master’s degree or foreign equivalent in Computer Applications, Business Technology, Computer Science (Applied) or related field and 3 years of related experience.
OR
Bachelor’s degree or foreign equivalent in Computer Applications, Business Technology, Computer Science (Applied) or related field and 5 years of post-bachelor progressively related experience.
Of the required experience, 3 years must be in each of the following:
• Implementing data warehouses;
• Analyzing and troubleshooting active enterprise intelligence and replication techniques;
• Working in the travel and transportation business domain;
• Experience managing a team of 3-4 resources;
• Experience with data warehousing integration tools including: IBM Datastage 8.5 Parallel (or higher version); UNIX Shell Scripting; IBM Tivoli Job Scheduler v8.5 (or higher version); Version control tools (including subversion); IBM Rational Clear Case; and Informatica Powercenter v8.1 (or higher version);
• Experience with Hadoop-Big Data including: MapReduce; Sqoop; Hive; HBase; and Hadoop Distributed File System (HDFS);
• Implement Hadoop-Big Data on existing systems in an efficient manner and for final active deployment; and
• Store and process data sizes in excess of 10 Terabytes of any kind of data using Hadoop-Big Data procedures.

Travel required up to 100% at various unanticipated locations based on business and client need, Telecommuting is permitted

TO APPLY: Must apply by email to STAFF.TDPM@Teradata.com and reference “Job Number – 201531” to be considered.

Requirements

Minimum Requirements:
Master’s degree or foreign equivalent in Computer Applications, Business Technology, Computer Science (Applied) or related field and 3 years of related experience.
OR
Bachelor’s degree or foreign equivalent in Computer Applications, Business Technology, Computer Science (Applied) or related field and 5 years of post-bachelor progressively related experience.
Of the required experience, 3 years must be in each of the following:
• Implementing data warehouses;
• Analyzing and troubleshooting active enterprise intelligence and replication techniques;
• Working in the travel and transportation business domain;
• Experience managing a team of 3-4 resources;
• Experience with data warehousing integration tools including: IBM Datastage 8.5 Parallel (or higher version); UNIX Shell Scripting; IBM Tivoli Job Scheduler v8.5 (or higher version); Version control tools (including subversion); IBM Rational Clear Case; and Informatica Powercenter v8.1 (or higher version);
• Experience with Hadoop-Big Data including: MapReduce; Sqoop; Hive; HBase; and Hadoop Distributed File System (HDFS);
• Implement Hadoop-Big Data on existing systems in an efficient manner and for final active deployment; and
• Store and process data sizes in excess of 10 Terabytes of any kind of data using Hadoop-Big Data procedures.

Travel required up to 100% at various unanticipated locations based on business and client need, Telecommuting is permitted

Categories

Share this job:

ETL Lead Consultant

Teradata Operations, Inc
Miamisburg, Ohio

Share this job

ETL Lead Consultant

Teradata Operations, Inc
Miamisburg, Ohio

Separate email addresses with commas

Enter valid email address for sender.

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast