SMSTR76 - Senior Software Engineer

We are hiring an ETL Developer / Data Engineer to build and support the data pipelines behind our fee management platform for large global investment banks. You will ingest, transform, and process high-volume financial data from flat files, databases, and APIs, ensuring accurate and timely delivery to internal teams and clients.

Key Responsibilities

• Design, develop, and maintain ETL pipelines using Talend and Informatica.
• Build data processing workflows using Python and Spark/PySpark for large financial datasets.
• Ingest and integrate data from flat files, relational databases, and APIs.
• Develop complex SQL queries, stored procedures, and database objects to support data processing and analytics.
• Work with structured and semi-structured datasets in cloud and on-premise environments.
• Collaborate with business, operations, and technology teams to understand data requirements and ensure data quality.
• Troubleshoot and optimize ETL jobs, database performance, and data processing workflows.
• Support cloud-based data platforms and participate in modernization initiatives.
• Drive adoption of Al-enabled development practices

Requirements

• 4+ years of experience in Data Integration and Data Engineering.
• Hands-on experience with Talend or Informatica PowerCenter.
• Working knowledge of Apache Spark / PySpark for large-scale data processing.
• Proficiency in Python for data processing and automation.
• Experience handling flat files, database sources, and API integrations.
• Strong SQL skills, including complex queries, CTEs, joins, window functions, and performance tuning.
• Solid database experience with relational databases such as Oracle and PostgreSQL.
• Experience with cloud platforms such as AWS and Microsoft Azure.
• Experience with job scheduling and orchestration tools such as Airflow and Control-M.

Good to Have Skillsets:

• Experience in the Financial Services / Banking domain.
• Experience with data warehousing concepts, data modeling, and data quality frameworks.
• Experience with Git and CI/CD practices for data pipelines.
• Experience with BI tools such as Power BI and Tableau.

Equality Statement: Smartstream is an equal opportunities employer. We are committed to promoting equality of opportunity and following practices which are free from unfair and unlawful discrimination.