Data Engineer - ETL (7-9 yrs)

Renous is looking to hire a Data engineer for an MNC client

Job Location : Bangalore

Job type : C2H

The ideal candidate should have 7+ years of hands-on experience with Data Engineering expertise using ELT/ETL tools requirements for analytics/reporting and is well versed with Matillion, AWS, Python and Snowflake.

1. Optimize Existing SQL Server Environment :

- Analyse and resolve performance issues in the current SQL Server databases.

- Implement governance and data quality checks.

2. Setup Reporting Database :

- Create a reporting database ensuring the new database supports all reporting and analytics requirements.

3. Support Existing Systems :

- Utilize SSIS, SSRS, and related tools for data integration and reporting tasks.

- Manage and monitor MS-SQL Server jobs and scheduling tools.

4. Cloud Data Warehousing on AWS :

- Implement a scalable, cloud-native data warehousing solution using AWS services like AWS Glue, Redshift, Lake Formation, and S3.

- Develop ETL/ELT pipelines and integrate data sources for analytics and reporting.

5. Data Governance and Security :

- Establish and enforce robust data governance policies.

- Ensure data security and compliance with relevant regulations.

6. Performance Optimization :

- Monitor and optimize the performance of both on-premises and cloudbased data systems.

7. Collaboration & Leadership :

- Collaborate with stakeholders to gather requirements and deliver effective solutions.

- Act as a technical expert and mentor for junior team members.

Required Skills & Qualifications :

Technical Expertise :

- Advanced knowledge of SQL Server, including replication technologies (e.g., merge replication).

- Proficiency in SSIS, SSRS, and other SQL Server tools.

- Strong understanding of AWS cloud services for data engineering (e.g., AWS Glue, Redshift, Athena, S3, and Lake Formation).

- Expertise in ETL/ELT processes and automation.

- Proficient in data modelling, query optimization, and database performance tuning.

Data Governance & Security :

- Strong understanding of data governance frameworks and compliance standards.

- Experience with securing data on cloud platforms.

Soft Skills :

- Excellent problem-solving and analytical skills.

- Strong communication skills for working with technical and non-technical stakeholders.

- Ability to work independently and deliver solutions with minimal supervision.

Preferred Qualifications :

- Experience in database migration to cloud native platforms.

- Familiarity with reporting tools like Power BI or third-party visualization tools.

- Knowledge of big data technologies and real-time data processing.

- AWS Data Engineering certification or equivalent is a plus.