AWS Data Lakehouse Consultant

1 month ago

Delhi, India Tri-Force Consulting Services, Inc. Full time
Job DescriptionTitle : AWS Data Lake house Consultant (Architect)Location:

Waterbury Village Historic District, VT 05676Client: The Vermont Department of Public SafetyNote: This is a hybrid position.Job Description:

The Vermont Department of Public Safety (DPS) is seeking to improve statewide law enforcement data access.

The purpose is to design and implement a state-controlled system to access de-identified, aggregated law enforcement andrelated data currently housed in a record management system.

DPS, in collaboration with the Vermont Agency of Digital (ADS) Services, is seeking to procure Amazon Web Service (AWS) professional services to work with the ADS Technical Lead to build out the Public Services Lake house environment.

Design and implement the Department of Public Safety Data Lake in the AWSEnvironmentStore Data in AWS CJIS compliant environment.

Implement and design the lake house technologies with the IT Tech Lead assigned to the project.

Design and implement using latest AWS Lake House standards.

Data Security Layer

Implement and design security Identity and Access Management roles and processes.

Design and Create security IAM templates.

Data Ingestion Layer

Ingestion Design for variety of sources

Operational Database Sources

MySQL, SQL Server

SaaS Applications

File Shares (SharePoint and one drive)

Stream Data Sources

System Templates of ingestion processesData Storage Layer

AWS S3 CJIS compliant S3 buckets

AWS Redshift Infrastructure

Power BI Connector processData Processing Layer

Data Extract, Load and Transform (ELT) process for loading from source to S3 and Transforming data from S3 to Redshift for reporting and analytics.

Templates for creating ELT processes for future processes.

Data Catalog LayerDesign and implement solution to solve data schema drift in AWS Glue for use with reporting and analytical needs.

Design and build crawlers for schema and build catalog that stores schema information.

Meta data store in catalog for consumption in data warehouse

Create Catalog crawler templates for data sources

PROFESSIONAL SERVICE REQUIREMENTSAWS Lake house Certification

AWS Design and Implementation Lake House Technologies

AWS IAM

AWS Lake house Technology

AWS Glue Knowledge

Data Catalog and Crawler

AWS Redshift

AWS Athena

CJIS certified data storage

AWS CJIS Data location

CJIS Security Background Check (See Additional Attachments / Assurances)

