The Gebbs Consulting Data Engineer interview guide, interview questions, salary data, and interview experiences.

Gebbs Consulting Data Engineer Interview Guide

Getting ready for an Data Engineer interview at Gebbs Consulting? The Gebbs Consulting Data Engineer interview span across 10 to 12 different question topics. In preparing for the interview:
<ul>
<li>Know what skills are necessary for Gebbs Consulting Data Engineer roles.</li>
<li>Gain insights into the Data Engineer interview process at Gebbs Consulting.</li>
<li>Practice real Gebbs Consulting Data Engineer interview questions.</li>
</ul>
Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the Gebbs Consulting Data Engineer interview.


Getting ready for an Data Engineer interview at Gebbs Consulting? The Gebbs Consulting Data Engineer interview span across 10 to 12 different question topics. In preparing for the interview:

- Know what skills are necessary for Gebbs Consulting Data Engineer roles.
- Gain insights into the Data Engineer interview process at Gebbs Consulting.
- Practice real Gebbs Consulting Data Engineer interview questions.

Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the Gebbs Consulting Data Engineer interview.
        

Overview

What Gebbs Consulting Looks for in a Data Engineer

We've gathered this data from parsing thousands of interview experiences sourced from members.

We've gathered this data from parsing thousands of interview experiences sourced from members.

Gebbs Consulting Data Engineer Interview Process

Interview Tips

You are tasked with keeping track of a customer’s addresses in your database.

However, customer’s addresses change whenever they move. We want to keep track of their moving history as well as the person that moves in afterwards.

How would you create or modify a schema to keep track of these address changes?

Create a schema to keep track of customer address changes

Address Schema

Data Modeling

Let’s say Accenture has a data pipeline that ingests raw sales data from multiple retail clients, processing 10 million records each night to generate daily sales dashboards for client teams. For the past week, the pipeline has been consistently failing at the data transformation stage.

How would you go about systematically diagnosing and resolving the root cause of these failures?

How would you systematically diagnose and resolve repeated failures in a nightly data transformation pipeline?

Pipeline Transformation Failures

Batch & Stream Processing

You’re tasked with designing a database system for Swipe Inc., a company that manages payments for software developers. Swipe manages a set of APIs so developers can abstract payment processes for their web service and transfer control over to Swipe’s APIs to manage payment security and finance handling (contacting credit card providers, etc.)

Your database system should store a collection of API keys with their attributes, as shown in the example below:

<pre tabindex="0" class="chroma"><code>{
 &#34;API_key&#34;:{
 &#34;Transaction_list&#34;:{
 &#34;User_ID&#34;:{
 &#34;Name&#34;:{
 &#34;f_name&#34;: 
 &#34;l_name&#34;: 
 }
 &#34;Card_Details&#34;:{
 &#34;Bank&#34;:
 &#34;Card_No&#34;:
 &#34;Expiry&#34;:
 &#34;CV&#34;:
 } 
 }
 }
 &#34;Curr_balance&#34;:
 }
}
</code></pre>

What are the functional and non-functional requirements for this database?

Determine the requirements for designing a database system to store payment APIs

Swipe Payment API

Gebbs Consulting Data Engineer Interview Questions

Responsibilities<ul><li>Responsible for day-to-day tasks related to data engineering, data modeling, ETL (Extract Transform Load), data warehousing, and data analytics.</li><li>Work with Azure Data Factory (ADF) and Databricks to design, develop, and maintain data pipelines and data platforms.</li><li>Build operational and automated dashboards, reports with help of Power BI and other reporting tools.</li></ul><li></li>Qualifications<ul><li>Proficiency in reporting tools and systems on MS SQL Server BI Stack, including SSRS and TSQL, Power Query, MDX, PowerBI.</li><li>Proficiency in Azure Data Factory (ADF), Azure Data Lake and Databricks.</li><li>Delta Lake, Azure SQL and Azure blob storage, Azure logic apps, Azure Functions and Azure Synapse, Azure Purview.</li><li>Extensive knowledge on big data concepts like Hive, and spark framework.</li><li>Should be able to write complex SQL queries. Sound understanding of DWH concepts.</li><li>Strong hands-on experience on Python and/or Scala.</li></ul> Required Skills<ul><li>Proficiency in reporting tools and systems on MS SQL Server BI Stack, including SSRS and TSQL, Power Query, MDX, PowerBI.</li><li>Proficiency in Azure Data Factory (ADF), Azure Data Lake and Databricks.</li><li>Delta Lake, Azure SQL and Azure blob storage, Azure logic apps, Azure Functions and Azure Synapse, Azure Purview.</li><li>Extensive knowledge on big data concepts like Hive, and spark framework.</li><li>Should be able to write complex SQL queries. Sound understanding of DWH concepts.</li><li>Strong hands-on experience on Python and/or Scala.</li></ul>

