We provide IT Staff Augmentation Services!

Teradata Dba/architect Resume

NJ

SUMMARY:

  • Expert in tuning complex Teradata SQL Queries including Joins, Correlated Sub queries, and Scalar Sub queries.
  • 11+ years of experience in Teradata Enterprise Data Warehouse (EDW/ADW) and Data Mart.
  • Teradata Certified Professional in V2R5.
  • Experience working with clients of all sizes in the insurance, financial, Retail, healthcare, manufacturing industries.
  • Good understanding of DataWarehousing concepts such as Third Normal form (3NF) as well as Dimensions Schema.
  • Used Informatics’ features to implement Type II, III changes in slowly changing dimension (SCD) tables.
  • Developed Teradata 14.10&15.10 features such as PPI, Character PPI, and Timestamp PPI, and Columnar Tables.
  • Having good experience in Teradata appliance/Enterprise server and its tools such as (Teradata 14, SLES, and Viewpoints, BAR, TASM, SWS, and TVI).
  • Expert DBA skills in Teradata DBMS Administration, development and production DBA support, use of Teradata Manager, FASTLOAD, MULTILOAD, TSET, TPUMP, SQL, PDCR and ARCMAIN, TASM for workload management.
  • Experience in planning and coordinating Di recovery solution for Teradata
  • Working with BUSINESS OBJECTS/OBIEE team to optimize various report run times by applying various TD performance techniques such as Partitioning, JIs, AJIs, USI and NUSI.
  • Existing FT Physical DM is created based on even distribution of tables by defining 10 to 20 column Primary Indexes not taking usage into consideration. Redesigned and Optimized the Finance Transform Physical DM by defining the right PIs and PPIs using ELDM. Also implemented multi - valued compressions and Soft RIs when necessary.
  • Implemented various Teradata recommended best practices while defining Profiles, Roles, Alerts, Multi-Value Compression, ABU, TARA GUI, Teradata Unity Data Mover, and NetBackup.
  • Created and implemented BAR strategy for the TD application and system databases.
  • Did the Teradata SQL troubleshooting and fine tuning of scripts given by Analysts and developers.
  • Created PPI for some of the monthly and daily tables to have a good performance on range queries with date constraints. Also created NUSI on PI column for the PPI tables have a good performance on queries with PI access.
  • Implemented ETL level collection statistics for the Indexes and for some of the columns going to be involved in the constraints or join conditions.
  • Defined account IDs, priority scheduler performance groups, and system date and time substitution variables in user and profile definitions.
  • Developed a Logical and Physical data models for all new applications.
  • Responsible for the design and implementation of the entire DW Dimensional Model architecture using Join Indexes and Partitioned Primary Indexes to achieve and exceed the desired performance.
  • Generated a Capacity management reports on analyzing the Spool/CPU/I/O/Usage resources and proactive monitoring to meet performance and growth requirements on PDCR Database.
  • Having good experience in SUSE 11/ Linux operating system and command set as well as competence with shell scripting.
  • Set up the Teradata Workload Manager with the proper partitions and workloads based on Service Levels. Set up Teradata Query manager to automate many of the DBA tasks such as collection of statistics, monitoring spool space, candidate tables for purge, etc.
  • Modification of views on Databases, Performance Tuning and Workload Management. Maintenance of Access Rights and Role Rights, Priority Scheduling, Dynamic Workload Manager, Database Query Log, Database Administrator, Partitioned Primary Index (PPI), Multi-Value Compression Analysis, Usage Collections and Reporting of ResUsage, AmpUsage, Security Administration Setup etc. and leading a team of developers for workaround with different users for different, complicated and technical issues.
  • Involved in Implementation projects such as ORACLE to TERADATA DB/DW, and SQL SERVER to TERADATA conversion projects.
  • Involved and logged the incidents in TaYS and called to Teradata (GSC) for analysis.
  • Gathered troubled SQL’s log through TSET and sent it to Teradata GSC.

TECHNICAL EXPERIENCE:

Database: Teradata 13.10, Teradata 14.0/14.10, 15.00/15.10 Teradata V2R5, V2R6, 13.00.01.19 and V2R12, DB2, Oracle 9i, Vsam

