We provide IT Staff Augmentation Services!

Senior Etl Consultant Resume

4.00/5 (Submit Your Rating)

New, YorK

SUMMARY:

  • Accomplished IT executive with extensive experience driving results and successfully supporting projects incorporating an extensive knowledge of all operational procedures, leading IT solutions through all phases of technology rollout. Dedicated Analyst with a demonstrated track record of leading tactical planning, scheduling and project prioritization strategies for high profile initiatives, with focused experience in the areas of business intelligence, Data analysis, and reporting.
  • Senior ETL Developer with over 10 Years of experience in Software Development Life Cycle (SDLC) within the design, coding, testing, development, and implementation of data warehouse/data mart under Unix and Windows Environments. Advanced knowledge and excellent concepts in the development and design of ETL methodology for supporting data transformations and processing ETL solutions.
  • Professional with extensive experience in Implementation of Enterprise Data warehousing projects and administration of Teradata, performance monitoring/tuning of Teradata, Teradata RDBMS internals and Data Warehousing model and concepts.
  • Excel in business process improvement analysis, as well as data analyses to identify problem root cause and resolution requirements. Extremely reliable, possessing a strong work ethic, willing and able to function in any role necessary to ensure project success.

TECHNICAL SKILLS:

OS Platforms: Windows 2000/XP/7/2003, SUSE Linux 10, 11 & UNIX MPRAS Sys V, HP - UX and Linux, AWS

Database Platforms: Teradata V2R5/R13.10/R14/R14.10/R15.0/R15.10 and Oracle

Programming Languages: C, C++, Java, Korn Shell Programming, SQL, PL/SQL, Python, Pro *C, Expect

Big Data: Teradata Aster, Hadoop, Pig, Hive, Sqoop, flume, kafka, oozie and Spark

ETL tools: Informatica9.6

Load Utilities: Multi load, Fast load, Fast Export, TPump and TPT

Debuggers: GDB, Windbg

Tools: BTEQ, Viewpoint, SQL Assistant, TD Administrator, CNStool, Index wizard, Checktable, Vprocmanager, Ferret, Filer, TSET, DBQL, PDCR, GNU s make, Arc/Restore, Teradata workload manager, Unity, Teradata workload designer, Autosys, Tivoli

PROFESSIONAL EXPERIENCE:

Confidential, New York

Senior ETL Consultant

Responsibilities:

  • Directed and actively supported the data warehouse platform to develop and establish strong business objectives. Worked on Positions and Gain and Loss module. Collected requirements from Financial Operation team and prepared designing documents for the same. Implemented the ELT approach using different stored procedures in Teradata and debugged stored procedures when the need arose.
  • Spearheaded the implementation of Physical modeling on Teradata such as the creation of a database, tables, indexes, views, normalization for the module.
  • Successfully set up Informatica environment for Gain and Loss module.
  • Designed an architecture for loading and exporting 100millions of records from Confidential to Gains Keeper daily.
  • Implemented workflows in Informatica for transforming the data and exporting data from Teradata to an external environment such as Gains Keeper.

Confidential, New York

Senior ETL Consultant

Responsibilities:

  • Successfully worked on Gain and Loss module in Fixed Income and Equities. Analyzed historical transactional data (1 PETABYTE of data) and generated reports for different IRS gap analysis defects. Developed stored procedures, workflows in the Dev environment and deployed the same in QA, UAT and Production environment.
  • Implemented Physical modeling on Teradata such as the creation of tables, indexes, views, for different historical reports.
  • Enhanced existing Stored Procedures according to requirements received from Financial Operation team.
  • Prepared TPT fast load scripts to upload historical data into Teradata Environment.

Confidential, New York

Senior ETL Consultant

Responsibilities:

  • Provided data warehousing architecture by writing SQL query code based on detail requirements provided. Analyzed PDCR data and generated regular reports, monitor application performance, adjust workload management and space management. Collaborated with a cross-functional team in the Development and Evaluation of ETL scripts and made recommendations as and when required.
  • Implemented Multi Value Compression (MVC), Block level Compression (BLC), PPI and SoftRI features on the data warehouse. Resulted in around 25% space savings and 25-30% of performance improvement.
  • Developed and maintained scripts using Teradata utilities like Multiload (MLoad), Fastload, BTEQ, TPT and TPUMP for the new and existing data marts to feed the Data Warehouse.
  • Identified and analyzed the long-running queries by analyzing DBQL table’s data and fixed many those queries using query tuning techniques.

We'd love your feedback!