Informatica Developer Jobs at TeraData

at | Posted on 26 May, 2014
Apply Mock Interview Refer
Job Description

1. Technical Consultant ( Teradata Operations Support Consultant )-154583


· -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

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


2. Senior Technical Consultant (Informatica Developer)-153764


As the global leader in data warehousing and analytic technologies, Teradata solutions make smart companies smarter.  Teradata gives companies the people, technology, innovation and a world-class network of customers and partners enabling them to gain competitive advantage to master their markets.  With Teradata, the smartest wins. Learn more at


Position Title: Senior Technical consultant

Job Category:   Permanent

Location: Mumbai

Job Summary  

Teradata has numerous positions available for staff consultant, consultant and senior consultant level data warehouse technical positions within the Teradata Global Consulting Center India organization. This is a project oriented position in either onsite or offsite situations having accountability for managing client expectations while delivering the services and solutions associated with the Teradata database. The Consultant provides technical services related to analysis, design, build, performance tuning, testing and integration of all components of the Business Intelligence solution in conjunction with other project team members on a specific client engagement.   

Basic Skills

•  -Excellent oral and written communication and presentation skills, analytical and problem solving skills

Basic Qualifications

  • -Bachelors Degree from a reputed Educational Institute.
  • -Post-graduate degree is a plus.
  • -Should have 8+ years of IT experience and 5 years of Informatica experience
  • -Should have worked on Informatica 8.x (preferably Informatica 8.6)
  • -Should have sufficient experience to work on UNIX & Shell Scripting
  • -Should have strong PL/SQL & SQL Tuning skills

Key Responsibilities  

  • -This individual will be responsible for solution design, integration, data sourcing and transformation, database design and development (logical / physical) and tool implementation related to data warehousing in the retail industry (responsibility level will be commensurate with the position level and will begin in a learning mode).
  • -Interface with Teradata engineering staff as needed to resolve complex technical issues
  • -Specify, demonstrate and scope Teradata solutions that deliver business value to the client / prospect.
  • -Transfer knowledge and expertise to other TERADATA professional services associates.
  • -Provide technical expertise to data warehouse clients that will contribute to innovative business solutions.

Professional Development Offered:-

-  Training on the Teradata database

-  Opportunities to work on high-profile international projects


Not disclosed


Not mentioned

About Company

About the Company: 

Teradata is a global leader in analytic data platforms, marketing and analytic applications, and consulting services. Teradata helps organisations collect, integrate, and analyse all of their data so they can know more about their customers and business and do more of what’s really important. Visit for details.


Specialties: analytic data platforms, marketing and analytic applications, consulting services


10000 Innovation Dr Miamisburg, OH 45342 United States

Know more about TeraData
Popular Skills
C# MVC HTML CSS JQuery Javascript SEO SQL PHP XML ASP.NET Unix Java Oracle PL/SQL C MySQL C++ Android Application Development IT Business development activities Marketing communications Networking Core Java Testing Photoshop Illustrator Magento Linux ManualTesting HTML5 CSS ajax css3 JDA Android Marketing and Publicity Social Media Marketing and Branding Content Writer business develpment marketing sales CRM Sales Management and Effectiveness Digital Marketing Business Development Excellent Communication Skills php with Mysql business analysis C#.Net Lead Generation R good communication skill Json iOS Willing to work in rotataional Shifts account Market Research Good Communication Skills creative writer Content Development technical writing HTTP Channel Sales Social Media Marketing Campaigns content development SQL Nagios Apache DNS Basic competencies: - Fluency in English– written and oral -