Position: Data Warehouse Engineer/ Data Engineer / ETL Developer
Category: Data Engineer
English level: fluent
Years of experience: 4


Experience:
• 2+ Amazon Web Services (S3, Glue, Athena, Lambda, CLI, Management Console, Systems Manager, Lake Formation, RedShift, IAM) + Terraform
• 2+ PostgreSQL (perfomance tuning)
• 2+ Apache Airflow (Python), Apache NiFi , Apache Zeppelin, Apache Kafka
• 2+ Grafana Dashboard Monitoring, Git (CI/CD with GitLab), Prometheus, Kibana, Docker, Kubernetes (Lens, Rancher, k9s), Tableau (Service Management)
• Integrations:
 Microsoft Dynamics with Oracle
 Salesforce with PostgreSQL (SOAP API)
 Salesforce with Amazon Web Services (Lambda)
 Google API to S3 Transfer

• 3+ Oracle Database 11/ETL (SQL, PL/SQL, performance issue resolution)
• Data Warehousing ETL experience of using Informatica Powercenter
• Troubleshoot and tune complex database query performance issues
• Handling numerous enhancement and maintenance requests, data updates, bug fixes
• Full cycle of SDLC / ITIL (GIT, Jira/Trello, Mantis, UML)
• Backlog / Incident / Change Request management (PagerDuty)
• Conduction meetings with USA / EU stakeholders and presentation the results in BRD / TDD.
• Gathering, analysis and documentation of functional and business requirements (Confluence)
• PM/Business Users' assistance in optimizing the scope, benefits and risks of proposed projects.
• Strong communication skills with USA, EU, Indian clients


Key skills
Backlog / Incident / Change Request management, SDLC establishment and follow-up, Application / Support development, Work with local and remote/distributed teams, Fluent English/French (C2/C1).

Amazon Web Services, Apache Airflow, PostgreSQL, Oracle, PL/SQL, SQL, Trade Data Warehouse (DWH), GIT, ITIL, Informatica Powercenter