The Role
Lead and manage ETL team to design, develop, and optimize ETL workflows using Informatica PowerCenter and IICS. Work with stakeholders to gather requirements, ensure data quality, perform advanced SQL-based extraction/transformation, optimize ETL (pushdown), troubleshoot errors, coordinate deployments, and mentor the team. Snowflake and shell scripting experience required; Python is a plus.
Summary Generated by Built In
Senior Data Specialist
Primary Skills
- About Brillio:
- Lead and manage a team of ETL developers and deliver high-quality deliverables
- Collaborate with business and technical stakeholders to gather requirements and translate them into technical specifications
- Hands-on expertise in Advanced SQL for data extraction, transformation, and validation tasks
- Strong understanding of Data Warehousing concepts.
- Experience working with Snowflake for building and managing cloud-based data platforms
- Design, develop, and optimize ETL workflows using Informatica Intelligent Cloud Services (IICS)
- Ensure data quality, performance tuning, and best practices in ETL processes
- Provide technical guidance, mentoring, and code reviews for the ETL team
- Manage task prioritization, timelines, and issue resolution in a fast-paced environment
- Coordinate deployments and support activities across development, QA, and production environments
- Having Python Knowledge is a plus #LI-PT1
Brillio is one of the fastest growing digital technology service providers and a partner of choice for many Fortune 1000 companies seeking to turn disruption into a competitive advantage through innovative digital adoption. Brillio, renowned for its world-class professionals, referred to as "Brillians", distinguishes itself through their capacity to seamlessly integrate cutting-edge digital and design thinking skills with an unwavering dedication to client satisfaction.
Brillio takes pride in its status as an employer of choice, consistently attracting the most exceptional and talented individuals due to its unwavering emphasis on contemporary, groundbreaking technologies, and exclusive digital projects. Brillio's relentless commitment to providing an exceptional experience to its Brillians and nurturing their full potential consistently garners them the Great Place to Work® certification year after year.
Specialization
- ETL Specialization: Data Specialist
Job requirements
- Role – Data Specialist Years of Experience –10+ years Strong hands-on in Informatica Advanced SQL , PowerCenter ,and IICS Strong knowledge on Data model, Data warehouse, Worked in ETL job optimization techniques(mainly Pushdown optimization) Worked on ETL error troubleshooting. Worked on Shell script. Worked on Snowflake. Expertise on SQL / Advanced SQL queries. A good team player/lead and quick learner Python knowledge is added advantage Tech skills – Informatica Power Center, IICS, Snowflake, Advanced SQL, Shell Scripting
Skills Required
- 10+ years of experience
- Hands-on experience with Informatica PowerCenter
- Experience with Informatica Intelligent Cloud Services (IICS)
- Advanced SQL / Expertise in SQL queries
- Experience with Snowflake
- Strong knowledge of data modeling and data warehousing concepts
- Experience with ETL job optimization techniques (including pushdown optimization)
- ETL error troubleshooting experience
- Shell scripting experience
- Team leadership, mentoring, and code review experience
- Python knowledge
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
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
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.
