Hello Folks, Teradata India is hiring Technical Consultants as per the below JD. Interested people please drop me a msg on FB or send a mail to aritra01@gmail ================================================= Description Responsibilities: · Monitor, analyze, troubleshoot, rectify and resolve TPT/BTEQ workflow/session failures & related issues · Log, in detail, the root-cause, the troubleshooting-flow, the impact of an incident etc. on available incident-management tool/application · Ensuring complete adherence to SLAs for all operations of workflows/sessions/jobs · Configure & maintain TPT/BTEQ environment using recognized best practices (ODBC installation & configuration, TTU configuration etc.). Install/provide support for TPT/BTEQ hot fixes, patches, upgrades etc. · Configure & maintain components for the data integration environment (folder creation; folder/file privileges; create/maintain/manage TPT/BTEQ run-time environment on Unix/Linux machine, Archive-scripts/logs, capture & maintain logs and log directories, cleanup of log directories) · Proactively analysing workflows/sessions/jobs and identifying, developing & implementing performance improvement opportunities · Handle deployment methodologies, code and data movement between Dev., QA and Prod Environments (deployment groups / folder copy/ data-copy etc.) · Maintain data integration environment scheduler (Control-M, JCL, Unix/Linux-cron etc.) schedules and dependencies as required · Handle L1-level database operations support activities and database administration activities including data-movement between/within system(s), database-user-management, database-space-management (e.g. MVC), database-object-management (e.g. Table-Creation/ Table-Rebuild etc.), database-privileges-management, database-performance-monitoring (using Viewpoint or OS-level utilities), release session locks, initiate & monitor BAR jobs etc. · Attend periodic meetings with client · Develop and produce daily/ weekly operations reports and metrics as required by IT management · Develop clear and detailed technical & process documentation (processes for service-requests; SOPs for incidents). Develop and maintain known-error-database (KEDB) documentation for operational issues · Use command line(OS-shell interface) to monitor/analyse/administer domain Qualifications Required Skills: · 3+ years of experience in Teradata-TPT/BTEQ support and development role · Skilled in assimilating ETL business-requirements(BR), understanding the underlying data-model, converting BRs to Teradata-ETL workflow/session/job and implementing the same · Should have strong Teradata-SQL writing skills (write various investigative queries) · Experience in maintaining/versioning Teradata-TPT/BTEQ/TD-Utilities like TPump/FLoad/MLoad/FExp etc. scripts/application on Linux/Unix servers · Good working knowledge of TPT/BTEQ and able to code TPT/BTEQ-jobs/workflow and integrate with Unix/ Linux shell-scripting · Good working knowledge and able to develop, maintain, schedule Unix/ Linux shell scripting, Unix/ Linux space management related with TPT/BTEQ Domain · Good understanding of LDM/PDM, Normalization and De-normalization concept; Ability to understand the data model ; Exposure to Enterprise-DW environment (Knowledge of ETL/DI/BI Reporting) · Good understanding of Teradata-database systems, Teradata database-administration operations. Possess skills in database-administration operations · Well conversant with usage of ticketing system(s) and concept of change-request/ incidents/ service-requests/ problem-records · Basic Unix/Linux shell script maintenance and hands-on experience of OS-command usage · Able to function well in a fast-paced and adaptive environment · Must be ready to work in a 24 X 7 operations/production support SLA based environment, with on-shift & on-call model, involving handling of critical tickets(P1/P2) · Good writing & verbal communication skills using English as a language and should be able to express thoughts, technical-topics in clear & concise manner Preferred: · Experience of and desirability to support data-integration applications like Informatica, Talend, Microsoft-SSIS and Master-Data-Management application like Teradata-MDM application is highly desirable and will be appreciated
Posted on: Tue, 02 Jul 2013 07:09:03 +0000
Trending Topics
Recently Viewed Topics
© 2015