Data Engineer Senior Consultant
Posted on:
30+ days ago
Vacancies:
1 Vacancy
Job Summary
Overview:
TekWissen is a global workforce management provider throughout India and many other countries in the world. The below job opportunity is to one of our clients who is a part of a trusted global innovator of IT and business services headquartered in Tokyo. We help clients transform through consulting industry solutions business process services IT modernization and managed services. This client enables us to move confidently into the digital future. This client committed to Long Term success and combine global reach with local client attention to serve them in over 50 Countries.
Position: Data Engineer Senior Consultant
Location: Hyderabad/Bangalore
Work Type: Hybrid
Job Type: Full Time
Job Description:
Responsibilities of the Engineer includes:
- Pipeline MigrationLogic & Scheduling: Refactoring and migrating extraction logic and job scheduling from legacy frameworks to the new Lakehouse environment.
- Data Transfer: Executing the physical migration of underlying datasets while ensuring data integrity.
- Stakeholder Engagement: Acting as a technical liaison to internal clients facilitating handoff and sign-off conversations with data owners to ensure migrated assets meet business requirements.
- Consumption Pattern MigrationCode Conversion: Translating and optimizing legacy SQL and Spark-based consumption patterns (raw and modeled) for compatibility with Snowflake and Iceberg.
- Usage analysis: Understand usage patterns to deliver the required data products.
- Stakeholder Engagement: Acting as a technical liaison to internal clients facilitating handoff and sign-off conversations with data owners to ensure migrated assets meet business requirements.
- Data Reconciliation & QualityA rigorous approach to data validation is required.
- Candidates must work with reconciliation frameworks to build confidence that migrated data is functionally equivalent to that already used within production flows.
- Engineer will also need to work with our other internal data management platform and must have an aptitude for learning new workflows and language constructs as necessary.
- Technical Skills:Basic QualificationsEducation: Bachelors or Masters degree in Computer Science Applied Mathematics Engineering or a related quantitative field.
- Experience: Minimum of 3-5 years of professional hands-on-keyboard coding experience in a collaborative team-based environment.
- Ability to trouble shoot (SQL) and basic scripting experience.
- Languages: Professional proficiency in Python or Java.
- Methodology: Deep familiarity with the full Software Development Life Cycle (SDLC) and CI/CD best practices & K8s deployment experience.
- Core Data Engineering Competencies: Candidates must demonstrate a sophisticated understanding of the following modeling concepts to ensure data correctness during reconciliation
- Temporal Data Modeling: Managing state changes over time (e.g. SCD Type 2).
- Schema Management: Expertise in Schema Evolution (Ref: Iceberg Apache) and enforcement strategies.
- Performance Optimization: Advanced knowledge of data partitioning and clustering.
- Architectural Theory: Balancing Normalization vs. Denormalization and the strategic use of Natural vs. Surrogate Keys.
- Technical Stack Requirements: While candidates are not expected to be experts in every tool the collective team must cover the following technologies:
- Extraction & LogicKafka ANSI SQL FTP Apache SparkData FormatsJSON Avro ParquetPlatformsHadoop (HDFS/Hive) Snowflake Apache Iceberg Sybase IQCore
- Competencies:Demonstrates strong integrity and consistently models good conduct and ethical decision-making.
- Acts as a trusted team player who collaborates effectively across multiple teams and functions.
- Communicates with clarity and confidence
- concise written updates structured verbal briefings and proactive stakeholder management.
- Works effectively with global teams across time zones and cultures; builds alignment and resolves issues constructively.
- Delivery-focused with a strong sense of ownership; drives work to closure and meets commitments.
- Brings high energy and urgency to achieve targets while maintaining quality and professionalism.
- Shows intellectual curiosity; asks thoughtful questions surfaces risks early and seeks feedback to continuously improve.
TekWissen Group is an equal opportunity employer supporting workforce diversity.