The Northstar group Data Engineer interview guide, interview questions, salary data, and interview experiences.

Northstar group Data Engineer Interview Guide

Getting ready for an Data Engineer interview at Northstar group? The Northstar group Data Engineer interview span across 10 to 12 different question topics. In preparing for the interview:
<ul>
<li>Know what skills are necessary for Northstar group Data Engineer roles.</li>
<li>Gain insights into the Data Engineer interview process at Northstar group.</li>
<li>Practice real Northstar group 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 Northstar group Data Engineer interview.


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

- Know what skills are necessary for Northstar group Data Engineer roles.
- Gain insights into the Data Engineer interview process at Northstar group.
- Practice real Northstar group 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 Northstar group Data Engineer interview.
        

Overview

What Northstar group 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.

Northstar group 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

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

You work as a data engineer for a city-wide bicycle rental company. The company wants to predict future bicycle rental volumes using historical data collected from multiple sources, such as station logs, weather files, and event schedules. You are given access to raw source files that are updated daily.

How would you design an end-to-end data pipeline to prepare and serve data for downstream predictive modeling of bicycle rental demand?

Design an end-to-end data pipeline to process and serve data for predicting bicycle rental volumes.

Bicycle Rental Data Pipeline

Batch & Stream Processing

Northstar group Data Engineer Interview Questions

Database Developer Experience: 4+ years Location: Bangalore Must Have: SQL Development, Azure Data Factory, ETL Processes The Ideal candidate will have a strong command of SQL, experience with ETL processes, and a deep understanding of data modelling and database performance tuning. Key Responsibilities:<ul><li>Design, develop, and maintain complex relational databases (e.g., SQL Server, Oracle, PostgreSQL, MySQL).</li><li>Write efficient and optimized SQL queries, stored procedures, functions, views, and triggers.</li><li>Develop and maintain ETL pipelines for data integration and transformation using tools like SSIS, Azure Data Factory, Informatica PowerCenter.</li><li>Design and implement data models (normalized and denormalized) for transactional and analytical purposes.</li><li>Monitor, maintain, and improve database security, integrity, and availability.</li></ul> Required Skills and Qualifications: <ul><li>4+ years of hands-on experience in database development and management.</li><li>Strong proficiency in SQL and emajor RDBMS (SQL Server, PostgreSQL, Oracle, MySQL).</li><li> ETL tools Azure Data Factory, Informatica PowerCenter, Snowflake.</li><li>building ETL pipelines to load data into Snowflake</li><li>data modelling concepts (star schema, snowflake, normalization).</li><li>performance tuning and query optimization.</li><li>version control systems (e.g., Git) and CI/CD pipelines.</li><li>Experience with cloud-based databases (e.g., Azure SQL, AWS RDS, Google Cloud SQL).</li></ul> Interested Candidates Kindly connect:8180989161swati.aghor@talentcorner.in

