Big Data Engineer

BriskWinIT; Chennai; On-site; INR 800,000 - 1,400,000; Full time

Job summary

BriskWin IT Solutions Pvt Ltd in Chennai seeks an experienced Datawarehouse Developer to design, develop and maintain data warehouse components with strong ETL and MS SQL skills. You will automate ETL processes, implement data models, and ensure data quality across the warehouse landscape.

Required 4-6 years in MS SQL development plus knowledge of data warehousing concepts; Python is a plus. This role requires collaboration with BI teams and good problem-solving abilities.

Qualifications

• 4-6 years of hands-on experience in MS SQL Server development.
• Solid understanding of data warehouse concepts, star/snowflake schema, and dimensional modelling.
• Experience with Python is a plus.
• Strong analytical and troubleshooting skills.
• Experience in performance tuning and query optimization.
• Good communication skills and ability to work collaboratively in a team environment.

Responsibilities

• Design, develop, and maintain data warehouse schemas, tables, views, and materialized views.
• Write complex MS SQL scripts for data extraction, transformation, and loading (ETL).
• Optimize database performance through query tuning, indexing, and partitioning.
• Develop and maintain stored procedures, functions, triggers, and packages.
• Collaborate with data architects, business analysts, and BI teams to translate business requirements into technical solutions.
• Ensure data accuracy, consistency, and security across the warehouse environment.
• Support production systems by monitoring jobs, troubleshooting failures, and resolving issues promptly.
• Participate in code reviews and contribute to improving data development standards and best practices.
• Document ETL workflows, data mappings, and database structures.

Skills

MS SQL Server

ETL development

Data warehousing

Query performance tuning

Dimensional modelling

Python (basic)

Problem solving

Job description

Exp: 6 years – 12 years

Location: Chennai

Np: Immediate Joiner only

Datawarehouse Developer with strong ETL and MS SQL skills Key Responsibilities :

• Design, develop, and maintain data warehouse schemas, tables, views, and materialized views.
• Write complex MS SQL scripts for data extraction, transformation, and loading (ETL).
• Optimize database performance through query tuning, indexing, and partitioning.
• Develop and maintain stored procedures, functions, triggers, and packages.
• Collaborate with data architects, business analysts, and BI teams to translate business requirements into technical solutions.
• Ensure data accuracy, consistency, and security across the warehouse environment.
• Support production systems by monitoring jobs, troubleshooting failures, and resolving issues promptly.
• Participate in code reviews and contribute to improving data development standards and best practices.
• Document ETL workflows, data mappings, and database structures. Required Skills & Qualifications
• 4-6 years of hands-on experience in MS SQL Server development.
• Solid understanding of data warehouse concepts, star/snowflake schema, and dimensional modelling.
• Experience with Python is a plus.
• Strong analytical and troubleshooting skills.
• Experience in performance tuning and query optimization.
• Good communication skills and ability to work collaboratively in a team environment. Preferred Skills (Nice to Have)
• Good understanding of Capital Markets domain is a plus.