Role overview 14-18 Years of experience Experience<ol><li>Experience with native and third-party Databricks integrations (Delta Live Tables, Auto Loader, Databricks Workflows / Apache Airflow, Unity Catalog)</li><li>8+ years data engineering experience</li><li>3+ years in a senior or principal engineer role</li><li>Experience designing scalable data pipelines</li><li>Experience leading projects within a team and across teams</li><li>Azure experience preferred</li><li>Azure Databricks implementation experience preferred</li><li>Experience designing and implementing data security and governance platform adhering to compliance standards (HIPPA, SOC 2) preferred</li></ol> Specific Job Knowledge, Skill and Ability<ol><li>Strong programming skills in pySpark/Scala</li><li>Strong Dataframe programming skills, such as Spark, Pandas, NumPy</li><li>Passion for mentoring and guiding others</li><li>Strong written and verbal communication skills</li><li>Expert knowledge in architecting, designing and implementing data solutions to serve the needs of our business processes and software products</li><li>Ability to keep security, maintainability, and scalability in mind with the solutions built</li><li>Possess excellent interpersonal communication skills and an aptitude for continued learning</li></ol> What would you do here? Duties and Responsibilities1. Lead and contribute to the creation of a self-service data platform for reporting and analytics2. Design and build data solutions using Databricks, SQL, Python, Spark, and Delta Lake in the Azure ecosystem (Blob Storage, Data Factory, Event Hubs)3. Ensure best practices for ETL / ELT processes (data quality management, data processing, data partitioning, maintainability and reusability)4. Collaborate with engineers, product, and business leaders to ensure data platform is integrated with other systems and technologies (Tableau, Power BI, APIs, custom applications)5. Establish CI/CD processes, test frameworks, infrastructure-as-code tools, and monitoring/alerting (Git, Terraform, Azure DevOps / GitHub Actions / Jenkins, Azure Monitor / Datadog)6. Adhere to the Code of Conduct and be familiar with all compliance policies and procedures stored in LogixGarden relevant to this position

Role: Data EngineerTotal years of experience: 9+ YearsLocation: PAN India (Any HCL office)Relevant experience for engagement: 5 Years Note: - We are conducting a virtual discussion on this coming Saturday, 13th of Sep 25 from 9:30 am to 6:30 pm, if interested please feel free to share your profiles Job Description:Relevant Skills:Maintain architecture principles, guidelines and standardsData WarehousingProgramming Language: Python/JavaBig DataData AnalyticsGCP ServicesExperience in designing & implementing solution in mentioned areas:Strong Google Cloud Platform Data Components – Big Query, Bigtable, Cloud SQL, Data proc, Data Flow, Data Fusion, Etc. Professional Summary<ul><li>Technical Data Engineer who is strong on Data Warehousing, Big Data, Data Analytics</li><li>Experience with developing software code in one or more languages such as Java and Python.</li><li>Strong Google Cloud Platform Data Components – Big Query, BigTable, CloudSQL, Dataproc, Data Flow, Data Fusion, Etc</li><li>Demonstrate extensive skills and success in the implementation of technology projects within a professional environment, with a particular focus on data engineering</li><li>Hands on experience with Data Projects in cloud specifically GCP</li><li>Sound knowledge of Data related concepts</li><li>Demonstrated excellent communication, presentation, and problem-solving skills.</li></ul> Good to have skills Good to have experience & knowledge of MPP systems, Database systems, ETL and ELT systems and Data Flow compute<ul><li>Should be able to advise the best of breed for the client solutions; Skills Needed</li><li>The Data Engineer coaches the junior data engineering personnel position by bringing them up to speed and help them get better understanding of overall Data ecosystem.</li><li>Prior experience developing, building and deploying on GCP</li><li>Working on Solution deck, IP build, client meetings on requirement gathering</li></ul> Certifications: Google Professional Cloud architect (Good to have)

