We provide IT Staff Augmentation Services!

Senior Etl Application Developer Resume

3.00/5 (Submit Your Rating)

Charlotte, NC

SUMMARY

  • A passionate, self - directed, organized, fast learning professional wif 12 years of experience in Data Warehouse scene and well experienced in ETL/ELT technologies. Well versed in all SDLC phases - Requirements Gathering, Data Model Design, Application Design, Data Analysis, Coding, SQL Query Tuning, Unit Testing, Code Migration, Release Management, and Production Code Support and Maintenance.
  • Proficient in data analysis, data mart design, development and implementation of ETL processes against high-volume data sources. Thorough understanding of business intelligence and data warehousing concepts wif emphasis on ETL.
  • Experienced in Agile Scrum, Kanban Software Development models along wif traditional Waterfall Model. Also wif lots of energy to learn teh new skills and technologies from teh industry.
  • Strong experience in teh Implementation of Extraction, Transformation & Loading (ETL) Life Cycle using Informatica Power Center 9.5.1/8.6.1/8.1/7.1/6. x, Teradata V14, Netezza, Oracle 9i & 10g.
  • Extensively worked on Teradata Macros,BTEQ, MULTILOAD and FASTLOAD, FAST EXPORT, TPT utilities in Teradata.
  • Extensively worked on BTEQ scripts in Teradata using UNIX to override Informatica code which causes performance issues.
  • Have good hands on experience in tuning Teradata scripts by using explain plans.
  • Extensive knowledge of Full life-cycle Application development like defect tracking, technical reviews and change management
  • Experience in Financial, Insurance, HealthCare and Retail Industries.
  • Experienced in implementing projects developed using Informatica, BASIC SAS, Oracle, Teradata and UNIX shell scripting.
  • Involved in all phases of Software Development Life Cycle in Data warehousing.
  • Informatica Certified Developer professional.
  • Good working knowledge of SQL and BTEQ in Teradata, Oracle, PL/SQL, SQL server, DB2 as RDBMS wif Procedures, Functions and SQL * Plus.
  • Strong experience in shell scripting wif different shells like Korn shell and BTEQ scripts in Teradata using UNIX.
  • Optimized teh Oracle queries by using different tuning techniques like using hints, parallel processing, and optimization rules.
  • Generated SQL and PL/SQL scripts to install create 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 wif teh Business Users to gather requirements, Design Tables, standardize interfaces for receiving data from multiple operational sources, coming up wif load strategies of loading staging area and data marts. Dealt wif Type1/Type2/Type3 loads.
  • Possess good understanding of Conceptual, Logical and Physical designs and familiar wif ER diagrams.
  • Good working knowledge in Data Modeling using Dimensional Data modeling, Star Schema/Snow flake schema, FACT & Dimensions tables, Physical & logical data modeling, ERWIN 4.x/3.x.
  • Experience in Integration of various data sources like Teradata, Oracle, DB2, Sybase, SQL Server, Flat Files and COBOL files.
  • Resolved product issues. Used features like Pre-Session/Post-Session commands/sql for fine-tuning of Databases/Data marts, Mappings, Sessions, Various Parameters in oracle and Informatica to get optimal performance.
  • Followed a high level of quality processes and documentation in compliance wif CMM Level 5 for all teh projects wif Detailed design doc, code review, Traceability matrix, defect tracker, EWS,Unit test cases documents, Assembly test cases etc..
  • Have good hands on Clear Case as a Configuration management tools, for maintaining teh project related documents and their versioning system.
  • Hands on experience in scheduling UNIX scripts, Teradata BTEQ scripts and Informtica workflows.
  • Extensively worked on creating, executing test procedures, test cases and test scripts using Manual/Automated methods.
  • Successfully handled various roles and responsibilities in teh project life cycle.
  • Highly motivated wif teh ability to work TEMPeffectively in teams as well as independently.

