Senior Database Administrator

Job Title: SQL Query Writer - Analytics Automation

Location: Thane (West), Mumbai

Experience: 4-5 years

Responsibilities:

• Develop and optimize SQL queries for efficient data retrieval and analysis.
• Automate analytics processes using platforms like SQL, Python, ACL, Alteryx, Analyzer, Excel Macros, and Access Query.
• Collaborate with cross-functional teams to understand analytical requirements and provide effective solutions.
• Ensure data accuracy, integrity, and security in automated processes.
• Troubleshoot and resolve issues related to analytics automation.

Qualifications:

• Minimum 3 years of experience in SQL query writing and analytics automation.
• Proficiency in SQL, Python, ACL, Alteryx, Analyzer, Excel Macros, and Access Query.
• Strong analytical skills and attention to detail.

Kindly note that candidates who have graduated in 2022 and 2023 only will be considered for the role who are based in Mumbai, immediate joiners

JD - Data Operations Analyst

What is the job and team like

• As a Data Operations Analyst we manage business reporting of numerous teams, constantly monitor performance
• Checking the integrity of the revenue reporting done by the different systems for the correct profitability to be
• reported to the CXOs
• Send reports periodically and alert stakeholders for changes in the key performance metrics
• Allocate efforts to different Business Implementations that help build Profit/Loss statement for the Financials.
• Track crucial data points which affect the core of the business and escalate it to senior stakeholders

Roles and Responsibilities

• Graduate in IT Background(BE/BSc IT/ BCA) 2022 and 2023 graduates only
• Executing a set of business processes daily/weekly/monthly as per Business requirement.
• Provide ad-hoc data support on any urgent reports and material in an expedited manner
• Maintain a list of open tasks and escalations, and send updates to the relevant stakeholders
• Have an eye for detail, should have the ability to look at numbers, spot trends and identify gaps
• Identify efficient and meaningful ways to communicate data and analysis through ongoing reports and dashboards
• Proficiency in SQL, Excel and any statistical and analytical tools such as SAS, SPSS is a big plus
• Managing master data, including creation, updates, and deletion.
• Ability to work in a fast paced, technical, cross functional environment
• Familiarity with Internet Industry and Online Advertising Business is a plus

Ideal candidate

• Import and export large volume of data to database tables as required
• Should be able to write Data Definition Language or Data Manipulation Language SQL commands
• Develop programs, methodologies to get analyzable data on a regular basis
• Good team player and multi-tasker
• Should have the ability to learn and adapt to change
• Self-starter Must be productive with minimal direction
• High-level written and verbal communication sk

Job Details

Work mode- In office

Must have skills - SQL, MS Excel, Communications

 Job DescriptionPosition: Sr Data Engineer – Databricks & AWS

Experience: 4 - 5 Years

Company Profile:

Exponentia.ai is an AI tech organization with a presence across India, Singapore, the Middle East, and the UK. We are an innovative and disruptive organization, working on cutting-edge technology to help our clients transform into the enterprises of the future. We provide artificial intelligence-based products/platforms capable of automated cognitive decision-making to improve productivity, quality, and economics of the underlying business processes. Currently, we are transforming ourselves and rapidly expanding our business.

Exponentia.ai has developed long-term relationships with world-class clients such as PayPal, PayU, SBI Group, HDFC Life, Kotak Securities, Wockhardt and Adani Group amongst others.

One of the top partners of Cloudera (leading analytics player) and Qlik (leader in BI technologies), Exponentia.ai has recently been awarded the ‘Innovation Partner Award’ by Qlik in 2017.

Get to know more about us on our website: http://www.exponentia.ai/ and Life @Exponentia.

​Role Overview: 

·         A Data Engineer understands the client requirements and develops and delivers the data engineering solutions as per the scope.

·         The role requires good skills in the development of solutions using various services required for data architecture on Databricks Delta Lake, streaming, AWS, ETL Development, and data modeling.

Job Responsibilities

•         Design of data solutions on Databricks including delta lake, data warehouse, data marts and other data solutions to support the analytics needs of the organization.