Are you passionate about creating seamless data experiences that power business decisions? We're seeking a talented Data Engineer to join our dynamic team and revolutionize how we connect, transform, and leverage data across our entire ecosystem. This is your opportunity to work with cutting-edge integration platforms while enjoying the flexibility of remote work from anywhere in India. Why You'll Love This Role:<ul><li>Remote - Work from your ideal environment</li><li>Work with modern tech stack (Boomi/Rivery, AWS Redshift, MongoDB)</li><li>Direct impact on business operations and strategic decisions</li><li>Collaborative environment with cross-functional teams</li><li>Opportunity to architect solutions that scale</li></ul> What You'll Do:<ul><li>Build & Innovate: Design and develop robust data pipelines using Dell Boomi/Rivery platforms, creating elegant solutions for complex integration challenges</li><li>Connect Everything: Seamlessly integrate diverse applications including Salesforce, NetSuite, and various APIs to create a unified data ecosystem</li><li>Ensure Excellence: Champion data quality, security, and governance while optimizing workflows for peak performance</li><li>Solve & Scale: Troubleshoot integration challenges and build scalable solutions using AWS Redshift, SQL Server, and MongoDB</li><li>Collaborate & Lead: Partner with business analysts and stakeholders to transform requirements into technical reality</li></ul> You're Perfect for This Role If You Have:Must-Haves:<ul><li>5+ Years of experience in software development role</li><li>3+ years of hands-on experience with Dell Boomi and/or Rivery platforms</li><li>Strong SQL skills across multiple databases (Redshift, SQL Server, MongoDB)</li><li>Expertise in JSON, XML, and various data formats</li><li>Experience building and maintaining data pipelines</li><li>Understanding of security protocols and data encryption</li></ul> Nice-to-Haves:<ul><li>Salesforce and NetSuite integration experience</li><li>Tableau reporting capabilities</li><li>Experience with Totango and 6sense</li><li>AWS stack expertise, especially Redshift stored procedures</li></ul> Tech Stack You'll Work With: Dell Boomi | Rivery | AWS Redshift | SQL Server | MongoDB | Salesforce | NetSuite | Tableau | JSON/XML | APIs What Makes You Stand Out:<ul><li>You're a problem-solver who thrives on turning complex data challenges into simple solutions</li><li>You believe in documentation and knowledge sharing</li><li>You're excited about remote work and can manage your time effectively</li><li>You're passionate about data quality and governance</li></ul> Ready to Transform Data Into Business Value?Join us in building the data infrastructure that drives real business impact. This is more than a job – it's an opportunity to shape how organizations leverage data in the digital age. Apply Now and let's discuss how you can contribute to our data transformation journey!

