Senior Data Specialist - ETL Informatica

2 Months ago • 10 Years +

Job Summary

Job Description

Brillio, a rapidly growing digital technology service provider, seeks a Senior Data Specialist. This role involves leading and managing an ETL development team, collaborating with stakeholders to translate requirements into technical specifications, and possessing hands-on expertise in Advanced SQL for data extraction, transformation, and validation. The ideal candidate will have a strong understanding of Data Warehousing concepts, experience with Snowflake for cloud-based data platforms, and proficiency in designing, developing, and optimizing ETL workflows using Informatica Intelligent Cloud Services (IICS). Responsibilities include ensuring data quality, performance tuning, providing technical guidance, mentoring the team, managing task prioritization, and coordinating deployments. Knowledge of Python is considered a plus.

Must have:

Informatica Power Center
Informatica Intelligent Cloud Services (IICS)
Advanced SQL
Snowflake
Data Warehousing concepts
ETL job optimization techniques
ETL error troubleshooting
Shell Scripting

Good to have:

Python Knowledge

8 skills required

8 skills required for this role

Add these skills to join the top 1% applicants for this job

task-prioritization

problem-solving

team-player

quality-control

user-experience-ux

python

shell

sql

Job Details

Senior Data Specialist

Primary Skills

About Brillio:

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.

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

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