<h3>Job Description</h3><div>Job Description<div>Short Description:Client is look for a resource to provide high-level data engineering administration expertise to support Dynamics 365/Azure data services, including Dataverse management, Azure Data Factory management, Synapse Analytics/SQL management, Power BI workspace. Complete Description: Client is seeking a Senior Data Engineering for managing and optimizing data services across Azure/Dynamics 365 and legacy Oracle Database environments. This role oversees Microsoft Dataverse, Azure Data Factory, Synapse Analytics, Power BI workspaces, and Oracle databases to ensure secure, compliant, and high-performance data operations. This position requires deep expertise in advanced SQL, database management, and database replication, including Health and human services data model experience. The candidate is responsible for design, build, and maintenance of scalable data pipelines, enforces privacy standards, and supports analytics teams with reliable, integrated data sets. The position involves cross-functional collaboration, architectural knowledge, and supporting program staff through data requests. Responsibilities: <ul><li>Provide Dataverse data management support to include schema integrity, TDS Endpoint configuration, Data extraction, query development, and data backup/restore operations</li><li>Design, monitor, and troubleshoot scalable data pipelines in Azure Data Factory, with focus on secure ingestion, transformation, and orchestration, including monitoring and troubleshooting pipeline health and performance</li><li>Manage Synapse workspaces (including Dataverse Link) and dedicated SQL pools/Managed SQL /Serverless SQLs, implementing advanced query optimization to support high-volume analytics and reporting workloads</li><li>Setup and maintain Power BI workspaces, datasets, and gateways, enforcing data security permissions including row-level security</li><li>Develop Power BI Dashboards leveraging database datasets, including log files, to determine system usage</li><li>Develop and refine complex SQL queries to support operational and performance reporting, including audit system log analysis</li><li>Build and maintain reusable Python scripts for parsing datasets, data cleansing, enrichment, and automation, involving structured and un-structured data</li><li>Develop and maintain data security for datasets across Azure data services platform</li><li>Provide data model and schema/table relationship diagram to support integrations and data exchange</li><li>Develop and maintain data replication tools to sync Dynamics data to Synapse Analytics, including managed SQL/Dedicated SQL pool, Serverless pool destination, and API-enabled data endpoints</li><li>Manage Legacy Oracle database, including data integrity, backup, and availability management</li><li>Collaborate with business stakeholders to understand data requirements, mapping, and transformation needs, ensuring alignment with the client information system's objectives. </li><li>Lead and coordinate Data Analysts and Reports Engineering Team activities, working closely with the system to ensure timely and accurate execution of data-dependent tasks, including Daily, Monthly, Weekly, Fiscal Year and Compliance reporting</li><li>Perform data profiling and analysis to identify data quality issues, data gaps, and potential risks for mitigation</li><li>Define and enforce data migration standards, best practices, and governance policies to maintain data integrity and consistency. </li><li>Create and maintain technical artifacts for data services implementation, including replication plans, data, data architecture, rules, and error reports. </li><li>Conduct training sessions and provide guidance to business staff and Functional Quality Assurance staff on data services and provide data extraction support </li><li>Stay current with industry trends and advancements in data management methodologies and tools, recommending improvements to enhance the overall data governance.  </li></ul>Skills:·       Bachelor’s degree in computer science, IT or related field or equivalent experience.·       Oracle Database management and administration experiences.·       Advanced SQL Query Development.·       Database security administration, including row-level security.·       Database Replication expertise, including replication schedule, rules for automatic detection of schema and table changes and validation rep results.·       Health and Human Services Data model experience.·       Project management skills with the ability to prioritize tasks and meet deadlines, including documentation of technical artifacts.·       Produce Data Model and Schema/Table link Diagram.·       Azure Data services management including Data factory, Synapse Analytics.·       Power BI Workspace Administration and Dashboard Development.·       Microsoft Azure Data Fundamentals certification.·       Microsoft Certified Azure Administrator certification.·       Python scripting knowledge. </div>Company Description<div>AHU Technologies Inc specializes in IT consulting, development services, and technology staffing solutions for top corporations in the United States. We pride ourselves on delivering customized IT solutions across various industries, helping clients manage costs efficiently and focus their in-house resources on strategic initiatives. In addition to project-based services, we offer end-to-end recruitment and staffing support, providing clients with highly qualified IT professionals for both contract and full-time roles. Our staffing services help companies quickly scale their teams with the right talent for specialized technology needs. Our growing talent pool is equipped to handle a wide range of development projects, including media and entertainment, ERP solutions, data warehousing, web applications, telecommunications, and healthcare for clients worldwide.</div></div><h3>Company Description</h3><div>AHU Technologies Inc specializes in IT consulting, development services, and technology staffing solutions for top corporations in the United States. We pride ourselves on delivering customized IT solutions across various industries, helping clients manage costs efficiently and focus their in-house resources on strategic initiatives.\r\n\r\nIn addition to project-based services, we offer end-to-end recruitment and staffing support, providing clients with highly qualified IT professionals for both contract and full-time roles. Our staffing services help companies quickly scale their teams with the right talent for specialized technology needs.\r\n\r\nOur growing talent pool is equipped to handle a wide range of development projects, including media and entertainment, ERP solutions, data warehousing, web applications, telecommunications, and healthcare for clients worldwide.</div>

