We provide IT Staff Augmentation Services!

Sr. Teradata Developer Resume

0/5 (Submit Your Rating)

San Jose, CA

SUMMARY

  • An accomplished IT professional with referable andtechnical 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
  • Very good understanding of Reporting tools like Cognos and Business Objects
  • Involved in troubleshooting of Informatica jobs and addressing issues like performance tuning and enhancements

TECHNICAL SKILLS

Tools: Teradata SQL Assistant, BTEQ, TPT, FastLoad, MultiLoad, FastExport, TPump, Informatica Power Center 6.x/7.x/8.x, Ab Initio

Languages: C, C++, UNIX Shell Scripting, SQL, PL/SQL, HTML, DHTML, Visual Basic

Applications: MS Word, Excel, Outlook, FrontPage, PowerPoint, MS-Vis

Databases: Teradata, Oracle 8i/9i/10g, DB2, MS SQL Server, Sybase

Data Modeling: Erwin 4.x

PROFESSIONAL EXPERIENCE

Confidential, San Jose, CA

Sr. Teradata Developer

Responsibilities:

  • Understanding the Business Process and providing the interim solution to users.
  • Retrieved data from Teradata database.
  • Involved in SQL performance tuning and also handled critical spool space errors in database.
  • Implemented quick fix and suggested a Permanent fix to the other Teams as per the Business need.
  • Implemented Data fix on database as per the User Request for the Business.
  • Generated the Adhoc data as excel Reports to Users (through Teradata SQl).
  • Done Root cause analysis on Production Support issues.
  • Created UNIX shell scripts as per the business requirement.
  • Developed simple & complex mappings using Designer to load dimension and fact tables as per STAR schema techniques.
  • Implemented Informatica transformations such as Source Qualifier, Aggregator, Expressions, Look up Filters and Sequence Generator.
  • Designing the flow and process of CDM process.
  • Validation of the data with respect to the Target CDM (Change Data Management) process.
  • Received the sales data from stores and loaded that into data warehouse.
  • Involved with migration team to fix the deployment issues in the Production environment.

Environment: Teradata 13.0, Teradata SQL Assistant, Teradata Manager, BTEQ, TPT, MLOAD, FLOAD, FASTEXPORT, UNIX, UNIX Shell Scripts, Ab Initio

Confidential, Richmond, VA

Teradata Developer

Responsibilities:

  • 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
  • Extracted data from various source systems like Oracle, SQL Server and flat files as per the requirements
  • Performed bulk data load from multiple data source (ORACLE 8i, legacy systems) to TERADATA RDBMS using BTEQ, Multiload and FastLoad
  • Created, optimized, reviewed, and executed Teradata SQL test queries to validate transformation rules used in source to target mappings/source views, and to verify data in target tables.
  • 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
  • Designing, creating and tuning physical database objects (tables, views, indexes, PPI, UPI, NUPI, and USI) to support normalized and dimensional models. Maintain the referential integrity of the database
  • Created proper Primary Index taking into consideration of both planned access of data and even distribution of data across all the available AMPS
  • Write numerous BTEQ scripts to run complex queries on the Teradata database
  • Used volatile table and derived queries for breaking up complex queries into simpler queries
  • Created a cleanup process for removing all the Intermediate temp files that were used prior to the loading process
  • Created test cases to unit test the code prior to the handover process to QA. Performed SQL tuning, provided testing approach for unit and SIT testing
  • Streamlined the Teradata scripts and shell scripts migration process on the UNIX box
  • Developed UNIX shell scripts to run batch jobs in production

Environment: Teradata V2R5/12.0, Teradata Administrator, Teradata SQL Assistant, Teradata Manager, BTEQ, MLOAD, FLOAD, FASTEXPORT, Erwin Designer, UNIX, Windows 2000, Shell Scripts

Confidential, Chicago, IL

Teradata Developer