Reporting Tool: Business Objects XI, OBIEE, MicroStrategy, SAS, Tableau

ETL: Informatica 9.0.1,TD ETL Mload, Fload, Xport, Bteq, Tpump, Jcl, SQL, Cobol, SPL, SSIS, ABINITIO, AB INITIO,PL/SQL, JAVA, TSO, MVS, ISPF, Teradata STUDIO 5.1

Modeling Tools: Erwin and Visio Enterprise

Operating Systems: Windows 2000, SUSE 11 LINUX, UNIX: Sun Solaris, HP-UX

Methodologies: Business Process, Relational Data Modeling, Logical Data Modeling, Object Oriented Modeling, SQL Assistant, Object Relational Modeling, and Physical Database Design, Power Designer 16, Tset, TPT, Visual Explain, Workload Manager, Teradata Priority Scheduler, Teradata Visual Explain, Teradata Manager & Administrator, Net vault, TASM, TD Unity Data Mover, Viewpoint, PDCR, SWS, TVI, BAR, SLES, TARA GUI, TDB, Autosys, SSIS, MQ Series.

Backup Technologies: ABU, Net vault/Netbackup GUI tools, Bar scripts, Data Mover, Tara

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Teradata DBA/Architect

Responsibilities:

  • Responsible for Installing and configured the Teradata 14.10 release for “ Confidential -EIW customer.
  • Performed performance Tuning and Administration activities of Teradata .
  • Have implemented Teradata Aster Big data, Hadoop analytics.
  • Worked on Big data MAP REDUCE functions in Aster DB.
  • Handled Confidential “EIW” SQL Server/DB2/ORACLE Migration project to Teradata.
  • Integrated Hadoop systems with Teradata DW/DB.
  • Setup and Configured the Teradata 14.10 release for Confidential client, and it is a TWO nodes Appliance server 2750 Model for PROD and QAT, and 1 node for DEV system.
  • Setup and installed the ABU Backup tool for Confidential client .
  • Setup and configured the Teradata Viewpoint portals for new systems such as Prod, Test, and Dev servers.
  • Installed, and configured all Teradata TTU 14.10/15.10 tools such as SQL Assistant, Teradata Admin, Viewpoint, and Visual explain, and stats wizard.
  • Handled Workload monitoring using TASM.
  • Handled Teradata 15.10 software upgrade, and also involved hardware and software maintenance activities.
  • Created alert policies for monitoring Sessions, Filters, Throttles, and Exceptions, TASM priority scheduler thru Workload Designer.
  • Involved in Physical Data Modeling, and deployed new DDL’s in Teradata DEV servers.
  • Deployed DDL’s in Stage and Integration databases in all the Servers.
  • Created a Good Primary Index based on SQL Join access frequency.
  • Created a Cover views on all Base tables.
  • Developed Semantic View logics for Business team.
  • Involved in Collect Stats task for all new DDL’s.
  • Involved in MVC Compression tasks.
  • Involved in Table Cleanup activities in Non-Prod servers.
  • Refresh PROD data into a Non-Prod Servers on Monthly basis.
  • Highly experienced in SQL performance tuning/SQL optimization and debugging of ETL Informatica process.
  • Handled Teradata performance SQL Tuning, Query optimization (Explain plans, Collect statistics, Primary and Secondary/ join indexes).
  • Involved in Teradata 14.10/15.00 DBA activities and implemented all new features such as Character based PPI, and Timestamp PPI, and Temporal tables, and columnar tables.
  • Implemented diff types of join Index’s, which helps optimizer to generate better Explain plans, for complex join conditions.
  • Developed Semantic views, and implemented diff types of Indexes such as NOPI, UPI, NUPI, USI and NUSI, PPI, and JI’s, and AJI’s (Multilevel Join Indexes with compressed).
  • Performed application level DBA activities creating tables, indexes, monitored and tuned Teradata BETQ scripts using Teradata Visual Explain utility.
  • Performed Space Management for Perm & Spool Space.
  • Developed a Logical and Physical data model.
  • Generated CPU and DISK IO usage capacity reports thru DBC queries on weekly.
  • Implemented Columnar tables and temporal tables.
  • Worked on SSIS ETL with Teradata VDI machines, and performed transformations.
  • The SSIS Import/Export Wizard helps create packages that move data from a single data source to a Teradata.
  • Connected different DB instances, and import/Export the data thru SSI into SQL Server/Teradata db.
  • Handled USER management requests such as creating new Users& Profiles, and Roles.
  • Teradata 15.10 Viewpoint is used to monitor the system performance when it is in load.
  • Debugging& Tuned the Complex end user written queries for better performance.
  • Handled Space Management.
  • Designed and implemented the Physical Data Model in Teradata thru ERWIN tool.
  • Defined the different access paths (i.e, UPI, NUPI, USI, NUSI, PPI, JI...) based on access frequency of the object.
  • Developed the DDL's as per Teradata standards in terms of performance gain.
  • Set upped diff types of Backup jobs such as Daily/Weekly/Monthly, and Full/Online backup jobs in ABU GUI Tool.
  • Developed BAR scripts for new databases and tables thru ABU GUI tool.
  • Having solid experience with NPARC, which handles the data movement between two diff systems using a named pipe instead Tape for faster.
  • Configured Teradata ABU for handling the Multistreams backup jobs.
  • Having sound experience in ETL informatica/Ab initio/SSIS with Teradata integration technologies, and Guided ETL team how to enhance the transformation logics thru BTEQ/PDO options.
  • Developed Bar, pie charts on Tableau desktop reporting tool.
  • Developed dashboard reports on Tableau tool.

