ETL Informatica - Senior Data Specialist - R01548962

Brillio; United States; Remote; USD 90,000 - 130,000; Full time

Job summary

An established industry player is seeking a Senior Data Specialist to lead a talented team of ETL developers. This role involves managing cloud-based data platforms, optimizing ETL workflows, and ensuring data quality. The ideal candidate will have a strong background in Advanced SQL, Informatica, and Snowflake, along with a passion for innovative digital solutions. Join a company renowned for its commitment to client satisfaction and exceptional employee experience, where your contributions will drive impactful digital transformations.

Qualifications

• 10+ years of experience in data management and ETL processes.
• Strong hands-on experience with Informatica and Snowflake.

Responsibilities

• Lead a team of ETL developers to deliver high-quality outputs.
• Collaborate with stakeholders to gather requirements and translate them.

Skills

Advanced SQL

ETL Optimization Techniques

Data Warehousing Concepts

Informatica PowerCenter

Snowflake

Shell Scripting

Python

Tools

Informatica Intelligent Cloud Services (IICS)

Snowflake

Job description

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. Renowned for its world-class professionals, called "Brillians," Brillio distinguishes itself through their ability to seamlessly integrate cutting-edge digital and design thinking skills with an unwavering dedication to client satisfaction. The company takes pride in being an employer of choice, attracting exceptional talent with its focus on contemporary, groundbreaking technologies and exclusive digital projects. Brillio's commitment to providing an exceptional experience and nurturing full potential has earned it the Great Place to Work certification year after year.

Responsibilities:

1. Lead and manage a team of ETL developers to deliver high-quality outputs.
2. Collaborate with business and technical stakeholders to gather requirements and translate them into technical specifications.
3. Hands-on expertise in Advanced SQL for data extraction, transformation, and validation tasks.
4. Strong understanding of Data Warehousing concepts.
5. Experience working with Snowflake for building and managing cloud-based data platforms.
6. Design, develop, and optimize ETL workflows using Informatica Intelligent Cloud Services (IICS).
7. Ensure data quality, performance tuning, and adherence to best practices in ETL processes.
8. Provide technical guidance, mentoring, and code reviews for the ETL team.
9. Manage task prioritization, timelines, and issue resolution in a fast-paced environment.
10. Coordinate deployments and support activities across development, QA, and production environments.
11. Knowledge of Python is a plus.

Specialization: ETL Specialization: Data Specialist

Job Requirements:

• Role: Data Specialist
• Experience: 10+ years
• Strong hands-on experience with Informatica PowerCenter, IICS, and Snowflake.
• Proficiency in Advanced SQL queries and data modeling.
• Experience in ETL job optimization techniques, especially pushdown optimization.
• ETL error troubleshooting skills.
• Experience with Shell scripting.
• Python knowledge is an added advantage.
• Excellent team player and quick learner.