Brillio · 2 days ago
Informatica Lead/ Architect - R01528895
Plainsboro, NJ
Full-time
Onsite
Senior Level, Lead/Staff
$150K/yr - $170K/yr
8+ years expBrillio is a rapidly growing digital technology service provider known for its exceptional professionals and commitment to client satisfaction. They are seeking a highly skilled Lead Data Engineer to lead data integration initiatives within their Life Science practice, focusing on data warehousing and Informatica solutions.
AnalyticsArtificial Intelligence (AI)Big DataCloud ComputingConsultingEnterprise ApplicationsMachine LearningMobile
Responsibilities
Lead the design, development, and optimization of ETL workflows using Informatica PowerCenter and IICS
Architect high-performance, scalable solutions on Snowflake Data Warehouse
Design robust data models with strong understanding of facts and dimensions
Act as a strategic advisor to business stakeholders, using data to drive insights and business outcomes
Partner with line-of-business leaders to identify and prioritize opportunities where data engineering can deliver measurable value
Lead a team of data engineers through complex integration efforts with a problem-solving attitude
Translate unstructured problems into structured, scalable data solutions
Deliver high-quality business presentations and solution documentation tailored to technical and executive audiences
Ensure alignment between technical delivery and business value realization
Optimize performance through effective data modeling, partitioning, and indexing
Lead data migration and integration projects to move legacy data systems to Snowflake
Collaborate with business analysts, data engineers, and stakeholders to define requirements and deliver data solutions
Qualification
Required
8+ years of experience in data engineering and ETL, with hands-on expertise in Informatica (PowerCenter and IICS)
Advanced SQL skills and experience with performance tuning
Proven experience designing and optimizing solutions in Snowflake
Strong foundation in data warehouse design, with a focus on dimensional modeling
Exceptional communication and stakeholder engagement skills
Demonstrated consultative mindset, capable of influencing and leading cross-functional discussions on data-driven value generation
Experience writing business process and technical documentation
Strong project management, organization, and team leadership skills
Ability to work in fast-paced environments with ambiguity and shifting priorities
Preferred
Prior experience in pharma domain with exposure to IQVIA, Komodo, and VEEVA datasets – strongly preferred
SnowPro certification is highly desirable
Company
Brillio
Brillio is a technology consulting and technology services company focused on the implementation of digital technologies.
5001-10000 employees
H1B Sponsorship
Brillio has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (258)
2024 (240)
2023 (281)
2022 (314)
2021 (196)
2020 (406)
Funding
Current Stage
Late StageTotal Funding
unknownKey Investors
The Orogen Group
2023-09-05Private Equity
2019-01-14Acquired
Leadership Team
Raj Mamodia
Chairman, Founder & CEO
Santosh Padmanabhan
Architect
Recent News
Canada NewsWire
2026-01-14
Financial Express
2025-03-21
Company data provided by crunchbase