Data Engineer

Company Description : About Apexon: Apexon is an AI-first technology services firm that engineers intelligent enterprises. Our interconnected disciplines of Domain & Strategy, Cognitive Architecture, and Harness Engineering guide every engagement, helping clients deliver meaningful business outcomes while applying collective intelligence to confidently scale from early AI strategies to enterprise-grade production systems. For over three decades, we have helped organizations by leveraging our deep and practical expertise in Artificial Intelligence, Data & Analytics, Digital Engineering, and Experience, combined with our industry knowledge across Banking & Financial Services, Healthcare and Life Sciences to create lasting business value. Apexon is backed by Goldman Sachs Asset Management and Everstone Capital. Engineer will be part of the datastore-migration Factory team that will be responsible to perform for the end-to end datastore migration from on-prem DataLake to AWS hosted LakeHouse. This is a high visibility and crucial project for Goldman Sachs. Responsibilities of the Engineer include: 1. Pipeline Migration a. Logic & Scheduling: Refactoring and migrating extraction logic and job scheduling from legacy frameworks to the new Lakehouse environment. b. c. Data Transfer: Executing the physical migration of underlying datasets while ensuring data integrity. Stakeholder Engagement: Acting as a technical liaison to internal clients, facilitating "hand-off and sign-off" conversations with data owners to ensure migrated assets meet business requirements. 2. Consumption Pattern Migration a. Code Conversion: Translating and optimizing legacy SQL and Spark-based consumption patterns (raw and modeled) for compatibility with Snowflake and Iceberg. b. Usage analysis: Understand usage patterns to deliver the required data products. c. Stakeholder Engagement: Acting as a technical liaison to internal clients, facilitating "hand-off and d. sign-off" conversations with data owners to ensure migrated assets meet business requirements. Data Reconciliation & Quality 3. A 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 internal data management platforms team and must have an aptitude for learning new workflows and language constructs as necessary. Technical Skills: 1. Basic Qualifications A. Education: Bachelor’s or Masters in Computer Science, Applied Mathematics, Engineering, or a related quantitative field. B. 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. c.Languages: Professional proficiency in Python or Java. d.Methodology: Deep familiarity with the full Software Development Life Cycle (SDLC) and CI/CD best practices & K8s deployment experience. 2. Core Data Engineering Competencies: Candidates must demonstrate a sophisticated understanding of the following modeling concepts to ensure data correctness during reconciliation: A. Temporal Data Modeling: Managing state changes over time (e.g., SCD Type 2). B. Schema Management: Expertise in Schema Evolution (Ref: Iceberg Apache) and enforcement strategies. c.Performance Optimization: Advanced knowledge of data partitioning and clustering. d.Architectural Theory: Balancing Normalization vs. Denormalization and the strategic use of Natural vs. Surrogate Keys. 3. Technical Stack Requirements: While candidates are not expected to be experts in every tool, the collective team must cover the following technologies: Extraction & Logic Kafka, ANSI SQL, FTP, Apache Spark Data Formats JSON, Avro, Parquet Platforms Hadoop (HDFS/Hive), Snowflake, Apache Iceberg, Sybase IQ Core 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. Our Commitment to Diversity & Inclusion: Did you know that Apexon has been Certified™ by Great Place To Work®, the global authority on workplace culture, in each of the four regions in which it operates: USA (for the seventh time in 2026), India (for the tenth consecutive time in 2026), the UK(for the fourth time in 2026) and Mexico (for the second time in 2026). Apexon is committed to being an equal opportunity employer and promoting diversity in the workplace. We take affirmative action to ensure equal employment opportunity for all qualified individuals. Apexon strictly prohibits discrimination and harassment of any kind and provides equal employment opportunities to employees and applicants without regard to gender, race, color, ethnicity or national origin, age, disability, religion, sexual orientation, gender identity or expression, veteran status, or any other applicable characteristics protected by law. You can read about our Job Applicant Privacy policy here Job Applicant Privacy Policy (apexon.com) Our Commitment to Environment: Actively contribute to Apexon's commitment to environmental responsibility by following sustainable practices and supporting ESG initiatives. Our Perks and Benefits: Our benefits and rewards program has been thoughtfully designed to recognize your skills and contributions, elevate your learning/upskilling experience and provide care and support for you and your loved ones. As an Apexon Associate, you get continuous skill-based development, opportunities for career advancement, and access to comprehensive health and well-being benefits and assistance. We also offer: o Group Health Insurance covering family of 4 o Term Insurance and Accident Insurance o Paid Holidays & Earned Leaves o Paid Parental LeaveoLearning & Career Development o Employee Wellness Job Location : Bengaluru, India Disclaimer : If you feel that this is a good match for your skillsets, please submit a current word version of your resume along with a cover letter describing your skills, experience and salary expectations. We are an Equal Opportunity Employer (EOE). You can read our job applicant privacy policy here . Disclaimer --> If you feel that this is a good match for your skillsets - please send a current word version of your resume along with a cover letter describing your skills, experience and salary expectations. We are an Equal Opportunity Employer (EOE) --> Disclaimer: If you feel that this is a good match for your skillsets, please submit a current word version of your resume along with a cover letter describing your skills, experience and salary expectations. We are an Equal Opportunity Employer (EOE). You can read our job applicant privacy policy here . --> Disclaimer: If you feel that this is a good match for your skillsets, please submit a current word version of your resume along with a cover letter describing your skills, experience and salary expectations. We are an Equal Opportunity Employer (EOE). You can read our job applicant privacy policy here . -->