Skip to content

 

Torrance, California - USD Full Time Posted: Thursday, 11 July 2019
 
 
Job Description

Job Title: ETL/Informatica Analyst/Developer
Requisition ID: 17513
Department: Enterprise Platform Services
Location: Torrance, CA
Position Type: Contract(Long Term)

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.

Business Experience
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

Company Description TechLink Systems is a privately held IT Consulting Firm that provides Consulting Services to organizations nationwide. TechLink Systems is a certified MWOBE and has been in business since 1998. Our network spans all major U.S. metropolitan areas touched by major sectors such as entertainment and leisure, finance, industry and government, health sciences, and information technology. Whether you are a client seeking IT services and support or a candidate searching for new opportunities, TechLink System's outstanding customer service and dedication will exceed your expectations in the marketplace! TechLink has 4 regional offices located in San Francisco, Los Angeles, New York City, Philadelphia and a Development Center in Bangalore, India.

Awards:
-Ranked Top 500 Asian-Owned & Asian Pacific American-Owned Businesses in the US -Ranked Top 100 Diversity-Owned & Privately-Owned Businesses in California -Ranked INC500 Fastest Growing Private Companies -Ranked Top 100 Largest Women Owned Business San Francisco Business Times -Ranked 50 Largest Minority-Owned Companies San Francisco Business Times - Ranked in Top 100 Woman Owned Business in the US, Diversity Business -Ranked in the Top 10 Minority-Owned Businesses in the Philadelphia Business Journal -Ranked in the Top 50 Woman-Owned Businesses in the 2014 Philadelphia Business Journal

Torrance, California, United States of America
IT
USD
Techlink Systems
Techlink Systems
JS7BBB7D91/731298693
7/11/2019 6:01:20 PM

We strongly recommend that you should never provide your bank account details to an advertiser during the job application process. Should you receive a request of this nature please contact support giving the advertiser's name and job reference.

Other jobs like this

Los Angeles, California
USD
Long Beach, California
USD
Glendale, California
USD
Torrance, California
USD
Universal City, California
USD
See more