Sr. Software Engineer - Data Warehouse

Domain Knowledge: Insurance (Mandatory)

Job Type: Permanent

Location: Hyderabad - IDA Cherlapally, ECIL and Divyasree Trinity, Hi-Tech City.

Experience: 3+ yrs.

Education: B. E. / B. Tech. / M. C. A.

Resource Availability: Immediately or a maximum period of 30 days.

Technical Skills

• Strong knowledge of data warehousing concepts and technologies.
• Proficiency in SQL and other database languages.
• Experience with ETL tools (e.g., Informatica, Talend, SSIS).
• Familiarity with data modelling techniques.
• Experience in building dimensional data modelling objects, dimensions, and facts.
• Experience with cloud-based data warehouse platforms (e.g., AWS Redshift, Azure Synapse, Google Big Query).
• Familiar with optimizing SQL queries and improving ETL processes for better performance.
• Knowledge of data transformation, cleansing, and validation techniques.
• Experience with incremental loads, change data capture (CDC) and data scheduling.
• Comfortable with version control systems like GIT.
• Familiar with BI tools like Power BI for visualization and reporting.

Responsibilities

• Design, develop and maintain data warehouse systems and ETL (Extract, Transform, Load) processes.
• Develop and optimize data models and schemas to support business needs.
• Design and implement data warehouse architectures, including physical and logical designs.
• Design and develop dimensions, facts and bridges.
• Ensure data quality and integrity throughout the ETL process.
• Design and implement relational and multidimensional database structures.
• Understand data structures and fundamental design principles of data warehouses.
• Analyze and modify data structures to adapt them to business needs.
• Identify and resolve data quality issues and data warehouse problems.
• Debug ETL processes and data warehouse queries.

Communication Skills

• Good communication skills to interact with customer.
• Ability to understand requirements for implementing an insurance warehouse system.