Environment: Teradata 14.10/15.10 , SQL, DBQL, Informatica 9.5, Data Mart Views, Semantic Views, Index, Tableau BI, Viewpoint, Linux, TASM, Admin Tool, ABU GUI (Arcmain, Restore, Copy), BO, (Teradata ELT Utilities - Multiload, FastLoad, SQL Assistant, Autosys, TSET, BTEQ, Tpump), DBA Tools(SWS, TVI, BAR, SLES), SSIS, Ab initio, TPT, Java, Teradata Studio 5.1, MQ series, Workload Manager, Teradata Studio, Join Indexes, Erwin.

Confidential, Minneapolis, MN

Teradata DBA /Architect

Responsibilities:

  • Responsible for solving the issues from “ TARGET-EDW” customer support on 24x7 bases .
  • Performed performance Tuning and Administration activities of Teradata .
  • Involved in the EDW complete re-design of the process flow, starting with design considerations, technical specification and source to target mapping.
  • Setup and configured the Teradata Viewpoint portals (thru Admin option) for new systems such as Prod, Test, and Dev servers.
  • Handled and performed Teradata Ferret utilities such as Packdisk, Scandisk, and freespace to release the unused spaces across cylinders thru Teradata Manager.
  • Installed, and configured all Teradata 13.10/14.10 tools such as SQL Assistant, Teradata Admin, Viewpoint, and Visual explain, and stats wizard.
  • Handled Workload monitoring using TASM.
  • Created alert policies for monitoring Sessions, Filters, Throttles, and Exceptions, TASM priority scheduler thru Workload Designer.
  • Highly experienced in SQL performance tuning/SQL optimization and debugging of ETL Informatica process.
  • Involved in Teradata Query Tuning and tuned complex Queries, and Views, and implemented Macro’s for reduce Parsing time.
  • Handled Teradata performance SQL Tuning, Query optimization (Explain plans, Collect statistics, Primary and Secondary indexes).
  • Involved in Teradata 13.10/14.10 DBA activities and implemented all new features such as Character based PPI, and Timestamp PPI, and Temporal tables, and columnar tables.
  • Implemented diff types of join Index’s, which helps optimizer to generate better Explain plans, for complex join conditions.
  • Developed Semantic views, and implemented diff types of Indexes such as NOPI, UPI, NUPI, USI and NUSI, PPI, and JI’s, and AJI’s (Multilevel Join Indexes with compressed).
  • Designed and build a Temporary tables thru Batch Job, for Simplify a Complex views.
  • Performed application level DBA activities creating tables, indexes, monitored and tuned Teradata BETQ scripts using Teradata Visual Explain utility.
  • Tuned & developed a semantic views for - Micro strategy report generated SQL ’s.
  • Wrote ETL Informatica scripts to load the data in Teradata DW.
  • Developed Unix/MVS Teradata Scripts to load source systems data into Target DW.
  • Performed Space Management for Perm & Spool Space.
  • Generated CPU and DISK IO usage capacity reports thru PDCRDATA queries on weekly.
  • Involved in migration of ORACLE data into TERADATA DB/DW.
  • Connected different DB instances, and import/Export the data thru SSI into SQL Server/Teradata db.
  • Handled USER management requests such as creating new Users& Profiles, and Roles.
  • Teradata 13.10 Viewpoint is used to monitor the system performance when it is in load.
  • Debugging&Tuned the Complex end user written queries for better performance.
  • Handled Space Management.
  • Designed and implemented the Physical Data Model in Teradata thru ERWIN tool.
  • Converted DB2/ORALCE Logical data models into Teradata Logical and Physical db models.
  • Defined the different access paths (i.e, UPI, NUPI, USI, NUSI, PPI, JI...) based on access frequency of the object.
  • Developed the DDL's as per Teradata standards in terms of performance gain.
  • Set upped diff types of Backup jobs such as Daily/Weekly/Monthly, and Full/Online backup and PPI&Triggered based backup jobs in Net vault/Netbackup GUI Tool.
  • Developed BAR scripts for new database’s and tables thru Netbackup/Netvault GUI tool.
  • Having good experience with Backup and Recovery using Teradata ARCMAIN in Net Vault.
  • Having solid experience with NPARC, which handles the data movement between two diff systems using a named pipe instead Tape for faster.
  • Having good experience with Teradata Unity Data Mover (TDM), which transfer the data and database object’s from Production into a Non-Production database’s thru schedule job.
  • Configured Teradata TARA server for handling the Multistreams backup jobs.

