Teradata-Informatica Developer Resume Example

7 years of experience in the IT industry, coupled with extensive experience in Data Warehousing Teradata (V2R6/12.0/13/14) & UNIX Environment for Decision Support Systems. *Extensive experience in TeradataDatabase design, implementation and maintenance mainly in large scale Data Warehouse environments. *Extensive experience in Administration and maintenance of Dev, Stage, prod and standby databases for DSS and Data Warehousing environments. *Strong background in healthcareand Clinical insurance projects. *Experienced working with healthcare data. *Comfortable with both technical and functional applications of RDBMS, Data Mapping, Data management, Data transportation and Data Staging. *Hands on experience in Teradata RDBMS using FASTLOAD, MULTILOAD, TPUMP, FASTEXPORT, Teradata SQL and BTEQ Teradata utilities. *Expertise in Resource Management using TDQM *Expert in Coding Teradata SQL, Teradata Stored Procedures, Macros and Triggers. *Involved in full lifecycle of various projects, including requirement gathering, system designing, application development, enhancement, deployment, maintenance and support. *Expertise in Query Analyzing, performance tuning and testing. *Hands on experience in monitoring and managing varying mixed workload of an active data warehouse using various tools like Teradata Workload Analyzer, Teradata Dynamic Workload Manager and Teradata Manager. *Experience in writing UNIXshell scripts to support and automate the ETL process. *Scheduled the Shell scripts through Maestro Jobs to kick off the Batches. *Experience in different database architectures like Shared Nothing and Shared Everything architectures. Very good understanding of SMP and MPP architectures. *Experience in Oracle RDBMS Architecture. *Worked on Agile methodology. *Extensive experience in Logical and physical modeling using Erwin. Hands on experience in 3NF, Star and Snowflakeschema design and De-normalization techniques. *Involved in Unit Testing, Integration Testing and preparing test cases. *Proficient in converting logical data models to physical database designs in Data warehousing Environment and in-depth understanding in Database Hierarchy, Data Integrity concepts and Data Analysis. *Developed Power BI reports using Power Query from SharePoint & different Data sources. *SSH TUNNEL, to allow compressed log transportation. *Experience in ETL tools like Informatica, AbInitio. *Experience with Teradata Unity system in the environment *Very good understanding of Reporting tools like Cognos and Business Objects. *Involved in production support activities 24/7 during on call and resolved database issues.