Responsibilities:

  • Development of scripts for loading the data into the base tables in EDW using FastLoad, MultiLoad and BTEQ utilities of Teradata
  • Extracted data from various source systems like Oracle, SQL Server and flat files as per the requirements
  • Performed tuning and optimization of complex SQL queries using Teradata Explain
  • Created a BTEQ script for pre population of the work tables prior to the main load process
  • Used volatile table and derived queries for breaking up complex queries into simpler queries
  • Involved in loading of data into Teradata from legacy systems and flat files using complex MultiLoad scripts and FastLoad scripts
  • Developed MLOAD scripts to load data from Load Ready Files to Teradata Warehouse
  • Involved heavily in writing complex SQL queries to pull the required information from Database using Teradata SQL Assistance
  • Created a shell script that checks the corruption of data file prior to the load
  • Loading data by using the Teradata loader connection, writing Teradata utilities scripts (FastLoad, Multiload) and working with loader logs
  • Created and automate the process of loading using Shell Script, Multi load, Teradata volatile tables and complex SQL statements
  • Created/Enhanced Teradata Stored Procedures to generate automated testing SQLs
  • Involved in troubleshooting the production issues and providing production support
  • Streamlined the Teradata scripts and shell scripts migration process on the UNIX box
  • Involved in analysis of end user requirements and business rules based on given documentation and working closely with tech leads and analysts in understanding the current system
  • Created a cleanup process for removing all the Intermediate temp files that were used prior to the loading process
  • Involved in troubleshooting the production issues and providing production support
  • Developed unit test plans and involved in system testing

Environment: Teradata V2R5, Teradata Administrator, Teradata SQL Assistant, Teradata Manager, BTEQ, MLOAD, FLOAD, FASTEXPORT, ERWin Designer, Quality Center, UNIX, Windows 2000, Shell Scripts

Confidential, Norristown, PA

Teradata/ETL Developer

Responsibilities:

  • Actively participated in transforming enhanced logical data model to physical data model
  • Actively involved in Data Gathering, recognizing and confirming the data sources/elements
  • Designed the ETL processes using Informatica to load data from Oracle, SQL Server, Flat Files, (Fixed Width), XML files and Excel files to target Teradata Database
  • Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center 7.x and 8.x.
  • Worked on installation, configuration of Oracle, Informatica and extensively worked on Repository manager
  • Extensively used ETL to load data from flat files into Staging area and then to Data warehouse
  • Experience in performance tuning of sources, mappings, targets and sessions
  • Implemented various Teradata specific features like selection of PI, USI/NUSI, PPI and Compression based on requirements
  • Implemented access rights mechanism using restricted views, macros and roles
  • Responsible for space management and user management including accounting based on performance group allocation
  • Provide ongoing Teradata system performance management using Teradata manager and PMON
  • Reviewing and monitoring priority scheduler and TDQM settings
  • Involved heavily in writing complex SQL queries based on the given requirements and used volatile tables, temporary tables, derived tables for breaking up complex queries into simpler queries
  • Gather information from different data warehouse systems and loaded into warehouse using FastLoad, FastExport, MultiLoad, BTEQ and Unix shell scripts
  • Involved in unit testing, systems testing, integrated testing and user acceptance testing.
  • Involved in 24x7 production support

Environment: Informatica Power Center 7.x and 8.x, NCR Teradata V2R5, Oracle8i, SQL, C, C++, Shell scripting, Teradata Manager, Teradata Administrator, TDQM, Priority scheduler, BTEQ, SQL Assistant, TSET, Index Wizard, Statistics wizard, FastLoad, MultiLoad, FastExport, TPump

Confidential

Informatica/Teradata Developer

Responsibilities:

  • Involved in the Data warehouse data modeling based on the client requirements
  • Developed Logical and physical database designs for the transaction system
  • Responsible for configuring the Workflow manager, Repository Server Administration Console, Power Center Server, Database Connection
  • Performance tuning on sources, targets, mappings and SQL queries in the transformations
  • Created reusable transformations and Mapplets based on the business rules to ease the development
  • Used various Informatica Error handling technique to debug failed session
  • Development of scripts for loading the data into the base tables in using FastLoad, MultiLoad and BTEQ utilities of Teradata
  • Involved heavily in writing complex SQL queries to pull the required information from Database using Teradata SQL Assistance
  • Done various optimization techniques in Aggregator, Lookup, and Joiner transformation
  • Developed mapping to implement type 2 slowly changing dimensions
  • Developed workflow tasks like reusable Email, Event wait, Timer, Command, Decision
  • Used various debugging techniques to debug the mappings
  • Created Materialized view for summary data to improve the query performance
  • Responsible for scheduling the workflow based on the nightly load
  • Supported Oracle 8i databases running mission critical 24*7 systems

Environment: Informatica - Power Center 6.1, Oracle 8i, Erwin Data Modeler, BTEQ, FastLoad, Multiload, TOAD, Windows XP, Teradata SQL Assistant

We'd love your feedback!