*Immediate Need - ETL/Teradata Developer with BTEQ - Hapeville, GA- 6 Months *
Job Title: ETL/Teradata Developer with BTEQ Location: Hapeville, GA Duration: 6 Months *(Must have strong Teradata BTEQ and Informatica)!! OPT EAD Candidates !!* *Responsibilities:* Design and coding of scripts for extracting and loading data into departmental data marts using one or more of the following design approaches: Develop BTEQ wrapped-SQL load scripts optimized for Teradata and/or Aster environment and executed via a scheduling tool such as Tivoli. Design of Informatica ETL processes for loading data into departmental data marts. Design and build out of Tivoli schedules for the purpose of scheduling one time and recurring executions of the Informatica workflows or SQL load scripts. Design and build-out of Unix shell scripts, as needed. Provide production support of data solutions, including troubleshooting production failures, script revisions and reviews, status notifications and on-going support of development activities. *Requirements:* Advanced SQL script development experience required. Must have demonstrated experience writing load scripts for optimized performance in a Teradata environment. Experience with Aster and/or TD 1700 appliance is a significant advantage. Intermediate Informatica experience required. Using toolsets (fast export, fast load, etc.) v8.5 or greater for building out workflows to be managed via a Tivoli Schedule. Intermediate/Advanced Unix shell scripting knowledge required Working knowledge of Tivoli or other comparable scheduler tools and ability to create schedules for managing data loads. Ability to work with development team to determine script load dependencies and then build out the production Tivoli schedule. Strong technical analysis background required; ability to troubleshoot issues, determine root/cause, define and implement a correction. Ability to facilitate and lead discussions related to technical processes for the purpose of root/cause analysis and determining process activities which must be performed (and in what sequence) in order to execute load processes and/or recover from failures. Ability to document technical/operational processes (Informatica, Tivoli, etc…) and run book procedures. Work with end user and internal teams to define data and technical requirements Excellent oral and written communication and presentation skills, analytical and problem solving skills. Ability to work in a highly dynamic environment, which includes the ability to multi-task and adapt to changing priorities. Intermediate experience (3-5 years) designing physical data models (star/snowflake schemas), preferably for use with BI applications such as Tableau or Cognos, strongly preferred but not required. *Regards,* *Rehan Khan - Sr. IT Recruiter* *ITBrainiac Inc.* *Direct: (609) 423-7945 | Email: rehan.k...@itbtalent.com <rehan.k...@itbtalent.com>* *www.itbrainiac.com <http://www.itbrainiac.com> | Gmail/Hangouts: usitstaf...@gmail.com <usitstaf...@gmail.com>* *Getting things done on time is our greatest Asset..* -- You received this message because you are subscribed to the Google Groups "SAP or Oracle Financials" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-or-oracle-financials+unsubscr...@googlegroups.com. To post to this group, send email to sap-or-oracle-financials@googlegroups.com. Visit this group at https://groups.google.com/group/sap-or-oracle-financials. For more options, visit https://groups.google.com/d/optout.
