Principal Consultant-Lead Data Engineer

5-10 years
a month ago 2 Applied
Job Description

With a startup spirit and 115,000+ curious and courageous minds, we have the expertise to go deep with the world&rsquos biggest brands&mdashand we have fun doing it. We dream in digital, dare in reality, and reinvent the ways companies work to make an impact far bigger than just our bottom line. We&rsquore harnessing the power of technology and humanity to create meaningful transformation that moves us forward in our pursuit of a world that works better for people. Now, we&rsquore calling upon the thinkers and doers, those with a natural curiosity and a hunger to keep learning, keep growing., People who thrive on fearlessly experimenting, seizing opportunities, and pushing boundaries to turn our vision into reality. And as you help us create a better world, we will help you build your own intellectual firepower.

Welcome to the relentless pursuit of better.

Inviting applications for the role of Principal Consultant, Lead Data Engineer !

In this role, the Senior Data Engineer is responsible for providing technical direction and lead a group of one or more developer to address a goal.


  • .Design, develop, and automate ETL processes using DBT and AWS

  • .Build robust data pipelines to move data from various sources to data warehouses or data lakes.

  • .Collaborate with cross-functional teams to ensure data accuracy, completeness, and consistency.

  • .Perform data cleansing, validation, and transformation to ensure data quality and integrity.

  • .Optimize database and query performance to ensure efficient data processing.

  • .Work with data analysts and data scientists to provide clean, reliable data for analysis and modelling.

  • .Writing SQL queries against Snowflake, developing scripts to do Extract, Load, and Transform data.

  • .Hands-on experience with Snowflake utilities such as SnowSQL, SnowPipe, Tasks, Streams, Time travel, Cloning, Optimizer, Metadata Manager, data sharing, stored procedures and UDFs.

  • .Have experience with Snowflake cloud data warehouse and AWS S3 bucket or Azure blob storage container for integrating data from multiple source system

  • .Should have good experience in Python/Pyspark.integration with Snowflake and cloud(AWS/Azure)

  • .Sound understanding of ETL tools / Data integration techniques.

  • .Work with business stakeholders to understand data requirements and develop ETL solutions

  • .Strong programming skills in languages such as Python, Java, and/or Scala.

  • .Experience with big data technologies such as Kafka.

  • .Experience with cloud computing platforms such as AWS.

  • .Familiarity with database technologies such as SQL, NoSQL, and/or Graph databases.

  • .Experience in requirement gathering, analysis, designing, development, and deployment.

  • .Should Have experience building data ingestion pipeline

  • .Good to have experience in deployment using CI/CD tools: Azure boards, Github and write automated test cases wherever applicable.

  • .Have experience in client facing projects.

  • .Have experience on Snowflake Best Practices

Qualifications we seek in you !

Minimum qualifications

  • .B.E./ Masters in Computer Science, Information technology, or Computer engineering or any equivalent degree with IT experience and relevant working experience as Senior Snowflake Data Engineer.

Preferred Qualifications/Skills

  • .Experience in IT industry

  • .Working experience with building productionized data ingestion and processing data pipelines in Snowflake

  • .Fully well-versed with data warehousing concepts.

  • .Expertise and excellent understanding of Snowflake features and integration of Snowflake with other data processing.

  • .Able to create the data pipeline for ETL.

  • .Excellent presentation and communication skills, both written and verbal Ability to problem solve and architect in an environment with unclear requirements.

  • .Able to create the high level and low-level design document based on requirement.

  • .Hands on experience in configuration, troubleshooting, testing and managing data platforms, on premises or in the cloud.

  • .Awareness on data visualisation tools and methodologies

  • .Work independently on business problems and generate meaningful insights

  • .Snowflake SnowPro Core Certification will be an added advantage.

Skill Metrix:

DBT, Snowflake, Python/PySpark, AWS/Azure/GCP, ETL, Data Warehousing concepts

Genpact is an Equal Opportunity Employer and considers applicants for all positions without regard to race, color, religion or belief, sex, age, national origin, citizenship status, marital status, military/veteran status, genetic information, sexual orientation, gender identity, physical or mental disability or any other characteristic protected by applicable laws. Genpact is committed to creating a dynamic work environment that values diversity and inclusion, respect and integrity, customer focus, and innovation. For more information, visit . Follow us on , , , and .

Furthermore, please do note that Genpact does not charge fees to process job applications and applicants are not required to pay to participate in our hiring process in any other way. Examples of such scams include purchasing a %27starter kit,%27 paying to apply, or purchasing equipment or training.

Job Source:

Genpact is an American professional services firm legally domiciled in Bermuda with its headquarters in New York City, New York. The company currently employs more than 100,000 people and provides services to clients in over 30 countries worldwide

People Also Considered

Career Advice to Find Better