We provide IT Staff Augmentation Services!

Sr. Application/teradata Developer Resume

SUMMARY

  • 7+ years of experience and 5+ years of Teradata development and design of ETL methodology for supporting data transformations & processing in a corporate wide ETL Solution using Teradata TD12.0/TD13.0, analyzing business needs of clients, developing effective and efficient solutions and ensuring client deliverable within committed deadlines.
  • Proven track record in planning, building, managing successful large - scale Data Warehouse and decision support systems. Comfortable with both technical and functional applications of RDBMS, Data Mapping, Data management, Data transportation and Data Staging.
  • Strong hands on experience using Teradata utilities (FastExport, MultiLoad, FastLoad, Tpump, TPT and BTEQ).
  • Proficient in TeradataQuery optimization, Performance Tuning.
  • Developed scripts for data cleansing, data validation, data transformation for the data coming from different source systems.
  • Performed all functions using UNIX Shell scripting (ksh) and Teradata SQL.
  • Created complex Stored Procedures that automated the application process and efficient.
  • Over 5+ years of industry experience in developing strategies for ETL mechanism using Teradata utilities, BTEQ scripts in complex, high volume Data Warehousing projects in UNIX.
  • Developed various UNIX shell scripts to run Data base jobs.
  • Well versed with UNIX shell scripts, KSH and Oracle PL/SQL programming.
  • Developed Scripts to load the data from source to staging and staging area to target tables using different load Teradata utilities.
  • Experience with business intelligence reporting tools using Business Objects.
  • Experience in Oracle SQL loader and partition exchange concept.
  • Functional knowledge of IBM Datastage.
  • Good Knowledge in Teradata Recursive Function.
  • Experience in all phases of SDLC like system analysis, application design, development, testing and implementation of data warehouse and non-data warehouse projects.
  • Experience in mapping business requirements and translating these requirements into End User Applications.
  • Good knowledge in scheduling batch jobs using Control-M scheduler.
  • Used version control tools like SVN and clear case.
  • Hand on Experience on Teradata Macros.
  • Good Knowledge about Campaign Management tool Unica. Working experience on creating Channel,Interaction Points,Slots, Segments etc.

TECHNICAL SKILLS

Teradata Tools: BTEQ, Teradata SQL Assistant,Viewpoint

ETL Tools: Datastage 8.0

DB Tools: SQL*Plus, SQL Loader, TOAD 8.0, BTEQ, Fast Load, Multiload, FastExport, SQL Assistant, SQL Sever

Databases: Teradata-13.0/12.0,Oracle-10g/11i,MS-SQL Server 2000/2005/2008

Scheduling Tools: Control-M

Version Control Tools: SVN,Clear Case

Programming Languages: C, SQL, PL/SQL and UNIX Shell Scripting

Operating Systems: Linux, Windows, UNIX

PROFESSIONAL EXPERIENCE

Confidential

Sr. Application/Teradata Developer

Responsibilities:

  • Development of scripts for loading the data into the base tables in EDW and to load the data from source to staging and staging area to target tables using FastLoad, MultiLoad, TPT and BTEQ utilities of Teradata.
  • Writing scripts for data cleansing, data validation, data transformation for the data coming from different source systems.
  • Written complex SQLs using joins, sub queries and correlated sub queries. Expertise in SQL Queries for cross verification of data.
  • Involved in Analysis, Design and Development, testing and implementation of business rules.
  • Developed the Teradata Macros, Stored Procedures to load data into Incremental/Staging tables and then move data from staging into Base tables.
  • Reviewed the SQL for missing joins & join constraints, data format issues, mis-matched aliases, casting errors.
  • The project involved extracting data from various sources, then applying the transformations before loading the data into target (warehouse) Stage tables and Stage files.
  • Developed procedures to populate the customer data warehouse with transaction data, cycle and monthly summary data, and historical data.
  • Dealt with initials, delta and Incremental data as well Migration data to load into the Teradata.
  • Performed application level activities creating tables, indexes, monitored and tuned Teradata BETQ scripts using Teradata Visual Explain utility.
  • Analyzing data and implementing the multi-value compression for optimal usage of space.
  • Query Analysis using Explain for unnecessary product joins, confidence factor, join type, order in which the tables are joined.
  • Very good understanding of Database Skew, PPI, Join Methods and Join Strategies, Join Indexes including sparse, aggregate and hash.
  • Extensively involved in developing & designing ETL by using SQL, BTEQ, MLoad, Fastload, FastExport.
  • Extensively used Teradata SQL, SQL Assistant, MultiLoad and BTEQ.
  • Developed UNIXshells cripts to run batch jobs and loads into production.
  • Used extensively Derived Tables, Volatile Table and GTT tables in many of the ETL scripts.
  • Tuning of Teradata SQL statements using Explain analyzing the data distribution among AMPs and index usage, collect statistics, definition of indexes, revision of correlated sub queries, usage of Hash functions, etc…
  • Development of scripts for loading the data into the base tables in EDW and to load the data from source to staging and staging area to target tables using BTEQ utility of Teradata.
  • Flat files are loaded into databases using FastLoad and then used in the queries to do joins.
  • Writing UNIXShellScripts for processing/cleansing incoming text files.
  • Use SQL to query the databases and do as much crunching as possible in Teradata, using very complicatedSQL Query optimization (explains plans, collect statistics, data distribution across AMPS, primary and secondary indexes, locking, etc) to achieve better performance.
  • Performed validations, Data Quality checks and Data profiling on incoming data.
  • Used Enterprise SVN for version control, Control-M for scheduling purposes.
  • Excellent experience in performance tuning and query optimization of the Teradata SQLs.
  • Provide 24*7 production support for the Teradata ETL jobs for daily, Monthly and Weekly Schedule.
  • Extensively used sqlldr to load data into Oracle to support the Unica Campaign real time system to issue offers.
  • Functional knowledge of IBM UNICA Campaign Management Application.
  • Experience in creating Channels,Interation Points,Flow charts,Mapping Tables in UNICA.

