We provide IT Staff Augmentation Services!

Etl Lead Resume

2.00/5 (Submit Your Rating)

PittsburgH

Hire Now

PROFESSIONAL SUMMARY:

  • Ten plus (10+) years of IT experience with Confidential Consultancy Services in the Analysis, Design, Development, Testing and Implementation of business application systems for Insurance (Property and Causality), Financial and Manufacturing Sectors.
  • Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications.
  • Strong Data Warehousing ETL experience of using Informatica 10.1/9.1/8.6/8.1 Power Center Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools Informatica Server, Repository Server manager using Oracle and Teradata (Teradata Professional Certified) as database.
  • Strong knowledge of OBIEE as a Business Intelligence tool and Business Objects (BO) as reporting tools.
  • Experience in RPD /Universe changes in the backend and can create reports/Dashboards through frontend reporting tools.
  • Worked extensively on OBIA 7964 version for Order Management, Service analytics and Siebel CRM Opportunity/ Quote OBIEE modules.
  • Experience in Oracle DAC to support the data loads for different OBIA modules.
  • Extensive knowledge in Design and integrating Oracle Apps AR, GL module, SAP, Siebel source system, DEMANTRA and Other ERP systems to data warehouse and to integrate multiple application through ETL using agile methodology.
  • Strong Experience in Performance tuning of SQL queries and ETL jobs.
  • Experience in using Automation Scheduling tools like Autosys and Control-M.
  • Extensive knowledge UNIX scripting.
  • Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburgh

ETL Lead

Technical Platform: Informatica Power Center, Unix, OBIEE, OBIA, Oracle

Responsibilities:

  • Integrate different ERP using agile methodology into OBIEE for better view of organization.
  • Onsite - offshore coordination.
  • Requirement gathering and handover to Offshore team, solution design.
  • Counter all the business related queries, proposals.

Confidential

Team Lead for ETL

Technical Platform: Informatica Power Center, Unix, Teradata

Responsibilities:

  • Impact analysis for the existing mappings or code.
  • Support for production ETL jobs and provide the solutions.
  • Testing during the upgradation of environment.
  • Change in the existing Informatica mapping as per the new requirement.
  • Tuning of Informatica mapping to increase the throughput.
  • Creation of new tables and views in Teradata database.
  • Creation of new Autosys jobs.

Confidential

Team Lead

Technical Platform: Informatica Power Center, Business Objects, Unix, Teradata, Oracle

Responsibilities:

  • Provide the solutions to the Business Queries
  • Data Load in Teradata and to the other applications
  • Administration of Informatica Power Center
  • Impact analysis for the new Projects on the existing components.
  • Enhancement of Universe through Business Objects.
  • Enhancements to the existing applications.

Confidential

Team Member

Technical Platform: Informatica Power Centre, DB2, UNIX

Responsibilities:

  • Extraction of data from multiple operational systems (policy, claims systems) and load to SDS( staging data store)
  • Analyze the existing business transactions
  • Develop the mappings through Informatica Power Centre
  • Impact analysis on existing mappings.
  • Building Data Marts from SDS

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship