Data Engineer (ETL Developer)

Job Summary:

You’re responsible for building, testing, and maintaining the infrastructure and tools to enable speedy development and release of software. We expect you to have a comprehensive understanding of technology stacks for automation in software development and infrastructure operations. You will collaborate with developer and operations teams to bridge the gap between development and operations, enabling a smooth and efficient software delivery process.

Job Description:

• Design and develop ETL solutions using data integration tools for interfacing between source application and the Enterprise Data Warehouse
• Experience with Big Data or data warehouse
• Analyze & translate functional specifications & change requests into technical specifications
• Experience in SQL programming in one of these RDBMSs such as Oracle
• Develops ETL technical specifications, designs, develops, tests, implements, and supports optimal data solutions
• Develops Documents ETL data mappings, data dictionaries, processes, programs and solutions as per established standards for data governance
• Design and create codes for all related data extraction, transformation and loading (ETL) into database under responsibilities
• Creates, executes, and documents unit test plans for ETL and data integration processes and programs
• Perform problem assessment, resolution and documentation in existing ETL packages, mapping and workflows in production
• Performance tuning of the ETL process and SQL queries and recommend and implement ETL and query tuning techniques

Qualifications:

• Bachelor’s degree in Information Technology, Computer Science, Computer Engineering, or a related field
• Experience with CI/CD tools (e.g., Jenkins, GitLab CI/CD) and automation frameworks
• Proficiency in cloud platforms such as AWS, Azure, and associated services
• Knowledge of IAC tools like Terraform or Azure ARM
• Familiarity with monitoring and logging tools like Prometheus, Grafana, ELK stack, APM, etc.
• Good understanding of IT Operations
• Strong problem-solving skills and the ability to troubleshoot complex issues
• Excellent communication and teamwork skills to collaborate effectively across various teams