Data Specialist - R01573377
- Bengaluru, India
- Hybrid
- Full-time
- Mid Level
- 4+ years
- Bachelor's degree
- Posted
Skills
Required
- ETL
- SQL
- Python
- Data Warehousing
- T-SQL
- Stored Procedures
- ETL Fundamentals
- Modern Data Platform
- Data Modelling Fundamentals
- PLSQL
- Hadoop / Spark
- Microsoft SQL Server / Oracle
- PL/SQL
Preferred
- data streaming
- ingestion frameworks
- data flows
- Boomi
- query optimization
- complex data manipulation
- Oracle-based
Data Specialist
ETL Specialization: Data Engineer
About Brillio
Specialization
Responsibilities
- Develop, optimize, and maintain advanced SQL queries, stored procedures, and scripts for efficient data processing and reporting 3.
- Collaborate with data architects and business analysts to define data requirements and deliver scalable ETL solutions aligned with business objectives 4.
- Build and maintain data models and warehousing solutions to support analytics and reporting initiatives 5.
- Troubleshoot and resolve ETL process issues to ensure data accuracy and reliability 6.
- Automate data pipelines using Python and ETL tools to improve operational efficiency 7.
- ETL job performance, conduct root cause analysis for failures, and implement improvements for optimal system performance 8.
- Document ETL processes and data flows to support ongoing maintenance and knowledge transfer Required Skills: 1.
- ETL development using tools such as Talend or Boomi 2.
- Advanced SQL for query optimization and complex data manipulation 3.
- PL/SQL programming for Oracle-based data integration 4.
- Stored procedure development for data transformation 9.
Requirements
Primary Skills
- ETL Fundamentals, SQL, SQL (Basic + Advanced), Python, Data Warehousing, Modern Data Platform Fundamentals, Data Modelling Fundamentals, PLSQL, T-SQL, Stored Procedures
- 4 to 6 years of professional experience, including at least 3 years of hands-on ETL development and data integration, with substantial experience in SQL-based solutions Key Responsibilities: 1.
- Design and implement robust ETL workflows to extract, transform, and load data from multiple sources into data warehouses, ensuring high data quality and consistency 2.
- T-SQL scripting for Microsoft SQL Server environments 5.
- Python scripting for ETL automation and data processing 6.
- Data warehousing implementation and maintenance 7.
- Relational and dimensional data modeling 8.
- Performance tuning of ETL workflows and SQL queries Preferred Skills: 1.
- Knowledge of cloud-based data integration solutions 2.
- Familiarity with big data technologies such as Hadoop or Spark 3.
- Bachelor's degree in Computer Science, Information Technology, Data Engineering, or a closely related discipline 2.
- Certification in ETL or data integration technologies such as Talend Data Integration, Informatica, or Microsoft Certified: Azure Data Engineer Associate 3.
- Certification in SQL or database technologies such as Microsoft SQL Server or Oracle PL/SQL Developer Certified Associate
Preferred
- Exposure to real-time data streaming and ingestion frameworks Desired Qualifications: 1.