Sr. Teradata Developer Resume
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