<h3>Job Description</h3><div>Job Description<div>OverviewCTG is seeking to fill a Data Engineer opening for our client in San Antonio, TX.Location: San Antonio, TX Duration: Permanent PlacementDuties:<ul><li>Work with big data systems and complex structured and unstructured data sets.</li><li>Support government data acquisition, analysis, and sharing efforts.</li><li>Design and maintain software infrastructure for big data scaled ingestion, including integrating new data sources, modifying existing sources, implementing testing, establishing monitoring, and troubleshooting.</li><li>Lead the department in achieving strategic goals, ensuring data integrity, and fostering a collaborative, innovative work environment.</li></ul>Skills:<ul><li>Proficiency in Java (unit and integration testing) and Python; familiarity with SQL schemas and statements.</li><li>Expertise in ETL creation and processing, code debugging, and data modeling design/troubleshooting from ingest to visualization.</li><li>Strong experience with Apache NiFi (administration and building/troubleshooting data flows), AWS S3 (bucket administration), and data flow solutions such as Kafka and AWS SQS.</li><li>Familiarity with JSON, XML, SQL, compressed file formats, and YAML configuration files.</li><li>Proficiency with Maven, GitLab, VSCode, IntelliJ/PyCharm, and Linux OS (BASH).</li><li>Ability to decompose technical problems and troubleshoot both system and dataflow issues.</li><li>Strong documentation and training skills in technical domains.</li><li>Desired: experience with Apache Airflow, Mage AI, Kubernetes, Docker, and Amazon SQS/SNS administration.</li></ul>Experience:<ul><li>Current active TS/SCI eligible Security Clearance.</li><li>Minimum 9 years of experience in software development/engineering, data engineering, database engineering, or related fields (additional 4 years of relevant experience may substitute for a BS degree).</li><li>Experience with unit and integration testing, data extraction, custom translation development, data prep and labeling, and multiple log formats (JSON, XML, etc.).</li><li>Familiarity with Agile environments and cyber/network security operations preferred.</li><li>Experience conducting data model reviews, developing custom logic for data modification, and administering databases and ODBC drivers.</li></ul>Education:<ul><li>Bachelor’s degree in Computer Science, Engineering, or related field preferred; equivalent experience accepted per qualifications above.</li><li>Must be DoD IAT II certified or higher.</li></ul>Excellent verbal and written English communication skills and the ability to interact professionally with a diverse group are required.CTG does not accept unsolicited resumes from headhunters, recruitment agencies, or fee-based recruitment services for this role.To Apply: To be considered, please apply directly to this requisition using the link provided. For additional information, please contact Nicole Shaw at Nicole.Shaw@ctg.com. Kindly forward this to any other interested parties. Thank you!The expected base salary for this position ranges from $150,000 to $196,000. Salary offers are based on a wide range of factors including relevant skills, training, experience, education, market factors, and where applicable, licensure or certifications obtained. In addition to salary, a competitive benefit package is also offered.</div></div>