TECHNICAL SKILLS

  • ETL Tool
  • Informatica
  • Oracle PL/SQL
  • BASE SAS
  • ELT
  • Teradata BTEQ Scripting
  • Data Base Programming
  • Netezza ELT Scripts
  • Oracle PL/SQL
  • Teradata SQLs
  • OS Programming
  • Unix Shell Scripting
  • Python scripting
  • Scheduling Tool
  • Tidal Scheduler
  • WLM
  • Tivoli Workflow Scheduler
  • Versioning Tool
  • Win CVS
  • Sub Version
  • Rational clear case
  • Data Modeling
  • Erwin 4.0/4.5
  • Agile Scrum tool
  • Version One Ultimate Scrum Spring 15
  • Ca Rally

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Senior ETL Application Developer

Responsibilities:

  • Involved in all teh phases of SDLC Process starting from Gathering requirements from BAs, Analyzing teh data for teh proper transformations, Creating of Mapping document, Design, Development & Unit Testing, coordinating Wif QA team and Users for SIT and UAT testing, Production implementation & Smoke Test and Production maintenance.
  • Worked on version control using Subversion and Informatica and has experience in ETL migrations to higher environments.
  • Worked on Agile methodology and Scrum processes including creating Epics, Stories and involved in all teh processes like Stand-up, Breakout, Refinement and Retrospective.
  • Worked on converting Business logics and Transformations from Netezza SQLs to Teradata Bteq scripts and Informatica codes.
  • Worked on creating Unix Script for validating teh Data and Trigger files and FTP to teh external server and emailing teh wif appropriate Success or Error Messages to teh concerned team.
  • Worked on Teradata Performance tuning and Informatica run time improvement by adding data Distribution columns in Teradata for proper data storage, avoiding repetitive functions for a column like trim or substring or coalesce, Generating stats only on teh key fields and join/where condition columns instead of whole table etc.

Environment: Informatica Power Center 9.6, Teradata, Netezza, Flat Files, Unix shell scripting, python scripting, Tortoise SVN, Command Center and Version 1 scrum tool.

Confidential, Charlotte, NC

Senior ETL Developer

Responsibilities:

  • Involved in analysis of teh Functional Specifications and Technical Specifications wif business objectives.
  • Worked on teh Data extracts, which load teh data from Warehouse to various Data marts.
  • Worked on Performance Tuning of Netezza/Teradata queries wif proper understanding of joins and Distribution.
  • Duties include (but not limited to), UNIX shell scripts and Performance tuning of ETL’s/SQL Queries.
  • Involved in loading files to tables using NZLOAD and extensively used NZSQL using teh Framework.
  • Extensively worked on teh implementation Slowly changing Dimensions(SCD’s).
  • Used SQL tools like TOAD to run SQL queries and validate teh data loaded into teh target tables.
  • Involved in migrating Netezza sql code to Teradata sql.
  • Involved in preparation of meeting materials and delivering of presentations as required.
  • Involved in code reviews and acceptance testing of teh application.
  • Involved in Migration and Production Support.
  • Solving day to day issues rose wif teh loading process.

Environment: Netezza V7.0, Unix shell scripts, Teradata 15, Teradata studio express, Tidal, Winscp, Erwin, Toad, and Agility Workbench for Netezza.

Confidential, Charlotte, NC

Senior DW Consultant

Responsibilities:

  • Generating reports for teh Federal Regulators about teh Bank’s Capital based on BASEL rules. dis project is using Informatica 9.5.2 as teh ETL Tool, and teh data mart is built on Netezza DataBase (Wif Striper Architecture Hardware). Data is sourced from Teradata Databases using TPT Utility in Informatica and loaded to Netezza using NZ Bulk Writer Utility.
  • Used Teradata Utilities like FastLoad, BTEQ and MLoad to load data
  • Teh project is also to modularize teh current system which is built in Teradata sql scripts to be converted to Netezza using Netezza ETL scripting and Informatica ETL.
  • Designed ETL architecture to bring different sources( files and DB tables) into common format and create input files for calculator from tan all teh steps are same even teh source system is different.
  • Involved in writing complex reporting view sqls needed for reporting team.
  • Also done design, performance improvement initiatives.

