ETL Informatica - Senior Data Specialist - R01548962 at Brillio

Hyderabad, Telangana, India

Brillio Logo
Not SpecifiedCompensation
Senior (5 to 8 years), Expert & Leadership (9+ years)Experience Level
Full TimeJob Type
UnknownVisa
TechnologyIndustries

Requirements

  • 10+ years of experience
  • Strong hands-on experience in Informatica, Advanced SQL, PowerCenter, IICS
  • Strong knowledge of data model and data warehouse
  • Experience with ETL job optimization techniques (mainly Pushdown optimization), ETL error troubleshooting, Shell Scripting, Snowflake
  • Expertise in SQL / Advanced SQL queries
  • Skills: A good team player/lead and quick learner
  • Added Advantage: Python Knowledge

Responsibilities

  • 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
  • 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

Skills

Key technologies and capabilities for this role

InformaticaPowerCenterIICSAdvanced SQLSnowflakeShell ScriptingData WarehousingData ModelingETL OptimizationPython

Questions & Answers

Common questions about this position

What is the salary for this ETL Senior Data Specialist position?

This information is not specified in the job description.

Is this role remote or does it require office work?

This information is not specified in the job description.

What key skills are required for this position?

The role requires 10+ years of experience with strong hands-on expertise in Informatica, PowerCenter, IICS, Advanced SQL, data modeling, data warehousing, ETL optimization (especially Pushdown), troubleshooting, Shell Scripting, and Snowflake.

What is the company culture like at Brillio?

Brillio is an employer of choice that attracts top talent through its focus on cutting-edge technologies, exclusive digital projects, and commitment to employee growth, earning Great Place to Work® certification yearly.

What makes a strong candidate for this role?

Candidates with 10+ years of experience, hands-on expertise in Informatica tools and Advanced SQL, leadership skills as a team player/lead, and quick learning ability stand out; Python knowledge is an added advantage.

Brillio

Technology consulting for digital transformation

About Brillio

Brillio helps businesses with their digital transformation by providing technology consulting services. The company focuses on creating customized digital solutions that utilize artificial intelligence and cloud technologies to meet the specific needs of each client. This includes improving operational efficiency and enhancing user experiences through real-time responses and better workflows. Brillio serves a variety of clients, including large Fortune 500 companies, with a strong emphasis on the healthcare sector. Unlike many competitors, Brillio's approach is centered on developing bespoke solutions that give clients a competitive advantage, aiming to help them evolve into 'generative enterprises.' The company's goal is to drive significant improvements in business operations and outcomes through its consulting services and technology implementations.

Edison, New JerseyHeadquarters
2014Year Founded
LATE_VCCompany Stage
Consulting, AI & Machine Learning, HealthcareIndustries
1,001-5,000Employees

Benefits

Remote Work Options

Risks

High competition in tech may impact Brillio's talent acquisition and service scaling.
Over-reliance on healthcare exposes Brillio to sector-specific regulatory and funding risks.
Expansion into new markets may stretch resources, leading to potential operational inefficiencies.

Differentiation

Brillio specializes in bespoke digital solutions for diverse industries, focusing on AI and cloud.
The company is recognized as an Enterprise Innovator in healthcare payer services.
Brillio's Cloud and AI Studio aims to modernize enterprise IT systems and optimize workflows.

Upsides

Increased demand for AI-driven healthcare solutions boosts Brillio's market potential.
Expansion in India enhances service delivery and innovation through a growing tech talent pool.
Recognition in Open Banking IT Services highlights Brillio's role in financial digital transformation.

Land your dream remote job 3x faster with AI