Job Title: ETL Lead
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
Know what it’s like to work and grow at Brillio: https://www.brillio.com/join-us/
Equal Employment Opportunity Declaration
Brillio is an equal opportunity employer to all, regardless of age, ancestry, colour, disability (mental and physical), exercising the right to family care and medical leave, gender, gender expression, gender identity, genetic information, marital status, medical condition, military or veteran status, national origin, political affiliation, race, religious creed, sex (includes pregnancy, childbirth, breastfeeding, and related medical conditions), and sexual orientation.
#LI-CH1
Skills Required
- Extensive hands-on data warehouse design experience
- Experience with Informatica (IICS) and Informatica PowerCenter
- Experience with IDMC
- Expertise with Snowflake DWH architecture and optimization
- Strong SQL skills
- Ability to lead and guide teams
- Excellent communication and articulation skills
- Thorough understanding of dimensional modeling (dimensions and facts)
- Problem solver attitude and ability to work in ambiguous situations
- Understanding of Pharma domain with respect to life-science datasets (IQVIA, Komodo, Veeva)
- Good understanding and knowledge of Snowflake Cortex AI
- Build and lead solution charters in data engineering
- Ability to create first-cut architecture designs and handle technical details
- Proven execution skills across small to large programs
- Experience handling complex information and presenting via business presentations
- Ability to write and design technical business process documentation
- Excellent project management, relationship building and organizational skills
- Pharma domain experience
Brillio Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Brillio and has not been reviewed or approved by Brillio.
-
Healthcare Strength — Healthcare is considered comprehensive, including medical coverage for employees and dependents alongside life, disability, and accidental death protections. Feedback suggests these protections are a core strength of the package.
-
Leave & Time Off Breadth — Time-off options include paid leave and parental leave, with flexible or ‘flexible PTO’ approaches cited in some contexts. Feedback suggests this breadth helps support work-life balance when team norms permit usage.
-
Wellbeing & Lifestyle Benefits — Wellbeing offerings span counseling, financial-management sessions, fitness programs, and travel insurance, plus region-specific extras like discounted IT hardware and work-from-home essentials. Feedback suggests these add-ons enhance perceived value beyond core insurance.
Brillio Insights
What We Do
Brillio is the leader in global digital business transformation, applying technology with a human touch. We help businesses define internal and external transformation objectives, and translate those objectives into actionable market strategies using proprietary technologies. With 2600+ experts and 13 offices worldwide, Brillio is the ideal partner for enterprises that want to quickly increase their core business productivity, and achieve a competitive edge, with the latest digital solutions.