•         Apply best practices during design in data modeling (logical, physical) and ETL pipelines (streaming and batch) using cloud-based services.

•         Design, develop and manage the pipelining (collection, storage, access), data engineering (data quality, ETL, Data Modelling) and understanding (documentation, exploration) of the data.

•         Interact with stakeholders regarding data landscape understanding, conducting discovery exercises, developing proof of concepts and demonstrating it to stakeholders.

Technical Skills 

•         Has more than 2 Years of experience in developing data lakes, and datamarts on the Databricks platform.

•         Proven skill sets in AWS Data Lake services such as - AWS Glue, S3, Lambda, SNS, IAM, and skills in Spark, Python, and SQL.

•         Experience in Pentaho

•         Good understanding of developing a data warehouse, data marts etc.

•         Has a good understanding of system architectures, and design patterns and should be able to design and develop applications using these principles.

Personality Traits

•         Good collaboration and communication skills

•         Excellent problem-solving skills to be able to structure the right analytical solutions.

•         Strong sense of teamwork, ownership, and accountability

•         Analytical and conceptual thinking 

•         Ability to work in a fast-paced environment with tight schedules.

•         Good presentation skills with the ability to convey complex ideas to peers and management.

Education:

BE / ME / MS/MCA.

From building entire infrastructures or platforms to solving complex IT challenges, Cambridge Technology helps businesses accelerate their digital transformation and become AI-first businesses. With over 20 years of expertise as a technology services company, we enable our customers to stay ahead of the curve by helping them figure out the perfect approach, solutions, and ecosystem for their business. Our experts help customers leverage the right AI, big data, cloud solutions, and intelligent platforms that will help them become and stay relevant in a rapidly changing world.

No Of Positions: 1

Skills required: 

• The ideal candidate will have a bachelor’s degree in data science, statistics, or a related discipline with 4-6 years of experience, or a master’s degree with 4-6 years of experience. A strong candidate will also possess many of the following characteristics:
• Strong problem-solving skills with an emphasis on achieving proof-of-concept
• Knowledge of statistical techniques and concepts (regression, statistical tests, etc.)
• Knowledge of machine learning and deep learning fundamentals
• Experience with Python implementations to build ML and deep learning algorithms (e.g., pandas, numpy, sci-kit-learn, Stats Models, Keras, PyTorch, etc.)
• Experience writing and debugging code in an IDE
• Experience using managed web services (e.g., AWS, GCP, etc.)
• Strong analytical and communication skills
• Curiosity, flexibility, creativity, and a strong tolerance for ambiguity
• Ability to learn new tools from documentation and internet resources.

Roles and responsibilities :

• You will work on a small, core team alongside other engineers and business leaders throughout Cambridge with the following responsibilities:
• Collaborate with client-facing teams to design and build operational AI solutions for client engagements.
• Identify relevant data sources for data wrangling and EDA
• Identify model architectures to use for client business needs.
• Build full-stack data science solutions up to MVP that can be deployed into existing client business processes or scaled up based on clear documentation.
• Present findings to teammates and key stakeholders in a clear and repeatable manner.

Experience :

2 - 14 Yrs

Job Description

▪ You are responsible for setting up, operating, and monitoring LS system solutions on premise and in the cloud

▪ You are responsible for the analysis and long-term elimination of system errors

▪ You provide support in the area of ​​information and IT security

▪ You will work on the strategic further development and optimize the platform used

▪ You will work in a global, international team requirement profile

▪ You have successfully completed an apprenticeship / degree in the field of IT

▪ You can demonstrate in-depth knowledge and experience in the following areas:

▪ PostgreSQL databases

▪ Linux (e.g. Ubuntu, Oracle Linux, RHEL)

▪ Windows (e.g. Windows Server 2019/2022)

▪ Automation / IaC (e.g. Ansible, Terraform)

▪ Containerization with Kubernetes / Virtualization with Vmware is an advantage

▪ Service APIs (AWS, Azure)

▪ You have very good knowledge of English, knowledge of German is an advantage

▪ You are a born team player, show high commitment and are resilient

Company Profile:

Easebuzz is a payment solutions (fintech organisation) company which enables online merchants to accept, process and disburse payments through developer friendly APIs. We are focusing on building plug n play products including the payment infrastructure to solve complete business problems. Definitely a wonderful place where all the actions related to payments, lending, subscription, eKYC is happening at the same time.

We have been consistently profitable and are constantly developing new innovative products, as a result, we are able to grow 4x over the past year alone. We are well capitalised and have recently closed a fundraise of $4M in March, 2021 from prominent VC firms and angel investors. The company is based out of Pune and has a total strength of 180 employees. Easebuzz’s corporate culture is tied into the vision of building a workplace which breeds open communication and minimal bureaucracy. An equal opportunity employer, we welcome and encourage diversity in the workplace. One thing you can be sure of is that you will be surrounded by colleagues who are committed to helping each other grow.

Easebuzz Pvt. Ltd. has its presence in Pune, Bangalore, Gurugram.

Salary: As per company standards.

Designation: Data Engineering

Location: Pune

Experience with ETL, Data Modeling, and Data Architecture

Design, build and operationalize large scale enterprise data solutions and applications using one or more of AWS data and analytics services in combination with 3rd parties
- Spark, EMR, DynamoDB, RedShift, Kinesis, Lambda, Glue.

Experience with AWS cloud data lake for development of real-time or near real-time use cases

Experience with messaging systems such as Kafka/Kinesis for real time data ingestion and processing

Build data pipeline frameworks to automate high-volume and real-time data delivery

Create prototypes and proof-of-concepts for iterative development.

Experience with NoSQL databases, such as DynamoDB, MongoDB etc

Create and maintain optimal data pipeline architecture,

Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.

Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and AWS ‘big data’ technologies.

Build analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency and other key business performance metrics.

Work with stakeholders including the Executive, Product, Data and Design teams to assist with data-related technical issues and support their data infrastructure needs.

Keep our data separated and secure across national boundaries through multiple data centers and AWS regions.

Create data tools for analytics and data scientist team members that assist them in building and optimizing our product into an innovative industry leader.

Evangelize a very high standard of quality, reliability and performance for data models and algorithms that can be streamlined into the engineering and sciences workflow

Build and enhance data pipeline architecture by designing and implementing data ingestion solutions.

Employment Type

Full-time

Pingahla is recruiting business intelligence Consultants/Senior consultants who can help us with Information Management projects (domestic, onshore and offshore) as developers and team leads. The candidates are expected to have 3-6 years of experience with Informatica Power Center/Talend DI/Informatica Cloud and must be very proficient with Business Intelligence in general. The job is based out of our Pune office.

Responsibilities:

• Manage the customer relationship by serving as the single point of contact before, during and after engagements.
• Architect data management solutions.
• Provide technical leadership to other consultants and/or customer/partner resources.
• Design, develop, test and deploy data integration solutions in accordance with customer’s schedule.
• Supervise and mentor all intermediate and junior level team members.
• Provide regular reports to communicate status both internally and externally.
• Qualifications:
• A typical profile that would suit this position would be if the following background:
• A graduate from a reputed engineering college 
• An excellent I.Q and analytical skills and should be able to grasp new concepts and learn new technologies.
• A willingness to work with a small team in a fast-growing environment.
• A good knowledge of Business Intelligence concepts

Mandatory Requirements:

• Knowledge of Business Intelligence
• Good knowledge of at least one of the following data integration tools - Informatica Powercenter, Talend DI, Informatica Cloud
• Knowledge of SQL
• Excellent English and communication skills
• Intelligent, quick to learn new technologies
• Track record of accomplishment and effectiveness with handling customers and managing complex data management needs
   

   3+ years of experience in deployment, monitoring, tuning, and administration of high concurrency MySQL production databases.

• Solid understanding of writing optimized SQL queries on MySQL databases
• Understanding of AWS, VPC, networking, security groups, IAM, and roles.
• Expertise in scripting in Python or Shell/Powershell
• Must have experience in large scale data migrations
• Excellent communication skills.