11+ Snow flake schema Jobs in Ahmedabad | Snow flake schema Job openings in Ahmedabad

Job Description

Mandatory Requirements 

• Experience in AWS Glue

• Experience in Apache Parquet 

• Proficient in AWS S3 and data lake 

• Knowledge of Snowflake

• Understanding of file-based ingestion best practices.

• Scripting language - Python & pyspark

CORE RESPONSIBILITIES

• Create and manage cloud resources in AWS 

• Data ingestion from different data sources which exposes data using different technologies, such as: RDBMS, flat files, Streams, and Time series data based on various proprietary systems. Implement data ingestion and processing with the help of Big Data technologies 

• Data processing/transformation using various technologies such as Spark and Cloud Services. You will need to understand your part of business logic and implement it using the language supported by the base data platform 

• Develop automated data quality check to make sure right data enters the platform and verifying the results of the calculations 

• Develop an infrastructure to collect, transform, combine and publish/distribute customer data.

• Define process improvement opportunities to optimize data collection, insights and displays.

• Ensure data and results are accessible, scalable, efficient, accurate, complete and flexible 

• Identify and interpret trends and patterns from complex data sets 

• Construct a framework utilizing data visualization tools and techniques to present consolidated analytical and actionable results to relevant stakeholders. 

• Key participant in regular Scrum ceremonies with the agile teams  

• Proficient at developing queries, writing reports and presenting findings 

• Mentor junior members and bring best industry practices.

QUALIFICATIONS

• 5-7+ years’ experience as data engineer in consumer finance or equivalent industry (consumer loans, collections, servicing, optional product, and insurance sales) 

• Strong background in math, statistics, computer science, data science or related discipline

• Advanced knowledge one of language: Java, Scala, Python, C# 

• Production experience with: HDFS, YARN, Hive, Spark, Kafka, Oozie / Airflow, Amazon Web Services (AWS), Docker / Kubernetes, Snowflake  

• Proficient with

• Data mining/programming tools (e.g. SAS, SQL, R, Python)

• Database technologies (e.g. PostgreSQL, Redshift, Snowflake. and Greenplum)

• Data visualization (e.g. Tableau, Looker, MicroStrategy)

• Comfortable learning about and deploying new technologies and tools. 

• Organizational skills and the ability to handle multiple projects and priorities simultaneously and meet established deadlines. 

• Good written and oral communication skills and ability to present results to non-technical audiences 

• Knowledge of business intelligence and analytical tools, technologies and techniques.

Familiarity and experience in the following is a plus: 

• AWS certification

• Spark Streaming 

• Kafka Streaming / Kafka Connect 

• ELK Stack 

• Cassandra / MongoDB 

• CI/CD: Jenkins, GitLab, Jira, Confluence other related tools

Team Leads Interior Design

• Experience: 10+ years
• Location: Ahmedabad(Sanand)
• CTC:Up to 80 k/ month
• Mon to Saturday
• Work from Office
• Degree of interior design is compulsory

Requirements and Skills

· A bachelor's or master's degree in Interior Designing is typically required.

· A minimum of 8 to 10 years of professional experience in Interior Designing, with demonstrated leadership skills and project coordination experience.

· Proficiency in Interior Designing software and tools.

· IIID association will be plus.

· Strong design creativity, attention to detail, and the ability to provide design guidance and feedback.

· Project management experience, including scheduling, budgeting, and resource allocation.

· Effective communication and interpersonal skills to collaborate with team members, clients, and stakeholders.

· Knowledge of Interior Designing principles, building systems, construction methods, and industry regulations.

Job Overview: We are looking for a highly skilled and experienced Node.js Developer to join our team. The ideal candidate will have over 5 years of experience in developing scalable, high-performance backend applications using Node.js and related technologies. You will work closely with cross-functional teams to design, develop, and deploy robust solutions.

Key Responsibilities:

· Develop, maintain, and optimize server-side applications using VueJs, Node.js and Express.js.

· Design and implement scalable RESTful APIs and GraphQL APIs.

· Work with databases such as MongoDB, PostgreSQL, or MySQL.

· Ensure the security, performance, and responsiveness of applications.

· Collaborate with front-end developers, UX designers, and product managers.

· Implement automated testing and continuous integration.

· Debug and optimize existing code for performance improvements.

·  Stay updated with the latest trends and best practices in Node.js development.

Required Skills & Qualifications:

· 5+ years of experience in backend development using Node.js.

· Proficiency in JavaScript & TypeScript.

· Strong knowledge of Express.js, Nest.js, or similar frameworks.

· Experience with microservices architecture and cloud platforms (AWS, Azure, GCP).

· Expertise in database technologies such as MongoDB, PostgreSQL, or MySQL.

· Familiarity with Docker, Kubernetes, and CI/CD pipelines.

· Experience with authentication and security best practices (JWT, OAuth, etc.).

· Strong debugging and performance optimization skills.

·  Ability to work in an agile environment and collaborate with cross-functional teams.

Preferred Qualifications:

· Experience with message queues (RabbitMQ, Kafka, etc.).

· Knowledge of DevOps practices and infrastructure as code (Terraform, Ansible).

· Familiarity with front-end technologies such as VueJs or React.

· Contributions to open-source projects or a strong GitHub portfolio.

