Design and implement ETL processes to extract, transform, and load data from various sources.Collaborate with cross-functional teams to understand data requirements and deliver solutions.Optimize and maintain existing ETL workflows for improved efficiency and performance.Ensure data integrity and quality through rigorous testing and validation.Create and implement best practices to ensure successful delivery and support of large data transformation layer.Collaborate with other team members to ensure timely and successful delivery of production ready applications.Prepare detailed technical documentation.Required Experience & Education :
- 8 - 1 1 years of relevant ETL development using Informatica and / or SSIS.
- Hands-on experience with building data integration solutions using Dell Boomi.
- Experience with Relational Database Development - Oracle, Teradata, SQL Server required .
- Strong understanding of database concepts and experience with query optimization and performance tuning.
- Hands-on experience with scripting languages like Python.
- Hands on experience with Databricks and Airflow monitoring.
- Excellent problem-solving skills and the ability to analyze complex issues and implement effective solutions.
Required Skills :
- Informatica, SSIS, SQL (SQL Server, Oracle, Teradata)
- Any experience with Dell Boomi.
- Performance Tuning, Issue Resolution
- Python, Databricks, DevOps, Basic Cloud Experience (AWS / Azure)
Preferred Skills , Experience & Education :
- Cloud Certification (AWS Cloud Practitioner or similar)
Skills Required
Python, Dell Boomi, Databricks, Informatica, Ssis, Sql