We provide IT Staff Augmentation Services!

Sr. Teradata Developer Resume

0/5 (Submit Your Rating)

San Jose, CA

SUMMARY

  • Over 6+ years of total IT experience andTechnical proficiency in the Data Warehousing involving Business Requirements Analysis, Application Design, Data Modeling, Development, testing and documentation.
  • Expertise in TeradataDatabase 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 Assistantand 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 UNIXshell 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 forUnit 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

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

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 TeradataSQl).
  • 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.

Confidential, Richmond, VA

Teradata Developer

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

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

Confidential, Chicago, IL

Teradata Developer

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

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 TeradataSQL 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

Confidential, Norristown, PA

Teradata/ETL Developer

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.

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

Confidential

Informatica/Teradata Developer

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

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 TeradataSQL 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

We'd love your feedback!