SUMMARY

• Over all 9.5 years of IT experience as ETL developer under mainframes/Informatica/Hadoop platforms and libraries in all phases of large - scale software architecture, design, development and testing.
• Over all 9 years of experience in Data Warehousing, Databases & Decision Support Systems.
• Strong experience in the Implementation of Extraction, Transformation & Loading (ETL) Life Cycle using Teradata V2R6, 10, 12 and 14, Mainframes and COBOL.
• Have 5 years experience in Informatica V 7.3, 8.1 and 8.6 using it as ETL tool.
• Experience working on Informatica transformations like normalizer, Lookup, Source Qualifier, Expression, Aggregator, Sorter, Rank and Joiner.
• Experience in Informatica Admin tasks - Creating test folders, Test to QA folder copy, Test to QA label deployment
• Have 3 years experience in Hadoop - DMX-H using it as ETL tool.
• Experience with data architecture including data ingestion pipeline design, Hadoop information architecture, data modeling and data mining, machine learning and advanced data processing. Experience optimizing ETL workflows.
• Involved in all phases of Software Development Life Cycle in Data warehousing.
• Good working knowledge of SQL and BTEQ in Teradata and MS access as RDBMS with Procedures and Functions.
• Extensively worked on BTEQ, MULTILOAD, FASTLOAD, FAST EXPORT and TPT utilities in Teradata.
• Have good hands on experience in tuning Teradata queries by using explain plans.
• Optimized queries by using different tuning techniques like re-indexing, redefining, de-normalization, parallel processing, strategic semicolon for grouping multi-inserts, etc.
• Generated SQL scripts to create, alter and drop database objects including tables, views, primary keys, indexes, and constraints.
• Good understanding of warehousing concepts, staging tables, Dimensions, Facts and Star Schema.
• Heavily interacted with the Business Users to gather requirements, Design Tables, standardize interfaces for receiving data from multiple operational sources, coming up with load strategies of loading staging area and data marts.
• Possess good understanding of Conceptual, Logical and Physical designs and familiar with ERWIN models/diagrams.
• Good working knowledge in Data Modeling using Dimensional Data modeling, Star Schema/Snow flake schema, FACT & Dimensions tables, Physical & logical data modeling.
• Experience in Integration of various data sources like Teradata, Flat Files and GDGs.
• Hands om experience in file management tools like FILA and FM.
• Exclusive knowledge in Identification of User requirements, System Design, writing Program specifications, Coding and implementation of the Systems.
• Have good hands on Changeman and Endevor as a Configuration management tools, for maintaining the project related documents and version control.
• Extensively worked on creating, executing test procedures, test cases and test scripts using Manual/Automated methods.
• Highly motivated with the ability to work effectively in teams as well as independently.

TECHNICAL SKILLS

Computer Systems: Intel(R)Core(TM)2 Duo

Operating Systems: Windows 2000/XP

Programming Languages: Teradata SQL, COBOL, JCL

Scripting Languages: JSP & Servlets, PHP, JavaScript, Unix Script, XML, HTML, Python and BashChangeman, Endevor, CA7, Peregrine, Maximo, Remedy, Teradata tool and utilities 8.0, IRIS, File-Aid, File Manager, Maximo, PODsInformatica V 7.3, 8.1, 8.6, 9.1 SAS Enterprise Guide 4.1 (BI) and SAS Data Integration Studio 3.4

Big Data Ecosystems: Hadoop, MapReduce, HDFS, HBase, Zookeeper, Hive, Pig, Sqoop, Cassandra, Oozie, Flume, Chukwa, Pentaho Kettle and Talend

Database: Teradata

PROFESSIONAL EXPERIENCE

Confidential

Sr. Teradata Technical Analyst

Responsibilities

• Understand the requirements of the clients and create estimates for the projects.
• Work on proposals for improving the process and value add to existing solutions.
• Prepare the design document with the listing of various sources, targets and impacted systems.
• Work on the necessary changes to the Logical or physical data models.
• Create test cases, Test plan or Test scripts for testing the requirements.
• Communicate with the System Of Records (SOR) for the changes planned for this release.
• Communicate with the DBA team for all the teradata component changes, access requests, archival process, etc and work on the necessary DDL/DCL documents.
• Identify the process to extract the data from various sources and modify or construct a program for fixes and other enhancements as per the requirement of the client.
• Get mapping confirmation from SOR and downstream.
• Create CA7 (PODS)/Autosys requests for all the scheduling changes.
• Do the required code changes, if Mainframes JCL, PROCS, Parms or Programs or Informatica/Hadoop transformations
• Create Changeman/Endevor package for all the mainframe code changes that has to be installed as part of this change. Migrate Informatica/Hadoop code from test to prod environment
• Organize meetings with various team to successfully receive the data in W.
• Build SIT and UAT environments for testing in lower(test) regions.
• Test the data with all conceivable conditions in the SIT and UAT cycles so that errors can be solved out before the production.
• Update metadata and data lineage that are impacted as part of the project.
• Get architect approval for the proposed changes.
• Get User Signoff for the changes planned for the install.
• Prepare for the Change control process and review required for the implementation.