Senior/Lead Data Engineer (7-10 yrs)

Job Description :

We are seeking a highly skilled Senior Lead Data Engineer to oversee the design, development, and optimization of our data infrastructure and integration processes. This role requires extensive experience in data engineering, leadership abilities, and proficiency in modern data technologies. Join us to drive innovation and lead a dynamic team in delivering robust data solutions.

Primary Skills : Azure, ADF, Databricks, DBT

Secondary Skills : AWS, Snowflake

The Lead Data Engineer will be responsible for overseeing the design, development, and maintenance of our data infrastructure and pipelines. This role requires strong technical expertise, leadership skills, and the ability to work collaboratively with cross-functional teams to ensure efficient and reliable data processes

- Design, develop, and maintain data integration pipelines and ETL/ELT workflows.

- Lead more than one project or manage a larger team that might have sub-tracks.

Role Requirement :

- Proficient in basic and advanced SQL.

- Proficient in using Python for data integration and data engineering tasks.

- Proficiency in ETL/ELT tools such as Informatica, Talend, SSIS, DBT, Databricks or equivalent.

- Experience with relational databases (like SQL Server, Oracle, MySQL, PostgreSQL) and NoSQL databases (like MongoDB, Cassandra), cloud databases (RedShift, Snowflake, Azure SQL).

- Familiarity with big data technologies like Hadoop, Spark, Kafka, and cloud platforms such as AWS, Azure, or Google Cloud. Solid understanding of data modeling, datawarehousing concepts, and practices.

- Good Knowledge and Understanding of Data warehouse concepts (Dimensional Modeling, change data capture, slowly changing dimensions etc.).

- Knowledgeable in performance tuning and optimization

- Experience in Data Profiling and Data validation

- Experience in requirements gathering and documentation processes and performing unit testing.

- Understanding and Implementing QA and various testing process in the project.

- Knowledge in any BI tools will be an added advantage.

- Sound aptitude, outstanding logical reasoning and analytical skills.

- Additional Requirement :

- Willingness to learn and take initiatives.

- Ability to adapt to fast-paced Agile environment.

- Relevant certifications in data engineering or cloud platforms are a plus.

- Minimum of 8 to 10 years of experience in data engineering, focusing on data integration, data warehousing, and big data technologies.

- At least 3-5 years in a leadership role, demonstrating the ability to manage and mentor engineering teams and lead complex projects