Environment: Teradata 13.10, SQL, Index, Viewpoint, PDCR DATA/INFO, ARC NET VAULT (Arcmain, Restore, TaraGui, Datamover), Microstrategy, Semantic Views, (Teradata ELT Utilities - Multiload, FastLoad, SQL Assistant, PMON, TPT, TSET, TASM, BTEQ, Tpump), Informatica 9.0.1, DBA Tools(SWS, TVI, BAR, SLES), SAS BI, Teradata Studio 5.1, TPT, Workload Manager, SSIS, Unity Data Mover, Join Indexes, Power Designer 16, Microsoft Products, ISPF, TSO, Java, Erwin.

Confidential, Charlotte, NC

Teradata Database Administrator

Responsibilities:

  • Involved in the complete re-design of the process flow, starting with design considerations, technical specification and source to target mapping.
  • Responsible for solving the issues from EIW customer support on 24x7 On-call issues.
  • Involved in Teradata 13.00.01 DBA activities in the tests, such as creation of users, spool, temporary, permanent space. Checking the tables skewing, compression.
  • Performance Tuning, Query optimization (Explain plans, Collect statistics, Primary and Secondary indexes).
  • Performed application level DBA activities creating tables, indexes, monitored and tuned Teradata BETQ scripts using Teradata Visual Explain utility.
  • Performed Space Management for Perm & Spool Space.
  • Created users with different profiles and Roles through Stored Procedures, to control the access on the system.
  • Supported Business Object report generated SQL’s.
  • Handled Netvault/Netbackup Backup and Recovery tasks, and Tape Management, and Drive issues.
  • Used Teradata Manager& Administrator to Monitor and Manage Teradata Databases.
  • Involved in various Operational Teradata DBA activities on daily basis.
  • Teradata 13 Viewpoint is used to monitor the system performance when it is in load.
  • Worked on loading of data from several flat files sources to Staging using Teradata TPUMP, MLOAD, FLOAD and BTEQ in Mortgage applications.
  • Interacted with Clients, Data Modeler and Data Analyst to develop the Logical & Physical Design for the new tables.
  • Worked on TSET tool, to get the Explain Log, and send it to Teradata team to analyze it.
  • Implemented the Work Orders in Production Systems.
  • Experienced with Backup and Recovery using Teradata ARCMAIN in Net Vault.
  • Build tables, views, UPI, NUPI, USI and NUSI, PPI.
  • Handled Workload monitoring using TASM.

