5-8 years of experience in data integration and data warehousing solutions
Hands-on experience with Informatica Intelligent Cloud Services (IICS)
Expertise in Snowflake architecture and features
Advanced SQL development and optimization skills
Proficiency in ETL/ELT development and data warehousing concepts
Familiarity with AWS or Azure cloud services (preferred)
Bachelor's degree in a relevant field, with certifications in Snowflake or Informatica preferred
Responsibilities
Design and maintain ETL/ELT pipelines using IICS for scalable data integration
Implement and optimize data workflows with robust error handling and scheduling
Develop complex mappings and reusable components for data transformation
Build and maintain Snowflake data warehouse solutions for analytics
Write and optimize advanced SQL queries and stored procedures
Implement data loading strategies from various source systems
Troubleshoot ETL failures and performance issues to ensure data reliability
Collaborate with cross-functional teams to deliver end-to-end data solutions
Benefits
Opportunities for professional development and certifications
Collaborative work environment with cross-functional teams
Exposure to cutting-edge data technologies
Flexible work arrangements
Potential for career advancement within the organization
Full Job Description
Senior Data Engineer Primary Skills
DataStream, ETL Fundamentals, SQL, SQL (Basic + Advanced), Python, Data Warehousing, Time Travel and Fail Safe, Snowpipe, SnowSQL, Modern Data Platform Fundamentals, Data Modelling Fundamentals, PLSQL, T-SQL, Stored Procedures
Specialization
Snowflake Engineering: Senior Data Engineer
Job requirements
Experience Range: With at least 5 to 8 years of experience designing, developing, and maintaining data integration and data warehouse solutions using IICS and Snowflake Key Responsibilities: 1. Design, develop, and maintain ETL/ELT pipelines using Informatica Intelligent Cloud Services (IICS) to support scalable data integration processes 2. Implement and optimize data integration workflows with IICS Cloud Data Integration (CDI), ensuring robust error handling, scheduling, and parameterization 3. Develop complex mappings, mapping tasks, taskflows, and reusable components for efficient data movement and transformation 4. Build and maintain Snowflake data warehouse solutions, including databases, schemas, tables, views, and stages to support business analytics 5. Write and optimize advanced SQL queries and Snowflake stored procedures to enable high-performance data processing and reporting 6. Implement data loading strategies from diverse source systems into Snowflake, including incremental loads, Change Data Capture (CDC), and Slowly Changing Dimensions (SCD) Type 1/Type 2 7. Perform data transformation, cleansing, validation, and reconciliation to ensure data quality and integrity 8. Troubleshoot ETL failures, data issues, and performance bottlenecks to ensure reliable data operations 9. Collaborate with business analysts, data architects, QA, and other technical teams to deliver end-to-end data solutions and support production deployments Required Skills: 1. Hands-on experience with Informatica Intelligent Cloud Services (IICS) and Cloud Data Integration (CDI) 2. Expertise in Snowflake data warehouse architecture and features including warehouses, stages, streams, tasks, time travel, and zero-copy cloning 3. Advanced SQL development and query optimization 4. Proficiency in ETL/ELT development and data warehousing concepts 5. Experience developing mappings, mapping tasks, and taskflows in IICS 6. Implementation of parameterization and error handling in ETL pipelines 7. Scheduling and automation of data integration workflows 8. Design and management of incremental and full data loads including SCD and CDC patterns Preferred Skills: 1. Experience with AWS or Azure cloud services for data integration and storage 2. Knowledge of AWS S3 or Azure Blob Storage for data ingestion 3. Familiarity with CI/CD and DevOps practices for ETL pipeline deployment 4. Proficiency in Python or scripting languages for automation 5. Experience with version control and automation tools such as Git, Jenkins, or Azure DevOps 6. Domain experience in Life Sciences or Pharmaceutical industry Desired Qualifications: 1. Bachelor's degree in Computer Science, Information Technology, Engineering, or a closely related discipline 2. Certification in Snowflake or Informatica Cloud Data Integration (preferred) 3. Certification in AWS or Azure cloud platforms (preferred)
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.