Job Overview: The Senior Data Engineer will be responsible for designing, developing, and maintaining ETL processes to extract, transform, and load data from various sources into our data warehouse. The ideal candidate should have hands-on experience with ETL tools as noted below with strong data analysis skills, and the ability to work with large datasets. <ul><li>Design, develop, and maintain ETL automations using Informatica Cloud and Azure Data Factory </li></ul><ul><li>Develop and Maintain Datawarehouse objects like tables, views and security roles in MS Azure Data Warehouse and Snowflake. </li></ul><ul><li>Extract data from various sources, such as databases, flat files, and APIs, process and post it to required destination storage such as SQL database, Azure blob, Azure table storage, Azure Service Bus, Snowflake, FTP, API etc. </li></ul><ul><li>Transform and cleanse data to ensure data quality and integrity across the data platform. </li></ul><ul><li>Load data into the data warehouses, ensuring data consistency and accuracy. </li></ul><ul><li>Optimize ETL processes for performance, scalability, and reliability. </li></ul><ul><li>Design and develop data dashboards using Microsoft Power BI. </li></ul><ul><li>Work closely with data architects, analysts, and developers to support data integration initiatives. </li></ul><ul><li>Implement data validation, data quality checks, and data security measures across all databases. </li></ul><ul><li>Troubleshoot and resolve data issues, performance bottlenecks, and ETL failures. </li></ul><ul><li>Implement best practices for data warehousing, data modeling, and ETL development. </li></ul><ul><li>Document ETL processes, data mappings, and configurations. </li></ul><ul><li>Strong expertise in writing SQL queries and SQL stored procedures. </li></ul> Total Rewards: <ul><li>Benefits, subject to election and eligibility: Medical, Dental, Vision, Disability, Paid Time Off (including paid parental leave, vacation, and sick time), 401k with company match, Tuition Reimbursement, and Mileage Reimbursement</li><li>Annual bonus based on performance and eligibility</li><li>It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.</li></ul> Requirements: <ul><li>A minimum of 5 years of experience with relational databases, ETL, and data warehouse required. </li><li>Advanced level knowledge of industry leading ETL tools such as Informatica Intelligent Cloud Services and Azure Data Factory </li><li>Strong experience in SQL programming and relational database concepts. </li><li>Hands on experience working with Python, </li><li>Bachelors degree in Computer Science or a related field with five years of related experience, or Masters degree in Computer Science or a related field with at least three years of related experience required. </li><li>Ability to work with different functional groups and levels of employees to effectively and professionally achieve results. </li><li>Strong organizational skills; ability to accomplish multiple tasks within the agreed upon timeframes through effective prioritization of duties and functions in a fast-paced </li></ul> Company Overview: Keurig Dr Pepper (NASDAQ: KDP) is a leading beverage company in North America, with a portfolio of more than 125 owned, licensed and partners brands and powerful distribution capabilities to provide a beverage for every need, anytime, anywhere. We operate with a differentiated business model and world-class brand portfolio, powered by a talented and engaged team that is anchored in our values. We work with big, exciting beverage brands and the #1 single-serve coffee brewing system in North America at KDP, and we have fun doing it! Together, we have built a leading beverage company in North America offering hot and cold beverages together at scale. Whatever your area of expertise, at KDP you can be a part of a team thats proud of its brands, partnerships, innovation, and growth. Will you join us? We strive to be an?employer of choice, providing a culture and opportunities that empower our team of ~29,000 employees to grow and develop. We offer robust benefits to support your health and wellness as well as your personal and financial well-being. We also provide employee programs designed to enhance your professional growth and development, while ensuring you feel valued, inspired and appreciated at work. Keurig Dr Pepper is an equal opportunity employer and recruits qualified applicants and advances in employment its employees without regard to race, color, religion, gender, sexual orientation, gender identity, gender expression, age, disability or association with a person with a disability, medical condition, genetic information, ethnic or national origin, marital status, veteran status, or any other status protected by law.