Environment: Teradata 13.1, UNIX, Viewpoint, Teradata Administrator& Manager, PDCR DATA/INFO, DBQL, NET VAULT/NETBACKUP (Arcmain Backup Restore, TaraGui, Datamover), (Teradata ELT Utilities - Multiload, FastLoad, PDCRDATA, SQL Assistant, PMON, TSET, TASM, MQ Series, Visual Explain, FastExport, BTEQ, Tpump), JAVA, Informatica 9.0.1, DBA Tools(SWS, TVI, BAR, SLES), ETL JCL, SAS BI, MVS, ISPF, TSO, Abi nitio, Autosys, ArcMain, TD SQL, Microsoft Products, Linux, DB2, Erwin.

Confidential, Medicaid, NY

Teradata Data Base Administrator

Responsibilities:

  • Involved in DBA activities in the tests, such as creation of users, spool, temporary, permanent space.
  • Checking the tables skewing, table compression, and Index recommendations.
  • Used Teradata Manager& Administrator to Monitor and Manage Teradata Databases.
  • Performed application level DBA activities creating tables, indexes, monitored and tuned Teradata BETQ scripts using Teradata Visual Explain utility.
  • Suggested some tuning of DBS control parms such as MaxLoadTasks, DBSCacheThr, MaxParseTreeSegs, ReadAheadCount, FreespacePercent, Cylinderssavedforperm, DefragLowCylProd, MiniCylPackLowCylProd etc.
  • Designing Archival Jobs, considering archival resources like the number of Media Servers, tapes, various limiting factors of Transmit/receive of data to the media in Netvault.
  • Capacity planning and proactive monitoring to meet performance and growth requirements on PDCR Database.
  • Debugged MicroStrategy queries, and enhanced the tuning tips.
  • Monitoring Production system whenever in need and controlling Online and Batch jobs.
  • Converted DB2 Logical data models into Teradata Logical and Physical database models.
  • Interacted with Clients, Data Modeler and Data Analyst to develop the Logical& Physical Design for tables.
  • The SSIS Import/Export Wizard helps create packages that move data from a single data source to a Teradata.
  • Performed bulk data load from multiple data source SQL SERVER, LEGACY SYSTEM to TERADATA RDBMS using BTEQ, Fastload, Multiload and TPump.
  • Extensively used Teradata system Priority Schedule in controlling the load of the system.
  • Worked on exporting data to flat files using Teradata FEXPORT.

Environment: Teradata 13/V2R6, Teradata Manager, Teradata Administrator, TSET, TPT, TDWM,, NETVAULT(TARAGUI, Archive*Restore), (ETL tools) Multiload, FastLoad, PMON, FastExport, BTEQ, JCL, Viewpoint, TASM, Tset, TPT, TD Unity Data Mover, PDCRDATA, DB2, Tpump, Power Designer 16, MicroStrategy, MQ Series, Priority Scheduler, Autosys, Ldap, JAVA, DBQL, PMCP, Visual Explain, Zeke Schedule, Unix-AIX, SSIS, Jcl, Mvs, TSO,ISPF, Td sql, ERWIN.

Confidential, Ar

Teradata DBA

