ETL / Informatica Technical Lead

Informatica, ETL, Informatica PowerCenter, Informatica administration, Installation
Full Time
$120,000 - $140,000
Work from home available

Job Description

Fortune 500 professional services company is seeking a highly accomplished ETL / Informatica Technical Lead with PowerCenter, BDM and EDC experience

 Position will be hybrid in/out of the office post pandemic and can be based in either Jersey City, NJ or Austin, TX.

ETL / Informatica Technical Lead

 What can you expect?

  • Recognition – global career advancement opportunities
  • Accountability – accountability and ownership of Solution Delivery of BI Solutions
  • Career Growth – excellent performance is recognized by career mobility
  • Design and implement complex reporting dashboards for visualization of key company metrics, models, and other essential datasets
  • Work in End to End of enterprise BI Team which works on the entire BI landscape
  • Completely hands-on role which would involve wearing different hats include that of a Data Architect, Solution Designer, Technical Lead, Delivery Lead, Support Lead, etc for the DWH Solution Team.

What is in it for you?

  • Exposure to GIT Executive level leadership
  • Drive strategy / implementation of latest ETL Technologies

We will count on you to:

  • Supporting Production, QA and development of Informatica Data Quality, Informatica PowerCenter and DEI 10.x environments
  • Administration of Informatica and prior experience installing, upgrading and supporting environments
  • Outlining best practices for Informatica repository usage, security controls, version control, code migration, and scripting, logging, and other development and deployment procedures
  • Troubleshooting during system downtime to restore service (working with vendor if necessary), determining root cause and establishing procedures to avoid recurrence

What you need to have: 

  • Minimum of Bachelor’s degree, ideally in Computer Science or related field.
  • 5+ years of hands-on experience with Informatica administration, installation and configuration in Linux environments with Informatica 10.2 , IDQ and Address doctor, EDC and BDM is a must
  • Strong experience in installation and configuration of third-party libraries
  • Expertise in SQL and Informatica ETL mapping design and development, follows best practices for coding and performance tuning and iterative development approach is a must
  • Strong understanding and exposure on Data warehousing concepts.
  • End to End production support experience and good knowledge of ITIL concepts
  • Experience managing Data Warehousing and BI Projects
  • Have strong technical experience on Data Architecture, Data Modelling, Data Warehouse Concepts, Informatica, SQL, Query Tuning
  • Experience designing of optimal BI solutions from Database, Data Warehousing and BI Reporting perspectives
  • Technical skills in database and scripting (PL/SQL, Oracle, SQL and Stored Procedures)
  • Understand the logical mapping and data models provided and design and develop ETL mappings as per available patterns.
  • Experience in Oracle, Mongo, Postgres database is a plus
  • Knowledge / exposure to Business Objects as Reporting Tool will be a plus
  • Knowledge / exposure to SSIS will be a plus
  • Ability to multitask and liaise with multiple stakeholders
  • Ability to identify process improvement opportunities
  • Ability to understand the big picture to work with the Architects and granular hands-on experience to work with the team
  • Ability to review and provide feedback for complex applications.
  • Proven experience working in onsite and offshore environment on major delivery programs.
  • Knowledge of all phases of SDLC and full lifecycle implementations.
  • Exposure to Business Intelligence Technologies like Analytics Tools and Data Warehouse
  • Exposure to industry architecture and experience with design patterns
  • Exposure to Cloud Technologies a big plus

 What makes you stand out?

 Experience in transitioning BI/ETL Technologies from On-prem to Hybrid / Cloud environments

Dice Id : emtekny
Position Id : edetladminlead
Originally Posted : 3 months ago
Have a Job? Post it