<div data-field="overview" class="jd-overview">Northside Hospital is award-winning, state-of-the-art, and continually growing. Constantly expanding the quality and reach of our care to our patients and communities creates even more opportunity for the best healthcare professionals in Atlanta and beyond. Discover all the possibilities of a career at Northside today.</div><div data-field="responsibilities" class="jd-responsibilities">OCCUPATIONAL SUMMARYThe Business Data Engineer for Business Intelligence & Data Strategies (BIDS) team is responsible for delivering solutions in both the BI space and Enterprise Data Warehouse (EDW) to benefit Northside Hospital (NSH).  Assists in the design, build and maintain the data infrastructure in order to transform data into actionable insights that can be used to inform business decisions through effective data pipelines. Develops accurate high quality BI reporting, visualizations, analytics and results driven solutions via any of the technologies supported in NSH. The position also requires strategic enterprise data deliverables including but not limited to; properly structuring data in the Enterprise Data Warehouse (EDW), optimizing end user consumables from the EDW, creating mechanisms for non-system specific data to be incorporated into the EDW.  This includes data or solution architecting, data architecting, and maintaining ETL best practices for operations of the EDW.   PRIMARY DUTIES AND RESPONSIBILITIES<ol style="margin-top: 0in;"><li>Collects, defines and translates business requirements into technical data solutions for the building and development of efficient reporting, data pipelines and analytical tools throughout the Finance division and other functional areas of the organization.</li><li style="margin-bottom: 0in;">Understands, efficiently uses and actively contributes to the development of business intelligence tools throughout the organization, which align with strategic goals and initiatives.</li><li style="margin-bottom: 0in;">Contributes to the design, build and maintenance of dashboards, scorecards and reporting analytics to user and scope specifications.</li><li style="margin-bottom: 0in;">Maintains mechanisms to administer manual or automated population of data tables in support of recurring reporting.</li><li style="margin-bottom: 0in;">Design, build and maintenance of data pipelines to optimize data retrieval and insights for specific business needs.</li><li style="margin-bottom: 0in;">Produces technical documentation for programming and reporting efforts.</li><li style="margin-bottom: 0in;">Generates and analyzes data to respond to routine and ad-hoc end user requests.</li><li style="margin-bottom: 0in;">Assist with special systems and analytics projects.</li><li style="margin-bottom: 0in;">Identifies opportunities and recommendations for process improvement within the organization, including process automation and data audits.  Responsible for programming and implementation of said improvements.</li></ol></div><div data-field="qualifications" class="jd-qualifications">KNOWLEDGE SKILLS AND ABILITIES/LICENSE OR CERTIFICATION REQUIRED<ol><li>S. in Computer Science/Information Systems, Industrial Engineering, or related field</li><li>0-2 years related work experience</li><li>Ability to quickly learn and synthesize new technologies</li><li>Aptitude for programming, Structured Query Language (SQL), Data Modeling and/or application design</li><li>Excellent communication, presentation and design skills</li><li>Excellent analytical skills interpreting meaning from data</li><li>Must have excellent technical aptitude and an affinity for data and analysis. </li><li>Must also have the aptitude to learn, engage and utilize new vendor applications and tools quickly. </li></ol>KNOWLEDGE SKILLS AND ABILITIES/LICENSE OR CERTIFICATION PREFERRED<ol><li>1-2 years’ experience in a healthcare environment</li><li>Experience and/or coursework related to scripting, programming and automation</li><li>Experience and/or coursework with database environments - IBM Netezza , Microsoft SQL Server, Oracle.</li><li>Experience and/or coursework with ETL software </li><li>Experience and/or coursework with developing with Business Intelligence Visualization software : Tibco Spotfire, Tableau, PowerBI or Qlikview </li><li>Experience and/or coursework with Python, R, Javascript, CSS, HTML, UNIX, PERL, Powershell or other scripting langages. </li><li>Familiarity with Data mining, Data modeling for applications and data warehousing, Data cleansing, Data and Data standardization  </li></ol></div>

