Oracle Administrator

Hi Kirti,

Job Title: Data Analytics Engineer

Experience: 3 to 6 years

 Location: Gurgaon (Hybrid)

Employment Type: Full-time

Job Description: 

We are seeking a highly skilled Data Analytics Engineer with expertise in Qlik Replicate, Qlik Compose, and Data Warehousing to build and maintain robust data pipelines. The ideal candidate will have hands-on experience with Change Data Capture (CDC) pipelines from various sources, an understanding of Bronze, Silver, and Gold data layers, SQL querying for data warehouses like Amazon Redshift, and experience with Data Lakes using S3. A foundational understanding of Apache Parquet and Python is also desirable. 

Key Responsibilities: 

1. Data Pipeline Development & Maintenance 

• Design, develop, and maintain ETL/ELT pipelines using Qlik Replicate and Qlik Compose. 
• Ensure seamless data replication and transformation across multiple systems. 
• Implement and optimize CDC-based data pipelines from various source systems. 

2. Data Layering & Warehouse Management 

• Implement Bronze, Silver, and Gold layer architectures to optimize data workflows. 
• Design and manage data pipelines for structured and unstructured data. 
• Ensure data integrity and quality within Redshift and other analytical data stores. 

3. Database Management & SQL Development 

• Write, optimize, and troubleshoot complex SQL queries for data warehouses like Redshift. 
• Design and implement data models that support business intelligence and analytics use cases. 

4. Data Lakes & Storage Optimization 

• Work with AWS S3-based Data Lakes to store and manage large-scale datasets. 
• Optimize data ingestion and retrieval using Apache Parquet. 

5. Data Integration & Automation 

• Integrate diverse data sources into a centralized analytics platform. 
• Automate workflows to improve efficiency and reduce manual effort. 
• Leverage Python for scripting, automation, and data manipulation where necessary. 

6. Performance Optimization & Monitoring 

• Monitor data pipelines for failures and implement recovery strategies. 
• Optimize data flows for better performance, scalability, and cost-effectiveness. 
• Troubleshoot and resolve ETL and data replication issues proactively. 

Technical Expertise Required: 

• 3 to 6 years of experience in Data Engineering, ETL Development, or related roles. 
• Hands-on experience with Qlik Replicate & Qlik Compose for data integration. 
• Strong SQL expertise, with experience in writing and optimizing queries for Redshift. 
• Experience working with Bronze, Silver, and Gold layer architectures. 
• Knowledge of Change Data Capture (CDC) pipelines from multiple sources. 
• Experience working with AWS S3 Data Lakes. 
• Experience working with Apache Parquet for data storage optimization. 
• Basic understanding of Python for automation and data processing. 
• Experience in cloud-based data architectures (AWS, Azure, GCP) is a plus. 
• Strong analytical and problem-solving skills. 
• Ability to work in a fast-paced, agile environment. 

Preferred Qualifications: 

• Experience in performance tuning and cost optimization in Redshift. 
• Familiarity with big data technologies such as Spark or Hadoop. 
• Understanding of data governance and security best practices. 
• Exposure to data visualization tools such as Qlik Sense, Tableau, or Power BI. 

Company Description

Appectual IT Solutions is a software development company based in Mumbai, specializing in creating usable, functional, and intuitive websites and apps. They are known for delivering impactful solutions powered by the latest technologies across various industries. Appectual has a track record of working with reputable brands like L'oreal, Reebok, Wockhardt, Apar Lubricants, and Birla, and is committed to finding the perfect solutions for their clients' needs.

Role Description

This is a full-time Hybrid role for as a Business Development Executive at Appectual IT Solutions in Mumbai. The Business Development Executive will be responsible for new business development, lead generation, business communication, and account management on a day-to-day basis.

Must-Have Skills:

Proposal Creation

Good conversion rate history

Relevant Experience: 6 Months- 2 Yrs

Expected Joining: 30 Days

Qualifications

New Business Development and Lead Generation skills

Strong business acumen and communication skills

Account Management expertise

Prior experience in sales or business development

Knowledge of the IT industry and software solutions

Ability to work well in a team and independently

Bachelor's degree in Business Administration, Marketing, or related field

• Own the product analytics of bidgely’s end user-facing products, measure and identify areas of improvement through data
• Liaise with Product Managers and Business Leaders to understand the product issues, priorities and hence support them through relevant product analytics
• Own the automation of product analytics through good SQL knowledge
• Develop early warning metrics for production and highlight issues and breakdowns for resolution
• Resolve client escalations and concerns regarding key business metrics
• Define and own execution
• Own the Energy Efficiency program designs, dashboard development, and monitoring of existing Energy efficiency program
• Deliver data-backed analysis and statistically proven solutions
• Research and implement best practices
• Mentor team of analysts

• B.Tech from a premier institute with 5+ years analytics experience or Full-time MBA from a premier b-school with 3+ years of experience in analytics/business or product analytics
• Bachelor's degree in Business, Computer Science, Computer Information Systems, Engineering, Mathematics, or other business/analytical disciplines

• Proven analytical and quantitative skills and an ability to use data and metrics to back up assumptions, develop business cases, and complete root cause
  analyses
• Excellent understanding of retention, churn, and acquisition of user base
• Ability to employ statistics and anomaly detection techniques for data-driven
  analytics
• Ability to put yourself in the shoes of the end customer and understand what
  “product excellence” means
