
Senior Software Engineer
- Telangana
- Permanent
- Full-time
- 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.
- Bachelor's degree in computer science, Information Technology, or a related field.
- 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