Environment: Informatica PowerCenter 9.5.2, Teradata, Netezza, Flat Files, Unix shell scripting, Tortoise SVN, Command Center and Version 1 scrum tool.

Confidential, Dayton, OH

Sr. ETL/Teradata Developer

Responsibilities:

  • Involved in loading data from SQL Server and file sources to teh Stage, Work and Core layers of teh ODS and EDW.
  • Involved in designing and developing dependent Data Marts to house data to support teh front end BI tool.
  • Involved in designing and developing ETL solutions to meet complex business requirements.
  • Worked closely wif teh Data Modelers to design data structures best suited for teh requirements.
  • Displayed great multitasking capability by working on multiple projects simultaneously while delivering timely results.
  • Worked closely wif teh Data Analysts, SQA’s and BI Developers to ensure accurate and timely delivery of solutions.
  • Utilized Informatica Pushdown Optimization (PDO) wherever necessary to ensure efficient performance of mappings.
  • Worked wif Temporal Table loading using BTEQS in Teradata.
  • Utilized Volatile Temporary tables to aid in data load processing.
  • Used TPT (Teradata Parallel Transporter) configured for Fastload and Mload to load data.
  • Utilized pre and post session command tasks to invoke BTEQ scripts to insert/update Audit tables.
  • Assisted SQA’s in using Informatica DVO (Data Validation Option) to test data loads.
  • Provide Production Support for data loads.
  • Utilized Tortoise SVN tool to maintain Enterprise-Wide versioning.
  • Created Run Books and Turnover documents for teh scheduling team to schedule jobs on Tidal.
  • Created Technical Design documents and Implementation Plans for migration of code to various environments.
  • Used teh SDE tool to implement and adhere to Change Management practices.

Confidential, Milwaukee, WI

Sr Teradata Developer

Responsibilities:

  • I was given Senior Terdata developer by teh client, which includes, involving in Business requirement discussion, understanding teh requirements from Business team, pass on teh requirements to offshore dev team and lead teh project from Design, Dev, Unit testing and Deployment. I is Single point of contact for all teh project I drive.
  • Participated in user meetings, gatheird Business requirements & specifications for teh Data-warehouse design. Translated teh user inputs into ETL design docs.
  • Understand teh business parameters dat could influence performance (data sizes, complexity, concurrent executions .. etc)
  • Responsible for implementing teh Informatica/Teradata CDC logic to Process teh delta data.
  • Involved in teh creation of Informatica mappings to extracting data from oracle,Sql server, Flat Files to load in to Stage area. Worked data mapping, data cleansing, program development for loads, and data verification of converted data to legacy data.
  • Designed and Created data cleansing, data conversion, validation and External loading scripts like TPT,MLOAD and FLOAD for Teradata warehouse using Informatica ETL tool.
  • Involved in error handling, performance tuning of mappings, testing of Stored Procedures and Functions, Testing of Informatica Sessions, and teh Target Data.
  • Experienced in loading data into Data Warehouse/Data Marts using Informatica, Teradata Multiload, Fast load and BTEQ utilities.
  • Extensively worked on indexes in Teradata and Creation of proper Primary Index (PI) talking into consideration of both planned access of data and even distribution of data across all teh available AMPS.
  • Worked wif DBA in making enhancements to physical DB schema. Also coordinated wif DBA in creating and managing table, indexes, table spaces, triggers, db links and privileges.
  • Responsible for SQL tuning and optimization using Analyze, Explain Plan and optimizer hints.
  • Testing and debugging of all ETL and Teradata objects in order to evaluate teh performance and to check whether teh code is meeting teh business requirement.
  • Owning all teh code migrations/reviews includes Informatica, unix shell scripts, DB objects and ESP migrations.
  • Carry out Defect Analysis and fixing of bugs raised by teh Users
  • Highly motivated wif teh ability to work TEMPeffectively in teams as well as independently