Responsibilities:

  • Involved in the complete re-design of the process flow, starting with design considerations, technical specification and source to target mapping.
  • Worked on loading of data from several flat files sources to Staging using Teradata TPUMP, MLOAD, FLOAD and BTEQ.
  • Interacted with Clients, Data Modeler and Data Analyst to develop the Logical and Physical Design for a table.
  • Created users with different profiles and Roles to control the access on the system.
  • Written several Teradata BTEQ scripts to implement the business logic.
  • Moved database schema changes to stage/production database.
  • Extensively worked on the Performance Tuning of mappings, ETL Procedures and process
  • Extensively used FEXP utility to export and load data to/from Flat files
  • Worked exclusively with the Teradata SQL Assistant to interface with the Teradata.
  • Experienced with Backup and Recovery using Teradata ARCMAIN.
  • Teradata PMON is used to monitor the system performance when it is in load.
  • Experienced in Teradata Manager which is used to create Alerts, Monitor system.
  • Worked on loading data from EDW and Supporting Subject areas using Ab Initio.
  • Familiar with Teradata Database Query Manager used mainly for query logging and access logging.
  • Developed BUSINESS OBJECTS (UNIVERSE) Desktop Intelligence&Crystal Reports to DOH users.
  • Experienced in using DBS Control Flags.
  • Worked on SSIS ETL with Teradata machines, and performed transformations.
  • Involved in documentation of requirements and technical design.

Environment: Teradata V2R5, Teradata Manager, (ETL Mf Jcl), Multiload, FastLoad, PMON, TSO, ISPF, SAP Business Object Universe, TD Unity Data Mover, Tset, FastExport, MicroStrategy, ViewPoint, Tset, TASM, Sql, BTEQ, Tpump, JAVA, MQ Series, DBA Tools(SWS, TVI, BAR, SLES), Mpras, W2k, Linux.

Confidential, Franklin Lakes, NJ

Teradata Administrator

Responsibilities:

  • Used Teradata manager to query Teradata RDBMS status and CPU utilization in reports and graphs.
  • Maintain and Tune Teradata Production and Development systems
  • Worked extensively with Teradata utilities BTEQ, Multiload, Fastload, TPUMP, Fastexport.
  • Performance Optimization
  • Measuring and monitoring the performance of the 16 node Teradata system with new Teradata file system having WAL feature embedded.
  • Designing and implementing the Physical Data Model. Received the Physical Data Model DDL from Erwin.
  • Measuring performance of the systems with different configurations. Configuration of the systems like changing number of AMP per node, Changing number of Clusters, Changing number of Clique, Changing number of nodes in a clique.
  • Capacity planning and proactive monitoring to meet performance and growth requirements
  • Performance Tuning and Administration activities of Teradata
  • Experienced in working with Teradata ETL tools like Fast Load, Multi Load, Tpump and Fast Export.
  • Teradata PMON is used to monitor the system performance when it is in load.
  • Disk array failures were recovered using AWS and SIMPLICITY .
  • Recovering the database/tables whenever we have disk drive failures. And used most of the recovery scenarios to recovery the data of the Teradata System.
  • Experienced with Backup and Recovery using Teradata ARCMAIN.
  • Upgrading the Teradata Versions.
  • Worked on patch upgrades of the Teradata systems.
  • Extensively used Teradata system Priority Schedule in controlling the load of the system.
  • Created users with different profiles and Rules to control the access on the system.
  • Experienced in Teradata Manager which is used to create Alerts, Monitor system.
  • Familiar with Teradata Database Query Manager.
  • Experienced in using DBS Control Flags.
  • Developed Universe (Metadata) WEBI Reports in SAP Business Objects.
  • Maintained Teradata system with all UNIX, LINUX and WINDOWS platforms.
  • Well familiar with System Administration activities and certified in Linux operating system.

Environment: Teradata Manager, Teradata V2R602/V2R611/V2R620, SQL Assistant, (ETL Abinitio tool), Multiload, FastLoad, Tset, PMON, Visual Explain, MQ Series, BUSINESS OBJECTS INFOVIEW, FastExport, BTEQ, Tpump, Td sql, Mpras, W2k, JAVA, Linux, Erwin.

Confidential, Overland Park City, KA

Systems Analyst/DBA