Job Title: GCP Data Engineer Location: Offshore – India (Preferred: Pune / Indore) Experience: 5+ YearsRole OverviewWe are seeking a highly skilled GCP Data Engineer to join our team and support a US-based customer (Texas). The ideal candidate will have a strong background in designing, building, and maintaining data pipelines and architectures on Google Cloud Platform (GCP). This role requires deep technical expertise, problem-solving ability, and the capability to translate business needs into scalable technical solutions.Key Responsibilities<ul><li>Develop, test, and maintain data acquisition pipelines for large volumes of structured and unstructured data (batch and real-time) on GCP.</li><li>Build scalable and optimized datasets in alignment with business requirements.</li><li>Construct end-to-end big data pipeline architectures.</li><li>Collaborate with business stakeholders to identify opportunities for data acquisition and translate requirements into technical specifications.</li><li>Work extensively with GCP tools such as Python, SQL, DataFlow, DataStream, CDC (Change Data Capture), Cloud Functions, Cloud Run, Pub/Sub, BigQuery, Cloud Storage.</li><li>Use SAP SLT to replicate SAP tables into GCP.</li><li>Develop JSON-based messaging structures to integrate with multiple applications.</li><li>Implement DevOps & CI/CD practices (GitHub, Terraform) to ensure reliability, scalability, and automation of pipelines.</li><li>Ensure data security and compliance by implementing IAM roles, Policy Tags, and authorized views in BigQuery.</li><li>Design and implement ingestion pipelines using REST APIs.</li><li>Monitor, troubleshoot, and optimize pipelines with logs and alerts.</li><li>Recommend and drive improvements to enhance data quality, reliability, and efficiency.</li></ul>Required Skills & Experience<ul><li>5+ years of experience as a Data Engineer with a focus on Google Cloud Platform.</li><li>Minimum 1 year hands-on experience with key GCP tools (Python, SQL, DataFlow, DataStream, Cloud Functions, Cloud Run, Pub/Sub, BigQuery, Cloud Storage).</li><li>Strong understanding of data ingestion, CDC techniques, and real-time/batch pipeline orchestration.</li><li>Experience with SAP SLT for replicating SAP data into GCP (preferred).</li><li>Solid knowledge of data partitioning, clustering, and governance in BigQuery.</li><li>Exposure to DevOps/CI/CD tools (GitHub, Terraform).</li><li>Strong problem-solving and communication skills.</li></ul>

With just over 7 years of experience in the Portuguese market, we share our DNA with more than 200 workers and position our offer according to 3 lines of service:<ul><li>Strategy (Outsourcing, NeXel, Team as a Service, Tech Academies);</li><li>R&D (Bootcamps, POC, Tech Lab);</li><li>Nearshore.</li></ul> In ADENTIS, we focus on PEOPLE. This is our emotional salary:<ul><li>Great Work-Life balance;</li><li>Very flexible organizational routine;</li><li>Health benefits (for you and your family);</li><li>Team Building activities;</li><li>Over 300 protocols to offer you great discounts in different areas;</li><li>Continuous professional development sponsored by our Training and Certification Department;</li><li>Regular feedback on your performance through a personalized plan;</li><li>Comprehensive career plan and progression involving assertive performance reviews.</li></ul> Responsibilities:• Distributed Data Processing: Develop and optimize distributed data pipelines using Apache Spark, ensuring efficient processing of large datasets• Caching & Computation Optimization: Implement advanced caching techniques and optimize distributed computation workflows to improve data retrieval times and resource utilization• Partition Key Join Optimization: Optimize partition keys joins to speed up query processing and enhance overall system performance in distributed environments• SQL Query Optimization: Optimize SQL queries for better performance and scalability, particularly in large-scale, distributed database systems• Cloudera Ecosystem: If applicable, leverage the Cloudera platform to manage and scale data workflows in big data ecosystems, ensuring reliability and efficiency • Wants to learn more about DevOps to be autonomous, with the following DevOps responsibilities (5-10% of the time) Requirements:• Expertise in Apache Spark and distributed computation techniques• Experience with advanced SQL optimization and caching strategies• Knowledge of the Cloudera ecosystem is a valuable asset for managing big data platforms• Ability to work independently and take initiative to solve technical problems• Excellent communication skills to effectively collaborate with technical and non-technical teams. • CI/CD Pipeline Automation• Version Control & Branching• Deployment Automation• Artifact Management• Containerization & Orchestration• Automation & Monitoring• Available to go to the office twice per week If you want to be part of a real People First organization, join us! Send your CV to andre.lago@adentis.pt