Environment: Teradata 13.0/12.0, Teradata SQL Assistant, Multiload, FastExport, FastLoad, Teradata Parallel Transporter (TPT), Oracle, UNIX, Shell scripts.

Confidential

Teradata Developer

Responsibilities:

  • Involved in Requirement gathering, business Analysis, Design and Development, testing and implementation of business rules.
  • Work with internal business partners to develop and implement additional functionality into RET application.
  • Developed mappings to load data from Source systems like Oracle, SAP BI, SQL SERVER to Data Warehouse.
  • The project involved extracting data from various sources, then applying the transformations before loading the data into target (warehouse) Stage tables and Stage files.
  • Writing MultiLoad scripts, FastLoad and BTEQscripts for loading the data into stage tables and then process into BID.
  • Dealt with Incremental data as well Migration data to load into Oracle.
  • Created proper Teradata Primary Indexes (PI) taking into consideration of both planned access of data and even distribution of data across all the available AMPS. Considering both the business requirements and factors, created appropriate Teradata NUSI for smooth (fast and easy) access of data.
  • Worked on exporting data to flat files using Teradata FastExport
  • Analyzed the Data Distribution and Reviewed the Index choices
  • In-depth expertise in the Teradata cost based query optimizer, identified potential bottlenecks
  • Written complex SQLs using joins, sub queries and correlated sub queries. Expertise in SQL Queries for cross verification of data.
  • Developed UNIX shell scripts to run batch jobs and loads into production.
  • Excellent experience in performance tuning and query optimization of the Teradata SQLs.
  • Code Reviewing and Bug Fixing in all areas of the application for all iteration.
  • Actively participated in weekly Iterative status meetings to track the progress for each iterative cycle and figure out the issues.
  • Worked with PPI Teradata tables and was involved in Teradata specific SQL fine-tuning to increase performance of the overall ETL process
  • Developed procedures to populate the customer data warehouse with transaction data, cycle and monthly summary data, and historical data.
  • Analyzed, Designed and documented requirements for data migration projects between numerous source Legacy/Oracle application feeds and the new Teradata platform.
  • Used Informatica (ETL) to load the data to Data warehouse Systems.
  • Testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and Target Data.
  • Involved in designing the data flow diagram. Documented the mappings used in ETL processes
  • Participated in Logical and Physical Data modeling. Identified the Entity types, their attributes and the relationship between the Entities in the organization’s business process.
  • Extensively used UNIX Shell Scripting for writing SQL execution scripts in Data Loading Process.
  • Developed complex mappings using multiple sources and targets in different databases, flat files.
  • Performed Unit testing, Integration testing and generated various Test Cases.
  • Performed Data analysis and Data validations.
  • Migrated data with help of Teradata FastExport, Insert/ Select, flat files from one system to another.
  • Convert and migrate generated SQL scripts and ad-hoc queries from Business Objects Universe, Oracle, and SQL Server 2000 to batch mode Reporting queries to Teradata RDBMS by using Teradata utilities.

Environment: Oracle,Sqlldr,, Business Object,Teradata, SQL,, Informatica Power Center 8.5, SQL Assistant, BTEQ, Multiload, FastExport, FastLoad, Unix Shell script.

Hire Now