• Ability to rethink existing products and use analytics to identify new features and product improvements.
• Ability to rethink existing processes and design new processes for more effective analyses
• Strong SQL knowledge, working experience with Looker and Tableau a great plus
• Strong commitment to quality visible in the thoroughness of analysis and techniques employed
• Strong project management and leadership skills
• Excellent communication (oral and written) and interpersonal skills and an ability to effectively communicate with both business and technical teams
• Ability to coach and mentor analysts on technical and analytical skills
• Good knowledge of statistics, basic machine learning, and AB Testing is
  preferable
• Experience as a Growth hacker and/or in Product analytics is a big plus

Designation: Graphics and Simulation Engineer

Experience: 3-15 Yrs

Position Type: Full Time

Position Location: Hyderabad

Description:

We are looking for engineers to work on applied research problems related to computer graphics in autonomous driving of electric tractors. The team works towards creating a universe of farm environments in which tractors can driver around for the purposes of simulation, synthetic data generation for deep learning training, simulation of edges cases and modelling physics.

Technical Skills:

● Background in OpenGL, OpenCL, graphics algorithms and optimization is necessary.

● Solid theoretical background in computational geometry and computer graphics is desired. Deep learning background is optional.

● Experience in two view and multi-view geometry.

● Necessary Skills: Python, C++, Boost, OpenGL, OpenCL, Unity3D/Unreal, WebGL, CUDA.

●  Academic experience for freshers in graphics is also preferred.

●  Experienced candidates in Computer Graphics with no prior Deep Learning experience willing to apply their knowledge to vision problems are also encouraged to apply.

● Software development experience on low-power embedded platforms is a plus.

 Responsibilities:

● Understanding of engineering principles and a clear understanding of data structures and algorithms.

● Ability to understand, optimize and debug imaging algorithms.

●  Ability to drive a project from conception to completion, research papers to code with disciplined approach to software development on Linux platform

● Demonstrate outstanding ability to perform innovative and significant research in the form of technical papers, thesis, or patents.

● Optimize runtime performance of designed models.

● Deploy models to production and monitor performance and debug inaccuracies and exceptions.

● Communicate and collaborate with team members in India and abroad for the fulfillment of your duties and organizational objectives.

● Thrive in a fast-paced environment and have the ability to own the project end to end with minimum hand holding

●  Learn & adapt new technologies & skillsets

● Work on projects independently with timely delivery & defect free approach.

● Thesis focusing on the above skill set may be given more preference.

·         Architect, develop and deploy software using Django/ Python

·         Strong hands on experience in Django and Python Experience with RDBMS, PostgreSQL, MySQL.

·         Experience with HTML5, HTML, CSS, JavaScript, jQuery.

·         Experience with Linux platform.

·         Experience building responsive web applications with Bootstrap

·         Understanding of Amazon AWS/ EC2 deployment architecture experience is a plus

·         Experience with source control management tools (Git preferred) Preferred skills 

·         Any work experience related to data scraping algorithms would be an add on weightage

 Skills and Qualifications:

1. A Master’s degree in computer application or B. tech is required.
2. Strong organizational and project management skills.
3. Required minimum 3 years of experience.
4. Knowledge of C#, ASP.NET, MVC, SQL Server, MYSQL, NOSQL, Oracle, MongoDB, HTML, CSS and Javascript
5. Familiarity with JavaScript frameworks such as Angular JS, React, and Amber. 
6. Experience developing web applications using .NET Framework 4.5.
7. Design building and maintaining efficient and reusable C# code using design patterns.
8. Knowledge of Agile methodology/ Kanban concepts is a plus.
9. Contribute to the Agile software development process including: design, programming, testing, documentation, quality assurance and implementation.
10. High proficiency in English (Written and oral) is mandatory.

• Coordinating the involvement of additional departments (cross functional), including sales, customer service and management resources if necessary, in order to meet partner performance objectives and partners’ expectations
• Meeting assigned targets for profitable sales volume and strategic objectives in the partner accounts
• Proactively assessing, clarifying, and validating partner needs on an ongoing basis
• Identifying, advising and assisting in implementing new or improved products, processes and procedures
• Leading solution development efforts that best address merchant and partner needs, while coordinating the involvement of all necessary departments
• Identifying key new partners and securing the relationship
• Taking care of all commercial and contractual negotiations with the partners
• Closing partnership agreements while properly balancing company goals, speed, and economic potential in delivering actual results
• Ensuring efficient and effective boarding and implementation of new partners, working closely with the partner’s sales and technical organization
• Taking designated targets for new accounts and getting them added to the pool target to deliver in the planned and promised timelines
• Preparing weekly, monthly, and quarterly report of performance and presenting it to the Vertical Head

Desired Candidate Profile

• MBA with Minimum 3 yrs+ proven track record in partner relationship management or Key Accounts Management
• Alliance or Lending experience is a plus
• Ability to articulate complex issues clearly to partners, management and internal departments
• Continuous learning mentality and eagerness to challenge/ improve current processes
• Creative and strategic thinking with problem solving attitude
• Strong sales orientation – driven by results – and commercial awareness
• Self-motivation and ability to handle stressful situations and failure
• Good initiatives on getting leads and partner
• Excellent MS Excel skills and confidence in timely reporting
• Excellent communications with superior written, verbal, presentation and interpersonal skills