If you are: bright, motivated, skilled, a difference-maker, able to get things done, work with minimum direction, enthusiastic, a thinker, able to juggle and multi-task, communicate effectively, and lead, then we would like to hear from you. We need exceptionally capable people for this role for our client, so get back to us and tell us why you think you are a fit.About Us:Tri-Force is one of the fastest growing companies in the Philadelphia region by receiving the award 5 times and 3 times (Ranked #931 2021) on In c. 5000 fastest growing companies in the USA. Tri-Force Consulting Services, In c. is an established consulting services firm offering innovative solutions to Government and Commercial sectors.We specialize in building customized software applications solutions such as knowledge management systems, business intelligence, data analysis, database support and maintenance, data warehouse implementation and support, systems architecture and systems integration for our clients. Our technical competencies are in Java,.NET, SharePoint, PHP, Business Intelligence (Cosign, Data Warehouse), mobile applications platforms (iPhone, iPad, Android, Blackberry), and various other technologies. We also specialize in providing resources to manage infrastructure projects.Tri-Force is one of the fastest growing companies in the Philadelphia region by receiving the award 5 times and 2 times on In c. 5000 fastest growing companies in the USA.RequirementsAWS Lakehouse Certification AWS Design and Implementation Lake House Technologies AWS IAM AWS Lakehouse Technology AWS Glue Knowledge Data Catalog and Crawler AWS Redshift AWS Athena CJIS certified data storage

  • AWS Data Lakehouse Consultant

    6 days ago

    Delhi, Delhi, India Tri-Force Consulting Services, Inc. Full time

    Job DescriptionTitle :AWS Data Lake house Consultant (Architect)Location:Waterbury Village Historic District, VT 05676Client: The Vermont Department of Public SafetyNote: This is a hybrid positionJob Description:The Vermont Department of Public Safety (DPS) is seeking to improve statewide law enforcement data access.The purpose is to design and implement a...

  • AWS Data engineer

    4 weeks ago

    delhi, India YASH Technologies Full time

    Experience4 - 6 YearsJob DescriptionMasters / Bachelors Degree in Computer Science, Information Technology or other relevant fields.• Minimum 5+ Years of Mandatory experience in Advance Data & Analytics Architecture, ETL, Data Engineering solution using the following Skills, tools and technologies:• AWS Data & Analytics Services: Athena, Glue, DynamoDB,...

  • AWS Data engineer

    6 days ago

    Delhi, Delhi, India YASH Technologies Full time

    Experience 6 YearsJob DescriptionMasters / Bachelors Degree in Computer Science, Information Technology or other relevant fields.Minimum 5+ Years of Mandatory experience in Advance Data & Analytics Architecture, ETL, Data Engineering solution using the following Skills, tools and technologies: AWS Data & Analytics Services: Athena, Glue, DynamoDB, Redshift,...

  • Architect : Big Data

    1 week ago

    Delhi, India Databricks Full time

    As a **Solutions Architect** (Analytics, AI, Big Data, Public Cloud), you will guide the technical evaluation phase in a hands-on environment throughout the sales process. You will be a **technical advisor **internally to the sales team, and work with the product team as an advocate of your customers in the field. You will help our customers to achieve...

  • Architect : Big Data / Ml

    2 months ago

    Delhi, India Databricks Full time

    As a **Solutions Architect** (Analytics, AI, Big Data, Public Cloud), you will guide the technical evaluation phase in a hands-on environment throughout the sales process. You will be a **technical advisor **internally to the sales team, and work with the product team as an advocate of your customers in the field. You will help our customers to achieve...

  • Architect : Big Data / Ml

    2 weeks ago

    Delhi, India Databricks Full time

    As a **Solutions Architect** (Analytics, AI, Big Data, Public Cloud), you will guide the technical evaluation phase in a hands-on environment throughout the sales process. You will be a **technical advisor **internally to the sales team, and work with the product team as an advocate of your customers in the field. You will help our customers to achieve...

  • AWS Data Engineer

    4 weeks ago

    new delhi, India Deloitte Full time

    As an AWS Data Engineer Consultant at Deloitte, you will be a key player in designing, implementing, and optimizing data solutions on the Amazon Web Services (AWS) cloud platform. This role involves working closely with clients from various industries, understanding their data needs, and delivering robust data engineering solutions. Your role will...

  • Solutions Architect

    2 weeks ago

    Delhi Cantonment, Delhi, Delhi, India Databricks Full time

    As a **Solutions Architect** (Analytics, AI, Big Data, Public Cloud), you will guide the technical evaluation phase in a hands-on environment throughout the sales process. You will be a **technical advisor **internally to the sales team, and work with the product team as an advocate of your customers in the field. You will help our customers to achieve...

  • AWS Consultant

    6 days ago

    Delhi, Delhi, India iitjobs, Inc. Full time

    GreetingsRole:AWS Consultant Cloud Platform(Associate/Architect/SeniorArchitect)Location- 100 % RemoteDuration: 6 Months ContractImmediate JoinerExperience Level: 6+ YearsRole Requirements AWS: Technical expertise and consulting.AWS Setup: Secure environments, Terraform/CloudFormation.Networking: VPCs, Transit Gateway, VPN.CI/CDTools: AWS tools, GitHub,...

  • Senior Data Engineer

    3 weeks ago

    delhi, India Bunker Full time

    Join Bunker, an early-stage FP&A SaaS startup poised to revolutionise the corporate finance function. Backed by leading investors like Alpha JWC, January Capital, GFC, and strategic angels including Patrick Walujo of Northstar Group, we leverage deep local insights and a contrarian approach to distinguish ourselves in the crowded fintech sector. With a...

  • Senior Data Engineer

    4 weeks ago

    delhi, India Bunker Full time

    Join Bunker, an early-stage FP&A SaaS startup poised to revolutionise the corporate finance function. Backed by leading investors like Alpha JWC, January Capital, GFC, and strategic angels including Patrick Walujo of Northstar Group, we leverage deep local insights and a contrarian approach to distinguish ourselves in the crowded fintech sector. With a...

  • Senior Data Engineer

    6 days ago

    Delhi, Delhi, India Bunker Full time

    Join Bunker, an early-stage FP&A SaaS startup poised to revolutionise the corporate finance function. Backed by leading investors like Alpha JWC, January Capital, GFC, and strategic angels including Patrick Walujo of Northstar Group, we leverage deep local insights and a contrarian approach to distinguish ourselves in the crowded fintech sector. With a...

  • AWS Data Scientist

    1 month ago

    Delhi, India ITTConnect Full time

    Job DescriptionITTConnect is seeking anAWS Data Scientistto fill a permanent role with a client in the Atlanta area. This is a position with a client that is a global leader in consulting, digital transformation, technology and engineering services present in nearly 50 countries. The end client is in the telecommunications space (internet, cable TV, cellular...

  • Solutions Architect

    6 days ago

    Delhi, Delhi, India Koantek Full time

    The AWS/Azure/GCP Architect at Koantek builds secure, highly scalable big data solutions to achieve tangible, data-driven outcomes all the while keeping simplicity and operational effectiveness in mind.This role collaborates with teammates, product teams, and cross-functional project teams to lead the adoption and integration of the Databricks Lakehouse...

  • Solutions Architect

    5 days ago

    Delhi, India Koantek Full time

    TheAWS/Azure/GCPArchitect at Koantek builds secure, highly scalable big data solutions to achieve tangible, data-driven outcomes all the while keeping simplicity and operational effectiveness in mind. This role collaborates with teammates, product teams, and cross-functional project teams to lead the adoption and integration of the Databricks Lakehouse...

  • Solutions Architect

    5 days ago

    delhi, India Koantek Full time

    The AWS/Azure/GCP Architect at Koantek builds secure, highly scalable big data solutions to achieve tangible, data-driven outcomes all the while keeping simplicity and operational effectiveness in mind. This role collaborates with teammates, product teams, and cross-functional project teams to lead the adoption and integration of the Databricks Lakehouse...

  • SXM Deltalake Developer

    6 days ago

    Delhi, Delhi, India Marlabs LLC Full time

    :What you'll do Spearhead the development of conceptual, logical, and physical data models, while implementing data marts/data warehouse/data lake/data lakehouse on Spark-based platforms Analyse existing models to identify variances/gaps and devise strategies to achieve alignment. Establish and enforce best practices and standards for data models. Generate...

  • Data Bricks in AWS

    6 days ago

    Delhi, Delhi, India Munif Enterprise Consulting Full time

    Munif Enterprise Consulting is a team of tech-savvy individuals who embrace technical challenges and are passionate about solving them. Our team consists of experts who have diverse IT experience and are committed to pushing existing projects further than ever before. We have clients from the US, UK, Middle East, and Asia.Role :Data Bricks resources in AWS -...

  • Aws Consultant

    1 month ago

    Delhi, India Tech Mahindra Full time

    Dear Candidate ,Hiring for AWS ConsultantExp-8 +Yearswork from officecan join in 15 daysJD:Must have:In-depth knowledge and hands-on experience with AWS services including EC2, S3, RDS, Lambda, VPC, IAM, CloudFormation, etc.Ability to design complex AWS solutions that meet business requirements and align with industry best practices.Proven experience in...

  • Aws Consultant

    6 days ago

    Delhi, Delhi, India Tech Mahindra Full time

    Dear Candidate ,Hiring for AWS ConsultantExp-8 +Yearswork from officecan join in 15 daysJD:Must have:In-depth knowledge and hands-on experience with AWS services including EC2, S3, RDS, Lambda, VPC, IAM, CloudFormation, etc.Ability to design complex AWS solutions that meet business requirements and align with industry best practices.Proven experience in...