ETL/Informatica Analyst/Developer

Data Warehousing, DB2, SQL, Hadoop, BDM, IICS, Informatica PowerCenter
Contract W2
Depends on Experience
Work from home not available Travel not required

Job Description

Job Description:
  • Design and implement industry best ETL technologies to satisfy client requirements
  • Design and develop optimal code to maintain exceptional performance in processing large volumes of data across diverse sources
  • Designs, develops, and tests ETL solutions including automating data loading processes
  • Communicates ideas to both technical and non-technical people in all levels of the organization
  • Effectively communicates technical architecture details of INFORMATICA and other parts of the BI solution to others
  • Identify and reuse of ETL components and services to avoid duplicative implementations
Academic/Experience/Competency:
  • BA/BS in computer science or equivalent training
  • Strong understanding and experience in implementing BI solutions and data warehousing using Informatica is required
  • Good understanding of Informatica 10.x BDM is required
  • Full comprehension of SQL, cardinality, levels of granularity, normalized vs de-normalized, handling of slowly changing dimensions, auditing and optimization techniques and other such best practices is required
  • Data Warehousing – 3-5 year(s)
  • Informatica – 5-7 year(s)
  • DB2/SQL Server – 3-5 year(s)
  • Unix Shell Scripting – 2-3 year(s)
Daily Tasks Performed:
  • Work with Data Architects to understand ETL requirements
  • Review and validate ETL specs
  • Design, Develop and Unit Test using Informatica
  • Perform code reviews/peer reviews
  • Document test results
  • Support SIT/UAT activities
  • Create scripts for automation and work with Operations to implement jobs
Wants:
  • Experience with Informatica PowerExchange (for VSAM files)
  • Informatica certification
  • Experience with Hive/Spark/HBase
  • Experience with Informatica BDM is a Plus
Unique Skill Sets Desired:
  • Strong Informatica PowerCenter Development experience
  • Strong Experience with Informatica Cloud (IICS)
  • Experience with Informatica BDM and Hadoop
  • Strong SQL Skills (DB2 and SQL Server)
  • Good understanding of Data Warehousing and BI concepts
  • Strong communication skills
Dice Id : 10111421
Position Id : AME17513
Have a Job? Post it

Similar Positions

Informatica/ETL Developer
  • Calance
  • Torrance, CA
Informatica Developer
  • iSpace, Inc
  • Burbank, CA
ETL Informatica Developer
  • IT Solutions
  • Burbank, CA
Senior Informatica ETL Consultant
  • Everest Technologies
  • Torrance, CA
Informatica Developer
  • Sharp Decisions
  • Torrance, CA
Informatica Cloud Developer
  • Farmers Insurance
  • Woodland Hills, CA
Informatica/ETL Developer (Big Data)
  • Tentek, Inc.
  • Torrance, CA
Informatica Developer/Tech Lead
  • Sysmind, LLC
  • Woodland Hills, CA
ETL Developer & Informatica
  • Trinus Corporation
  • Glendale, California
Talend informatica developer
  • Xebia US
  • Santa Monica, CA
MDM Informatica Developer
  • Solugenix Corporation
  • Los Angeles, CA
Informatica ETL admin
  • Enterprise Solutions
  • Los Angeles, CA
ETL Developer
  • LegalZoom.com, Inc.
  • Glendale, CA
MDM Informatica Developer
  • Cygnus Professionals
  • L A, California
SR. ETL Developer
  • PrimaSolv
  • Los Angeles, CA