ETL Lead Developer

Prophecy Technologies

$112K — $135K *
Pharmaceuticals & Biotech
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • 5-7 years of experience in ETL development with a strong focus on data warehousing.
  • Expertise in Informatica tools (PowerCenter and IICS) and SQL.
  • Proficient in Snowflake architecture and optimization.
  • Experience in the pharma domain with familiarity with datasets from IQVIA, Komodo, and VEEVA.
  • Demonstrated leadership skills and ability to guide teams in challenging situations.

Responsibilities

  • Lead the design and implementation of data warehouse solutions.
  • Utilize Informatica skills to solve complex data integration issues.
  • Guide and mentor team members through technical challenges.
  • Communicate effectively with business and technical stakeholders.
  • Develop architecture designs for data engineering projects.
  • Present complex information clearly to diverse audiences.
  • Manage and document technical business processes.

Benefits

  • Hybrid work model (4 days on-site in Plainsboro, NJ).
  • Opportunities for professional development and training.
  • Supportive team culture with emphasis on collaboration.
  • Exposure to innovative technologies in data management.
  • Potential for career advancement within the company.
Full Job Description
Job Title: ETL Lead Developer

Location: Hybrid - Plainsboro NJ - 4Days

Primary Skills: IICS, IDMC, Snowflake, SQL

Key responsibilities :

* Extensive Hands-on in data warehouse designing

* Hands on in Informatica skills with excellent problem solving capability.

* Ability to lead the team and guide them through difficult situations.

* Excellent communication and articulation skills.

* Presentable skills to Business and technical teams.

* Through understanding for dimension and facts.

* Need to have a Problem solver attitude.

* Understanding of Pharma domain with respect to Life Science datasets from IQVIA, Komodo, VEEVA tool sets

* Expertise with Snowflake DWH in terms of architecture and optimization

* Experience with Informatica Power center and IICS

* Strong business communication Good understanding and knowledge one Snowflake Cortex AI

* Good to have Pharma domain experience.

* Build and lead solution charter in areas of data engineering

* Comfortable with technical details like building first cut architecture design

* Razor sharp skills on execution of small to large programs

* Ability to work in ambiguous situations with unstructured problems and anticipate potential issues/risks

* Experience in handling complex information and presenting it in compelling narratives through business presentations for various audiences

* Professional agility and strategic thinking

* Ability to write and design technical business process documentation

* Excellent project management, relationship building and organizational skills

Similar Jobs

More Jobs at Prophecy Technologies

More Pharmaceuticals & Biotech Jobs

Find similar ETL Lead Developer jobs: