We provide IT Staff Augmentation Services!

Sr Teradata/etl Developer Resume

4.00/5 (Submit Your Rating)

SUMMARY

  • Over 7 Years of Total experience in Analysis, Design, Development, Implementation, Modeling, Testing, Reconciling and support for Data Warehousing applications.
  • Extensively worked on Data Modeling including Dimensional Data Modeling, Star Schema/Snowflake Modeling, FACT & Dimensions tables, Physical & Logical Data Modeling.
  • Excellent knowledge in Data Warehouse / Data Mart development life cycle, Star schema, Snowflake schema, SCD, Surrogate Keys, Normalization/De - Normalization, Dimension and Fact tables.
  • Experience working with Teradata Parallel Transporter (TPT), BTEQ, Fast load, Multiload, TPT, SQL Assistant, DDL and DML commands.
  • Proficient in Teradata EXPLAIN plans, Collect Stats option, Primary Indexes (PI, NUPI), Secondary Indexes (USI, NUSI), Partition Primary Index (PPI), Join Indexes (JI), Volatile, global temporary, derived tables etc.
  • Experience in extraction of data from various Heterogeneous sources (Relational database, Flat Files) to load into data warehouse/data mart targets.
  • Sound knowledge in Data Migration from DB2, SQL Server and Oracle to Teradata using automated Unix shell scripting, Oracle/TD SQL, TD Macros and Procedures etc.
  • 7 Years’ experience with Teradata SQL, Advanced SQL, Macros, Triggers, Stored procedures, BTEQ and Loader Utilities - Multiload, TPump, FastLoad & TPT.
  • Extensive experience in designing logical and physical Data Modeling using Erwin tool.
  • Proficient knowledge in ER and Dimensional Modeling, identifying Fact and Dimensional Tables with data modeling tools ERWIN and ER Studio.
  • In-depth expertise in the Teradata cost based query optimizer, identifying potential bottlenecks with queries from the aspects of query writing, skewed redistributions, join order, optimizer statistics, physical design
  • Considerations (PI/USI/NUSI/JI etc.) etc.
  • Extensive experience in implementing slowly changing dimensions to maintain historical data and for
  • Change data capture(CDC).
  • Extensive experience in writing SQL scripts/Analytical queries as per the Business specifications.
  • Excellent knowledge of relational databases through exposure to Teradata, Oracle, SQL Server.
  • Built UNIX shell scripts, Library wrapper scripts, common to all users in Data warehouse team.
  • Built UNIX shell scripts for automation of daily loading of Oracle and flat file data through scheduling.
  • Expert with ODBC connections and defining system DSN’s, built shell wrappers to support the ETL process.
  • Proficient in writing Perl/shell scripts and UNIX functions to automate and simplify the day to day activities.
  • Experience in Performance Tuning of mappings, ETL Procedures and process.
  • Experience in Performance Tuning ofTeradataSQL using explains plan and understanding Joins and Data distribution.
  • Scheduling the automated jobs for daily, weekly and monthly jobs using UNIX Shell scripts for Tivoli scheduling.
  • Daily standup meetings with onsite managers.
  • Experience in identifying bottlenecks in ETL processes and performance tuning.
  • Heavily involved in performance tuning of the ETL to reduce the load times and the business reports tuning.
  • Experienced in Debugging mappings. Identifying bugs in existing mappings by analyzing the data flow and evaluating transformations.
  • Leading EDW/ETL production support team and was on weekly on-call rotation and provided on-call support for the projects in production during the warranty period.
  • Excellent Coordination skills in working with cross functional team.
  • Experience with master data management and worked with all types (1,2,3) of dimension tables.
  • Experienced as on call support (24X7) as part of a scheduled rotation with other team members.

TECHNICAL SKILLS

ETL Tools: Teradata Load Utilities (Mload, FastLoad, TPump, Teradata Parallel Transporter), SQL Assistant, Fast Export

RDBMS: Teradata V2R5, Teradata 12,13,14,15, DB2, Oracle.

Languages: UNIX Shell Scripting, Perl, SQL

Object Modeling Tools: Erwin 9.7

SQL Tuning: SQL Tuning, Explain Plan, Table Partitioning, Materialized views.

Scheduling Tools: Tivoli

PROFESSIONAL EXPERIENCE

Confidential

Sr Teradata/ETL Developer

