Data Engineer

  • Hyderabad
  • Chubb
Job Description: Strong experience with SQL and database technologies such as SQL Server, Oracle etc. (Preferably Azure Synapse) Create and maintain SQL-based database objects, including tables, views, indexes, and triggers. & Write optimized queries and ensuring that the database performs efficiently Troubleshoot database performance issues and identifying solutions to improve performance Should be Familiar with data modeling and data integration techniques Strong ETL development skills using Microsoft SSIS and Microsoft SQL Server Develop and maintain ETL mappings, workflows, and job schedule Design, develop and implement ETL solutions to extract, transform and load data from various sources into data warehouse ETL/ELT development using IICS-CDI (Cloud Data Integration), including experience with IICS Cloud Console and PowerCenter Designer Monitor ETL jobs to ensure successful completion, identify and resolve errors and performance issues. Troubleshoot and resolve issues with existing ETL processes. Good understanding of data warehousing concepts, ETL/ELT frameworks, and best practices Understanding of distributed file systems: HDFS, ADLS etc. Ensure data quality, integrity, and consistency by performing data validation, cleansing, and enrichment activities Be able to Work with cross-functional teams to understand business requirements and translate them into technical specifications for ETL development Experience with version control tools such as Git and follow CICD practice. Experience with scripting languages such as Python or Shell scripting Excellent analytical and problem-solving skills, with a keen attention to detail Ability to work independently and Support Team members in a team-oriented, collaborative environment Strong communication and interpersonal skills Familiarity with Agile development methodologies