SUMMARY:

• Around 6+ years of experience in design, development, implementation, testing, maintenance and administration of Teradata database and having knowledge on big data technology like Hadoop.
• Having good knowledge on Teradata Database Architecture, Database Features and Teradata tools.
• Having good knowledge on ETL tool Informatica Power Center on OLAP and OLTP environment for Banking Insurance and Health care clients.
• Experience in using Teradata tools and utilities like BTEQ, SQL Assistant, Teradata Manager, Teradata Workload Analyzer, Teradata Visual Explain, Teradata Index Wizard.
• Designed, developed, tested and supported Extract, Transform and Load (ETL) processes necessary to load and validate data warehouse using UNIX shell scripting.
• Proficient in data modeling for OLTP relational da tabases and Data Warehouse applications using Ralph Kimball and Bill Inman design principles including facts and dimensions tables, Slowly Changing Dimensions (SCD) and Dimensional Modeling - Star and Snow Flake Schema.
• Strong hands on experience on Teradata tools such as BTEQ, FLOAD, MLOAD, TPUMP, FASTEXPORT, TPT(Teradata Parallel Transporter).
• Well versed knowledge on SQL scripts on various Relational Databases.
• Expertise in creating databases, users, tables, triggers, macros, views, functions, Packages, joins and hash indexes in Teradata database.
• Having good knowledge on Hadoop Eco-systems like HDFS, MapReduce, PIG, HIVE.
• Extensively knowledge with Teradata SQL Assistant. Developed BTEQ scripts from to load data from Teradata. Staging area to Data Warehouse, Data Warehouse to data marts for specific reporting requirements. Tuned the existing BTEQ script to enhance performance.
• Strong Knowledge in Relational Database Concepts, Entity Relation Diagrams, Normalization and De-normalization Concepts.
• Experience with software development life cycle (SDLC), Agile, Scrum and Project Management Methodologies.
• Attend and participate in meetings that pertain to assigned responsibilities.
• Expertise in Problem solving and Tracking Bugs during the production failure.
• Strong experience in shell scripting with different shells like Korn shell and BTEQ scripts in Teradata using UNIX.
• Highly interacted with the Business Users to gather requirements, Design Tables, standardize interfaces for receiving data from multiple operational sources, coming up with load strategies of loading staging area and data marts. Dealt with Type1/Type2/Type3 loads.
• Good knowledge on Teradata Macros, BTEQ scripts & Utilities like Multi load, Fast load etc.
• Involved in Teradata BTEQ scripts performance tuning for long running queries in production by using explain plains.
• Generated SQL and PL/SQL scripts to install create and drop database objects including tables, views, primary keys, indexes, and constraints.
• Experience on Agile Methodology is good.
• Extensive ability to debug, to troubleshoot, and solve complex PL/SQL issues, and the ability to reverse engineer existing PL/SQL code into functional requirements.
• Extensively worked on creating, executing test procedures, test cases and test scripts using Manual/Automated methods.
• Highly motivated with the ability to work effectively in teams as well as independently.

TECHNICAL SKILLS:

Programming Languages: C, SQL,PL-SQL Shell scripting

Databases: Teradata

Teradata Load and Unload Utilities: FLOAD, FASTEXPORT, MLOAD, TPUMP, TPT

Database Administration Tools: Index Wizard, Query scheduler, Workload analyzer, Viewpoint

Query management tools: BTEQ, SQL assistant

ETL Tools: AIX-BM Tool, Informatica

Administrator tools: Teradata Manager, Teradata Administrator

Operating Systems: UNIX, LINUX and Windows

PROFESSIONAL EXPERIENCE:

Confidential, Long Beach, CA

Sr.Teradata Developer

Responsibilities:

