Informatica SSIS ETL Developer

ETL Developer / PowerBI
Full Time
Depends on Experience
Travel not required

Job Description

***This is a 6 month CTH role, no 3rd party candidates and no sponsorship is available***

Prestigious Enterprise Company is currently seeking an Informatica and SSIS ETL Developer with PowerBI experience. Candidate will design and develop enterprise and departmental business intelligence and data warehousing solutions.

Responsibilities:

  • 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.
  • Provide technical and business knowledge support to the team.
  • Ensure effective communication of user requirements.

Qualifications:

  • 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).
Dice Id : napil006
Position Id : CJ-ETLw
Originally Posted : 1 year ago
Have a Job? Post it

Similar Positions

Senior Data Warehouse Developer
  • Request Technology, LLC
  • Pleasant Prairie, WI