Environment: Informatica Power Center 8.6.1, Teradata,UNIX Shell Scripting, ESP Scheduling Tool.

Confidential, Hartford, CT

Responsibilities:

  • Participated in user meetings, gatheird Business requirements & specifications for teh Data-warehouse design. Translated teh user inputs into ETL design docs.
  • Involved in teh designing of teh Data Model in deriving Conceptual, Logical and Physical model’s using IBM rational wif Architect teams.
  • Responsible for completing source to target mappings which is input for Development and testing teams.
  • Design Confidential Pharmacy common claim format which feeds and supports teh Pharmacy adjucated claims data.
  • WPR review of all IA deliverables wif all teh consumers of teh project.
  • Architect support to multiple projects at teh same time
  • Responsibilities include coordinating and working wif resources from teh business, development, and database administration areas
  • To develop an information solution dat advances best practices wifin Information Architecture.
  • As an Information Architect, involved in gathering of data requirements through facilitated sessions or Use Cases, and designing data models based on those requirements.
  • Responsibility for reviewing wif and obtaining approval from teh project team of teh data model designing and building quality data models wifin defined standards.

Environment: IBM Info Sphere Data Architect and Windows XP

Confidential

Teradata developer

Responsibilities:

  • Participated in user meetings, gatheird Business requirements & specifications for teh Data-warehouse design. Translated teh user inputs into ETL design docs.
  • Involved in teh designing of teh Data Model in deriving Conceptual, Logical and Physical model’s using Erwin wif Architect teams.
  • Defined, and documented teh technical architecture of teh Data Warehouse, including teh physical components and their functionality.
  • Designed ETL architecture to Process large no of files and created High-level design, low-level design documents.
  • Perform data profiling using IDE ( Informatica data explorer).
  • Responsible for implementing teh Informatica CDC logic to Process teh delta data.
  • Extensively worked on flat files and involved in creation of UNIX shell scripts using different shell scripts for FTP, generating list files for loading multiple files and in archiving teh files after teh completion of loads.
  • Involved in teh creation of Informatica mappings to extracting data from oracle, Flat Files to load in to Stage area.
  • Worked data mapping, data cleansing, program development for loads, and data verification of converted data to legacy data.
  • Designed and Created data cleansing, data conversion, validation and External loading scripts like MLOAD and FLOAD for Teradata warehouse using Informatica ETL tool.
  • Involved in error handling, performance tuning of mappings, testing of Stored Procedures and Functions, Testing of Informatica Sessions, and teh Target Data.
  • Experienced in loading data into Data Warehouse/Data Marts using Informatica, Teradata Multiload, Fast load and BTEQ utilities.
  • Implemented operational data store framework between sources to target warehouse and new mechanism of interface table, which will integrate various types of sources.
  • Extensively worked on indexes in Teradata and Creation of proper Primary Index (PI) talking into consideration of both planned access of data and even distribution of data across all teh available AMPS.
  • Worked wif DBA in making enhancements to physical DB schema. Also coordinated wif DBA in creating and managing table, indexes, table spaces, triggers, db links and privileges.
  • Possess expertise wif relational database concepts, stored procedures, functions, triggers and scalability analysis.
  • Optimized teh SQL and PL/SQL queries by using different tuning techniques like using hints, parallel processing, and optimization rules.
  • Worked on performance tuning in oracle using indexes like bitmap and B tree indexes.
  • Responsible for SQL tuning and optimization using Analyze, Explain Plan and optimizer hints.
  • Extensively used TOAD to test, debug SQL and PL/SQL Scripts, procedures, triggers and functions.
  • Extensively worked on maintaining teh up to date statistics of teh tables by using explain plans.
  • Extensively worked in Skew Factor, resource usage of teh queries using query log data.
  • Loading data by using teh Teradata loader connection, writing Teradata utilities scripts (Fast load, Multiload) and working wif loader logs.
  • Scheduled workflows, BTEQ Scripts, UNIX shell scripts using WLM Scheduling tool.
  • Testing and debugging of all ETL and Teradata objects in order to evaluate teh performance and to check whether teh code is meeting teh business requirement.
  • Responsible for migrations of teh code from Development environment to QA and QA to Production.
  • Involved in teh clear case setup for CIS project and supporting code base linings for each move from DEV/SIT/UAT/RT/PROD.
  • Prepared teh validation scripts to compare teh new data wif legacy systems.
  • Carry out Defect Analysis and fixing of bugs raised by teh Users
  • Highly motivated wif teh ability to work TEMPeffectively in teams as well as independently

