Senior Teradata Developer Resume
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
