Teradata Developer Resume
SUMMARY
- 6+ years of extensive IT experience in analyzing the requirements, developing applications with a strong expertise as a TERADATA DEVELOPER and SQL DEVELOPER.
- Over 3+ years of experience on Teradata development and OLAP operation with Teradata database.
- Strong hands on experience using the Teradata utilities (SQL ASSISTANT, B - TEQ, Fast Load, MultiLoad, Fast Export, Tpump, Visual Explain, Query man) and Unix Shell (Korn) scripting.
- Loading data by using the Teradata loader connection, writing Teradata utilities scripts (FastLoad, MultiLoad) and working with loader logs.
- Extensive experience in writing and executingBTEQ scriptsfor validation and testing of the sessions, data integrity between source and target database and for report generation.
- UsedTeradata utilities like Multi-Load, Tpump, and Fast Load to load data into Teradata data warehouse from other databases.
- Well versed in writing korn, bash UNIX Shell scripting.
- Skilled in large-scale multi-terabyte initial database load and ongoing update techniques, backup and recovery requirements, SQL, etc.
- Technical expertise in the areas of logical design, physical design and performance tuning of the RDBMS.
- Involved in upgrading from TD12 to TD13.Implemented many applications in present processing utilizing many of the performance enhancements in this upgrade.
- Familiar with designing the application data model and identifying the Primary Index, Secondary Index, Join Indices in Teradata for efficient storage and retrieval.
- Involved in understanding, translating the business requirements to high-level and low-level designs for Extraction Transformation Load (ETL) processes with SSIS and Informatica.
- Designing and developing ETL solutions using SQL Server Integration Services (SSIS) for the interfacing between the source application and the corporate data.
- Design of ETL Mappings and Workflows using Power Center Designer and workflow manager with Informatica.
- Experience in Database Development such as Creation of Databases, Tables, Stored Procedures, Cursors, Triggers and Functions using Transact-SQL (DDL, DML) statements and Database testing.
- Experience in developing ETL modules for extracting, transforming data using Joins, Macros, Indices and Views.
- Provided performance tuning, physical and logical database design support in projects for Teradata systems and have an in-depth understanding of the Database Hierarchy, Data Integrity concepts.
- Involved in designing the physical and logical data models of various applications and gained knowledge in Star and Snowflake Schema, 3NF.
- Possess excellent skills in Data Modeling using MS Visio.
- Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
- Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, data validation, systems integration and user acceptance testing.
- Rapid accommodation to emergent technologies, able to quickly learn new technologies and proprietary
- Experience in interacting with the Business Users to understand the Business needs and create data models to accommodate the same.
TECHNICAL SKILLS
Data Warehousing, Database Tools: Teradata 14.0/13.10/V12/V2R6/V2R5; SQL Enterprise Manager, SQL Client Configuration utility, SQL Management Studio, SQL Server Business Intelligence Development Studio
Teradata Utilities: BTEQ, FastLoad, MultiLoad, FastExport, SQL*Loader,Teradata SQL Assistant, Exp/Imp.
ETL Tools: BTEQ, Informatica.
Reporting Tools: Business Objects,OBIEE 10.x, Excel.
Databases: Teradata, MS SQL Server 2005/2008,Oracle, MS-Access
Other Tools: .Net frame work, MS Office, Quality centre 9.0
Languages: SQL, HTML, XML, PL/SQL, C programming, java
Operating Systems: Windows XP/2000/98, Win NT, UNIX, MS-Dos
PROFESSIONAL EXPERIENCE
Confidential, Washington, DC
Teradata developer
Responsibilities:
- Created Teradata External loader connections such as MultiLoad, Upsert and Update, FastLoad while loading data into the target tables in Teradata Database.
- Created proper Primary Index (PI) taking into consideration of both planned access of data and even distribution of data across all the available AMPS.
- Involved in writing the Business logic in BTEQ and Query optimizations.
- Created Informatica workflows and scheduled the jobs.
- Worked on Teradata loading utilities Multi load, Fast load and Fast Export.
- Worked with Teradata inbuilt macros to take care of capacity planning.
- Participated in implementing and deploying custom ETL framework for customers.
- Creation of Data bases, users, capacity planning, space forecasting, and authorization in Teradata QA and Stage environments.
- Space and User maintenance on dev machine and designing the ETL and conducting review meets.
- Involvement in database optimization and preparation of Production support document.
- Developed the triggers to handle history and audit data for production environment.
- Created users, roles, profiles and Objects and system rights.
- Performance changes to allow fast handling of transaction processing related request (plan caching).
- Created/Enhanced Teradata Stored Procedures to generate automated testing SQLs.
- Involved in tuning of SQL queries for better performance. Worked on database connections, SQL joins views and aggregate conditions.
- Created Understanding documentation and Release Testing documentation on the tickets handled, and documented the issues found in a central repository.
- Involved in the code reviews prepared by the teams.
- Involved in extracting, discussing, and refining business requirements from users and team members.
- Analyzing production support documents and finding the feasible time to run their jobs.
Environment: Teradata V12,V13.1, SFTP, BTEQ, Query man, MultiLoad, fast export, Informatica 7.1, SQL Tools, PL/SQL, Solaris 5.3, Windows XP.
Confidential, Lansing, MI
Teradata/SQL Developer
Responsibilities:
- Involvement in implementation of BTEQ and Bulk load jobs.
- Developed processes on both Teradata and Oracle using shell scripting and RDBMS utilities such as Multi Load, Fast Load, Fast Export, BTEQ (Teradata) and SQL*Plus, SQL*Loader,(Oracle).
- Created joins, macros and secondary indexes for faster retrieval of data.
- Used SSIS and Bulk Insert Task to transfer data in and out of the Server.
- Created tables, views, indexes and user defined functions.
- Optimized query performance by creating Indexes.
- Involved in extracting, cleansing and transforming of the data.
- Staging all the daily files through weekly update cycle and data marts.
- Understanding BRD, Data required document and mapping documents.
- Created SSIS packages for transferring the data from different systems.
- Upgraded SQL Server 2000 DTS packages to SSIS for uploading various formats of files and databases to MS SQL Server 2005 using SQL Server Integration Services (SSIS).
- Worked on preparing a table of summarization and aggregation of the fact data.
- Involved in implementing performance tuning of TSQL queries and Stored Procedures in sync with Performance testing team.
- Developed complex stored procedures to create various reports.
- Used DDL and DML for writing triggers, stored procedures and data manipulation.
- Created primary keys, primary indices, secondary indices, views, triggers, macros for easy data retrieval as well as for data integrity.
Environment: Teradata V2R6, Teradata SQL Assistant, BTEQ, FLOAD, FEXP, MLOAD, FTP, Windows XP, UNIX.SQL Server 2000/2005, SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), Visual Studio, .Net, Windows XP/2003 Server.
Confidential
SQL DEVELOPER
Responsibilities:
- Developing Star Schemas, extraction, transformation & loading processes creation of tables, Indices, Triggers, Constraints, Stored Procedures, Views, Logins, Roles, Users and assigning permissions.
- Created maintenance plans for optimization, integrity, backups of databases, transaction logs, restoring databases and DBCC Checks
- Responsible for Database Recovery, Database Backups and Restores, Attaching and Detaching Databases to move it on different servers.
- Tuning and Optimization of Queries.
- Using Visual Source Safe for Version Control of scripts and stored procedures.
- Upgraded SQL Server 7.0 to SQL Server 2000 and applied patches as and when needed.
- Created the logical and physical data modeling using MS Visio tool.
- Loaded data using BCP utility.
- Configured the Log shipping and created the Standby server.
- Prepared Estimates for Database, table size growth.
- Tuned Complex SQL Queries.
- Preparing the reports for the day-to-day as well as weekly/monthly purposes.
- Wrote and integrated Stored Procedures to generate the Reports.
Environment: Windows NT 4.0, SQL Server 7.0/2000, MS Visio, Visual Source Safe 6.0.
Confidential
Jr.SQL Server Developer
Responsibilities:
- Study and understand the requirements of the information required by company’s Procurement Department about the vendors.
- Normalize data sets and re-design the data from scratch including logical and physical design.
- Actively involved in troubleshooting problems throughout the development process.
- Install, Update, Configure and Maintain the MS SQL Server.
- Created a report interface using Visual Basic 6.0, which allowed users to select reports and dynamically filter reports.
- Tuning front-end applications like Visual Basic, which query the SQL Server database.
- Involved in implementation of user logins, roles and profiles as a part of Security Policies for various categories of users.
- Created database objects like tables, views, indexes, stored-procedures, triggers, and user defined functions.
- Written T-SQL queries for the retrieval of the data.
- Developed administrative tasks of SQL Server of performing daily Backups and Recovery procedures.
- Worked with the developing team in the Writing functions in Visual Basic 6.0 for Upload download functionality, Data transfer and migration.
- Involved in developing functions in VB for Encryption, Decryption of Password and User name.
- Develop code and analyze it in Visual basic 6.0 for the front-end interface.
- Played an important role in ensuring timely delivery of the whole set of data & their queries to the Procurement Department.
Environment: MS SQL Server 2000, Windows NT, Visual Basic 6.0, Access, Excel, Windows 2000.