<h3>Job Description</h3><div>Job Description<div>OverviewCTG is seeking to fill a Data Engineer – Data Modeling opening for our client in Houston, TX.Location: Houston, TX Duration: 6 monthsDescription: The Data Engineer – Data Modeling will design and implement data models for applications and related systems, translating business needs into logical and physical data models. The role requires strong expertise in data modeling tools and techniques, including ERWin, MDM, and/or ETL, to support data integration, governance, and analytics initiatives.Duties:<ul><li>Collaborate with business analysts, developers, and stakeholders to gather requirements and translate them into data models.</li><li>Design, develop, and maintain logical and physical data models to support business processes and reporting needs.</li><li>Implement data architecture standards, governance, and best practices.</li><li>Utilize modeling tools such as ERWin or equivalent for data design and documentation.</li><li>Support data integration processes using ETL/ELT frameworks.</li><li>Optimize database performance and data structures for scalability and efficiency.</li><li>Ensure data integrity, consistency, and quality across systems.</li><li>Provide technical guidance and mentorship on data modeling concepts and practices.</li></ul>Skills:<ul><li>Strong understanding of data modeling concepts and methodologies.</li><li>Expertise in data modeling tools (e.g., ERWin).</li><li>Proficiency in SQL for data analysis, optimization, and transformation.</li><li>Hands-on experience with ETL/ELT tools and processes.</li><li>Familiarity with data warehousing and business intelligence platforms.</li><li>Knowledge of master data management (MDM) principles.</li><li>Experience with Snowflake or other modern cloud data platforms (preferred).</li></ul>Experience:<ul><li>5+ years of experience in data engineering, data modeling, or related fields.</li><li>Proven track record in designing and implementing scalable data models.</li><li>Experience working with relational databases, data warehouses, and cloud platforms.</li><li>Background in supporting enterprise-level data integration and analytics solutions.</li></ul>Education:<ul><li>Bachelor’s degree in Computer Science, Information Systems, Data Engineering, or a related field (or equivalent work experience).</li></ul>Excellent verbal and written English communication skills and the ability to interact professionally with a diverse group are required.CTG does not accept unsolicited resumes from headhunters, recruitment agencies, or fee-based recruitment services for this role.To Apply: To be considered, please apply directly to this requisition using the link provided. For additional information, please contact Jamie Robinson at Jamie.Robinson@ctg.com. Kindly forward this to any other interested parties. Thank you!</div></div>

About Company : They balance innovation with an open, friendly culture and the backing of a long-established parent company, known for its ethical reputation. We guide customers from what’s now to what’s next by unlocking the value of their data and applications to solve their digital challenges, achieving outcomes that benefit both business and society. · Job Title: Azure Data engineer · Location: Bangalore(Hybrid) · Experience: 7to 16 yrs · Job Type : Contract to hire. · Notice Period:- Immediate joiners. Mandatory Skills: Having strong experience and knowledge in Azure data engineering and should have DATA BRICKS Certification.

Job Title: Junior Data Engineer (Azure)   We are seeking an entry level Data Engineer to join our team. The ideal candidate will have experience in designing, building, and maintaining data solutions on the Azure cloud platform. You will work closely with cross-functional teams to understand business requirements and translate them into scalable and efficient data pipelines and architectures.   Responsibilities: <ul><li>Design, develop, and deploy data solutions on the Azure cloud platform, leveraging services such as Azure Data Factory, Azure Databricks, Azure SQL Database, and Azure Synapse Analytics. </li><li>Collaborate with analysts, and other stakeholders to understand business requirements and translate them into technical solutions. </li><li>Build and maintain scalable data pipelines for ingesting, processing, and transforming large volumes of structured and unstructured data. </li><li>Optimize data storage, retrieval, and processing techniques to ensure high performance and cost efficiency. </li><li>Monitor and troubleshoot data pipelines to identify and resolve performance issues and bottlenecks. </li><li>Document data solutions, including architecture diagrams, technical specifications, and operational procedures. </li><li>Responsible for collaboration with cross-functional team to understand the business requirements and translate it to solutions ensuring that design is in line with the business requirements. </li><li>Be involved in analysis and design phases of a project, participate in application design sessions, and make solution recommendations. </li><li>Work cooperatively in a team environment. Remain flexible on changing workloads. </li></ul> Qualifications: <ul><li>BE/BTech/MSc/MCA degree in computer science or related field </li><li>Minimum 0-3 years of experience in data engineering, with a focus on designing and building data solutions on the Azure cloud platform. </li><li>Hands-on experience with Azure services such as Azure Data Factory, Azure Databricks, Azure SQL Database, Azure Synapse Analytics, Azure Data Lake. </li><li>Experience with programming languages such as C#, Python for data processing and automation. </li><li>Experience using DBT (Data Build Tool) for building and managing data pipelines and transformations in a data warehouse environment. </li><li>Familiarity with data warehousing concepts, dimensional modeling, data modeling, and data integration patterns ETL/ELT processes. </li><li>Proficiency in SQL and experience working with relational databases such as SQL Server, or MySQL and non-relation databases such as Cosmos DB. </li><li>Hands-on experience with SSIS components such as Control Flow tasks, Data Flow transformations, Connection Managers, and Event Handlers. </li><li>Strong communication and collaboration skills, with the ability to work effectively in a cross-functional team environment. </li><li>Demonstrated analytical, problem-solving, organizational, and interpersonal communication skills. </li><li>Microsoft Azure Data Engineer, MSBI, Power BI Analyst certification is preferred </li></ul>

