We provide IT Staff Augmentation Services!

Etl Developer Resume Profile

Boston, MA

Objective: Position as a Teradata DW/BI application Developer/Lead role.

Professional Summary

  • Around 9 years of IT experience- high degree of proficiency dealing with RDBMS- Tearadata, MS SQL Server and DB2 in the areas of development/DBA. Sound knowledge of software development life cycle SDLC with substantial experience with object-oriented analysis and design methodologies. Possess experience in independently handling design, development, documentation and testing phases in a project environment.
  • 1 year experience at Hanu Software Solutions USA as ETL Developer and SQL Server DBA.
  • 6 months experience at CTS at Hyderabad, India as Teradata Lead.
  • More than 7 years' experience at Infosys www.infosys.com as a Teradata Senior Developer at Bangalore, Hyderabad, India and Ohio, USA.
  • High degree of proficiency in gathering user specifications from business users and preparing detailed Business Requirement Documents.
  • Experience in all aspects of analytics/data warehousing solutions Database issues, Data modelling, Data mapping, Data Analysis, ETL Development and data migration I have been key in delivering innovative database /data warehousing solutions to the Banking and Insurance Industries.
  • Proficient in data warehousing techniques for data cleaning, Slowly Changing Dimension phenomenon, surrogate key assignment and CDC change data capture , Error Handling Techniques for ETL process.
  • Extensively worked with Teradata utilities like BTEQ, Fast Export, Fast Load, Multi Load and TPUMP to export and load data to/from different source systems including flat files.
  • Proficient in performance analysis, monitoring and SQL query tuning using EXPLAIN PLAN, Collect Statistics.
  • Excellent Experience with different indexes UPI, NUPI, USI, NUSI, JI and Collect Statistics.
  • Proficiency in Data Modelling, Star Schema Modelling, Snow-Flake Modelling, FACT and Dimension Table design and Physical Data modelling implementations.
  • Experienced in building Data marts, data structures, data storages, data warehouses, data archives, and data analysis.
  • Advanced SQL skills, including use of derived tables, unions, multi-table inner/outer joins.
  • Experienced in UNIX shell scripts to write wrapper scripts to call ETL Jobs
  • Familiarity on Teradata Parallel Transporter TPT scripts.
  • Well versed with Informatica 9.0.1 and DataStage 8.1 ETL Tools.
  • Developed mappings in Informatica to load the data from various sources into the Data warehouse using different transformations like Source Qualifier, Expression, Lookup, Aggregate, Update Strategy and Joiner.
  • Experience in installation, Configuration, Maintenance and Administration of SQL server 2005/2008/2012.
  • Ensure all database servers are backed up in a way that meets the business's Recovery Point Objectives RPO
  • Responsible for disaster recovery processes. Well conversant in developing backup and disaster recovery plans for SQL server in Windows Azure Cloud.
  • Experience with database availability, clustering, log shipping, and mirroring.
  • 24 x 7 Production Database on Call Support.
  • Experience in building Data Integration and Workflow Solutions for data warehousing using SQL Server Integration Service SSIS .
  • Completed LOMA 280 certification- principals of insurance
  • Strong team player with good analytical skills.
  • Good Communication skills, with emphasis on strong client relationships.
  • Involved in Technical/ process related events. Demonstrated success in coordinating and mentoring development teams.

Technical Expertise

Databases:

Teradata V2R5, Teradata 12, Teradata 13, Teradata 14, MS SQL Server 2012, SQL Server 2005/2008 and DB2

Programming:

Teradata SQL, T-SQL, C, Java, COBOL, PL1

DBA:

database administration of MS SQL Server 2012, 2008, 2005

Operating System:

Windows 2008/2003 Advanced Server, NT Windows 9x, Linux

Other Software:

Windows 2008/2003 Advanced Server, NT Windows 9x, Linux

Tools:

BTEQ, MLOAD, FASTLOAD, FASTEXPORT, TPUMP, Informatica 9.0.1 and SSIS

Professional Experience

Confidential

Role: ETL Developer

Responsibilities

  • Used ETL SSIS to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
  • Transferring the data ETL to Data ware house by SQL Server 2005 Integration Services.
  • Created dynamic and customized packages for ETL from various data sources using SSIS.
  • Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task and Send Mail task etc.
  • Setup Database Maintenance Plans to reorganize indexes, re-indexing and update the index statistics on the production databases.
  • Developed Different Maintenance Plans such as backups, index management, fragmentation management, cleaning history, deleting old files.
  • Created user databases, tables, indexes, and stored procedures.
  • Worked on simple to complex SQL Queries and TSQL statements
  • Designed and Implemented comprehensive Backup plans and disaster Recovery strategies.
  • Created SQL Server logins and assigning roles and Authentication models as a part of Security.
  • Worked on DR strategies and documentation of DR procedures.
  • Provided 24x7 on call production support.

