We provide IT Staff Augmentation Services!

Senior Teradata Etl Developer Resume

Concord, CA


  • Around nine years of combined Industry Experience as a Data Warehousing Expert and ETL Developer in designing, developing and implementing ETL processes for business applications.
  • Extensive experience in analysis, design, development & migration of data warehouse applications.
  • Worked on Development, Maintenance, enhancement and support related projects.
  • Diversified domain experience in banking domain.
  • Working in banking domain for over 4 yrs.
  • Demonstrated understanding of Dimensional modeling (Star & Snow flake schema) and other data warehousing concepts.
  • Worked on Informatica versions of INFORMATICA 8.1.1 & INFORMATICA 9.0.1
  • Worked on Mainframe ETL Process using Z/OS
  • Extensive experience in implementing the ETL processes which include developing the data model, designing the change capture and disaster recovery strategies.
  • Have clear understanding of Data Warehousing concepts with emphasis on ETL and Life Cycle Development including requirement analysis, design, development, testing and implementation.
  • Experience in Data Warehouse development working with Extraction/Transformation/Loading using Informatica PowerMart/PowerCenter with Teradata, DB2 & Oracle databases.
  • Experience in automating of the ETL processes for migration and patching Informatica objects.
  • Worked with various Power Center/Power Mart components like Informatica Server and Client tools e.g.) Designer, Workflow Manager, and Repository Manager & Workflow Monitor.
  • Strong experience with star and snowflake schema, dimensional data modeling, Fact and dimensional tables, slowly changing dimensions.
  • Developed shell scripts for invoking Informatica workflows.
  • Involved in Informatica Performance tuning of the ETL process and SQL tuning.
  • Extensive experience in designing the architecture for Extract, Transform, Load environment and development of mappings and process using Informatica Power Center.
  • Extensive experience in formulating error handling mechanism.
  • Experience in integration of various data sources like Teradata and Oracle.
  • Worked extensively on Teradata Utilities like MLOAD, TPUMP, FASTLOAD, TPT & FASTEXPORT and also Oracle Stored Procedures, Table Partitions SQL queries and loading data into Data Warehouse/Data Marts using Informatica/Mainframe.
  • Extensively used third party tools which include Autosys, Maximo, CA7, IBM Clearquest, HP Service center tool for ticket management & Quality center etc.
  • Used various third party version control tools like Sub Version, Changemen, Endevor tools.
  • Excellent communication skills, Good organizational skills, outgoing personality, Self-motivated, hardworking, ability to work independently or cooperatively in a team, eager to learn, ability to grasp quickly.

Technical Skills:

ETL Tools: Informatica Power Center 8.x/9.x, Mainframe

Databases: Teradata V2R5 & V2R6, 12/13/14 Oracle 8.i/9.i/10g & IBM DB2

Data Modeling Tools: Erwin 4.1.

Version Control Tools: Sub Version, Changemen & Endevor

Languages: SQL, PL/SQL

Scripting Languages: Korn Shell, Bash shell scripting

Business Intelligence Tools: Had training on Informatica Power Exchange, Hadoop, DMX

Scheduling tools: Autosys and Tivoli

Special Tools: Autosys, Maximo, CA7, HP Quality center, Changemen, NDM & File-Aid, IBM Clearquest, HP Service center and Core FTP tool.

Operating Systems: Windows, Sun Solaris, Z/OS

Professional Experience


Senior Teradata ETL Developer


  • Handling Project Meetings & Perform analysis of the existing W data to understand the mapping rules in the current environment.
  • Finalize design, Model and High Level Design and Low Level Design Documents.
  • Perform analysis of existing code in mainframes or in ETL tools like Informatica to understand the mapping logics
  • Coordinating with offshore for Coding Testing and Deployment in prod.
  • Developing the mapping documents including System of Record field names, Mapping Rules and W Target field names.
  • Transmission of the System of Record files from mainframes / UNIX to new environment.
  • Coding in new environment as per the mapping documents.
  • Preparation of test cases to validate the output data generated using the mapping documents.
  • Validation of the test cases and Defect tracking using Quality Center tool.

Environment: Informatica 9.1, Teradata 13.10, UNIX, F-SECURE, Teradata SQL Assistant, Autosys Scheduler, CA7,


