1 day ago
Bengaluru, IndiaMid Level / Senior
Responsibilities
- Design and implement ETL workflows that extract, transform, and load data from multiple sources into data warehouses.
- Develop, optimize, and maintain advanced SQL queries, stored procedures, and scripts for data processing and reporting.
- Collaborate with data architects and business analysts to define requirements and deliver scalable ETL solutions.
- Build and maintain relational and dimensional data models and data warehousing solutions for analytics and reporting.
- Troubleshoot ETL issues and resolve data accuracy and reliability problems.
- Automate data pipelines using Python and ETL tools.
- Monitor ETL job performance, investigate failures through root cause analysis, and implement improvements.
- Document ETL processes and data flows for maintenance and knowledge transfer.
Requirements
- 4 to 6 years of professional experience, including at least 3 years of hands-on ETL development and data integration experience.
- Experience developing ETL solutions with tools such as Talend or Boomi.
- Advanced SQL skills for query optimization and complex data manipulation.
- PL/SQL programming experience for Oracle-based data integration.
- T-SQL scripting experience in Microsoft SQL Server environments.
- Python scripting experience for ETL automation and data processing.
- Experience implementing and maintaining data warehouses and relational and dimensional data models.
- Experience developing stored procedures for data transformation and tuning ETL workflows and SQL queries.
- Knowledge of cloud-based data integration solutions is preferred.
- Familiarity with Hadoop, Spark, and real-time data streaming or ingestion frameworks is preferred.
- Bachelor's degree in Computer Science, Information Technology, Data Engineering, or a closely related discipline is desired.
- Relevant ETL, data integration, SQL, database, or data engineering certifications are desired, including Talend Data Integration, Informatica, Microsoft Certified: Azure Data Engineer Associate, Microsoft SQL Server, or Oracle PL/SQL Developer Certified Associate.
Tech Stack
Categories
Data Engineering
About Brillio
Brillio is a privately held digital engineering and enterprise AI services firm that helps Fortune 1000 companies modernize products, data, and infrastructure. It combines consulting and managed services with an accelerator platform (ADAM) across cloud, AI, data engineering, customer experience, and infrastructure workstreams. Founded in 2014 and headquartered in Dallas, it operates delivery centers across North America, Europe, and Asia, with focus areas that include healthcare and life sciences.