ETL Informatica Developer

etl, informatica, powercenter, informatica data quality, t-sql, ssrs, ssis, ssas, power bi
Contract W2, 6 Months
Depends on Experience
Work from home not available Travel not required

Job Description

***We are unable to sponsor as this is a permanent full time role***

A prestigious company is on the search for an ETL Informatica Developer. This role will be contract to hire position. A degree is a necessary for this role. This role will be designing and developing enterprise and departmental BI and data warehousing solutions. A big responsibility will be designing and implementing ETL frameworks for complex data warehouse projects using Informatica PowerCenter or Informatica Data Quality. The dress code for this role is dress shirt and tie for men, dress or suite for woman.

Responsibilities

  • Design and develop enterprise and departmental business intelligence and data warehousing solutions.
  • Collaborate with project leads, business analysts, end users and third-party contacts to design, implement and test data warehouse applications.
  • Design and implement ETL processes in support of business analytics and reporting.
  • Develop and perform unit, system, performance and regression testing on ETL mappings.
  • Create source-to-target mapping specifications for ETL development.
  • Follow established coding standards, perform code reviews and improve standards to assure compliance.
  • Support and improve production data integration system and environment.

Minimum Requirements

  • Bachelor's degree in IT or related major.
  • 8+ years of data-related experience.
  • 5+ years of hands-on experience in design and implementation of ETL framework for complex data warehouse projects using Informatica PowerCenter or Informatica Data Quality (equivalent experiences in IBM DataStage are acceptable).
  • Strong analytical skills to troubleshoot issues and identify resolutions.
  • Available for off-business hours implementation and support.
  • Excellent knowledge of relational data modeling (ERD), SQL and data warehousing.
  • Experience in multiple database platforms, including SQL Server, Oracle and DB2.
  • Hands-on experience in writing complex T-SQL and database performance tuning.
  • Strong knowledge of Microsoft BI technology (SSRS, SSIS, SSAS and Power BI).

Posted By

Dillon Grooss

200 East 5th Ave., Suite 116 Naperville, IL, 60563

Contact
Dice Id : napil006
Position Id : 6312631
Originally Posted : 3 weeks ago
Have a Job? Post it

Similar Positions

Informatica ETL Developer
  • Request Technology, LLC
  • Kenosha, WI
ETL Informatica BDM
  • Dynamic Enterprise Solutions Inc
  • North Chicago, IL
ETL/Informatica Developer
  • Systegration/ACT Group
  • North Chicago, IL
SR Informatica Developer
  • TITAN TECHNOLOGIES
  • Pleasant Prairie, WI
Informatica Developer
  • Multivision Inc-IL
  • Northbrook, IL
Informatica Administrator
  • Computer Resource Solutions
  • Northbrook, IL
Informatica Admin
  • Net2Source Inc.
  • Franklin, WI
ETL Developer (multiple positions junior and senior)
  • Evolution Services, Inc.
  • Pleasant Prairie, WI
ETL Developer
  • Interactive Business Systems
  • Kenosha, WI
ETL Developer
  • First Tek, Inc.
  • Kenosha, WI
Sr. ETL Consultant (Talend/AWS)
  • System One
  • Highland Park, IL
ETL Developer
  • Reliable Software Resources
  • Racine, WI