Key Result Areas and Activities: <ul><li>Study existing technology landscape and understand current data integration framework and do impact assessment for the requirements.</li><li>Develop spark jobs using Scala for new project requirements.</li><li>Enhance existing spark jobs for any ongoing product enhancement.</li><li>Performance tuning of spark jobs, stress testing etc.</li><li>Create new data pipelines for developed/enhanced spark jobs using AWS Lambda or Apache Airflow</li><li>Responsible for database design process, logical design, physical design, star schema, snowflake schema etc.</li><li>Analyze data processing, integration, modelling and reporting requirements & Define data loading strategies considering volume, data types, frequency and analytics specifications.</li><li>Ensure optimal balance between cost and performance.</li><li>Project documentation, Adheres to Quality guidelines & Schedules.</li><li>Works hand in hand with PM for successful delivery of project and provide Estimation, scoping, scheduling assistance.</li><li>Manage build phase and quality assure code to ensure fulfilling requirements and adhering to Cloud architecture. Resolve difficult design and develop issues.</li></ul> Work and Technical Experience: Must-Have:<ul><li>Overall, 7-9 years of IT Exp</li><li>5+ years of AWS related project</li><li>Good to have Associate Level and Professional Level AWS Certification</li><li>In depth knowledge of following AWS Services required: S3, EC2, EMR, Severless, Athena, AWS Glue, Lambda, Step Functions</li><li>Cloud Databases (Must have) – AWS Aurora, Singlestore, RedShift, Snowflake</li><li>Big Data (Must have) - Hadoop, Hive, Spark, YARN</li><li>Programming Language (Must have) – Scala, Python, Shell Scripts, PySpark</li><li>Operating System (Must have) - Any flavor of Linux, Windows</li><li>Must have very strong SQL Skills</li><li>Orchestration Tools (Must have): Apache Airflow</li><li>Expertise in developing ETL workflows comprising complex transformations like SCD, deduplications, aggregations etc.</li><li>Should have thorough conceptual understanding of AWS VPC, Subnets, Security Groups, & Route Tables</li><li>Should be a quick and self-learner and be ready to adapt to new AWS Services or new Big Data Technologies as and when required</li></ul> Qualifications: <ul><li>Bachelor’s degree in computer science, engineering, or related field (Master’s degree is a plus)</li><li>Demonstrated continued learning through one or more technical certifications or related methods</li><li>Minimum 5 years of experience on Cloud related projects</li></ul> Qualities:<ul><li>Hold strong technical knowledge and experience</li><li>Should have the capability to deep dive and research in various technical related fields</li><li>Self-motivated and focused on delivering outcomes for a fast-growing team and firm</li><li>Able to communicate persuasively through speaking, writing, and client presentations</li><li>Able to consult, write, and present persuasively</li><li>Able to work in a self-organized and cross-functional team</li><li>Able to iterate based on new information, peer reviews, and feedback</li><li>Prior experience of working in a large media company would be added advantage</li></ul>

