Role: Teradata Developer
Location: Alpharetta, GA
Contract: 30 months
Work authorization: Open
Interview Type: In-person
Primary Skills: Relational database development
Minimum of 7 years of relevant work experience in the information technology field. Participated in full Software Development Life Cycle (SDLC) of the data warehousing project; 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.
Minimum of 5+ years strong NCR 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. Certification in Teradata and Teradata SQL preferred.
Applicant's must be able to successfully:
1. Use Teradata utilities fastload, multiload, tpump to load data.
2. Write BTEQ scripts to transform data.
3. Write Fastexport scripts to export data.
4. Write, test and implement Teradata Fastload, Multiload and Bteq scripts, DML and DDL.
5. Construct Kornshell driver routines (write, test and implement UNIX scripts).
6. Write views based on user and/or reporting requirements.
7. Gather system design requirements, design and write system specifications.
8. Will be expected to be available for on-call response in order to provide 24x7 emergency response capabilities.
9. SQL proficient.
Job details are sourced from the employer's original posting.
Open job postingAbout the company
Headquartered in New Jersey (U.S), Cygnus Professionals Inc. is a next generation global information technology Solution and Consulting company powered by strong management and leadership team with over 30 person years of experience. Today, Cygnus has strong footprints in more than 4 countries with more than 25 satisfied customers. We strive to extend our presence across industries and geographies with our industry-focused business excellence. Cygnus Professionals Inc. has been named by the US Pan Asian American Chamber of Commerce Education Foundation (USPAACC) as one of the “Fast 100 Asian American Businesses” – joining the country’s fastest-growing Asian American-owned companies, based on percentage revenue growth over the immediate past two years.