Etl Informatica Developer

Etl Informatica Developer

Software Guidance & Assistance

Etl Informatica Developer

Details of the offer

Software Guidance & Assistance, Inc., (SGA), is searching for an ETL Developer for a Contract assignment with one of our premier Financial Services clients in San Francisco, CA.

Develop software from user requirements
Solution Architecture
Data modeling
High-Level data movement (staging and processing)
Research data sources Profile/Analyze source data
Staging and Dimensional table creation Security modeling
Develop ETL
Code, in the ETL tool, the extraction, transformation, and loading of data from source systems to the data warehouse
Create OLAP data Cubes
Implement user interface design using style sheets and gifs as provided by creative design from Analyst
Translate creative design into code
Work with Analyst Role as needed for Preliminary Use Cases
Expand/Implement Requirements
o Create prototypes
o Code software following standard design patterns.

Required Skills:
Data Warehouse Developer 5 to 9+ years of experience developing and supporting moderate to complex data warehouses or data marts
Strong Experience in Installing and/or Upgrading Informatica
ETL Tools (Informatica, MS SQL Server DTS, etc.)
Data Modeling - Dimensional and Normalized Relational; SQL (MS SQL Server, Oracle, etc.)
Business Intelligence Tool (Business Objects, Tableau, Microstrategy, JasperSoft)
OLAP & Data Mining
Operating System Environment basic knowledge (Windows, Unix, etc.)
HTML; JavaScript; Python; Spark, Hive, SQL and other Hadoop framework components
Flume-Kafka integration; AWS Cloud; experience in Informatica Data Quality (IDQ).
SGA is a Certified Women's Business Enterprise (WBE) celebrating over thirty years of service to our national client base for both permanent placement and consulting opportunities. For consulting positions, we offer a variety of benefit options including but not limited to health & dental insurance, paid vacation, timely payment via direct deposit. SGA accepts transfers of H1 sponsorship for most contracting roles. We are unable to sponsor for Right-to-Hire, Fulltime, or Government roles. All parties authorized to work in the US are encouraged to apply for all roles. Only those authorized to work for government entities will be considered for government roles. Please inquire about our referral program if you would like to submit a candidate for any of our open or future job opportunities. SGA is an EEO employer. We encourage Veterans to apply. To view all of our available job postings and/or to learn more about SGA please visit us online at



  • Basic
  • SQL

Microstrategy specialist

The Microstrategy Specialist will need to have strong technical BA experience as he/she will articulate what is built and be able to define remapping...

North Carolina

Published a month ago

Data analyst

We are seeking to add a data analyst to our team About IPIX IPIX Corporation manufactures and markets video surveillance equipment. The Company produces 36...


Published a month ago

Data analyst

We are seeking to add a data analyst to our team We are seeking to add a data analyst to our team; this professional should have a strategic mind and a complete...


Published a month ago

Managing director, scalability & integration

Your Opportunity Our main goal here at Schwab is to transform people's lives by changing the way the world invests. Schwab is recruiting to hire a results...

From Charles Schwab & Co., Inc. - Texas

Published a month ago