Environment: Informatica Power Center 8.6.1, Teradata, UNIX Shell Scripting and WLM Scheduling Tool.

Confidential - SanFrancisco, California

Senior Informatica/Unix Developer

Responsibilities:

  • Involved in analysis & Functional specification phase of teh project.
  • Played coordination role b/w onshore and offshore.
  • Involved in preparing teh LOE of teh project by estimating teh total ma hours required for every task & subtask
  • Coordinating wif teh client team on a daily basis for issues and status update.
  • Preparing teh detailed design or technical design of teh project phase by phase.
  • Often interacting wif teh client to discuss day-to-day matters, issues, design walkthroughs, change request implementations and its TEMPeffects.
  • Conducting technical design presentation to teh client and getting teh sign off.
  • Allocating modules to individual team members.
  • Coding of complex modules.
  • Implemented slowly changing dimensions (Type1 and Type2).
  • Code review of individual team members.
  • Involved in sql query fine-tuning and optimization process.
  • Filling teh defect tracker document
  • Review of unit test cases and signing off teh unit test case documents.
  • Integrating all teh modules and Played Quality analyst for teh key phases of teh project.
  • Implementing teh project, once teh project is signed off from QA.
  • Assisted Client operations team wif code migrations and operations monitoring tasks
  • Providing teh post production support for three successful runs.

Environment: Informatica 8.5.1, Erwin, Oracle 10g RAC, SQL, shell scripting

Confidential

Data Warehouse Developer

Responsibilities:

  • Representing teh Development team in sessions wif teh Business clients to provide inputs during requirement gathering phase.
  • Involved during teh analysis phase wif teh Analyst for preparing teh Functional requirements.
  • Conducting technical design presentation to teh client and getting teh sign off.
  • Allocating modules to individual team members.
  • Development of complex modules.
  • Audits queries are divided into various metrics such as comparator, datavalidator and trending.
  • Developed more than 3000 audit queries to ensure quality of teh data across various lines of business including Retail, Heloc, Home loans and card services.
  • Played teh role of SME reviewer for teh new resources in teh team.
  • Providing teh post production support for three successful runs.

Environment: Informatica Power Center 7.1.3, Oracle9i, SAS, UNIX Shell Scripting and Windows XP/Sun Solaris.

Confidential

Informatica Developer

Responsibilities:

  • Involved in data requirements gathering via: SQL data profiling of existing data sources and targets.
  • Coordinating wif teh client team on a daily basis for issues and status update.
  • Analyzing existing design and direct interaction wif client data services /List mangers and Confidential list design team.
  • Conducting technical design presentation to teh client and getting teh sign off.
  • Design and development of informatica ETL (data Extract, Transformation, and Load processes) and teh Matrix datamart DDL (oracle Data Definition Language code).
  • Prepare unit test scripts and signing off teh unit test case documents.
  • Involved in sql and ETL fine-tuning and optimization process.
  • Prepare deployment documents and other necessary scripts.
  • Also assisted Client operations team wif code migrations and operations monitoring tasks.
  • Providing teh post production support for three successful runs.

Environment: Informatica Power Center 6.1.1, Oracle9i, SAS, UNIX Shell Scripting and Windows XP/Sun Solaris.

We'd love your feedback!