Responsibilities:

  • Interacting with Business for the requirements
  • Upgrade the Logical Model as per the Business requirements.
  • Develop and enhance the Physical Data model using Erwin. The Design shall be served as per the requirements.
  • Performance tuning of the existing engines data.
  • Involved in the tests, such as creation of users, spool, temporary, permanent space, checking the tables skewing, table compression, Troubleshooting the failure jobs
  • Worked on loading of data from several flat files sources to Staging using Teradata MLOAD, FLOAD and BTEQ.
  • Worked on exporting data to flat files using Teradata FEXPORT
  • Query optimization (Explain plans, Collect statistics, Primary and Secondary indexes)
  • Build tables, views, Procedures, UPI, NUPI, USI and NUSI
  • Used ETL for complex transformations
  • Attending the calls with Business and other technical groups to resolve the production issues
  • Writing QA and Production Migration scripts.
  • Design reviews with Informatica team.
  • Responsible for overseeing the Quality procedures related to the project.

Environment: Td (ETL Fload,Mload,Fxport,Bteq), Teradata V2R5, Teradata Manager, ORACLE, ETL Informatica tool, PMON, Tset, Visual Explain, Tpump(MQ Series), sql, Mpras, W2k, Cognos, Linux, Netvault, MS SQLServer 2000, Autosys, SQL Assistant.

Confidential, MI

Jr.Teradata DBA/Developer

Responsibilities:

  • Modifications and adding new insurance policies as per Clients Requirements.
  • Converting the Finance Segments (WFIN25SD, WFIN26SD) data from DB2 Database to TERADATA region.
  • Experienced in Designing Database with prominent activities like deciding Primary / Secondary index, creating Join index, creating Partitioned Primary Index, Compare Load Utilities to determine the best Scenario, using Automatic Data protection using Recovery Journals and Fallback protection.
  • Disk array failures were recovered using AWS and SIMPLEX software.
  • Recovering the database/tables when ever we have disk drive failures and used most of the recovery scenarios to recovery the data of the Teradata System.
  • Experienced with Backup and Recovery using Teradata ARCMAIN.
  • Used Normalization and Denormalization considering merits and demerits of SQL query execution.
  • Worked on patch upgrades of the Teradata systems.
  • Extensively used most popular tool of Teradata system, Priority Scheduler, in controlling the load of the system, where we define performance Group, Allocation groups, performance periods, Resource Partition.
  • Creating users with different profiles and Rules to control the access on the system.
  • Experienced in Teradata Manager which is used to create Alerts, Monitor system, and see historical Reports.
  • Familiar with Teradata Database Query Manager.
  • Experienced in using DBS Control Flags.
  • Extensively used EXPLAIN in analyzing the SQL query execution flow. Using this analysis tuned SQL queries to use Teradata resources efficiently.

Environment: Teradata V2R5, Multiload, FastLoad, Mf Jcl, Tset, Teradata Manager, FastExport, BTEQ, Tpump, sql, Netvault, Cognos, Mpras, W2k, Linux, SQL Assistant.

Confidential, MI

Teradata Developer/ETL

Responsibilities:

  • Involved in the complete re-design of the process flow, starting with design considerations, technical specification and source to target mapping.
  • Worked on loading of data from several flat files sources to Staging using Teradata TPUMP, MLOAD, FLOAD and BTEQ.
  • Interacted with Clients, Data Modeler and Data Analyst to develop the Logical and Physical Design for a table.
  • Generated the OLAP Reports in Cognos to the End Users.
  • Created users with different profiles and Roles to control the access on the system.
  • Written several Teradata BTEQ scripts to implement the business logic.
  • Generated the Teradata Fload, Mload Scripts in Unix Operating Systems region.
  • Moved database schema changes to stage/production database.
  • Extensively worked on the Performance Tuning of mappings, ETL Procedures and process
  • Performed bulk data load from multiple data source (Unix, legacy systems) to TERADATA RDBMS using BTEQ, Fastload, Multiload and TPump.
  • Experienced in working with Teradata ETL tools like Fast Load, Multi Load, Tpump and Fast Export.
  • Used MVC (Multi Value compression) tool for sizing of the database.

Environment: Teradata/V2R5, Explain, NetVault, Db2, Query man, Unix, Td Sql, Rdbms, Index, View, Elips, CA7,Oltp, Dss, Mf Jcl, Autosys, Erwin, File Manager.

Hire Now