We provide IT Staff Augmentation Services!

Teradata Developer Resume

3.00/5 (Submit Your Rating)

Bothell, WA

SUMMARY

  • Architected and implemented user authentication via LDAPin multiple security enclaves to supportusers, hosts, and access control.
  • 6 Years of experience in Information Technology, with focus on Data Warehousing and Application development.
  • Experience in Teradata 16.20/15.10 (Teradata SQL Assistant, BTEQ, Fast Load, Multi Load, TPump, TPT (Teradata Parallel Transporter), Fast Export, Visual Explain, PMON, Statistical Analyzer.
  • Worked with various versions of Informatica like Informatica 9.5.1.
  • Strong knowledge in Data Warehouse Implementation Stages including Analysis, Requirement Gathering, Design, Development, Testing, and Deployment.
  • Experienced with mentoring Teradata Development teams, data modeling, program code development, test plan development, datasets creation, testing and result documentation, analyzing defects, bug fixing.
  • Extensively used Teradata application utilities like BTEQ, Multi Load, Fast Load, TPUMP and TPT.
  • Strong knowledge of Data warehouse concepts, Dimensional Data Modeling, Star Schema, Snow - Flake schema, FACT and Dimensions Tables.
  • Worked in remediation (Performance Tuning) team for improving query performance of user queries and production SQL’s.
  • Very good experience in customer facing skills and release and change management.
  • Proficient in Teradata Database Design (Physical and Logical), Application Support and setting up the Test and Development environments.
  • 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.
  • Expertise in using Teradata SQL Assistant, Teradata Manager, Teradata Administrator, Teradata Index Wizard and data load/export utilities like BTEQ, Fast Load, Multi Load, Fast Export and exposure to Tpump on UNIX environment.
  • Exposure to Data Mapping/Modelling for data warehousing and Acquisition/Conversion related tasks.
  • Have a strong exp in Teradata development and index’s (PI,SI,PARTITION,JOIN INDEX) etc.
  • Experienced in development/support of various data warehousing applications in communication, health services, insurance, banking and Financial industries.
  • Expertise in database programming like writing Stored Procedures (SQL), Functions, Triggers, Views in Teradata.
  • Exposure in extracting, transforming and loading (ETL) data from other databases and text files using SQLServer ETL tools.
  • Experience in writing complex SQL to implement business rules, extract and analyze data

TECHNICAL SKILLS

Databases: Teradata (V16.20,V15.10), SQL Server, Oracle

Teradata Tools & Utilities: BTEQ, Multi Load, Fast Load, Fast Export, Tpump, Teradata Manager, SQL Assistant, Teradata Administrator, TSET, Index Wizard, Statistics Wizards,PMON,Srtored Procedure, PL/SQL.

ETL tools: Informatica Power Center 9, Talend Open Studio

Data Modeling Tools: Erwin

Process/Methodologies: Waterfall, Agile Methodology

PROFESSIONAL EXPERIENCE:

Confidential

Teradata Developer

Responsibilities:

  • Perform data analysis and gathered columns metadata of source systems for understanding requirement feasibility analysis.
  • Creating complex mapping using transformations like Source Qualifier, Router, Filter, Expression, Sorter, Aggregator, Normalizer, Joiner, Rank, Sequence Generator, Connected, Unconnected Lookup and Update Strategy.
  • Transform Logical Data Model to Physical Data Model ensuring the Primary Key and Foreign key relationships in PDM (Physical Data Modelling), Consistency of definitions of Data Attributes and Primary Index considerations.
  • Prepare low level technical design document and participated in build/review of the BTEQ Scripts, FastExports, Multiloads and Fast Load scripts, Reviewed Unit Test Plans & System Test cases.
  • Have strong knowledge in data mover for importing and exporting of data. Work on loading data from Teradata Database to Oracle database for external clients. Development of test cases and testing.
  • Work on optimizing and tuning the Teradata views and SQL’s to improve the performance of batch and response time of data for users.
  • Provide support during the system test, Product Integration Testing and UAT.
  • Need to do the impact assessment in terms of schedule changes, dependency impact, code changes for various change requests on the existing Data Warehouse applications that running in a production environment.
  • Create and maintaining source-target mapping documents for ETL development team.
  • Use Teradata Data Mover to copy data and objects such as tables and statistics from one system to another.
  • Analyze business requirements, designs and write technical specifications to design/redesign solutions.
  • Involve in complete software development life cycle (SDLC) including requirements gathering, analysis, design, development, testing, implementation and deployment.
  • Develop technical design documents (HLD and LLD) based on the functional requirements.
  • Work on marketing database for creating marketing campaigns.
  • Creating the extracts for the external clients.
  • Work on loading data from Teradata Database to Oracle database for external clients.

Environment: Informatica Power Center 9, Teradata V16, Teradata V15, BTEQ, MLOAD, FLOAD, ORACLE, SQL, UNIX, Windows, Talend, JIRA, HP ALM, Tortoise SVN.

Confidential, Bothell, WA

Teradata Developer

Responsibilities:

  • Responsible for gathering requirements from Business Analysts and Operational Analysts and identifying the data sources required for the requests
  • Developed the Informatica mappings using various transformations, Sessions and Workflows. Teradata was the target database, Source database is a combination of Flat files, Oracle tables, Teradata, Excel files etc.
  • Responsible for working closely with the Informatica administrator to migrate Source and Target definitions, Mappings, Workflows, and Flat Files from development environment to the production environment.
  • Extensively used the Lookup and Update Strategy Transformations for implementing the Slowly Changing Dimensions.
  • Worked with the Informatica Administrator in migrating the mappings, sessions, source/target definitions from the development repository to the production environment.
  • Involved with the DBA in performance tuning of the Informatica sessions and workflows. Created the reusable transformations for better performance.
  • Used Informatica Data Explorer and Informatica Data Quality for Data Quality Management and Data profiling purposes.
  • Hands on experience in Teradata RDBMS using Fast Load, Multiload, TPump, Fast Export, Teradata SQL Assistant and BTEQ
  • Used TOAD to FTP file moving processes to and from source systems.
  • Created scheduling of jobs in Workflow Manager to trigger tasks on a daily, weekly and monthly basis.
  • Involved in the mirroring of the staging environment to production.
  • Involved in conducting the unit tests, System tests.
  • Scheduling jobs using Autosys to automate the Informatica Sessions.
  • Optimizing the Autosys batch flow.
  • Developing control files, Stored Procedures to manipulate and load the data into Oracle database

Environment: Informatica Power Center, Teradata V15, BTEQ, MLOAD, FLOAD, ORACLE, SQL, UNIX, Windows, Oracle, Control-M, Unix/Linux

Confidential, Atlanta, GA

Teradata Developer

Responsibilities:

  • Involved with business requirements, Technical requirements, and Design documents and coordinated with Data analyst team on the requirements.
  • Managing database space, allocating new space to database, moving space between databases as need basis.
  • Creating roles and profiles as needed basis. Granting privileges to roles, adding users to roles based on requirements.
  • Extensively worked with DBQL data to identify high usage tables and columns. Redesigning the Logical Data Models, and Physical Data Models.
  • Worked on ETL Informatica Power Centre for creating mappings/workflows and also invoking bteq’s via workflows.
  • Developing complex sql’s and bteq scripts for processing the data as per coding standards.
  • Invoking shell scripts to execute bteq, fast load,multi load, Tpump utilities.
  • Extensively worked on Mainframe/Unix and Informatica environments to invoke Teradata Utilities and file handlings.
  • Expertise in understanding data modeling involving logical and physical data model.
  • Monitoring bad queries, aborting bad queries using PMON, looking for blocked sessions and working with development teams to resolve blocked sessions.
  • Review of statistics and joins for performance improvement of Teradata SQL's using DBQL, Explain Plans

Environment: Teradata,Informatica Power Centre, Unix, Korn Shell, Teradata - Bteq, Fast load, Multi load, FastExport, TPUMP, Oracle, Sql server.

We'd love your feedback!