ETL & Database Developer (Informatica / Greenplum / Cloud)
Core
Designing and maintaining scalable ETL pipelines and data workflows for large-scale datasets in a financial services environment.
Role type
Senior ETL & Database Developer (Informatica/Greenplum/Cloud)
Builds
Production data pipelines, optimized SQL models, and cloud data warehouse solutions
Domain
Financial services, Data Engineering, Cloud Data Warehousing
Deliverable
production ML models | product features | dashboards & analysis
Required skills
Informatica ETL development, Greenplum/MPP database tuning, SQL query optimization, Cloud data platforms (Redshift/Snowflake), Linux shell scripting, Job scheduling (Autosys/Control-M/Airflow), Production support, Data governance compliance
Preferred skills
Airflow orchestration, Kafka streaming, Enterprise data quality frameworks, Financial dataset knowledge (Transactions/Positions/Corporate Actions), Monitoring tools (Splunk/Dynatrace/AppDynamics), Agile/DevOps practices
Technologies
Informatica, Greenplum, PostgreSQL, Amazon Redshift, Snowflake, Autosys, Control-M, Airflow, Kafka, Splunk, Dynatrace, AppDynamics
Responsibilities
Develop and maintain ETL pipelines and data workflows using Informatica; Build, optimize, and tune SQL queries, stored procedures, and data models in Greenplum/PostgreSQL; Work with cloud-based data platforms such as Amazon Redshift and Snowflake; Ensure data quality, performance tuning, and compliance with data governance standards; Troubleshoot ETL failures, analyze root causes, and provide timely fixes; Perform application support activities including batch/job monitoring, incident triage, and resolution of job failures; Collaborate with operations teams to ensure smooth execution of daily, weekly, and monthly data loads; Identify recurring production issues and implement long-term preventive solutions; Partner with cross-functional teams to support production releases and data pipeline enhancements
Seniority
Senior, hands-on IC