Confidential

Role: MS SQL Server Database Administrator

Responsibilities

  • Responsible for the day-to-day administration, technical support, troubleshooting, maintenance, performance and overall health of MS SQL Server 2008 within a Microsoft Windows Server environment. Ensure high levels of data availability and reliability of the systems.
  • Provided 24x7 on call production support.
  • Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing
  • Scheduled the backups for Databases and Transaction logs. Performed restoration operations. Suggested backup strategies.
  • Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environments.
  • Worked on simple to complex SQL Queries and TSQL statements
  • Rebuilding the indexes at regular intervals for better performance.
  • Involved in Disaster Recovery planning, testing and execution.
  • Implemented log shipping as disaster recovery solution.

Confidential

Role: Teradata Database Lead

Responsibilities

  • Lead the execution of the development pipeline and delivery of the code to QA, and ultimately Production
  • Ensure that best practices for coding, architecture, and security are employed across the team consistently, and maintain responsibility for the quality development of the applications.
  • Provide hands-on development and mentoring as necessary for other members of the development team.
  • Designed the order of flow for the execution of the jobs and scheduling the jobs.
  • Fine tuning of SQL to optimize the performance, spool space usage and CPU usage.
  • Created proper Primary Index PI talking into consideration of both planned access of data and even distribution of data across all the available AMPS.
  • Worked on concepts involving different types of Indexes, Joins, and Spaces etc. for optimum performance of Teradata.
  • Done Query optimization explain plans, collect statistics, Primary and Secondary indexes used volatile table and derived queries for breaking up complex queries into simpler queries.
  • Streamlined the Teradata stored procedures.
  • Build tables, views, UPI, NUPI, USI and NUSI.
  • Worked with DBA's for transition from Development to Testing and Testing to Production.
  • Responsible for migration and production support.
  • Performing Data Validation and Reviewing the code developed
  • Status tracking of project activities.
  • Onsite - Offshore Co-ordination.

Confidential

Role: Teradata DW/BI Sr. Developer

Responsibilities

  • Involved in requirements gathering and data gathering to support developers in handling the design specification.
  • Preparing Technical Design Document
  • Created, updated and maintained ETL technical documentation.
  • Prepared Unit Test Specification Requirements.
  • Extracted data from various source systems like Oracle, SQL Server and flat files as per the requirements.
  • Extensive experience in writing and executing BTEQ scripts for validation and testing of the sessions, data integrity between source and target database and for report generation.
  • Involved in loading of data into Teradata from legacy systems and flat files using complex MLOAD, TPUMP and FASTLOAD scripts.
  • Designed/Developed scripts to move data from the staging tables to the target tables.
  • Fine tuning of SQL to optimize the performance, spool space usage and CPU usage.
  • Created proper Primary Index PI talking into consideration of both planned access of data and even distribution of data across all the available AMPS.
  • Familiar with concepts involving different types of Indexes, Joins, Spaces etc. for optimum performance of Teradata
  • Write numerous BTEQ scripts to run complex queries on the teradata database.
  • Created Mappings and scheduled Workflows using Informatica.
  • Developed mappings in Informatica to load the data from various sources into the Data warehouse using different transformations like Source Qualifier, Expression, Lookup, Aggregate, Update Strategy and Joiner.
  • Reduced Teradata space used by optimizing tables adding compression where appropriate and ensuring optimum column definitions.
  • Responsible for migration and production support.
  • Wrote hundreds of DDL scripts to create tables, views and indexes in the company Data Warehouse.
  • Created Global and volatile temporary tables to load large volumes of data into teradata database.
  • Performing Data Validation and Reviewing the code developed
  • Status tracking of project activities.
  • Onsite - Offshore Co-ordination

Confidential

Role: Mainframe Developer

Responsibilities

  • Involved in full project life cycle involving Requirement Analysis, Design, Coding, Testing and Implementation phases
  • Involved in preparing the technical design documents and carrying out walkthrough meeting with the IT Business managers.
  • Modified and tested COBOL and PL1 programs and JCL codes per the requests of business departments.
  • Prepared Unit Test Specification Requirements.
  • Analyze, Design, Develop test activities in PL1,CICS,DB2
  • JCL job creation and maintenance.
  • Performing Data Validation and Reviewing the code developed
  • CA-7 job scheduling / ABEND resolution and JCL coding.
  • Create JCL 'PROCs' cataloged procedures

Hire Now