Software Engineer - Data Engineer

Software Engineer - Data Engineer-075901 Description Job Description: As a Senior Engineer, you will build distributed data processing solution and highly loaded database solutions for various cases including reporting, product analytics, marketing optimization and financial reporting. Supply as part of self-organized team of authority data engineers working in an exciting, innovative environment for our client, creating the foundation for decision-making at a company dealing with billions of events per day. Investigate, create, and implement the solutions for existing technical challenges. Provide guidance, instruction, direction, leadership to a development team with the purpose of achieving project goals. Responsibilities: Obtains tasks from the project lead or Team Lead (TL), prepares functional and design specifications, approves them with all customers. Ensures that assigned area/areas are delivered within set deadlines and required quality objectives. Provides estimations, agrees task duration with the manager and gives to project plan of assigned area. Analyzes scope of alternative solutions and makes decision about area implementation based on their experience and technical expertise. Leads functional and architectural design of assigned areas. Makes sure design decisions on the project meet architectural and design requirements. Addresses area-level risks, provides and implements mitigation plan. Reports about area readiness/quality, and raises red flags in crisis situations which are beyond their AOR. Responsible for resolving crisis situations within their AOR. Initiates and conducts code reviews, creates code standards, conventions, and guidelines. Suggests technical and functional improvements to give to the product. Constantly improves their professional level. Collaborates with other teams. Requirements: 5+ years of professional experience. University degree or equivalent experience in Computer Related Sciences or similar. Advanced proficiency in Complex SQL In-depth knowledge of Data Warehousing and Data Modeling techniques Proficiency in Python programming languages. Proficiency in Airflow for efficient workflow automation Experience with Spark/EC2/S3 will be effective. Expertise in Analytics and Reporting Familiarity with Snowflake/Databricks proven experience in ETL orchestration and workflow management tool Airflow. Authority in Database fundamentals, SQL and distributed computing. Experience in Spark, Snowflake & Databricks. Excellent communication skills and experience working with technical and non-technical teams. Able to clear hacker rank code test. Experience in AWS (EC2/S2/IAM) would be plus. confirmed experience with the Distributed data/similar ecosystem (Hive, Presto) and/or streaming technologies such as Kafka/Flink- would be plus. Experience working with Redshift, PostgreSQL and/or other DBMS platforms would be plus. Life at Capgemini Capgemini supports all aspects of your well-being throughout the changing stages of your life and career. For eligible employees, we offer:  Collaborating with teams of creative, fun, and driven colleagues Flexible work options enabling time and location-based flexibility Company-provided home office equipment  Virtual collaboration and productivity tools to enable hybrid teams Comprehensive benefits program (Health, Welfare, Retirement and Paid time off)  Other perks and wellness benefits like discount programs, and gym/studio access. Paid Parental Leave and coaching, baby welcome gift, and family care/illness days Back-up childcare/elder care, childcare discounts, and subsidized virtual tutoring  Tuition assistance and weekly hot skill development opportunities Experiential, high-impact learning series events Access to mental health resources and mindfulness programs Access to join Capgemini Employee Resource Groups around communities of interest