We provide IT Staff Augmentation Services!

Etl Consultant Resume

5.00/5 (Submit Your Rating)

San Jose, CA

TECHNICAL SKILLS:

Programming Languages: UNIX Shell Scripting, SQL.

Database Used: Teradata 14, Oracle

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

Software Tools/Framework: GIT, UC4 scheduler, Teradata SQL Assistant, Toad, Oracle SQL Developer, Putty, WinSCP

Operating Systems: UNIX, Linux, MS Windows NT/2000

S/W Methodologies: Agile, Waterfall models.

WORK EXPERIENCE:

Confidential, San Jose, CA

ETL Consultant

Responsibilities:

  • Experience in Data warehousing, Concepts, Data Profiling, Data Mining, ETL process and Business Intelligence.
  • Experience working in Credit data warehouse and involved in the ETL development for PPPWC ( Confidential working capital) application, developed data models for Application, Eligibility & Decision, Account, Contract, Loan & Repayments data from different DB's to DWH as a single source of truth for downstream users.
  • Primarily responsible for gathering requirements, Data Analysis and developing Extraction, Transformation and loading process using ETL Tool Informatica.
  • Developed new business modules and SQL queries to implement business rules and logics on ETL for the credit database.
  • Developed SQL queries to load the merchant credit data available from different sources to Data Integration layer.
  • Developed Informatica mappings to load the data from Credit database (Oracle) to warehouse.
  • Developed Informatica mappings and workflows to implement business rules and brings the data from OLTP system to Data Warehouse.
  • Used Debugger for validate mappings and for gaining troubleshooting information about data by inserting Breakpoints.
  • Strong understanding of Data Modeling (Relational, dimensional, Star and Snowflake Schema), Data analysis, implementations of Data warehousing using Windows and UNIX.
  • Involved in Optimizing the Queries and mappings to have Optimum Performance and reduce the bottlenecks.
  • Performed Unit Testing, Functional Testing, End to End testing.
  • Developed UNIX shells scripts to handle various activities of ETL process to automate the entire procedures from Source system to Target System.
  • Taking care of the production push and project handover documents to operations team and help them understand the project and support the production jobs.
  • Provide production support for the deployed project in case of production failures.

Technology stack: Informatica Power Center 9.x, Teradata, Oracle, Shell Scripting, UNIX, UC4 Scheduler, GIT.

Confidential, Waltham, MA

ETL Consultant

Responsibilities:

  • Developed new business modules and SQL queries to implement business rules and logics on ETL.
  • Involved in End - to-End Software Development Life cycle process from Requirement Gathering to Development, Testing, Deployment and Documentation.
  • Extraction of data from various sources using Informatica as ETL tool.
  • Developed mappings, created tasks, sessions and workflows.
  • Worked on Informatica Power Center tool for data conversion from variety of source systems. Dealt with various transformation logic like Lookup, Aggregator, Joiner, Source Qualifier, Router, Expression, Update Strategy, Filter and more while designing and developing complex mappings and mapplets.
  • Developed unit test cases and did End to End testing.
  • Developed Unix Scripts to automate the Jobs.
  • Developed Adhoc SQL queries for retrieving the data based on the end user requirements.

Technology stack: Informatica Power Center 8.x/9.x, Oracle, Shell Scripting, UNIX.

Confidential

ETL Developer

Responsibilities:

  • Involved in gathering requirements, Data Analysis and developing Extraction, Transformation and loading process using ETL Tool Informatica.
  • Developed new business modules and SQL queries to implement business rules and logics on ETL for the sales data.
  • Developed unit test cases and did End to End testing.
  • Developed Unix Scripts to automate the Jobs.
  • Developed Adhoc SQL queries for retrieving the sales data based on the end user requirements.

Technology stack: Oracle, Informatica, Shell Scripting, UNIX.

Confidential

ETL Developer

Responsibilities:

  • Involved in design and development of data warehouse environment, for business users and/or technical teams gathering requirement specification documents and presenting and identifying data sources, targets and report generation.
  • Worked on Informatica Power Center 8.6/9.0 tool - Source Analyzer, warehouse designer, Mapping Designer, Workflow Manager, Mapplets, and Reusable Transformations.
  • Using Informatica Designer Designed Mappings, which populated the Data into the Target Star Schema
  • Extensively used Router, Lookup, Aggregator, Expression and Update Strategy Transformations.
  • Translation of Business processes into Informatica mappings for building Data marts.
  • Involved in the Migration process from Development, Test and Production Environments.
  • Used SQL tools like SQL Developer to run SQL queries and validate the data.

Technology Stack: Informatica Power center 8.6/9.0, SQL Server 2008, Oracle 10g, UNIX Shell Scripting, Crontab.

We'd love your feedback!