• Extensively used TPT for distributing data into data streams shared with multiple instances of operators to scale up data parallelism.
• Worked on loading techniques like slowly changing dimensions and incremental loading for extraction, transformation, and loading of the data using Teradata.
• Extensively used TPT to provide optimal and scalable performance for getting data in and out of your Teradata Database.
• Involved in Create / Modify / Drop Teradata objects like Tables, Views, Join Indexes, Triggers, Macros, Procedures, and Databases.
• As a initial load process, we will Mload this file in to Teradata staging table and archive the file in to archive folder after Mload completes successfully.
• This actual load process contains mostly Teradata stored procedures and are scheduled to run every day through 3 rd party scheduling tool.
• After completion of load process, we will run Validation process to validate the data loaded in target tables against source.
• Develop Fast load scripts to load data from host file in to Landing Zone table.
• Involved in writing the ETL specifications and unit test plans for the mappings.
• Apply the business transformation using BTEQ scripts.
• Creating Database Tables, Views, Functions, Procedures, Packages as well as Database Sequences, Triggers and database link.
• Written SQL queries for retrieving the required data from the database.
• Tested and Debugged PL/SQL packages.
• Create BTEQ scripts to load the data from staging table in to target table.
• Used standard packages like UTL FILE, DMBS SQL, and PL/SQL Collections and used BULK Binding involved in writing database procedures, functions and packages.
• Provided required support in Multiple (SIT, UAT & PROD) stages of the project.
• Prepared BTEQ import, export scripts for tables.
• Written BTEQ, FAST LOAD, MLOAD scripts.
• Developed statistics macros and automated to run based on the frequency.
• Performance tuning, monitoring and index selection w Cleaned up the unused Profiles and Roles, eliminated redundant security rights to eliminate user level security. hile using PMON, Teradata Dashboard, statistics wizard and Index wizard and Teradata Visual Explain to see the flow of SQL queries in the form of Icons to make the join plans more effective and fast.

Environment: Teradata 14, Teradata SQL Assistant, Teradata Manager, PL/SQL, UNIX, Scripts, MLOAD, BTEQ, FASTLOAD.

Confidential, Greenwood Village, CO

Teradata Developer

Responsibilities:

• Interacted with business analyst and business team based on the need to understand the business purpose of the requirements.
• Requirements analysis, data assessment, business process reengineering, index maintenance & analysis. Working with ETL leads to formulate ETL approach and appropriately uses Teradata Tools and Utilities.
• Created database schemas based on the logical models and involved in planning of the physical database and data-files mapping.
• Worked on Workflow Manager to Schedule the workflows and run the sessions according to job dependency.
• Implemented phasing and checkpoint approach in ETL process to prevent data loss and to maintain uninterrupted data flow against process failures.
• Uploaded data from operational source system (Oracle 8i) to Teradata.
• Used utilities of FLOAD, MLOAD, FEXP, TPUMPof Teradata and created batch jobs using BTEQ.
• Designed the ETL processes using Informatica to load data from various heterogeneous sources to target Teradata Warehouse database.
• Optimized distribution of data on amps thru creation of matching PI's across instances.
• Prepared BTEQ scripts to load data from Preserve area to Staging area.
• Worked on Teradata SQL Assistant querying the source/target tables to validate the BTEQ scripts .
• Troubleshoot the issues by checking sessions and workflow logs.
• Wrote Unix Shell scripts to automate workflows.
• Developed unit testing, systems testing and post-production verification.
• Involved in writing the test cases and documentation. Implemented change data capture (CDC) using Informatica power exchange to load data from clarity DB to Teradata warehouse.
• Implemented different kind of purging techniques to free up space in certain teradata databases and to remove orphan records from collection tables.
• Provided support during the system test, Product Integration Testing and User Acceptance Testing and also Edited the data that is in excel as per the User request by applying filters right from the data connection which is excel.

Environment: Teradata 12, Teradata Utilities (Fast Load, Multi Load, Fast Export, SQL Assistant, Bteq), Viewpoint, TASM, Visual Studio, Tableau 4, Teradata SQL, Teradata EDW Roadmaps, Teradata Relationship Manager, SSIS, SSAS, Informatica 8.X.