<h3>Job Description</h3><div>Job Description<div><div>Who is Credible?We are a marketplace where users can compare personalized, prequalified rates and quotes from multiple lenders and carriers, for student loans, mortgages, personal loans, and insurance. We're challenging the status quo by giving power to the consumer. We believe in a world where 'ethical', 'lending', and 'insurance' can coexist, so we set out to build innovative platforms that actually work for customers. Our mission is to help people find the best loan or insurance policy possible. We believe researching and buying loans or insurance shouldn't be confusing or complex, so we've focused on simplicity. We've created the only unbiased loan and insurance buying process out there, which makes finding options straightforward and clear. </div>About the Role:Our Business Intelligence team is looking for a BI Data Engineer III who is passionate about data, analytics, and business strategy. You will help the team learn more about our business, teach others in the company about analytics, and improve the use of our data. You'll be an integral part of providing data-driven insights that inform significant company decisions.Responsibilities:<ul><li>Build data pipelines and python-based ETL tools for getting, processing, and delivering data.</li><li>Develop and optimize data models/schemas in our data warehouse that enable performant, intuitive analysis.</li><li>Generate end to end reporting solutions (from data ingestion to dashboards).</li><li>Work with business leaders to define key metrics and reporting requirements.</li><li>Conduct in-depth data analyses that improve infrastructure and product performance.</li><li>Become an expert on all aspects of Credible's data and analytics infrastructure.</li><li>Be the driving force behind the adoption and effective use of our BI tool within every team at Credible.</li></ul>Education and Experience:<ul><li>BA/BS in a quantitative field.</li><li>3-5+ years of work experience as a data engineer, or in a highly analytical role.</li><li>Experience writing SQL queries and using a BI tool.</li><li>Experience with programmatic scripting using Python to develop ETL pipelines and tooling.</li><li>Experience using the command line and git.</li><li>Strong grasp of statistics and experience conducting rigorous data analyses.</li><li>Experience developing models and visualizations in Looker a plus.</li><li>Experience at an e-commerce or fintech company is a plus.</li></ul>Nice to Have:<ul><li>The capacity to juggle multiple priorities effectively within a fast-paced environment is critical.</li><li>You're a highly motivated self-starter with the ability to work efficiently with minimal supervision.</li><li>Anticipate business needs and think with a business owner mindset – think critically about analyses, don't just complete them.</li><li>Passion for spreading the value of data throughout the company and communicating insights to a broad audience with varying levels of technical expertise.</li></ul>Credible is open to hiring candidates in the following locations: California, Colorado, Connecticut, Florida, Georgia, Illinois, Indiana, Kentucky, Massachusetts, Michigan, Missouri, Nevada, New Jersey, New Mexico, New York, North Carolina, South Carolina, Texas, Tennessee, Utah, Virginia, Washington<div><div>Pursuant to state and local pay disclosure requirements, the pay ranges for this role, with final offer amount dependent on education, skills, experience, and location, are listed below. This role is also eligible for an annual discretionary bonus, various benefits, including medical/dental/vision, insurance, a 401(k) plan, paid time off, and other benefits in accordance with applicable plan documents. View more details about Credible Benefits</div><div>For high cost of labor markets such as but not limited to New York City and San Francisco:</div><div>$100,800—$133,200 USD</div><div>For all other US locations:</div><div>$84,000—$111,000 USD</div></div><div><div>Why work at Credible?</div><div>We combine the intelligence, expertise, and confidence of a financial advisor with the approachability and honesty of a friend. In other words, we're the friend you always wish you had in finance.We are optimistic, challengers, trustworthy, clever, and smart. We are open and transparent. We strive to act as advisors by being friendly, objective, and open in our communication. We use language that is intelligent yet approachable. When appropriate, we'll drop in a bit of wit to position ourselves as a fresh, reliable voice in the financial world.<div>We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, gender identity, disability, protected veteran status, or any other characteristic protected by law. We will consider for employment qualified applicants with criminal histories consistent with applicable law.</div></div></div></div></div>

About us Visit Health is changing the face of employee health and wellness in India. 1 mn+ users across 200+ large Indian conglomerates to new age start-ups trust Visit as their Health and Wellness Partner, catering to the missing and unexplored Wellness Primary Healthcare needs. Traditionally, Employee Health Benefits were synonymous with insurance/hospitalization benefits only; ie, Secondary Care. Today, 90% of individual healthcare and wellness-related expenses in India are out of pocket on Primary Care; be it Mental Wellness, Fitness, Nutrition, Diagnostics, Medicines, and most of all, regular doctor appointments. The Covid-19 Pandemic has not only caused such expenses to increase multi-fold but also created a need for accessible systems. In a professional setting, such offerings are either lacking or provided in an ad hoc, broken manner through various individual platforms. As a result, the experience for an employee is disconnected, with limited utilization and engagement. This is where Visit Health comes in - a one-stop solution for all employee health benefits needs. We help Companies build a Customized Wellness solution focused on Primary Care aspects such as Fitness, Mental Health, Doctor Teleconsultation, OPD programs, etc. for employees and their families, thereby reducing out-of-pocket expenses and creating healthier workforces. We have stitched up the broken pieces of employee health benefits in India to make one streamlined platform while increasing employee engagement through gamification. Visit Health has raised in total of $250million and is backed by renowned investors such as PolicyBazaar, Twitter Co-founder Biz Stone, and Kunal Bahl of Snapdeal. Don't just take our word. Check us out @ <a>https://vsyt.me/o/app</a> We are looking for a Data Engineer to join our high-energy team You will have a direct impact on the tooling/development cycles/testing frameworks. You'll work as part of a high-energy team that's scaling across all engineering functions. Pushing high-quality code on NodeJS, ensuring Data integrity across multiple data storages (DB/Kafka/S3, etc) while also balancing the pros/cons of speed/quality will be critical. As part of your day-to-day work, you will <ul><li>Process data and information according to guidelines.</li><li>Help develop reports and analyses.</li><li>Support the data warehouse in identifying and revising reporting requirements.</li><li>Evaluate changes and updates to source production systems.</li><li>Identify and develop data pipelines to support data standardization.</li><li>Handle multiple sources of data, structure large data sets to find usable information, and the ability to come up with standardized schema.</li><li>Use graphs, infographics, data dumps, cohorts, heat maps, clusters, and other methods to visualize data.</li></ul> Must-haves <ul><li>4 to 6 years of relevant experience.</li><li>Should have various skills and qualifications that help them solve problems using large amounts of data.</li><li>Good knowledge of databases such as MySQL (scripts, procedures, functions, indexes, relationships, schema management) and No SQL.</li><li>Good Coding skills in languages such as Python.</li><li>Proficiency in Microsoft Excel.</li><li>Analytical and problem-solving skills.</li><li>Knowledge of data gathering, cleaning, and transforming techniques.</li><li>Reporting and data visualization skills using software like Tableau, PowerBI, or any other tool.</li><li>Understanding of data warehousing and ETL techniques.</li><li>Strong written/verbal communication skills.</li><li>Ability to analyze existing tools and databases and provide software solution recommendations.</li><li>Understanding of addressing and metadata standards.</li></ul>

