PROFESSIONAL SUMMARY:

• Having 8.2 years of IT experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing.
• Hands - on expertise using Teradata and Informatica, with strong business understanding of Banking, Insurance and Telecom sectors.
• Experienced with SIMEXS documents and Customer Change request documents and Adoc documents.
• Worked with Teradata client utilities i.e. BTEQ,FLOAD,MLOAD,TPT(Teradata parallel transporter)
• Experienced on Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center 9.5.1 (Designer, Workflow Manager, Workflow Monitor, Repository Manager) as ETL tool on Teradata.
• Worked with Monitoring Tools like: Tealeaf, IDSS, Nagios, Introscope, Splunk, BMC Remedy, SVN etc.
• Perform production support activities which involve assignment of issues and issue analysis and resolution within the specified SLAs.
• Coordinate with Application Development Team to successfully deploy software releases in both User Acceptance Testing and Production environments.
• Extensive experience in developing Views and Complex SQL queries using Teradata SQL.
• Identified long running Queries, scripts, and Spool Space issues and implemented PerformancesTuning concepts.
• Familiar with DWH concepts like Data Modeling, Data Profiling, Data Marts etc.
• Familiar with Teradata DBA concepts and Teradata mapping manager tools.
• Experienced in preparing the unit test case documents with test results for the assignments.
• Excellent interpersonal and communication skills, and experienced in working with senior level managers, business people and developers across multiple disciplines.

TECHNICAL SKILLS

Operating Systems: UNIX Flavor and Windows Flavor.

Languages: SQL

Databases: Teradata12/13

ETL Tool: Informatica 9.5.1/Datastage

Tools & Utilities: BTEQ, Fastload, Multiload, TPT

PROFESSIONAL EXPERIENCE

Confidential

Teradata Developer

Responsibilities:

• Understanding requirements, design of solution and preparation of mapping documents.
• Responsible for work allocation and ensures that all deliverables/tickets are completed as per baseline.
• Different types of Data Loading (Direct, Incremental, SCD Type2 et...) implemented using Teradata client tools i.e BTEQ,FLOAD,TPT,MLOAD scripts and used configuration files .
• Working on BTEQ scripts to resolve the batch issues and incidents quickly to complete on time.
• Worked on assigned tickets and suggesting all possible and probable solutions to the user and also by following the client quality of design and code.
• Analyzing tickets and developing, enhancing Teradata SQL and Utilities Fload, Multi load and FExport
• Follow up with other teams like DBA, ETL etc., for periodically to complete work on time
• Did data reconciliation across various source systems.
• Involved in query tuning and performance for some existing queries built for reports.
• Suggest fixes to complex issues by doing a thorough analysis of root cause and impact of the defect.
• Delivering the data to higher management to meet the SLA
• Creation of reports based on Daily and monthly.
• Prepared test scripts and Unit test the load scripts and checked for data validation and data integration.

Confidential

Teradata developer

Responsibilities:

• Involved in Analysis of existing ETL processes (Unix,Awk, Sybase Procedures etc.) and design new processes.
• Extensively worked on ETL development using the Teradata client tools like Bteq, Fast load, Multiload, TPT and awk scripts.
• Experienced in the Database design in Teradata to migrate Database object from Sybase to Teradata.
• Prepared the basic shell scripts for processing the data files and move the log files into proper subject area.
• Prepare the unit test palns with result sets.
• Perform comparison testing with existing production data for accuracy and performance improvement.
• Participate in integration testing, Defect tracking and fixing.
• Creation of operation support manual.

Confidential

Production Support

Responsibilities:

• Defect fixing if any issue persists in coding after the code deployment to production.
• Interacting with Business Users.
• Co-ordination with Onsite/Offshore.
• Worked with various databases of Teradata warehouse in our project like Stage, Target, Work and temp database.
• Worked with collect statistics, join indexes etc.
• Involved in building tables, views and Indexes.
• Involved in developing and update existing scripts as per project requirements.
• Prepared Unit Test Specification documents.
• Closely work with release management team to move the code in production environment.
• Monitor applications in production environments and provide real time support for analyzingand troubleshooting issues.
• Update Knowledge Repository for all new issues and keep the repository up to date withrelevant info for other known issues.
• Document and share the tips for Incident resolution with team.
• Root cause analysis and implementation of permanent fix for the outage.

Confidential

ETL Developer

Responsibilities:

• Working with different sources like flat files.
• Developed Data Stage jobs to extract, transform and load the data from source to target
• Tuned Data Stage jobs for better performance
• Extensively used Data Stage Client Tools - Data Stage Designer, Director
• Used various Stages in Data Stage (PX) like Lookup, Join and Merge
• Used Aggregate stages for summarizing the data
• Worked with ER, UV and WT tables in error handling.
• Worked exclusively with the Teradata SQL Assistant to interface with the Teradata