Sr. Data Engineer 4B

Overview

Sr. Data Engineer role at Genpact focused on expanding and optimizing data and data pipeline architecture, improving data flow and collection, and supporting data science and business stakeholders.

What you'll do

• Maintain and provide enhancements to data architecture within new and existing systems, including the Data Warehouse.
• Recommend and implement processes to improve data quality, data reliability, and database performance.
• Employ a variety of ETL and integration tools for system and data integrations.
• Architect solutions that support data scientists and business stakeholders.
• Conduct ETL testing and data transformation testing.
• Develop data models for the data science team that can be utilized for data mining.
• Maintain source-to-target documentation and process flow documentation.
• Take on DBMS responsibilities, including serving as SQL Server DBA for processes, jobs, error handling, troubleshooting and scheduling.
• Proactively monitor ETL processes and jobs.

What you'll need

• Relevant hands-on work experience in a Datawarehouse testing role.
• ETL (Extract Transform Load) / ODS (Operational Data Store) experience.
• MS SQL Server experience.
• Bachelor's degree in computer science or information technology from an accredited institution.
• ETL tools: SSIS and Azure Data Factory (ADF), including API source exposure.
• Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL), and working familiarity with a variety of databases.
• Working knowledge of Azure.
• Proficient in Azure Managed MS SQL Server database, including setting indexes, database security, and backups.
• Fundamental knowledge of data warehouse concepts.
• Experience in data quality, source systems analysis, and business rules validation.
• Ability to write and understand source-to-target documentation.
• Detail oriented and meticulous approach to duties.
• Familiarity with data and cybersecurity.
• Good analytical skills.
• Ability to work independently and in groups.
• Capacity to manage a pipeline of duties with minimal supervision.
• English language proficiency (Required; Proficient, C2).

Nice to have

• Commercial Real Estate experience.
• ZappySys.
• C#.
• Microsoft Fabric.
• Azure Logic App and Azure Function.

Details

• Location: DLF Commercial Building 3, Phase V, Gurugram, India.
• Job type: Regular; Day shift (India).
• Work location type: Office work.