We provide IT Staff Augmentation Services!

Etl Development Lead Resume

Charlotte, NC

SUMMARY:

  • Around 9 years of IT experience in design, development and implementation of projects in Data Warehousing.
  • Extensive experience in working on databases like Netezza, Teradata and Oracle.
  • Strong knowledge in UNIX Shell Scripting and scheduling using CRONTAB.
  • Expertise in Netezza Architecture and database concepts like NZSQL, NZLoad, Zone Maps, CBT.
  • Good knowledge on Teradata architecture, SQL and data load/export utilities like BTEQ, Multi Load and Fast Export.
  • Completed the certification and obtained the title “TERADATA 12 CERTIFIED PROFESSIONAL” on the Basics of Teradata Architecture.
  • Involved in understanding and translating the business requirements to High Level and Low level design for implementation.
  • Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
  • Extensive experience in various projects across the Telecommunication domain.
  • Experience in performance tuning of SQL queries in Netezza and Teradata.
  • Multi environment working experience across platforms like UNIX and Windows.
  • Strong Knowledge in Relational Database Concepts, Entity Relation Diagrams, Normalization and Denormalization Concepts.
  • Completed Organization level certifications on .NET and Operating System (UNIX).
  • An excellent team player and team leader with an ability to perform individually with strong verbal, interpersonal, leadership and written communication skills.
  • Competent in the Global delivery model with effective co - ordination of the team to meet deadlines and deliverables on time.

TECHNICAL SKILLS:

Databases: Netezza, Teradata, Oracle 9i/10g

Tools: SQL*PLUS, TOAD, WinSQL, MS Office, Secure CRT, Putty, TIDAL,Quality Center, CITRIX, MS Visio, BMC Change/Remedy Management

Languages: C, C++, SQL, UNIX Shell Scripting

Versioning Tools: Tortoise SVN, WinCVS, SharePoint Server

Operating Systems: Windows 7/Vista/XP, UNIX

ETL: Informatica Power Center 9.x

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

ETL Development Lead

Responsibilities:

  • Developed and Implemented stored procedures to get the usage flat files to the Teradata environment and perform the data quality checks on the data.
  • Developed and Implemented the Viewership Fact and Several Dimensional tables using Hive and HDFS.
  • Exploring and understanding the use TALEND as a tool for creating and automating the run of Hive queries over Spark to load data.
  • Working closely to provide solutions to the day to day adhoc requests from business which help in their varied analytics on viewership data.
  • Performed Unit Testing and created Unit Test Case documents.
  • Managed the co-ordination and utilization of offshore developers.

Environment: Teradata, Hive, HDFS, WinSCP, UNIX, One Automation, SVN, HP ALM.

Confidential, Charlotte, NC

ETL Development Lead

Responsibilities:

  • Developed and implemented the automated data extracts over Legacy Confidential system for the Product Intelligence Team.
  • Developed and implemented the automated data extracts over the Legacy Bright House Networks system for the Product Intelligence Team.
  • Delivered adhoc requests for ETL changes on the Legacy Confidential data on the XBI Layer.
  • Performed Unit Testing and created Unit Test Case documents.
  • Managed the co-ordination and utilization of offshore developers.

Environment: Teradata, Netezza, Oracle, Toad for Oracle, WinSQL, UNIX, TIDAL, SVN, HP Quality Center.

Confidential, Charlotte, NC

ETL Development Lead/Technical Business Analyst

Responsibilities:

  • Subject Matter Expert contributing to the analysis and design sessions with business analysts to identify the requirement, design and specifications for the re-platforming of Digital Phone Project from Oracle to Netezza.
  • Prepared ETL design specification documents with information on implementation of business logic.
  • Created SQL’s to get usage data into the Netezza warehouse and perform reconciliation.
  • Created UNIX shell scripts to get history data from Source (Oracle) to Netezza (Target).
  • Improved performance of the Netezza SQL through review and query optimization.
  • Performed Unit Testing and created Unit Test Case documents
  • Automated the jobs using TIDAL Scheduler to handle daily volume.
  • Managed the co-ordination and utilization of offshore developers.

Environment: Netezza, Oracle, Toad for Oracle, WinSQL, UNIX, TIDAL, WinSQL, SVN, HP Quality Center.

Confidential, Charlotte, NC

ETL Development Lead/Technical Business Analyst

Responsibilities:

  • Subject Matter Expert contributing to the analysis and technical design sessions with business analysts to identify the requirement, design and specifications for the patch.
  • Prepared ETL design specification documents with information on implementation of business logic.
  • Created Netezza SQL’s to apply the business logics and handle varied scenarios in which the data had been corrupted.
  • Created UNIX shell scripts to get data from Source (Oracle) to Netezza (Target).
  • Created wrapper scripts in UNIX to run the patch in batches.
  • Improved performance of the Netezza SQL through review and query optimization.
  • Performed Unit Testing and created Unit Test Case documents.
  • Responsible for designing, developing and implementing the automation of the patch, full load and disaster recovery.
  • Automated the jobs using TIDAL Scheduler to handle daily volume.
  • Managed the co-ordination and utilization of offshore developers.

Environment: Netezza, Oracle, Toad for Oracle, WinSQL, UNIX, TIDAL, WinSQL, SVN, HP Quality Center.

Confidential

ETL Development Lead

Responsibilities:

  • Worked closely with various levels of individuals to coordinate and prioritize tasks. Estimate, schedule and track the day to day achievements.
  • Responsible for communication with the client and the management the offshore effort.
  • Creation of seeded records and loading the seeded records to the tables through specific scripts.
  • Develop and optimize the SQL queries based on the requirements.
  • Enhancements to the existing UNIX scripts and SQL’s.
  • Unit testing of the newly created SQL’s through scripts.
  • Creation of UTP’s, Test Results, Run book and Release Manuals for every development/enhancement.
  • Migration of the baselined scripts to Win CVS and Support for QA Testing

Environment: Netezza, Oracle, Toad for Oracle, WinSQL, UNIX, TIDAL, WinSQL, SVN, HP Quality Center.

Confidential

ETL Development Lead

Responsibilities:

  • Communication with the Client and Management of effort at offshore.
  • Creating the various design and flow documents.
  • Design and Review of developed UNIX shell scripts.
  • Creating DM Express Jobs for loading tables.
  • Unit testing and system integration of newly created scripts.

Environment: DM Express, Teradata, UNIX

Hire Now