
Senior Software Engineer 1 and Data Engineering Specialist
- Bangalore, Karnataka
- Permanent
- Full-time
- Essential duties and responsibilities include the following. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions:
- Implement data replication and data ingestion software features and products following best practices such as authoring of unit tests, writing maintainable code, applying established patterns and algorithms.
- Specialize in data engineering as a member of a project team.
- Design and development of software engineering strategies.
- Design and implement ETL processes to extract, transform, and load data from diverse sources.
- Develop and optimize SQL queries for data extraction and transformation.
- Perform data profiling, cleansing, and validation to ensure data accuracy and integrity.
- Troubleshoot and resolve issues related to data integration processes.
- Create and maintain documentation for ETL processes, data mappings, and transformations.
- Stay abreast of industry best practices and emerging technologies in ETL and data integration.
- Investigate and resolve issues following best practices such as authoring or updating unit tests, writing maintainable code, applying established patterns and algorithms.
- Analyze performance and develop improvements to performance.
- Assist and analyze security best practices.
- Develop software to support internal initiatives, tools, update framework and application functionality.
- Work as part of an Agile SCRUM team in the planning, scoping, estimation, and execution of technical solutions.
- Other duties as assigned.
- Bachelor's degree in Computer Science or Information Technologies required, or equivalent experience:
- 5+ years' experience in software engineer role.
- Strong experience with Snowflake and various database (MySQL, MSSQL, etc.) platforms.
- Strong experience in TSQL and writing SQL transformations.
- Strong experience in building data engineering pipelines using Python.
- Experience with any replication technologies like SQL Replication, Fivetran, Qlik Replicate.
- Understanding of data governance.
- Experience in building CI/CD pipelines.
- Excellent written and verbal communication skills.
- Excellent ability to work with current software design principles and concepts such as patterns, algorithms.
- Ability to handle a heavy workload while working on multiple projects and frequent interruptions.
- Ability to work in a changing, dynamic environment.
- Ability to provide an accurate and reliable estimate.
- Willingness to work in a fast-paced environment.