Data Warehouse Developer

Job Description

Position: Data warehouse Developer Domain Knowledge: Insurance (Mandatory) Job Type: Permanent Location: Hyderabad - IDA Cherlapally, ECIL and Divyasree Trinity, Hi-Tech City. Experience: 3+ Years Education: B. Tech / MCA 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