ETL Developer
Job Summary
Job Description
- Design, develop, and maintain ETL processes.
- Write code for mass scale ETL processes.
- Perform translation of non-standard data into internal data standard formats.
- Understand the technology and data modeling behind the core system.
- Identify and implement areas lacking automation.
- Be available for weekend on-call shifts on a rotational basis.
- Possess 3-5 years of IT experience.
- Comfortable with bash scripting and using FTP/FTPS/SFTP and encryption utilities.
- Experience with Java and any ETL tool.
- Understanding of data formats: XML/JSON/CSV/Excel.
- Experience with Python and Data warehousing.
- Proficiency in SQL.
- Computer Science/Engineering background.
- Exposure and experience to finance.
9 skills required
Job Details
ETL Developer
At Clearwater Analytics, we are on a mission to become the world's most trusted and comprehensive technology platform for investment management, reporting, accounting, and analytics. We partner with sophisticated institutional investors worldwide and are seeking ETL Developer who shares our passion for innovation and client commitment.
The Role:
The role of an ETL (Extract, Transform, Load) Developer at Clearwater Analytics involves designing, developing, and maintaining ETL processes to support the organization's data integration and data warehousing needs. ETL Developers play a crucial role in ensuring the efficient extraction, transformation, and loading of data from various sources into target systems. In this role, you will help Clearwater Analytics team with the importing and exporting of portfolio level information (trades, positions etc) along with reconciliation of that information. This will require an understanding of finance along with a strong grasp of technology, specifically ETL tools.
Responsibilities:
- ### Write code for mass scale ETL processes
- ### Java
- ### Bash
- ### SQL
- ### Kettle - Pentaho
- ### Perform translation of non standard data into internal data standard formats
- ### Learn how the technology and data modeling behind the core of the system works.
- ### Identify and implement areas lacking automation.
- ### Weekend on-call shift on a rotational basis
Required Skills:
- ### 3-5 yrs. IT experience
- ### Computer Science/Engineering background (preferred)
- ### Exposure and experience to finance (preferred)
- ### You should be comfortable bash scripting and using FTP/FTPS/SFTP and encryption utilities.
- ### Experience with Java
- ### Experience on any ETL tool
- ### Understanding of data formats: XML/JSON/CSV/Excel
- ### Python and Data warehousing
- ### SQL
Welcome
Thank you for your interest in a career with Clearwater!
About us
Clearwater Analytics (NYSE: CWAN) is transforming investment management with the industry’s most comprehensive cloud-native platform for institutional investors across global public and private markets. While legacy systems create risk, inefficiency, and data fragmentation, Clearwater’s single-instance, multi-tenant architecture delivers real-time data and AI-driven insights throughout the investment lifecycle. The platform eliminates information silos by integrating portfolio management, trading, investment accounting, reconciliation, regulatory reporting, performance, compliance, and risk analytics in one unified system. Serving leading insurers, asset managers, hedge funds, banks, corporations, and governments, Clearwater supports over $8.8 trillion in assets globally. Learn more at **www.clearwateranalytics.com
**.
Read More
Don’t meet every single requirement?
Studies have shown that women and people of color are less likely to apply to jobs unless they meet every single qualification. We are dedicated to building a diverse, inclusive and authentic workplace, so if you’re excited about this role but your past experience doesn’t align perfectly with the job description, we encourage you to still apply! You may be just what we're looking for.
Read More
Similar Jobs
Looks like we're out of matches
Similar Skill Jobs
Looks like we're out of matches
Jobs in Mumbai, Maharashtra, India
Looks like we're out of matches
Programming Jobs
Looks like we're out of matches
About The Company
Clearwater Analytics (NYSE: CWAN) is the leading provider of web-based investment portfolio accounting, reporting, and reconciliation services for institutional investors at thousands of organizations.
Clearwater aggregates, reconciles, and reports on more than $6.4 trillion in assets across thousands of accounts daily. Our clients include corporate treasuries, insurance companies, investment managers, banks, governments, and other institutional investors both in the United States and worldwide.
For more than a decade, we have leveraged web-based software and world-class client service to help clients such as American Family Insurance, Arch Capital, C.V. Starr & Co., Cisco, Facebook, Oracle, Selective Insurance, Sirius Group, Sompo International, Starbucks, WellCare Health Plans, Wilton Re, and many others, streamline their investment and accounting operations. Clearwater also works with hundreds of custodians, investment managers, dealers/brokers, and electronic trading portals who offer Clearwater to their many clients.
With global headquarters in Boise, Idaho, and offices in Edinburgh, Frankfurt, London, New Delhi, New York, Paris, Seattle, Singapore, and Washington D.C., Clearwater sets the new global standard for investment portfolio reporting.
Get notified when new jobs are added by Clearwater Analytics
