We provide IT Staff Augmentation Services!

Etl/teradata Lead Resume

5.00/5 (Submit Your Rating)

Kansas City, MO

SUMMARY

  • Client - focused ETL\Teradata Developer with 7 Plus years of experience in the areas of Application Software Requirement Analysis, Design, Development, Testing, Implementation, and Maintenance with proficiency as Teradata developer innovative and achieving high client satisfaction.
  • Over 4 Plus years of experience using Teradata SQL Assistant, and data load/unload utilities like BTEQ, Fastload, Multiload, Fast Export and Tpump
  • Extensive experience on Mainframes (MVS) Job Control Language (JCL).
  • Extensive experience in writing and executingBTEQ scriptsfor validation and testing of the sessions, data integrity between source and target database and for report generation.
  • Expertise in creating databases, users, tables, triggers, macros, views, stored procedures, functions, Packages, joins and hash indexes in Teradata database
  • Familiar with designing the application data model and identifying the Primary Index, Secondary Index, Join Indices in Teradata for efficient storage and retrieval.
  • Hands on experience in writing SQL queries in multi database environment.
  • Good knowledge of Dimensional Data Modeling, Star Schema, Snow-Flake schema, FACT and Dimensions Tables.
  • Working knowledge on the Business Intelligence Reporting Tool - Microstrategy.
  • Done a lot of Performance Tuning for improving query performance of user queries and production SQL’s.
  • Proficient in Teradata Database Design (Physical and Logical), Application Support and setting up the Test and Development environments.
  • Worked on TCRM application on Campaign Management.
  • Excellent Retail domain and ITIL knowledge
  • Extensive experience working in Agile and Waterfall methodologies.
  • Good documentation skills with the ability to meet project deadlines and ability to work in a cross functional environment.
  • Strong communication skills, interpersonal skills, leadership skills, self-motivated, quick learner and team player

TECHNICAL SKILLS

ETL Tools: ETI extract, Teradata SQL Assistant, MLOAD, TPUMP, FAST LOAD, FAST EXPORT, BTEQ, TOAD

Languages: SQL, SPL, COBOL,JCL

Database: Teradata TD12/TD13/TD14, DB2, Oracle 9i

Operating Systems: Windows 2003/2000/NT, UNIX, Mainframe

Office Suits: Microsoft Office - Word, Excel, Access, Visio, PowerPoint

Reporting Tools: Microstrategy, Excel.

Data Modeling Tools: ERWIN

EDI Translation Tool: GENTRAN

PROFESSIONAL EXPERIENCE

Confidential, Kansas City, MO

ETL/Teradata Lead

Responsibilities:

  • Actively involvedin requirements gathering, creating design specifications and ETL designdocuments.
  • Participated in Daily meeting with Business Units to resolve any issues/concerns.
  • Loading Data to the Teradata Data Warehouse Tables from multiple data sources using Teradata utilities.
  • Created tableswith appropriatePItaking into consideration of bothplanned access of data and even distribution of data across all the availableAMPS.
  • Analyzed anddesignedSIbased on the columns used in joins during data retrieval.
  • Used BTEQ andTeradata SQL Assistant front-endtools to issue SQL commands matching the business requirements to TeradataRDBMS.
  • Utilizing Teradata Explain and Visual Explain to analyze and improve query performance. Redesigning and fine Tuning Teradata SQL for higher Performance.

Environment: Mainframe, Teradata 14, Datastage, Fastload, Multiload, BTEQ, FastExport, TPUMP.

Confidential, Houston, TX

Technology Analyst

Responsibilities:

  • Coordinate with offshore team on Development activities.
  • Setup new trading partners and monitor the EDI data for any data issues or application job failures.
  • Interact with the end customers who wish to interface with us using EDI and develop new maps for 810, 850, 855, 832, 997 transactions as per their requirements.
  • Manage a team size of five along with the application support.
  • Use ITIL tools for Incident, Problem and Change Management to track the Service Level Adherences and production data changes.
  • Execute SQL to report the analytics on the orders placed by the customers.

Environment: COBOL, JCL, GENTRAN, BMC Remedy, DB2.

Confidential, Kansas City, MO

ETL/Teradata Analyst

Responsibilities:

  • Participate in Daily meeting with Business Units to resolve any issues/concerns.
  • Create ER diagrams using Erwin and Microsoft visio based on the business requirements.
  • Maintain all Customer data applications, TCRM and Enterprise Data Warehouse (EDW).
  • Use Teradata Mload and FastLoad utilities through mainframe to extract data from flat files and load to Teradata tables.
  • Wrote BTEQ scripts in mainframe to import and export data to and from the Teradata tables.
  • Create views with OLAP functions for business to do analysis.
  • Extract, Transform and Load data from various data sources to Teradata using Teradata utilities.
  • Do performance tuning in the user queries and batch queries running in test and production environments.
  • Coordinate with offshore team on Development activities
  • Implemented changes in coordination with Infrastructure team and Provide Warranty Support.
  • Worked as Production support team for production issues with Space forecast on the system
  • Troubleshooting any issues related to production, database development and documenting issues.
  • Working on improvement of existing process by integrating various sources and helping in maintenance code hence ensuring process is efficient.
  • Review of statistics and joins for performance improvement of Teradata SQL's using DBQL, Explain Plans
  • Making changes to Physical model to assist with performance improvement by implementing partitioning, compressions and indexes on EDW tables.

Environment: COBOL, UNIX, BTEQ, Teradata SQL Assistant, Mload, Fastload, FastExport, TPUMP, Oracle, DB2, Teradata 12/13, TOAD, Erwin, Microstrategy, Microsoft visio.

We'd love your feedback!