We provide IT Staff Augmentation Services!

Teradata Developer Resume

Bloomfield, CT

SUMMARY

  • Over 7+ years of experience in information technology and have Teradata experience utilizing tools, analyzing business needs of clients, developing effective and efficient solutions and ensuring client deliverables.
  • Extensive knowledge and good achievements in Teradata query and application tuning/optimization.
  • Setup and reviewing workload management process, giving solutions to various customer concerns on workload management set up and providing Teradata’s best practices.
  • Worked in several areas of Data Warehouse including Analysis, Requirement Gathering, Design, Development, Testing, and Implementation.
  • Experience in design and setup BI standards, best practices and rules for DWBI environment on enterprise level.
  • Good knowledge of Dimensional Data Modeling, Star Schema, Snow - Flake schema, FACT and Dimensions Tables.
  • Around 4+ years of strong data warehousing experience using Informatica Power Mart 6.1/5.1/4.7, Power Center 9.5.0/9.1.0/8.6.1/8.1/7.1.3/7.0/6.2/5.1 , Power Exchange, Power Connect as ETL tool.
  • Worked in remediation (Performance Tuning) team for improving query performance of adhoc user queries and production queries (ETL & Reporting).
  • Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX shell scripting, SQL Loader.
  • Expertise in performance tuning and query optimization of the Teradata SQLs. Experience in Designing, developing data conversion/data integration modules to support large scale system migrations and implementations.
  • Expertise in Report formatting, Batch processing, and Data Loading and Export using BTEQ.
  • Decent knowledge on using TD Administrator, FASTLOAD, MULTILOAD, TSET, TPUMP, SQL, PDCR, ARCMAIN,TASM for workload management.
  • Have strong expertise in Teradatadevelopment and indices (PI, SI, PARTITION, JOIN INDEX) etc.
  • Worked on Data Mining techniques for identifying claims on historical data.
  • Expertise in database programming like writing Stored Procedures (SQL), Functions, Triggers, Views in Teradata, DB2 & MS Access.
  • Created several BTEQ scripts involving derived tables and volatile/Global temporary tables for ad hoc purpose to extract data for several business users on scheduled basis.
  • Well versed in handling face to face meetings with Business Users, Business Stakeholders, Technical team members to gather and analyze business requirements, outline the proposed solution
  • Extensively involved in Data Loading activities: created many Informatica mappings to source data from Upstream
  • Expert in tuning performance of SQL queries and ETL process.
  • Design, development and coding with Teradata
  • Expertise in OLTP/OLAP System Study, Analysis and E-R modelling, developing Database Schemas like Star schema and Snowflake schema (Fact Tables, Dimension

TECHNICAL SKILLS

Tools: & Utilities: TPT, BTEQ, Fast Load, Multiload, Tpump, Fast Export, SQL Assistant, Teradata Viewpoint, TSET, Teradata mapping manager

ETL Tools: Informatica 10.2.0/9.6.1 /9.5.0/ 9.1.0/ 8.6.1/ 8.1 /7.1.3/7.0/6.2/5.1 , Power centre, Hadoop 2.6.2 (HDFS, MapReduce, Hive, Sqoop, Pig)., Datastage8.7

Operating Systems: UNIX, Windows 7/8/10/XP/2000, Windows NT 4.0 and Z/OS and MVS (OS/390).

Databases: Teradata V2R5/V2R6, V12, V14, V15, Oracle (8i/9i),(10g/11g)SQL Server 2000 /2005 /2008/ 2012/2014/2016 DB2.

Data warehouse: Teradata, Oracle, SQL Server

Data Modelling: Erwin, Visio, Autosys

Applications: MSWord, Excel,Outlook,FrontPage, PowerPoint, MS- Visio

Reporting Tools: Micro Strategy 9.2.1/9.0/8i/7.i.

Support Tools: Tivoli, Impact, Autosys, Control-M, UC4, HPQC

Other Languages/ Technologies / Platforms: SQL, JAVA, VB, C#, UNIX, C, C++, Shell scripting (K-shell, C-Shell), SQL.

PROFESSIONAL EXPERIENCE

Confidential, Bloomfield, CT

Teradata Developer

Responsibilities:

  • Worked in all the stages of the SDLC like Business, Functional, Technical Requirements Gathering, Designing, Documenting, Developing and Testing.
  • Involved heavily in writing complex SQL queries based on the given requirements such as complex Teradata Joins, Stored Procedures, Macros, etc.
  • Worked onTeradataStore procedures and functions to confirm the data and load it on the table.
  • Worked in the conversion of SQL server functions into theTeradataStore procedure for confirming the data.
  • The financial data mainly included Accounts Payables, Account Receivables, Budget, Fixed Assets, General Accounting, Procurement, Treasury Accounting, Performance Budgeting etc.
  • Created, optimized, reviewed, and executedTeradataSQL test queries to validate transformation rules used in source to target mappings/source views, and to verify data in target tables.
  • Wrote numerous BTEQ scripts to run complex queries on theTeradatadatabase.
  • Analyzed the system for the functionality required as per the requirements and created System Requirement Specification document (Functional Requirement Document).
  • Manage and support production/development/test servers, databases, Data Warehouses on standalone, clustered, (AWS,Azure) cloud environments
  • Designed and used shell scripts that automate thedatastagejobs and validate files.
  • Extensively usedInformaticaClient tools - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplets Designer,InformaticaRepository Manager andInformaticaWorkflow Manager.
  • Developed various complex mappings using Mapping Designer and worked with Aggregator, Lookup (connected and unconnected), Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
  • Optimized and Tuned SQL queries used in the source qualifier of certain mappings to eliminate Full Table scan.
  • Created and Configured Workflows, Work lets and Sessions to transport the data to target warehouse tables usingInformaticaWorkflow Manager.
  • Created various tasks like Email, Event-wait and Event-raise, Timer, Scheduler, Control, Decision, Session in the workflow manager.
  • Involved in the administration of theInformaticaRepository and in the design and architecture of multiple repositories to support multiple application development areas.
  • Created, Tested and debugged the Stored Procedures, Functions, Packages, Cursors and triggers using PL/SQLdeveloper.
  • Developed UNIX shell Scripts to generate parameter files and executed oracle procedures as batch jobs.
  • Created scripts for Batch test and set the required options for overnight, automated execution of test scripts.
  • Created Shell Script to send the data to downstream systems using FTP / SFTP.
  • Involved in Performance tuning at source, target, mappings, sessions, and system levels.
  • Expertise in writing scripts for Data Extraction, Transformation and Loading of data from legacy systems to target data warehouse using BTEQ, Fast Load, Multiload, Tpump.
  • Wrote complex SQL’s and used volatile tables for code modularity and to improve performance of the query.
  • Created Data Mapping Documents as part of the Data migration projects.
  • Worked closely with the Business to understand their needs and provided my inputs to address their needs and requirements.

Environment: Teradata 15/14, Microsoft SQL Server, UNIX, Informatica, Tpump, Fast load, BTEQ, Power center, MLoad, MS Office Tools, Erwin, Jira, Tableau.

Confidential, West Chester PA

Teradata/ ETL Consultant

Responsibilities:

  • Involved in Requirement gathering, business Analysis, Design and Development, testing and implementation of business rules.
  • Extracted Source data from REST API using UNIX shell scripts.
  • Analysing the requirements and the existing environment to help come up with the right strategy to load and Extract on Data warehouse.
  • Prepared the ETL specifications, Mapping document, ETL framework specification
  • Implement slowly changing Dimension logics in the mapping to effectively handle change data capture which is typical in data warehousing systems.
  • Prepared functional and technical specific, design documents.
  • Responsible for data profiling, data cleansing and data conformation
  • Actively participated in code migration process to higher environment and documents creation for the same.
  • Created a BTEQ scripts for preloading of the work tables prior to main load process
  • Proficient in understanding Teradata EXPLAIN plans, Collect Stats option, Secondary Indexes (USI, NUSI), Partition Primary Index (PPI), Volatile, global temporary, derived tables etc.
  • Reviewed the SQL for missing joins, join constraints, data format issues, miss-matched aliases and casting errors.
  • Use of Teradata Manager, BTEQ, FASTLOAD, MULTILOAD, TPUMP, SQL and TASM for workload management.
  • Wrote various TPT scripts for ad hoc requirements and used tdload for exporting data from one environment to other environment using TPT
  • Perform workload management using various tools like Teradata Manager, Fast Load, Multi Load, TPUMP, TPT, SQL Assistant.
  • Developed the scripts using Teradata Parallel Transporter and implemented the Extraction- Transformation-Loading of data with TPT.
  • Unit Testing, Database testing, Data verification and validation of the code developed and compare the results with Sybase and Teradata systems.
  • Identify the performance bottlenecks in the production processes and identify key places where SQL can be tuned to improve overall performance of the production process
  • Wrote numerous BTEQ scripts to run complex queries on the Teradata database.
  • Developed UNIX scripts to automate different tasks involved as part of loading process.

Environment: Teradata 15, Teradata SQL Assistant, REST API,TPT, BTEQ, MLOAD, FLOAD, FASTEXPORT, Erwin Designer, Informatica 9.5, Tableau, POWER BI, UNIX, Korn Shell scripts.

Confidential, EL Segundo, CA

ETL /Teradata Developer

Responsibilities:

  • Understanding the specification and analyzed data according to client requirement.
  • Creating roles and profiles as needed basis. Granting privileges to roles, adding users to roles based on requirements.
  • Managing database space, allocating new space to database, moving space between databases as needed basis.
  • Assist developers, DBAs in designing, architecture, development and tuning queries of the project. This included modification of queries, Index selection, and refresh statistic collection.
  • Proactively monitoring bad queries, aborting bad queries using PMON, looking for blocked sessions and working with development teams to resolve blocked sessions.
  • Proactively monitoring database space, identifying tables with high skew, working with data modeling team to change the Primary Index on tables with High skew.
  • Worked on moving tables from test to production using fast export and fast load.
  • Extensively worked with DBQL data to identify high usage tables and columns.
  • Implemented secondary indexes on frequently used columns to improve efficiency in retrieval.
  • Worked on exporting data to flat files using TeradataFastExport.
  • Worked exclusively on TeradataSQL Assistant to interface with the Teradata.
  • Written several TeradataBTEQ scripts to implement the business logic.
  • Populated data into Teradatatables by using Fast Load utility.
  • Created Teradatacomplex macros, Views and stored procedures to be used in the reports.
  • Perform error handling and performance tuning in Teradata queries and utilities.
  • Creating error log tables for bulk loading.
  • Actively involved in the TASM workload management setup across the organization. To define TASM Workloads, helped to develop TASM exceptions by contributing workload dynamics from development stand point.
  • Worked on capacity planning, reported disk and CPU Usage growth reports usingTeradata Manager, DBQL and re-usage.
  • Used TeradataManager collecting facility to setup AMP usage collection, canary query response, spool usage response etc.
  • Developed complex mappings using multiple sources and targets in different databases, flat files.
  • Developed TeradataBTEQ scripts. Automated Workflows and BTEQ scripts
  • Query optimization (explain plans, collect statistics, Primary and Secondary indexes).

Environment: Teradata 12, Cron-tab, Austosys, PMON, BMC Remedy, TARA, Symantec NetBackup, Teradata Administrator, Teradata SQL Assistant, BTEQ, FastExport,Fast Load, Subversion, Informatica.

Confidential

Software Engineer

Responsibilities:

  • Created Star Schema model with required facts and dimensions.
  • Defined various facts and Dimensions in the data mart including Aggregate and Summary facts.
  • Converted DataMart from Logical to Physical design, defined data types, Constraints, Indexes, generated Schema in Database, created automated scripts, defined storage parameters for objects in the Database.
  • Created and Maintained Teradata Tables, Views, Macros, Triggers and Stored Procedures
  • Coding using Teradata Analytical functions, BTEQ SQL of TERADATA, write UNIX scripts to validate, format and execute the SQLs on UNIX environment.
  • 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).
  • Worked on complex queries to map the data as per the requirements.
  • Populate or refresh Teradata tables using Fast load, Multi load & TPump utilities for user acceptance testing and loading history data into Teradata.
  • Created UNIX Scripts for triggering the Stored Procedures and Macro.
  • Involved in Performance tuning for the long running queries.

