Rajendar Reddy Email & Phone Number

Over 6 years of total IT experience and Technical proficiency in the Data Warehousing involving Business Requirements Analysis, Application Design, Data Modeling, Development, testing and documentation.• Expertise in Teradata Database design, implementation, and maintenance mainly in large-scale Data Warehouse environments• Certified Teradata consultant with experience in Teradata Physical implementation and Database Tuning• Hands on experience in Teradata RDBMS using FastLoad, MultiLoad, TPump, FastExport, Teradata SQL Assistant and BTEQ• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star schema and Snowflake schema (Fact Tables, Dimension Tables) used in relational, dimensional and multidimensional modeling• 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• 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• Experience in writing UNIX shell scripts to support and automate the ETL process• Technical expertise in ETL methodologies, Informatica 6.x/7.x/8.x - Power Center, Power Mart, Client tools – Mapping Designer, Workflow Manager/Monitor and Server tools – Informatica Server Manager, Repository Server Manager, and Power Exchange• Expertise in testing the applications and creating test cases for Unit Testing, Integration Testing and make sure the data extracted from source is loaded into target properly in the right format• Involved in troubleshooting of Informatica jobs and addressing issues like performance tuning and enhancements

Listed skills include Bteq, Teradata, Tpt, Performance Tuning, and 14 others.

• 

  Sr.Teradata Developer

  Codeforce 360

  2008 - 2015

  • Involved in Requirement gathering, business Analysis, Design and Development, testing and implementation of business rules• Implemented logical and physical data modeling with Star and SnowFlakes techniques using Erwin in Data Mart• Created tables, views in Teradata, according to the requirements• Performed bulk data load from multiple data source (ORACLE 8i, legacy systems) to TERADATA RDBMS using BTEQ, Multiload and FastLoad• Performed tuning and optimization of complex SQL queries using Teradata Explain• Responsible for applying the right collect stats on the FACT tables• Performance Tuning of sources, Targets, and SQL queries in transformations• worked on Partition Primary Index(PPI) to improve the performance involving range queries• Validation of the data with respect to the Target CDM (Change Data Management) process.

• 

  Jntuh

  Computer Science