We provide IT Staff Augmentation Services!

Senior Teradata Developer Resume

4.00/5 (Submit Your Rating)

Charlotte, NC

SUMMARY

  • Close to 9+ years of IT experience inTeradata, SQL, Mainframe, Vertica and UNIX shell scripting.
  • Expertise in creating databases, users, tables, triggers, macros, views, stored procedures, functions, Packages, joins and hash indexes in Teradata database.
  • Extensively worked with Teradata utilities like BTEQ, Fast Export, Fast Load, Multi Load to export and load data to/from different source systems including flat files.
  • Expertise in writing large/complex queries using SQL.
  • Proficient in performance analysis, monitoring and SQL query tuning using EXPLAIN PLAN, Collect Statistics in Teradata.
  • Excellent experience in implementing Slowly Changing Dime nsions (SCD) and Change Data Capture (CDC).
  • Excellent Experience with different indexes (PI, SI, JI, AJIs, PPI (MLPPI, SLPPI)) and Collect Statistics.
  • Extensive knowledge of JCL, COBOL, UNIX and IBM Mainframe Systems.
  • Good understanding of Business practices in Banking & Financial Services Industry.
  • Well versed with all stages ofSoftware Development Life Cycle (SDLC)i.e. Requirement(s) gathering & analyzing, Design/redesign, Implementation and Testing.
  • Having complete domain and development Life Cycle knowledge of Data Warehousing & Client Server Concepts and knowledge of basicdata modeling.
  • Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses
  • Experience in using Automation Scheduling tools like Autosys and CA7
  • Very good in Fast learning, Analytical thinking, decision making and problem solving skills.
  • Expertise in RDBMS, databaseNormalization & Denormalizationconcepts and principles and good understanding of OLAP/OLTP systems.
  • Proficient in preparinghigh/low level documentslike design and functional specifications.
  • Actively involved inQuality Processes and release management activities - To establish, monitor and streamline quality processes in the project.
  • Very good in Analytical thinking, decision making and problem solving skills.
  • Involved in review meetings with Project Managers, Developers and Business Associates for Project
  • Quick adaptability to new technologies and zeal to improve technical skills.
  • Ambitious, self-motivated, ability to work independently as well as in teams, possess multi-tasking skills, results oriented engineering professional.

TECHNICAL SKILLS

Operating Systems: Intel(R)Core(TM)2 Duo, GNU/Linux, x86 64, Windows NT/ 2000/ XP, IBM S390 Mainframes

Databases: Teradata V2R5/R6/R12/R13, Vertica, DB2, SQL Server 2008/2005, Oracle 8i/9i/10/11g

Languages: SQL, PL/SQL, Teradata, Shell scripting, COBOL, JCL

Tools: & Utilities: BTEQ, Multi Load, Fast Load, Fast Export, Tpump, SQL Assistant, Putty

Special Software: Autosys, File-Aid, Changeman, NDM, CA7

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Senior Teradata Developer

Responsibilities:

  • Involved in completesoftware development life-cycle (SDLC)including requirements gathering, analysis, design, development, testing, implementationanddeployment.
  • Responsible for Business Analysis and Requirements Collection.
  • All the sub-applications those come under C&RA and CDM are analyzed and compared.
  • The Impact on the Downstream Process to C&RA and CDM are analyzed.
  • Low Level Design (LLD) document created to document the changes to the impacted applications.
  • Creating and maintainingsource-target mapping documents.
  • Analyzebusiness requirements, designsand writetechnical specificationstodesign/redesignsolutions.
  • Developed various shell scripts to load data from Teradata to Vertica.
  • Development of Unit test cases and Unit testing of the changed/new code.
  • Development of System Integration test cases and System Integration Testing (SIT) of the changed/new code.
  • Involved in setting up of data for UAT environment and supporting.
  • Data validation after each level of testing.
  • Peer review and release planning.
  • Coordinate with Configuration management team in code deployments.
  • Upstream/Downstream coordination.
  • Creation of Production Install and PIW documents.

Environment: x86 64, IBM Power PC, Windows 7/XP, GNU/Linux, Shell Scripting, SQL, Autosys, Putty, Vertica, BTEQ, Changeman, File-Aid, NDM, CA7, TSO, Teradata SQL, JCL, Easytrieve, COBOL, Teradata SQL Assistant V12.0

Confidential, Charlotte, NC

Teradata Developer

Responsibilities:

  • Involved in CompleteSoftware Development LifecycleExperience (SDLC) from Business Analysis to Development, Testing, Deployment and Documentation.
  • Worked on Teradata Multi-Load, Teradata Fast-Load utility to load data from mainframes Server to Teradata.
  • Wrote numerousBTEQ scriptsto run complex queries on theTeradata database.Used volatile table and derived queries for breaking up complex queries into simpler queries
  • Wrote Fast Export scripts to export data.
  • Tuning SQL Queries to overcome spool space errors and improve performance.
  • Also involved in creating Views, Conformed views and mapping them from the table.
  • Worked with complexSQL queriesto test the data generated by process against target data base.
  • UsedSQL Assistantto querying Teradata tables.
  • Created, optimized, reviewed, andexecutedTeradataSQL test queriesto validate transformation rules used in source to target mappings/source views, and to verify data in target tables
  • Performance Tuning of sources, Targets, mappings andSQL queriesintransformations designing, creatingand tuning physical database objects (tables, views, indexes, PPI, UPI, NUPI, and USI) to sup-port normalized and dimensional models.
  • Involved in analysis of end user requirements and business rules based on given documentation and working closely with tech leads and analysts in understanding the current system.
  • Designing flow of data from daily tables to weekly tables.
  • Coding of Teradata scripts and main frame jobs.
  • Preparing unit and System integration test cases.
  • Involved in setting up of data for UAT environment and supporting.

Environment: Intel(R) Core(TM) 2 Duo, IBM S390 Mainframes, Windows 2000, XP, Teradata SQL, JCL, Easytrieve, COBOL, Teradata SQL Assistant V12.0, BTEQ, Changeman, File-Aid, NDM, CA7, TSO

We'd love your feedback!