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.
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
Top Skills
Informatica Powercenter,Informatica Intelligent Cloud Services (Iics),Snowflake,Sql,Shell Scripting,Python
Brillio Chennai, Tamil Nadu, IND Office
Chennai, India
Similar Jobs
.jpg)
AdTech • Cloud • Marketing Tech • Productivity • Software • Analytics • Automation
Design, develop, and maintain containerized microservices using Java and React/TypeScript; build and consume REST APIs; write unit and automated tests; support CI/CD and AWS-based systems; operate services on-call; collaborate across US-India timezones and mentor teammates.
Top Skills:
ArgocdAws BedrockAws KinesisAws SnsAws SqsCi/CdContainersDynamoDBGitGradleJavaJenkinsKubernetesMcp ServersMicroservicesMySQLOpensearchPostgresPrompt EngineeringReactRest ApisSnowflakeSQLTypescriptUnit And Automated Testing
Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
The HR Ops Intern will manage onboarding processes, maintain documentation, support induction sessions, and address employee queries, ensuring a seamless experience for new hires.
Top Skills:
ExcelMicrosoft OutlookMicrosoft Word
Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
Drive enterprise-wide automation initiatives by designing and implementing solutions using N8N and Tray.ai. Collaborate with teams to automate processes, integrate systems, and ensure high availability of workflows while mentoring others and reporting on impact.
Top Skills:
Gemini EnterpriseJSONMcpN8NPythonRest ApisSQLTray.AiXML
What you need to know about the Chennai Tech Scene
To locals, it's no secret that South India is leading the charge in big data infrastructure. While the environmental impact of data centers has long been a concern, emerging hubs like Chennai are favored by companies seeking ready access to renewable energy resources, which provide more sustainable and cost-effective solutions. As a result, Chennai, along with neighboring Bengaluru and Hyderabad, is poised for significant growth, with a projected 65 percent increase in data center capacity over the next decade.
