Teradata Developer/data Architect Resume
Wilmington, DE
SUMMARY
- Teradata 12 Certified Technical Specialist with over 8 years of experience supporting EDWs residing on Teradata. Used all Teradata utilities (Multiload, Fastload, FastExport, BTEQ, SQL Assistant, PMON) extensively.
- Sound Knowledge of Data Warehousing concepts, E - R model & Dimensional modeling (3NF) like Star Schema, Snowflake Schema and database architecture for OLTP and OLAP applications, Data Analysis and ETL processes.
- In depth knowledge of Teradata architecture, various Indexes, Data distribution process.
- Good knowledge on all the ETL processes, have worked with other ETL tools like Informatica.
- Strong Teradata expertise in the areas of Enterprise Information Management, Enterprise Data Warehousing, Business Intelligence, Data Modelling, Data Integration, Data Integrity and Master Data Management.
- Architect Teradata processes using data integration tools, stored procedures, scripts to extract data from multiple systems, applications, and load data into enterprise data warehouse.
- Proficient in using Informatica Designer, workflow manager, workflow monitor, Repository Manager and Administration Console to create, schedule and control workflows, tasks and sessions
- Experience in identifying performance bottlenecks and tuning ofInformaticasources, targets, mappings, Transformations, and sessions for better performance.
- Experienced with Teradata query performance and tuning using collect statistics, checking data skewness, modifying indexes, rewriting the query and checking step by step execution in PMON.
- Strong experience working with conceptual, logical and physicaldatamodeling considering Metadatastandards.
- Strong experience in Creating Database Objects such as Tables, Views, Functions, Stored Procedures, Indexes, Triggers, Cursors in Teradata.
- Experience in scheduling workflows using scheduling tools like Autosys, JAMS etc.
- Expertise in writing and debugging large/complex SQL queries and improving performance.
- Strong skills in resolving Teradata issues, providing workaround for the problems, knowledge on diagnostics, Database Tuning, SQL Tuning and Performance Monitoring.
- In depth understanding and experience of implementing data warehousing concepts.
- Conversant with all stages ofSoftware Development Life Cycle (SDLC)i.e. Requirement(s) gathering & analyzing, Design/redesign, Implementation and Testing using waterfall, Agile methodology.
- Expertise in performing GAP Analysis, Data Analysis and Data Profiling.
- Lead global teams in different geographies. Have experience in working production support team.
- Facilitated Change Management across entire process from Project conceptualization to Testing through Project Delivery. Tracking and managing requirement and using Requirement Traceability Matrixes (RTMs) that controls numerous artifacts produced by the teams across the deliverables for a project.
- Hold good knowledge on UNIX Shell scripting, Experience in working with SQL server studio and SAS.
- Hold good understanding on Hadoop EcoSystem, Yarm, MapReduce, Sqoop and Spark concepts.
- Proficient in writing documentslike BRD, FRD and RTM. Ability to solve problems quickly & effectively.
- Excellent communication & presentation skills. Good in multi-tasking. Ambitious, self-motivated, ability to work independently as well as in teams.
- Experience in multiple business domains.
TECHNICAL SKILLS
RDBMS: Teradata 13, 13.1, 14.0, SQL Server Management Studio
Query Tools: Teradata SQL Assistant, BTEQ
Teradata Utilities: BTEQ, Fast load, Multi-Load, Fast Export
Scripting languages: UNIX Shell Scripting
ETL: Informatica
Scheduling Tool: Autosys, JAMS
Operating Systems: Windows XP, 2000,UNIX
Methodologies: Waterfall, Agile
Requirement Management Tools/ Business Process modeling tools: Power designer, MS Visio
Microsoft Office Suite: Excel, PowerPoint, Word, and Outlook
Defect Tracking Tools: Bug Zilla, Quality Center
PROFESSIONAL EXPERIENCE
Confidential, Wilmington, DE
Teradata Developer/Data Architect
Responsibilities:
- Involved in requirement gathering and understanding the business rule with end user.
- Identify all potential issues during the requirement gathering phase by doing data profiling and to describe actions to address those issues.
- Create the BRD and FRDs and present it to business users.
- Creating conceptual, logical and physicaldatamodels considering Metadatastandards.
- Designed and created Teradata enterprise wide EDW and data mart architecture.
- Creating and maintaining Teradata database table, Views, Stored Procedures, Macros and indexes.
- Creating/modifying Teradata Bteqs, FastLoad, MultiLoad, SAS scripts and Stored Procedures on SQL Server.
- Creating maintaining Autosys and Jams jobs to schedule the Teradata and SQL Server Daily/Weekly/Monthly loads.
- Created Unix shell script for automating the creation/modification of Teradata objects.
- Performing Gap analysis for the new business requirements, analyze and recommend solutions for any gaps identified.
- To deliver a reusable ETL and data quality framework.
- Doing production support, monitoring the Daily, weekly and monthly loads for any issue and perform the data analysis to check the data quality and quantity.
- Identify the performance issue with the processes and provide a solution to fix the same by optimizing the process and SQL tuning.
- Communication with the source team to resolve any source data issue.
Environment: Teradata, SQL Server, SAS, Autosys, JAMS
Confidential, Wallingford, CT
Teradata Developer/Data Architect
Responsibilities:
- Designed and created Teradata enterprise wide EDW and data mart architecture.
- Understanding of the Requirements Documents and interact with client team to get clarifications for issues if any.
- Worked on data analysis by writing SQLs and analyzing the result using Teradata SQL assistant.
- Worked on the identifying and optimizing the slow running SQLs.
- Used Teradata SQL assistant to query the database objects and do as much crunching as possible in Teradata, using very complicated SQL Query optimization (explains plans, collect statistics, data distribution across AMPS, primary and secondary indexes, locking, etc) to achieve better performance.
- Created proper PI taking into consideration both planned access and even distribution of data across all the available AMPS.
- Modify BTEQ/Informatica WFs and test the same in lower environments and present the same to SME with the fix and the results.
- Extensively used the Teradata utilities like BTEQ, FastLoad, Multiload, DDL Commands and DML Commands (SQL).
- Perform end to end analysis on BTEQ/Informatica WFs to find the root cause of data related issues.
- Fix the production data issue by providing the resolution.
- Identify the slow running processes and provide the performance improvement by tuning the SQL queries.
- Work on the IM tickets - Production failures for which the temporary solutions provided to continue with load.
- Work on Ad-hoc requests. i.e. Performance tuning SQLs, Loading missing data files, clarification on queries raised by users.
- Monitor and provide support to all the scheduled workflows and take appropriate action whenever there is an issue.
- Documentation of all issues and the resolution. This is used as a knowledge portal for all the information for futurereference.
- Work with Development team during any new application launches like providing approval from support team end to launch theapplication changes.
- Working with them in getting the required knowledge transfer (KT) for the proposed launch.
Environment: Teradata SQL Assistant, BTeq, Informatica, WLM Monitor
Confidential
Senior Teradata Associate
Responsibilities:
- Involved in analysis of end user requirements and business rules based on given documentation.
- Designing thetechnical solutionof Business requirement and creating the study and TDD for the same.
- Identify all potential issues during the requirement understanding phase and to describe actions to address those issues.
- Created/Modified scripts like Bteq, MLoad, FLoad and Ksh which are impacted as part of particular business requirement.
- Performedtuningandoptimizationof complexSQL queries.
- Writingcomplex SQL queriesto perform the analysis on a requirement.
- Fine-tune the existing scripts/SQLs and process to achieveincreased performance and reduced load times for faster user query performance.
- Communicate instructions clearly to team members and providing strategic and tactical direction to the team.
- Performing data Analysis for issue identification.
- Troubleshooting database issues related to performance and data mismatch.
- Analyze and recommend solutions for data issues.
- Created mapping document between source and target data.
- Creates, validates and updates thedata dictionary and analyzing documentationto make sure that the information captured is correct.
- Post production implementation support responsibility.
Environment: Teradata SQL Assistant, BTeq, UNIX
Confidential
Teradata Consultant
Responsibilities:
- Involved in requirement understanding and designing oftechnical solutionof Business requirement.
- Worked closely with analysts to come up with detailed solution approach design documents.
- Lead a team of 2 members and acted as a liaison between the offshore and onsite teams.
- Creating theBTEQ Scripts, FastExports, MultiloadsandFast Load scripts.
- Performedtuningandoptimizationof complexSQL queries.
- Writingcomplex SQL queriesto perform the analysis on a requirement.
- Provided support during thesystem test, Product IntegrationTesting andUAT.
- Worked on a data migration project, from Oracle to Teradata using Informatica.
- Done the impact analysis in terms of schedule changes, dependency impact, code changes for various change requests on the existingData Warehouseapplications that running in a production environment.
- Provided quick productionfixesand proactively involved in fixing production support issues.
- Creating and maintainingsource-target mapping documentsforETL developmentteam.
- Providing requirement specifications and guide theETL teamfor development of theETL jobsthrough InformaticaETL tool.
- Involved in completesoftware development life-cycle (SDLC)including requirements gathering, analysis, design, development, testing, implementationanddeployment.
- Developed technical design documents (HLD and LLD)based on the functional requirements.
Environment: Teradata SQL Assistant, BTeq, MLoad, FLoad, PMON, Informatica, UNIX
Confidential
Teradata Developer
Responsibilities:
- Communicating with the business users to understand business requirements clearly.
- Development of scripts for loading the data into the base tables in EDW usingFastLoad,MultiLoad and BTEQ utilities of Teradata.
- Worked on testing primary index and skew ratios before populating data into tables using sampling techniques,explain plan in Teradata before querying large tables with several joins.
- Performedtuningandoptimizationof complexSQL queriesusingTeradata Explain.
- Used variousTeradata Index techniquesto improve the query performance.
- Involved in loading of data into Teradata from legacy systems and flat files using MultiLoadscripts and FastLoadscripts.
- Involved heavily in writingcomplex SQL queriesto pull the required information from Database usingTeradata SQL Assistance.
- Involved introubleshooting the productionissues and providing production support.
- Developed unit test plans and involved in testing.
- Created Project estimate, Study Document and Technical response
- Typically involved in different tasks throughout the project life cycle
Environment: Teradata SQL Assistant, MLoad, FLoad, PMON, MVS, UNIX
Confidential
.Net Developer
Responsibilities:
- Worked as a Web Developer in a team of 8 people.
- Performed Web Development for clients in diverse fields.
- Worked closely with senior developer and learned advance project management skills.
- Performed maintenance and updates to existing client Web sites.
Environment: .Net, Java Script, HTML