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

- Solid 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.

Send an email to [email protected] with the updated resume to contact.

📌 Sr. Software Engineer - Data Warehouse (Hyderabad)
🏢 Jarus Technologies
📍 Hyderabad