Job Description

3.00 to 10.00 Years
Teradata Developer1)      Informatica 10.2.0, Power Center experience in  tools like workflow manager, workflow monitor, designer and should possess strong Oracle database skills (SQL and PL/SQL)2)      Must be proficient and have extensive experience in ETL   Informatica and Teradata SQL assistant 3)      Analysis, Design, Development and Implementation of ETL process using various Teradata utilities like TPT, BTEQ, FLOAD, MLOAD, TPUMP and FEXPORT4)      Expertise in PL/SQL stored procedures, cursors, triggers and performance tuning5)      Advanced knowledge of ETL, including the ability to read and write efficient, robust code, follow or implement best practices and coding standards, design/implement common ETL strategies (CDC, SCD, etc.), and create reusable/maintainable jobs6)      Experience with Business Intelligence/Data warehousing tools and skills including data  management, database support, SQL, ETL and OLAP concepts7)      Strong knowledge on the Informatica Develop and deploy ETL job workflow with reliable exception handling and rollback framework8)      Creation of complex Informatica mappings and understand performance tuning activities.9)      Knowledge on data modelling to develop Dimension and Fact mappings/jobs10)   Adapt ETL code to accommodate changes in the source data and new business requirements.11)   Manages automation of file processing as well as all ETL processes within a job workflow.12)   Hands on experience in Unix commands, shell scripting and batch processes.13)   Better understanding of Problem solving and RCA   Root cause Analysis 14)   Perform the unit testing, system integration testing and assist with User acceptance testing15)   Strong communication skills with a proven leadership track record and client facing skills