Account Management


  • Leading the projects from Onsite/Offshore, which includes a daily interaction with clients, and Business Analysts for requirements gathering, clarifications and suggestions in data integration
  • Participate in dispatch meeting , analyze the requirements and work with users to generate require data for reporting
  • Preparing all necessary documents like Low Level Design, Deployment Sheets and Delivery packages
  • Creating/updating eProducts data model using Erwin designer
  • Work with bank privacy application team to generate the privacy related views
  • Design and development SQL queries as per the business requirement
  • Extensively used Changemen ,Endevor tools
  • Created a RTAS (Rules, Trends, Alerts system) generic data validation driven by control tables which has been made as standard for data validation across the project
  • Preparing Unit/SIT/UAT Test Cases and Test Results documents
  • Coordinating with testing team for fixing QA and UAT Defects
  • Scheduling the jobs in CA-7 and monitoring its daily run in Production
  • Support the Application and users until completion of warranty

Environment: Teradata R12/R13.11.11, Teradata SQL Assistant, SQL, VSS, Outlook, Putty, MLOAD, TPUMP, FAST LOAD, FAST EXPORT, TPT,



  • Involved in Complete Software Development Lifecycle Experience (SDLC) from Business Analysis to Development, Testing, Deployment and Documentation
  • Wrote, tested and implemented Teradata Fastload, Multiload and BTEQ scripts, DML and DDL
  • Wrote views based on user and/or reporting requirements
  • Wrote Teradata Macros and used various Teradata analytic functions
  • Performance tuned and optimized various complex SQL queries
  • Good knowledge on Teradata Manager, SQL assistant and BTEQ
  • Gathered system design requirements, design and write system specifications
  • Coordinated with the business analysts and upstream to discuss issues in interpreting the requirements
  • Worked on conversion of existing customer data to new intuit platform

Environment: Teradata R12/13.11, Teradata SQL Assistant, Putty, MLOAD, TPUMP, FAST LOAD, FAST EXPORT, TPT, BTEQ.



  • Requirements analysis, data assessment, business process reengineering
  • Provide analysis with expertise in different technologies ,business areas ,application wide analysis and proposal of solutions
  • Responsible for high level work breakdown structure, review the project requests describing user needs to estimate time and cost required to accomplish the project
  • Query and Indexing optimization and fine tuning
  • Coding using Teradata Analytical functions, BTEQ SQL of Teradata, format and execute the SQLs on Mainframe environment
  • Propose, and negotiate performance enhancement changes into data models, ETL workflows and BI reporting, by working with Data, ETL & BI architects
  • Developed mainframe Jobs to automate redundant tasks
  • Application development that enables data to be moved from legacy systems and external data sources into a staging area for the transformation effort to final data load into the Enterprise data warehouse Teradata, the tools extensively used were Multiload, Fastload, Fast export, and BTEQ
  • Automatic Email generation process once the stream completes and send the reports on

Environment:Teradata R12/R13.11, Teradata SQL Assistant, SQL, VSS, Outlook, MLOAD, TPUMP, TPT, FAST LOAD, FAST EXPORT.


System Engineer


  • Involved in business analysis and technical design sessions with business and technical staff to develop data models, requirements document, and ETL specifications.
  • Involved in designing the system and designing the logical database design using ER Studio.
  • Involved in designing the physical database system.
  • Involved in data quality and cleansing of data source.
  • Involved in creation of database schema and capacity planning of schema for the warehouse.
  • Coding as per the mapping/D953 documents.
  • Unit testing of the mappings.
  • Responsible for migration of applications from dev environment to Test and finally to Production.
  • Developed UNIX scripting for data feed files for making ready to processing as per System.
  • Scheduled jobs in Autosys scheduler.
  • Developing the mapping documents including System of Record field names, Mapping Rules and BI Target field names.
  • Discussion of the mapping document with Architects and mapping team to appropriately map Source elements to SCMBI target model and create a D953 design document.
  • Continuous support through conference calls with mapping team and development team to provide accurate data in new environment.
  • Transmission of the System of Record files from UNIX to SCMBI environment.
  • Preparation of test cases to validate the output data generated using the mapping documents.
  • Validation of the test cases using Quality Center tool.
  • Defect tracking through Quality Center and SharePoint portal.

Environment: Informatica 8.1.1/8.6, Oracle, UNIX, Autosys Scheduler, Sub Version Control Tool



  • Understanding the requirements and Business Functionality.
  • Gathered system design requirements, design and write system specifications.
  • Preparation of Detail Design document and Unit Test Plans & Test results
  • Coding as per project standards.
  • Defect fixing in each stages like Unit, Integration, UAT, Regression and system testing
  • The project is executed based on an Onsite/Offshore model.
  • Effective communication and co-ordination with onsite members is involved. Also, communication with the Client as and when required
  • Coordinating the team activities and Reviewing the tasks done by the team

Environment: Teradata V2R3/V2R5, COBOL, JCL, CA7

Hire Now