1 month ago
Chennai, IndiaSenior
Responsibilities
- Develop and maintain dbt data models for cleaning, transforming, and structuring data in Snowflake.
- Design and implement ETL/ELT pipelines from APIs, data lakes, and on-premise systems into Snowflake.
- Write efficient SQL and Snowflake-specific SQL for data extraction and transformation.
- Perform data validation, integrity checks, and testing of dbt models and Snowflake data objects.
- Collaborate with data engineers, analysts, and architects to deliver scalable data solutions.
- Automate dbt project deployment through CI/CD pipelines and schedule workflows with orchestration tools such as Apache Airflow.
Requirements
- Strong SQL expertise, including familiarity with Snowflake-specific SQL or SnowSQL.
- Hands-on experience with dbt for data transformation and model management.
- Familiarity with cloud platforms, especially AWS.
- Knowledge of data warehousing, dimensional modeling, and star and snowflake schemas.
- Experience with orchestration tools such as Apache Airflow is preferred.
- Python, Git, and data governance knowledge are beneficial.
- A bachelor's degree in Business Analytics, Computer Science, or Statistics, or a master's degree in Data Science.
- Proficiency in English at C2 level.
Benefits
- Regular employment with a hybrid work arrangement in India.
- Day-shift work schedule.
- Hands-on experience, mentorship, and learning opportunities.
- Opportunity to work on AI-powered transformation and enterprise business challenges.
- Values-driven environment focused on integrity, inclusion, collaboration, and innovation.
Categories
Data Engineering
About Genpact
Genpact is a global professional services and technology firm that runs and transforms mission-critical operations for large enterprises through consulting, managed services, and AI- and analytics-driven platforms. It serves industries such as banking, insurance, healthcare, and manufacturing/supply chain, modernizing finance, risk, customer service, and back-office processes. Headquartered in New York and listed on the NYSE (G), Genpact originated within GE before becoming an independent public company.