Responsibilities:

  • Co-ordinated with the Business Analysts, Data Architects, DM’s and users to understand business rules.
  • Designed and Developed the ETL application to integrate Ecom Data into Data warehouse.
  • Developed Technical design documents and getting approvals from business team.
  • Helped developers to create MLOAD scripts to load data into staging tables.
  • Developed scheduling jobs Teradata and UNIX objects to run the jobs on daily/weekly basis depending on business requirement.
  • Developed the Teradata Macros, Stored Procedures to load data into Incremental/Staging tables and then move data from staging into Base tables.
  • Built UNIX Wrapper script to extract data from AS/400 to Teradata through Mload.
  • Modified existing UNIX Wrapper script to remove unwanted characters in the source file before loading into respective staging table.
  • Built Validation scripts to Validate data in target tables with source data.
  • Performed data analysis & data cleansing to clean source data as per business rules.
  • Handling exception data into exception table for further analysis.
  • Responsible for migrations of the code from Development environment to QA and QA to Production.
  • Provided production support on various issues during daily loads.
  • Worked on analyzing various production issues and necessary enhancements required.
  • Participated in knowledge transfer sessions to Production support team on business rules, Teradata objects and on scheduling jobs.

Confidential

Sr. Teradata/ETL Developer

Responsibilities:

  • Performed data analysis to item related data coming from new feed PDM.
  • Developed mapping document for PDM columns with existing PIM columns.
  • Reviewed code developed by team to load existing PIM staging tables from PDM feed.
  • Worked on code changes to incorporate version effective time stamp in existing PIM target tables.
  • Lead the team in analyzing/coding/testing the changes in EDW.

Confidential

Sr. Teradata/ETL Developer

Responsibilities:

  • Developed the ELT application to integrate Mexico Retail Data.
  • Developed Mload Scripts to extract source data from AS/400 system (104 Tables) using Teradata Utilities.
  • Developed mappings to build the application.
  • Developed & compiled stored procedures.
  • Designed the Tivoli schedules for application.

Confidential

Teradata ETL Developer

Responsibilities:

  • Developed ELT Application to Integrate PIM data.
  • Implemented Slowly Changing Dimensions (SCD). Used Type 2 dimension to keep the history changes.
  • Developed Scripts to extract source data from SQL Server using Teradata Utilities (Mload & OLELOAD) using Windows Server.
  • Performed the Source Data analysis to create Logical/Physical Data Model.
  • Developed Mapping document to map source to target columns based on Data model and Business rules.
  • Developed & compiled stored procedures to load data into target tables (Development Phase).
  • Developed scheduling scripts to run batch load everyday 4AM.

Confidential

Teradata ETL Developer

Responsibilities:

  • Developed ELT Application to Integrate Confidential Data.
  • Developed Source Data Extracts from AS/400 system (150 Tables) using Teradata Utilities & shell scripts.
  • Developed stored procedures to load Confidential data into POS sales/Inventory data into existing target tables.
  • Built validation scripts to validate sales/inventory data after batch process completes every day at 9 AM.
  • Tuned & Optimized Teradata SQLs to minimize waiting time for the reporting team to report on Confidential Sales Data.
  • Built a process to capture Exchange rate for Confidential .

Confidential

ETL Developer

Responsibilities:

  • Developed ELT Application to Integrate Confidential Data.
  • Developed Source Data Extracts from AS/400 system using Teradata Utilities & shell scripts.
  • Developed stored procedures to load Confidential data into sales/Inventory data into existing target tables.
  • Built validation scripts to validate sales/inventory data after batch process completes.
  • Tuned & Optimized Teradata SQLs to minimize waiting time for the reporting team to report on Confidential Sales / Inventory Data.

Confidential

ETL Developer

Responsibilities:

  • Developed ELT Application to Integrate Confidential Data.
  • Developed Source Data Extracts from AS/400 system using Teradata Utilities & shell scripts.
  • Built UNIX wrapper scripts to extract source data using table name as input parameter.
  • Developed stored procedures to load Confidential data into sales/Inventory data into existing target tables.
  • Built validation scripts to validate sales/inventory data after batch process completes every day at 9 AM.
  • Tuned & Optimized Teradata SQLs to minimize waiting time for the reporting team to report on Confidential Sales Data.

We'd love your feedback!