<h3>Job Description</h3><div>Job Description<div>Description:What We Do MattersTransImpact is an industry leader in the development and application of end-to-end technology-based solutions that optimize shipping operations, create dramatic supply chain efficiencies, and transform the business performance of customers. We are an exciting entrepreneurial-minded company that continues to grow nationwide. Our clients include many well-known names, and we excel in growing our client base through referrals from our satisfied customers. TransImpact has been honored to have achieved multiple awards and acknowledges our employees for them. Location and WorkThis position is available remotely, or hybrid at either our Emerald Isle, NC or Cleveland, OH offices, with a preference for those available for work during Eastern Time zone hours. Our Benefits and Perks<ul><li>We are consistently reviewing our benefits and making improvements to stay competitive and provide our teams with the best options and the most positive culture. Below are the highlights:</li><li>3 weeks of PTO in your first year of employment and 4 weeks of PTO in your 2nd year.</li><li>Half-day Fridays during the Summer months if your schedule allows</li><li>Hybrid work schedule - Mondays and Fridays you can work from home if you're within 45 miles from one of our offices.</li><li>Medical, dental, and vision coverages at very affordable premiums that include family coverage</li><li>6% 401k match after your first year of employment, fully vested.</li><li>At our offices, we provide free snacks, drinks, fancy coffee, a putting green, and other amenities that add to our laid-back, casual atmosphere.</li><li>Our headquarters is by the beach in Emerald Isle North Carolina, and we have adopted that laidback but serious about our work type of atmosphere at all of our locations. We work hard and play hard! </li></ul> About the Position and Our TeamTransImpact is seeking a Principal Data Engineer to lead our Data-at-Rest and Data-in-Motion platform strategies. Principal Data Engineers are hands-on contributors that have full technical responsibility for interpreting, organizing, executing, and coordinating strategies for their domain of expertise across the entire Product Development organization. They plan and develop solutions concerned with unique and abstract opportunities which have an important impact on highly visible, strategic initiatives. Principal Data Engineers are delegated responsibility for exploring, defining, and selecting solutions during development of novel concepts and unique areas of need regarding how Data is handled in the platform. They are organization-wide mentors and governance chiefs for data strategies, coordinating important programs for the organization in advancing platform capabilities. Principal Data Engineers act as staff specialists, serving as the foremost domain experts in building scalable data solutions via the application of advanced theory, concepts, principles, and processes. They keep abreast of new methods and developments within their domain, while ensuring that they maintain their effectiveness when used in the organization, through the constant development and refinement of platform standards.Responsibilities<ul><li>Lead efforts in implementing data storage and transportation best practices across the entire TransImpact platform.</li><li>Lead impactful efforts in ensuring Product Development teams build resilient, data-driven solutions that are fault-tolerant, scalable, efficient, maintainable, and manageable, through mentorship and coaching.</li><li>Lead technical ownership of all Data Engineering standards and initiatives, across multiple platform offerings and complete products.</li><li>Identify key areas of focus to meet business objectives regarding Data capabilities in the platform, including partnership with Product and Data Science.</li><li>Contribute as a core member of the Standards Review Board in designing and ensuring the success of constant improvement for delivery and adherence to best practices.</li><li>Job responsibilities and any other duties needed to help drive our vision, fulfill our mission, and support our organization’s values.</li></ul> Qualifications and Skills Required<ul><li>Experience designing and implementing Data-at-Rest and Data-in-Motion solutions at SaaS organizations, at scale, preferably on an Azure infrastructure within a .NET/Python solution space.</li><li>Experience designing and implementing distributed data architectures resulting in highly performant data storage, orchestration, and pipeline solutions, ideally for 10+ years.</li><li>Experience and understanding of Data Engineering best practices, integration patterns, and system tradeoffs, including security and performance.</li><li>Demonstrable ability to ideate, execute, and complete initiatives that realize specific improvements for a data-driven, SaaS platform.</li><li>Demonstrable ability to act as a thought leader, championing novel concepts to success through engagement and mentorship’s.</li><li>Demonstrable ability to act as a peer leader, working with other Principals and people leaders to encourage a culture of innovation and accountability within an Agile environment.</li><li>Clear communication and documentation skills, both for technical and non-technical audiences.</li></ul>What We Will Love About You<ul><li>You want to be a part of something bigger than yourself</li><li>You respect all people</li><li>You are mature and thoughtful in how you express ideas; a strong verbal and written communicator.</li><li>You hustle every day and understand the importance of urgency and owning your outcomes.</li><li>You’re a leader and a teambuilder. </li><li>You’re goal-oriented and know how to influence others to move in a unified direction.</li></ul> What You Will Love About UsHere at TransImpact, we know there’s a direct link between happy employees and happy customers, which together generate success for all of us. We believe that a supportive atmosphere, an emphasis on giving and humanity, and approachable leaders and managers help our employees reach their greatest potential.We are very proud of our corporate culture and commitment to giving back to the community. Our employees are encouraged to commit to charity work and volunteering and are allotted 20 hours of PTO time to support our communities. We Are Serious About Our MissionOur world is changing. Our values are not. Since the beginning, TransImpact has maintained a steadfast dedication to our core values: Work Ethic, Integrity, Professionalism, Passion, and Perfection. They guide everything we do. Every interaction with a client, every interaction with each other, everything we create. Applicants must be authorized to work for any employer in the United States. We are unable to sponsor or take over sponsorship of an employment visa. TransImpact is an affirmative action and equal opportunity employer (EOE). Applicants will not be discriminated against because of race, color, creed, sex, sexual orientation, gender identity or expression, age, religion, national origin, citizenship status, disability, ancestry, marital status, veteran status, medical condition, or any protected category prohibited by local, state, or federal laws. TransImpact is committed to providing access, equal opportunity, and reasonable accommodation for people with disabilities. To request a reasonable accommodation, contact Wendy Bott, Human Resource Department, 440-394-2206. Recruiters: By submitting candidates without having been formally assigned on and contracted for a specific job requisition by TransImpact, or by failing to comply with the TransImpact recruitment process, you forfeit any fee on the submitted candidates, regardless of your usual terms and conditions. TransImpact works with a preferred supplier list and will take the initiative to engage with recruitment agencies based on its needs and will not be accepting any form of solicitation.Requirements: </div></div>

Question	Topic	Difficulty	Ask Chance
Address Schema	Data Modeling	Medium	Very High
Pipeline Transformation Failures	Batch & Stream Processing	Medium	High
Swipe Payment API	Data Modeling	Easy	High