ETL Senior Software Engineer 2

ETL – Senior Software Engineer

Job Location: India (Hyderabad)

About MyComplianceOffice (MCO)

MyComplianceOffice (MCO) is a global leader in conduct-risk compliance management. From our modest beginnings as a startup, we’ve grown over the last 15 years into a dominant force in compliance technology, serving hundreds of marquee clients around the world. Our SaaS platform continues to evolve rapidly - fuelled by innovation, acquisitions, and unmet market needs. With impressive growth and profitability metrics, MCO is poised for the next phase of its expansion. We're looking for smart, driven professionals to help shape our future.

The MCO SaaS Platform

MCO’s cloud-based compliance platform empowers organizations to reduce conduct risk by proactively managing the regulated activities of employees, vendors, and other third parties. Designed for flexibility and speed, our suite of modular, easy-to-deploy solutions ensures compliance teams can act quickly, demonstrate accountability, and reduce risk—all while keeping costs low. With compliance automation at its core, the MCO platform helps clients of all sizes stay ahead in a fast-changing regulatory landscape.

About the Role

We are seeking a highly skilled and experienced ETL/ELT Developer to join our multinational team. The ideal candidate will be proficient in developing ETL applications using RDBMS, Python (Mandatory), Unix Shell Scripting, and cloud-based applications such as Snowflake, Si-sense or any such third-party tool. The ask is to redesign and come up with a new data warehouse or data lake that could support MCO’s future needs (including AI integration). The role is an SSE role and hence the candidate is expected to be a self-starter, and to lead a helping hand and be on the ground during the development efforts from the front with minimum supervision. Also, the candidate must be technically adaptable to new technologies, should not be shy to learn, design and implement any technology of need on the go. Additionally, the candidate should have strong expertise in design patterns, and in fixing performance issues pertaining to the existing RDBMS OLTP. This role requires a developer who is adaptable, innovative, and capable of working in a fast-paced environment.

Key Responsibilities

• Design, develop, build and maintain ETL/ELT application components using the existing OLTP/OLAP 19c (Using Python, Unix Shell scripting).
• Write clean, SOLID code in Python and Unix Shell scripts, ensuring application performance and responsiveness. Implement back-end interfaces using Snowflake, adhering to modern design patterns and best practices.
• Collaborate with cross-functional teams to define, design, and ship new features and enhancements within an agile workflow.
• Troubleshoot, debug, and upgrade existing systems, ensuring high performance and responsiveness. Participate in code reviews to maintain high-quality code standards and promote knowledge sharing.

Experience and Skills Required

• 4-10 Years of Proven experience as an ETL/ELT Developer or similar role.
• Proficiency in ETL development using RDBMS and Unix Shell scripting. This should include knowledge on Python programming, how to write clean and organized Python code within a modern context.
• Basic knowhow of Cloud based ETL offerings such as (not limited to) Snowflake or Si-Sense, their architecture and implementation.
• In-depth knowledge of Relational database and how it could be migrated to a file based (JSON) or any other format better suited for AI needs.
• Experience with databases, particularly RDBMS, and should have clear understanding of RDBMS vs non-RDBMS, their strengths, weaknesses, migrations techniques. Proficient understanding of code versioning tools, such as Git.
• Excellent problem-solving skills and the ability to work in a fast-paced environment.
• Strong communication and teamwork skills, with the ability to collaborate effectively with other developers, POs, and product managers.
• Be open to any solution proposed which would suit MCO future architectural needs in lieu of its AI centric approach.

We are seeking a highly skilled and experienced ETL/ELT Developer to join our multinational team. The ideal candidate will be proficient in developing a data warehouse/ data lake from scratch using Cloud and non-cloud options. Additionally, the candidate should have strong expertise in design patterns, this role requires a developer who is adaptable, innovative, and capable of working in a fast-paced environment.

• Seniority Level
• Associate
• Industry
• Software Development
• Employment Type
• Full-time
• Job Functions
• Product Management
• Skills
• ETL Developer
• Python Programming
• RDBMS
• Unix Shell Scripting