Environment: Teradata 12, Teradata SQL Assistant, BTEQ, FLoad, FExport, MLoad, TPT, TPump Erwin4.1.4, Quest Toad 9.3, UNIX Shell Scripting, SQL*Loader, Smart Putty, SQL Server, Windows XP, UNIX.

Confidential

ETL Developer

Responsibilities:

  • Understanding the client specifications and validating the same against the data model.
  • Develop BTEQ scripts based on the technical specifications for loading the tables.
  • Understanding and documenting the dependencies between the different tables from a referential integrity perspective and implementing the same from a scheduling perspective.
  • Written several Teradata BTEQ scripts for reporting purpose.
  • Developed BTEQ scripts to load data from Teradata Staging area to Teradata data mart.
  • Actively participated in the requirement discussion from end users, Dashboard design sessions with the data/business analysts and data model sessions with the data team.
  • Created dashboards at different levels of data and enabled navigation across them using hyperlinks and report links.
  • Develop UNIX scripts for handling exceptions and special requests from production support team.
  • Monitoring production run.
  • Working on issues if any production batch has.
  • Perform enhancements on the D3A scripts to resolve production issues.

Environment: Teradata V12/V13, Teradata SQL Assistant, Teradata Utilities (BTEQ, MLoad, Fast Load, Fast Export and TPT), Informatica 8.6.1, DB2, SQL server 2005/2008, SAS, Control-M, UNIX.

Hire Now