Sun Life is a leading financial services company with history of 150+ years that helps our clients achieve lifetime financial security and live healthier lives. To do this, we offer a broad range of protection and wealth products and services to individuals, businesses, and institutions, including:Insurance. Life, health, wellness, disability, critical illness, stop-loss, and long-term care insurance.Investments. Mutual funds, segregated funds, annuities, and guaranteed investment productsAdvice. Financial planning and retirement planning servicesAsset management. Pooled funds, institutional portfolios, and pension funds Sun Life Global Solutions (SLGS)Established in the Philippines in 1991 and in India in 2006, Sun Life Global Solutions, (formerly Asia Service Centres), a microcosm of Sun Life, is poised to harness the regions’ potential in a significant way - from India and the Philippines to the world. We are architecting and executing a BOLDER vision: being a Digital and Innovation Hub, shaping the Business, driving Transformation and superior Client experience by providing expert Technology, Business and Knowledge Services and advanced Solutions. We help our clients achieve lifetime financial security and live healthier lives – our core purpose and mission. Role requirements/Key responsibilities : <ul><li>Excellent problem-solving skills with the ability to analyze business problems systematically and deliver effective right-sized solutions in a timely manner.</li><li>Proven analysis and design/development skills on AWS platforms.</li><li>Develop, Test, and Implement the changes following the Software Development Life Cycle methodologies and quality concepts.</li><li>Strong knowledge on AWS – Glue/Python/PySpark.</li><li>Understanding of AWS data/automation services – Step functions, Lambda, SNS, SQS.</li><li>Hands-on experience in ETL projects.</li><li>Good knowledge of data warehousing concepts.</li><li>Good analytical and problem-solving skills.</li><li>Experience in GIT code versioning tools. </li><li>Strong knowledge of relational database (Oracle/PostgreSQL).</li><li>Good understanding of Software Development Life Cycle.</li><li>Good Reasoning and analytical skills.</li></ul> Key Qualifications and experience: <ul><li>B.Tech/B.E/MCA/M.Tech degree in IT/Computer Science or related technology degree.</li><li>Minimum 5 to 8 years of overall IT experience</li><li>4+ years of experience on AWS Glue/Python/PySpark</li><li>Strong knowledge of AWS Glue/PySpark, relational databases (Oracle/PostgreSQL, SQL Server).</li><li>Good understanding of AWS data/automation services – Step functions, Lambda, SNS, SQS.</li></ul> Interested candidates can please send their Updated Resume on sanjaysingh@sunlife.com with your CTC, Expected CTC and Notice Period details.

About Client :-Our client is a French multinational information technology (IT) services and consulting company, headquartered in Paris, France. Founded in 1967, It has been a leader in business transformation for over 50 years, leveraging technology to address a wide range of business needs, from strategy and design to managing operations.The company is committed to unleashing human energy through technology for an inclusive and sustainable future, helping organizations accelerate their transition to a digital and sustainable world.They provide a variety of services, including consulting, technology, professional, and outsourcing services.Job Details:-Skil : Azure Data Engineerlocation : PuneMode Of Work : HybridNotice Period : Immediate JoinersExperience : 6-10yrsType Of Hire : Contract to Hire Job Description :-Key Responsibilities:Mandatory skills:AWS/Azure/SAP - MasterELT - MasterData Modeling - MasterData Integration & Ingestion - SkillData Manipulation and Processing - SkillGITHUB, Action, Azure DevOps - SkillData factory, Databricks, SQL DB, Synapse, Stream Analytics, Glue, Airflow, Kinesis, Redshift, SonarQube, PyTest - Skill

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