MCO (MyComplianceOffice)
Website:
mycomplianceoffice.com
Job details:
About the Role
We are seeking a highly skilled and experienced ETL Developer to join our multinational team. The ideal candidate will be proficient in developing ETL applications using variety of RDBMSs. The candidate is expected to clearly demonstrate experience dealing with issues of performance, cost & reliability with ETLs. Knowledge in Python programming is a must. The role is a Lead role and hence the candidate is expected to be a self-starter, and to lead the development efforts from the front with minimum supervision. Also, the candidate must be technically adaptable to new technologies, should be adept to learn, design and implement any technology on the go. The ideal candidate will be proficient in developing ETL applications using Relational databases, Java, Kafka, Python (Pandas, Py-Arrow, Py-Spark), Unix Shell Scripting, and exposure to Reporting/BI tools such as Snowflake, Tableau or Databricks. The candidate must possess strong knowledge in understanding database design patterns, Normal forms (1NF/2NF/3NF), Star schema or Snowflake schema design patterns. They should also have good knowledge of how-to performance tune or suggest design patterns to improve the existing database designs. Exposure to Third party licensed ETL tools such as Air-byte, Blade-Pipe is added advantage. We are in process of setting up a new data warehouse or data lake that could support MCO’s future needs (including AI integration). Additionally, the candidate should have strong expertise in design patterns, latest data warehousing/ETL trends and in fixing performance issues. This role requires a developer who is adaptable, innovative, and capable of working in a fast-paced environment.
Responsibilities
- Design, develop, build and maintain ETL Application, and developing a warehouse
- Strong preference for Python experience (must have skill).
- Design, develop, build and maintain ETL application components using the existing OLTP systems (Using Java, Kafka, Python, SQL Engine Options, Unix Shell scripting).
- Write clean, SOLID code in Java, Python, Kafka, PL/SQL Code and Unix Shell scripts, ensuring application performance and responsiveness. Implement back-end interfaces using Snowflake, adhering to modern design patterns and best practices.
- Can clearly demonstrate experience dealing with issues of performance, cost & reliability with ETLs.
- 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.
- Knowledge on Columnar databases an added advantage.
- Basic Knowhow of Iceberg tables and schema evolution would be beneficial
Experiences and Skills
- 10-15 Years of Proven experience as an ETL Backend Developer.
- Strong proficiency in Python/Java Programming, who knows how to write clean and organized Python code within a modern context.
- Proficiency in ETL development using Java (or) Python, Kafka, Debezium, PL/SQL and Unix Shell scripting. This should include knowledge on Python or Java programming, how to write clean and organized Python or Java code within a modern context.
- Basic knowhow of Cloud based ETL offerings such as (not limited to) Snowflake or Si-Sense and their architecture and implementation.
- In-depth knowledge of Relational database and how it could be migrated to a file based or any other format better suited for AI needs.
- Knowledge on Columnar and Graph databases such as Cassandra or clickhouse.
- Experience with databases 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.
About MCO (MyComplianceOffice)
MCO is a global leader dedicated to empowering Financial Services firms to manage compliance programs with ease and efficiency. Our mission is to foster a fair, transparent, and trusted financial environment worldwide by helping organizations meet their regulatory obligations to society.
At the heart of MCO’s offering is our unique, unified platform, which seamlessly integrates compliance monitoring and data into a single, comprehensive view. This holistic approach enables firms to maintain compliance across all internal systems, structures, and processes—ensuring peace of mind in an ever-evolving regulatory landscape.
Headquartered in Dublin, MCO has an international footprint, with offices in London, Singapore, Hyderabad, New York, Chicago, Fort Worth, Switzerland, South Africa, Slovenia, and the UAE. Since our founding in 2008, we have evolved from a specialist provider of “best of breed” employee compliance solutions to a pioneer in integrated compliance technology.
In recent years, MCO has rapidly expanded its product suite by tripling investment in internal development and acquiring four innovative companies: Pythagoras, Fairwords, Schwab Compliance Technologies and Governor Software. These strategic moves have strengthened our capabilities in regulatory governance, third-party management, and communications compliance.
Today, our team of over 400 professionals supports more than 1.5 million users in 128 countries. Our diverse customer base includes small businesses, large enterprises, four of the world’s top ten asset managers, twenty of the top seventy-five global banks, and three of the top five investment banks for global M&A transactions.
Driven by ambition and innovation, MCO is excited to lead the industry forward with our comprehensive suite of integrated compliance solutions—helping clients scale new heights with confidence.
Click on Apply to know more.