URGENT REQUIREMENT graphic designer FOR LEADING pharmaCEUTICAL COMPANY

Job Description:

• Candidate must have knowledge of Corel draw, Photoshop & Illustrator
• Product designs & brochures,3D box designer, flyers
• Handles rejection
• Pharma background designer

Candidate Profile:

• Candidate should be a Graduate preferably with hands on 3-5 years’ experience in Pharma Industries
• Should have excellent command in Computer Skills
• Work well under pressure
• Innovative thinker & Ability to learn fast
• Can be work independently
• Excellent communication skill
• Time and resource management skills

Additional Information:

Legal Assistant responsibility include:

• Negotiate, review, drafting, vetting of various contracts and agreements 

• Drafting knowledge of notices/reply notice/letters to any govt., & Non-Govt. authorities.

• Drafting of other miscellaneous documents like Power of Attorney, Undertakings required as per the need of business, Memorandum of Understanding, No Objection Certificate (NOC)

• Responsible for supporting Groups Secretarial function, convening of Board shareholders & Committee Meeting

• Attending and handling court cases, case notices and handle all litigation matters with support of external counsel;

• Submission of reports/ MIS/ litigation updates, contract trackers to the Department on monthly & quarterly basis.

• Conduct research on relevant laws, regulations

• Taking care of any matter as and when received from the management and advising them within the legal ambit.

• Maintain knowledge of all new changes in the law, analyze implications and suggest a manner of implementation.

• Responsible for maintaining all legal records & documents within the legal department.

• Organize and maintain documents in a paper or electronic filing systems.
• Maintaining of statutory register and records

• To work with external law firms, other consultants, statutory auditors as and when required.

• Manage the day-to-day affairs of assigned sub-tasks.

• Perform other tasks as assigned to support the department as and when required.

• Develop, record and maintain cutting edge web-based PHP applications on portal plus premium service platforms
• Build innovative, state-of-the-art applications and collaborate with the User Experience (UX) team
• Ensure HTML, CSS, and shared JavaScript is valid and consistent across applications
• Prepare and maintain all applications utilizing standard development tools
• Utilize backend data services and contribute to increase existing data services API
• Lead the entire web application development life cycle right from concept stage to delivery and post launch support
• Convey effectively with all task progress, evaluations, suggestions, schedules along with technical and process issues
• Document the development process, architecture, and standard components
• Coordinate with co-developers and keeps project manager well informed of the status of development effort and serves as liaison between development staff and project manager
• Keep abreast of new trends and best practices in web development

• 7+ Year of experience with Dot Net Technology with MVC Framework: Angular must require. 
• Mock-ups and designs into pages complete with CSS, HTML, and Angular Writing tested, idiomatic, asynchronous and documented Angular, HTML and CSS. 
• Aware of new features in Angular 7,8,9 
• Ability to develop UIT from wireframes & prototypes 
• Write modular, secure, and well-tested front-end code cooperating with the back- end developer in the process of building the Restful API, Develop User interfaces for Modern Rich Internet Applications with the latest Front-End Technologies. 
• Experience Design overall architecture of the web application Proficient understanding of web trends and technologies like HTML5, CSS3, JavaScript, object-oriented JavaScript, jQuery and Responsive design. 
• Must have experience of working on enterprise single page application can write client-side code for web-based applications, create fast, easy-to-use, high volume production applications, and develop prototypes quickly. Extensive experience of JavaScript, Angular, React and Node.js 

Must to have skills: 

• Angular with updated version, Dot Net, C# and above, HTML 5, CSS 3, Bootstrap, jQuery, Typescript, MVC 5, Web API 2.x, Entity Framework, SQL Server 2012, Store Procedures, Triggers. 

Good to have skills: 

• Dot Net + Angular

Responsibilities:

• Implement effective sourcing, screening, and interviewing techniques

• Developing fair HR policies and ensuring employees understand and comply with them

• Manage employee relations, employee engagement, appraisals, PF, ESI, etc.

• Act as the point of contact regarding labor legislation issues

• Manage employees’ grievances
• Create and run referral bonus programs
• Oversee daily operations of the HR department

Requirements:

• Must have at least 2+ years experience in Human Resource in manufacturing/industrial company. 
• Proven work experience as an HR Executive, HR Manager or similar role
• Familiarity with Human Resources Management Systems and Applicant Tracking Systems
• Experience with full-cycle recruiting
• Good knowledge of labor legislation (particularly employment contracts, employee leaves, and insurance)
• Demonstrable leadership abilities
• Solid communication skills
• BSc/MSc in Human Resources Management or relevant field

Skills:

1. Should have good strong knowledge in ASP.NET MVC 3.0 and above
2. 3+ Years Of Experience in .Net Framework, C#, WCF, ASP.Net, MYSQL, SQL Server 2005/ 2008.
3. 2+ Years Of Hands-on Experience on MVC
4. Well-versed with Javascript, Jquery, AJAX, Web-services, Threading.
5. Good understanding of HTML5, CSS3, Web Services, XML, XSLT, Object Oriented Design, with experience working in high transactional applications.
6. Have strong concepts of OOPS.
7. Experience with Cloud computing (AWS Amazon Web Services/Windows Azure) will be an added advantage
8. Practical experience with Agile methodologies