Teradata ETL Developer

SRI Tech solutions Inc; Town of Florida (NY); On-site; USD 100,000 - 130,000; Full time

Job summary

A fast-growing IT staffing firm is seeking an experienced IT professional with a strong background in data warehousing and Big Data technologies. The ideal candidate will possess over 7 years of IT experience and at least 5 years of proficiency in Teradata and SQL. Responsibilities include full participation in software development life cycles, data modeling, and deploying solutions to end users. This role requires excellent communication skills and the ability to manage complex software applications.

Qualifications

• Minimum of 7 years of relevant work experience in IT field.
• Strong Teradata and SQL skills with 5+ years of experience.
• Experience with Big Data Technologies like Hadoop, Map Reduce, Hive.

Responsibilities

• Participate in full Software Development Life Cycle (SDLC) of data warehousing projects.
• Design and implement complex software applications.
• Load unstructured data into Hadoop File System (HDFS).

Skills

Teradata

SQL

UNIX

Apache Hadoop

Big Data Technologies

NoSql databases

Kornshell

Data Warehouse Modeling

Job description

SRI Tech is an IT staffing and solutions firm that serves clients with a full range of IT services that we deliver effectively and efficiently. Ranked in the top 20% of the fastest growing companies in the US by Inc. 5000 - SRI Tech is fast growing & dynamic firm maintaining its speed to be one of the leaders in serving IT.

Job Description

Job Location: Temple Terrace, FL

Duration: 6+ months

Responsibilities

• Minimum of 7 years of relevant work experience in the information technology field. Participation in full Software Development Life Cycle (SDLC) of data warehousing projects; project planning, business requirement analysis, data analysis, logical and physical database design, setting up the warehouse physical schema and architecture, developing reports, security and deploying to end users. Good communication skills and business knowledge.
• Minimum of 5+ years strong Teradata and SQL, UNIX, Data Warehouse Modeling, Teradata Utilities , Aggregates and building efficient views; other SQL and UNIX experience plus Teradata certification may be substituted for years of Teradata experience.
• Installed and configured Apache Hadoop, Hive and Pig environment on the prototype server.
• Configured MySQL Database to store Hive metadata.
• Responsible for loading unstructured data into Hadoop File System ( HDFS).
• Design and code from specifications, analyzes, evaluates, tests, debugs, documents, and implements complex software apps
• Uses coding methods in specific programming languages to initiate or enhance program execution and functionality

Qualifications

• Design and write system specifications.
• Use Teradata utilities fast load, multiload, tpump, and TPT to load data.
• Write BTEQ scripts to transform data.
• Write Fast export scripts to export data.
• Write, test and implement Teradata Fast load, Multiload and Bteq scripts, DML and DDL.
• Construct Kornshell driver routines (write, test and implement UNIX scripts).
• Write views based on user and/or reporting requirements.
• Will be expected to be available for on-call response in order to provide 24x7 emergency response capabilities.
• Over 2 years of experience with Big Data Technologies like Hadoop, Map Reduce, Hive, Pig and Sqoop
• Experience with NoSql databases like MongoDB and HBase
• Experience in Installation and Configuration of Hadoop cluster

Additional Information

All your information will be kept confidential according to EEO guidelines.