Automation Architect - ETL Informatica

Company: Emonics, LLC
Location: Pleasanton
Posted on: May 16, 2023

Job Description:

-Title : Automation Architect - ETL Informatica
Location : Pleasanton, CA
Job Type : Fulltime


Job Description:

Experience required:

• 
  
• 8+ Years
  
  
  Job Descriptions :
  
  Analysis and Design Responsibilities
  
  
  • 
    
  • Assist in identifying entities, attributes, and relationships, define them in a complete and accurate form.
    
  • Prepare technical documents to identify work flows & data flows and source & destination mappings
    
    
    Development and Implementation Responsibilities
    
    
    • 
      
    • Develop ETL (Extraction, Transformation & Load) programs to load data marts and data warehouses.
      
    • 5+ years of experience in Development and Implementation of Data warehouse & BI solutions
      
    • 3+ years solid hands-on database development & SQL programming experience (stored procedures, triggers) using MS SQL Server, Oracle, and/or other databases
      
    • 2+ Experience in ETL Development using tools like Informatica,
      
    • Thorough knowledge and experience in Relational & Dimensional Data Models, OLAP, Star & Snow-flake schema and experience in developing data models using Erwin , MS-VISIO
      
    • Good knowledge and experience of data warehouse architecture, design principles, practices, systems development, & analysis
      
    • Experience in developing Reporting & Analytical solutions using tools like Business Objects, Cognos, etc.
      

Keywords: Emonics, LLC, Pleasanton , Automation Architect - ETL Informatica, Professions , Pleasanton, California