Digital & Technology Architecture Head

Job Title: Sr. ETL Test Engineer

Experience: 7+ Years

Location: Gurgaon / Noida / Pune (Work From Office)

Joining: Immediate joiners only (≤15 days notice)

About the Role

We are seeking an experienced ETL Test Engineer with strong expertise in cloud-based ETL tools, Azure ecosystem, and advanced SQL skills. The ideal candidate will have a proven track record in validating complex data pipelines, ensuring data integrity, and collaborating with cross-functional teams in an Agile environment.

Key Responsibilities

• Design, develop, and execute ETL test plans, test cases, and test scripts for cloud-based data pipelines.
• Perform data validation, transformation, and reconciliation between source and target systems.
• Work extensively with Azure Data Factory, Azure Synapse Analytics, Azure SQL Database, and related Azure services.
• Develop and run complex SQL queries for data extraction, analysis, and validation.
• Collaborate with developers, business analysts, and product owners to clarify requirements and ensure comprehensive test coverage.
• Perform regression, functional, and performance testing of ETL processes.
• Identify defects, log them, and work with development teams to ensure timely resolution.
• Participate in Agile ceremonies (daily stand-ups, sprint planning, retrospectives) and contribute to continuous improvement.
• Ensure adherence to data quality and compliance standards.

Required Skills & Experience

• 5+ years of experience in ETL testing, preferably with cloud-based ETL tools.
• Strong hands-on experience with Azure Data Factory, Azure Synapse Analytics, and Azure SQL.
• Advanced SQL query writing and performance tuning skills.
• Strong understanding of data warehousing concepts, data models, and data governance.
• Experience with Agile methodologies and working in a Scrum team.
• Excellent communication and stakeholder management skills.
• Strong problem-solving skills and attention to detail.

Preferred Skills

• Experience with Python, PySpark, or automation frameworks for ETL testing.
• Exposure to CI/CD pipelines in Azure DevOps or similar tools.
• Knowledge of data security, compliance, and privacy regulations.

What you'll do:

• Mandatory - Experience & hands-on experience in setting up, optimizing, and securing analytical distributed data sources such as ClickHouse, Druid, or similar distributed database systems. Intermidiate DBA skills required.
• Deploy, configure, and maintain Kubernetes clusters for our microservices architecture.
• Utilize Git and Helm for version control and deployment management.
• Implement and manage monitoring solutions using Prometheus and Grafana.
• Work on continuous integration and continuous deployment (CI/CD) pipelines.
• Containerize applications using Docker and manage orchestration.
• Manage and optimize AWS services, including but not limited to EC2, S3, RDS, and AWS CDN.
• Maintain and optimize MySQL databases, Airflow, and Redis instances.
• Write automation scripts in Bash or Python for system administration tasks.
• Perform Linux administration tasks and troubleshoot system issues.
• Utilize Ansible and Terraform for configuration management and infrastructure as code.
• Demonstrate knowledge of networking and load-balancing principles.
• Collaborate with development teams to ensure applications meet reliability and performance standards.

Additional Skills (Good to Know):

• Familiarity with ClickHouse and Druid for data storage and analytics.
• Experience with Jenkins for continuous integration.
• Basic understanding of Google Cloud Platform (GCP) and data center operations.

Who you are:

• Minimum 3 years of experience in a Site Reliability Engineer role or similar.
• Proven experience with Kubernetes, Git, Helm, Prometheus, Grafana, CI/CD, Docker, and microservices architecture.
• Strong knowledge of AWS services, MySQL, Airflow, Redis, AWS CDN.
• Proficient in scripting languages such as Bash or Python.
• Hands-on experience with Linux administration.
• Familiarity with Ansible and Terraform for infrastructure management.
• Understanding of networking principles and load balancing.
• Bachelor's degree in Computer Science, Information Technology, or a related field.

Roles and responsibilities:

- Audit the current Information Security system and procedures and do a Gap analysis

- Identify immediate potential Information Security Risks and manage remediation tasks through to closure

- Create an Information Security Compliance Roadmap and execute end-to-end compliance initiatives by that roadmap

- Design high-quality test plans and direct Data/Information security control test activities

- Continuously improve Octro Data/Information security control framework

- Maintain handbook pages and procedures related to Information security compliance

- Identify opportunities for Information security compliance control automation, execute them and then maintain

- Provide actionable and constructive advisement to cross-functional teams, including driving remediation activities for high and select moderate-risk Observations across all Octro departments

- Design, develop, and deploy scripts to automate continuous control monitoring, administrative tasks and metric reporting for all security compliance programs

- Direct and support external audits as and when necessary

Requirements

- A minimum of 6-8 years' experience working with Data/Information Security Compliance programs

- Detailed knowledge of common information security management frameworks, regulatory requirements and applicable standards such as: ISO, SOC 2, GDPR, PCI etc.

About Octro Inc :

We are one of the fastest-growing mobile gaming companies around, a technology-driven organization at heart, and take pride in the platforms we create.

Founded in 2006 with a mission to create productivity applications for Mobile Devices. After pioneering one of the first mobile Voice-over-IP infrastructures called OctroTalk, the company ventured into building mobile gaming platforms. Sequoia Capital has invested in Octro. The funding was announced in June 2014.

• This role sits within the project management vertical of the organization. It will support the project delivery and execution of project tasks related to clients and is expected to bring an understanding of the importance of data in value creation and process efficiency, alongside demonstrated success working as part of a team. 
• Assumes responsibility for maintaining documentary support of projects and delivery of assigned project tasks. Supports ongoing administrative and compliance activities in the team, identifying issues and proposing solutions. 

• The position is very hands-on and requires an energetic self-starter and innovative team player, comfortable with an agile way of project delivery. Willingness to undertake varied tasks, apply thought processes to data management and process improvement, share ideas, and work resolution of issues with customers and internal teams. 
• This role must develop strong working relationships with the development team for product support.

• Execute the delivery of customer project tasks, processes, and solutions, especially within the SAP IAM/ASPM platform, including maintaining a project office and status reporting using MS office & internal project management tools up to intermediate skill level with MS Excel, PowerPoint, and MS Word 
• Utilize Excel and database skills to execute project tasks involving data mining and normalization for agile delivery 

• Demonstrate technical aptitude to execute project activities 
• Provide resolution to client’s support tickets through customer interaction and communication 
• Interact with customers through defined communication channels for any information 
• Create and edit customer Power BI reports as per the client’s business needs 
• Support development of training material as per the requirements 

• Testing AsInt’s applications with the support of the development team 
• Document management and versioning for up-to-date documentation 
• Have the desire and ability to work in a fast-paced agile project delivery environment 

• 2 to 5 years of strong project management experience, preferably in SAP product implementation. 

• BE or B. Tech degree with a minimum of 2 years of professional project delivery experience 
• Advanced Excel skills for data mining and normalization. Must be able to write excel formulas and VBA Macros, create graphs and visualizations 
• Power BI intermediate level proficiency – Create basic visualization as an end user 
• MS Access for data management 
• Excellent communication (Good Verbal, Written, and Presentation) and soft skills for client interaction 

• Basic SQL query 
• Application Testing from an end user perspective to create test scenarios 
• Working in Agile Methodology

GOOD TO HAVE 

• SAP Intelligent Asset Management product basic hands-on as an end-user 

• Basic Asset Management understanding 

1.Take daily doubt sessions for their respective subjects (Phys/Chem/Maths) 

2.Problem solving and solution preparation
3.Content Creation (DPP's, test series etc) and supervision.