Data Engineering Advisor

• 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.

Qualifications

Required Experience & Education:

• 11 - 13 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)