We provide IT Staff Augmentation Services!

Data Engineer Resume

Plano, TX

SUMMARY

  • IT Professional extensive experience on Data platforms and data integration.
  • Over 9 years of Working experience in all the phases of the Data engineering life cycle involving Design, Development, Testing and production release.
  • Excellent experience with Online Analytical Processing tools (OLAP) like Informatica, designing Data Marts and Data Warehouse using Star Schema and Snowflake Schema in implementing Decision Support Systems, fact and dimension tables modeling of data at all the three levels: view, logical and physical.
  • Experience working in Agile Methodology and the scrum process.
  • Hands on with Teradata and performance tuning of ETL loads using Teradata parallel transporter (TPT).
  • Worked on various Teradata utilities such as TPUMP, BTEQ scripts, Multiload, Fast Load to load data
  • Working experience in creating various analytical reports using Busin2
  • Responsible for interacting with business partners to identify information needs and business requirements for Reports.
  • Experience working on Dual Shore model. Coordinating with offshore teams on day - to-day activities and transitioning the knowledge for quality deliverable to the end users.
  • Strong experience with PL/SQL including stored procedures, packages, SQL tuning.
  • Very strong mix of Academic and Professional experience in the related area, demonstrated through the implementation of successful projects and diverse roles, recognized Team player with the ability to perform well in a group or individually and can cope well in a high intensity work environment, excellent interaction/communication skills.

TECHNICAL SKILLS

Databases: Teradata, Oracle 11g

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

Data Modeling: Star-Schema and Snowflake Modeling

Languages: Oracle PL/SQL, SAS

Tools: Toad 9.6.1, SQL*Plus, WS FTP Pro, SQL Assistant

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

Data Engineer

Responsibilities:

  • Review & analyze the Requirements, define data flows, design the approach to meet the required functionality and authoring the technical design document.
  • The technology lead & first point of contact for Business partners
  • Proactively identifying opportunities for improving efficiency & attaining stability within the production environment.
  • Build ETL and database scripts to automate the data ingestion, data processing and data delivery to downstream consuming applications
  • Define test plan, review test cases, monitor the execution and validate / approve the results.
  • DevelopedETL programs using Informatica Power center to implement the business requirements.
  • Involved inEnhancing existing Production informatica objects for change or additional requirements and pushing it back to production after successful QA testing.
  • Expertise in usingTeradata Utilities BTEQ, M-Load, F-Load, TPT n combination with Informatica for better Load in to Teradata Ware House.
  • Implemented & followed organization levelInformatica best Standards & Procedures.
  • Tuned theperformance of mappings by following Informatica best practicesand also applied several methods to get best performance by decreasing the run time of workflows.
  • Implemented & followed organization levelInformatica best Standards & Procedures.
  • Manage Production Release process
  • Co-ordination with all the technology and business stakeholders and ensure the application is up & running

Confidential, Allen, TX

Sr. ETL Developer

Responsibilities:

  • Understanding the Requirement Specifications, preparing the Functional and technical design documents.
  • Written documentation to describe program development, logic, coding, testing, changes and corrections, optimized the mappings by changing the logic and reduced running time.
  • Included error-handling and exception handling by logging in the error tables and sending an alert message via e-mail to the concerned distributions list.
  • Created different transformations for applying the key business rules and functionalities on the source data.
  • Involved in performance tuning of sources, targets, mappings, and sessions. Also involved in tuning of SQL queries and PL/SQL procedures.
  • Extensively used Debugger to identify data transfer problems in mappings.
  • Analyzing long running SQL's and tuning them.
  • Developing test plan and scripts, conducting testing, and dealing with business partners to conduct end-user acceptance testing.
  • Worked on integration testing of all the modules and preparation of test plans
  • Ensuring that all production changes are processed according to release management policies and procedures.
  • Involved in performance tuning of ETL loads using Teradata parallel transporter.
  • Worked on various tickets and monthly release.

Confidential, Mountain View, CA

ETL Developer

Responsibilities:

  • Understanding the Requirement Specifications, preparing the Functional and technical design documents.
  • Written documentation to describe program development, logic, coding, testing, changes and corrections, optimized the mappings by changing the logic and reduced running time.
  • Included error-handling and exception handling by logging in the error tables and sending an alert message via e-mail to the concerned distributions list.
  • Extensively used Debugger to identify data transfer problems in mappings.
  • Analyzing long running SQL's and tuning them.
  • Developing test plan and scripts, conducting testing, and dealing with business partners to conduct end-user acceptance testing.
  • Worked on integration testing of all the modules and preparation of test plans
  • Ensuring that all production changes are processed according to release management policies and procedures.
  • Involved in performance tuning of ETL loads using Teradata parallel transporter.
  • Worked on various tickets and monthly release.
  • Good knowledge on Agile Methodology and the scrum process.

Hire Now