4-6 years of professional experience in ETL development and data integration
At least 3 years of hands-on experience with SQL-based solutions
Proficiency in ETL tools like Talend or Boomi
Strong skills in advanced SQL, PL/SQL, and T-SQL
Experience with Python for ETL automation
Bachelor's degree in Computer Science, IT, or related field
Relevant certifications in ETL or SQL technologies preferred
Responsibilities
Design and implement ETL workflows for data extraction, transformation, and loading
Develop and optimize SQL queries and stored procedures for data processing
Collaborate with data architects and analysts to define data requirements
Build and maintain data models for analytics and reporting
Troubleshoot and resolve ETL process issues for data accuracy
Automate data pipelines using Python and ETL tools
Monitor ETL job performance and conduct root cause analysis
Benefits
Opportunities for professional development and certifications
Collaborative work environment with data architects and analysts
Exposure to modern data technologies and cloud solutions
Potential for involvement in innovative data projects
Support for ongoing maintenance and knowledge transfer initiatives
Full Job Description
Data Specialist Primary Skills
ETL Fundamentals, SQL, SQL (Basic + Advanced), Python, Data Warehousing, Modern Data Platform Fundamentals, Data Modelling Fundamentals, PLSQL, T-SQL, Stored Procedures
Specialization
ETL Specialization: Data Engineer
Job requirements
Experience Range: 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. 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. Monitor 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. 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. Stored procedure development for data transformation 9. 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. Exposure to real-time data streaming and ingestion frameworks Desired Qualifications: 1. 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
About Brillio
Brillio is a technology consulting and technology services company focused on the implementation of digital technologies.
Brillio Careers
There has never been a more opportune time to join Brillio—the forefront of innovation and digital transformation.
Opportunities Await
Brillio offers a plethora of job opportunities aimed at harnessing the potential of professionals eager to drive change. With a focus on technology and consulting, Brillio is not just a company; it's a vibrant ecosystem conducive to growth and professional development.
Transform Your Career
Embark on a journey of growth and leadership at Brillio. This is where industry expertise meets digital innovation to transform businesses and industries. Brillio stands out in the marketplace, providing a unique blend of technology solutions and strategic insights.
Join a Diverse and Inclusive Team
Brillio is committed to diversity and inclusion, ensuring a wide range of perspectives that fuel innovation and creative solutions. The team at Brillio, enriched with diverse skills and backgrounds, collaborates to deliver excellence and drive success.
Internship Programs and Employment
Kickstart your career with Brillio's internship programs, designed to offer hands-on experience and a gateway to full-time employment. Brillio is dedicated to nurturing young talent, providing them with the necessary tools and guidance to excel.
Innovate and Lead
At Brillio, every team member is an innovator and leader. The company fosters a culture of continuous learning and improvement, encouraging each individual to push boundaries and contribute to groundbreaking projects.
Networking and Professional Development
Networking at Brillio opens doors to influential connections, mentorship, and collaborative opportunities. Brillio supports career advancement through professional development, offering training in leadership, diversity, and specific job skills.
Benefits and Culture
Brillio is known for its dynamic culture and the comprehensive benefits it offers. Team members enjoy a supportive environment that values their well-being and professional growth.
Explore Job Positions
Brillio is hiring! Explore the various positions available that match your skills and interests. Brillio seeks passionate, curious, and solution-driven professionals ready to make an impact.
Prepare for Your Interview
Brillio helps candidates succeed by providing resources on how to effectively prepare your resume and ace the interview process. Stand out as a prospective employee by demonstrating your knowledge and enthusiasm for Brillio's mission.
Stay Connected with Brillio Careers
Keep up to date with career tips, industry insights, and the latest job openings at Brillio. Personalize your job search and stay informed about new and exciting opportunities within the company.
APPLY TO BRILLIO JOBS
Read Careers Blog
Stay ahead in your career with insights from Brillio's experts. Discover articles and advice tailored to advancing your career and enhancing your professional journey.
Job Alert Emails
Subscribe to receive customized job alerts and the latest news from Brillio. Discover the rewarding career opportunities that await and how Brillio can be the key to your professional future.