Data Analyst

Bangalore / Chennai

• Hands-on data modelling for OLTP and OLAP systems
• In-depth knowledge of Conceptual, Logical and Physical data modelling
• Strong understanding of Indexing, partitioning, data sharding, with practical experience of having done the same
• Strong understanding of variables impacting database performance for near-real-time reporting and application interaction.
• Should have working experience on at least one data modelling tool, preferably DBSchema, Erwin
• Good understanding of GCP databases like AlloyDB, CloudSQL, and BigQuery.
• People with functional knowledge of the mutual fund industry will be a plus

Role & Responsibilities:

● Work with business users and other stakeholders to understand business processes.

● Ability to design and implement Dimensional and Fact tables

● Identify and implement data transformation/cleansing requirements

● Develop a highly scalable, reliable, and high-performance data processing pipeline to extract, transform and load data from various systems to the Enterprise Data Warehouse

● Develop conceptual, logical, and physical data models with associated metadata including data lineage and technical data definitions

● Design, develop and maintain ETL workflows and mappings using the appropriate data load technique

● Provide research, high-level design, and estimates for data transformation and data integration from source applications to end-user BI solutions.

● Provide production support of ETL processes to ensure timely completion and availability of data in the data warehouse for reporting use.

● Analyze and resolve problems and provide technical assistance as necessary. Partner with the BI team to evaluate, design, develop BI reports and dashboards according to functional specifications while maintaining data integrity and data quality.

● Work collaboratively with key stakeholders to translate business information needs into well-defined data requirements to implement the BI solutions.

● Leverage transactional information, data from ERP, CRM, HRIS applications to model, extract and transform into reporting & analytics.

● Define and document the use of BI through user experience/use cases, prototypes, test, and deploy BI solutions.

● Develop and support data governance processes, analyze data to identify and articulate trends, patterns, outliers, quality issues, and continuously validate reports, dashboards and suggest improvements.

● Train business end-users, IT analysts, and developers.

Required Skills:

● Bachelor’s degree in Computer Science or similar field or equivalent work experience.

● 5+ years of experience on Data Warehousing, Data Engineering or Data Integration projects.

● Expert with data warehousing concepts, strategies, and tools.

● Strong SQL background.

● Strong knowledge of relational databases like SQL Server, PostgreSQL, MySQL.

● Strong experience in GCP & Google BigQuery, Cloud SQL, Composer (Airflow), Dataflow, Dataproc, Cloud Function and GCS

● Good to have knowledge on SQL Server Reporting Services (SSRS), and SQL Server Integration Services (SSIS).

● Knowledge of AWS and Azure Cloud is a plus.

● Experience in Informatica Power exchange for Mainframe, Salesforce, and other new-age data sources.

● Experience in integration using APIs, XML, JSONs etc.

JD

·       Minimum 4-18 Years of Core Java Programming with spring boot Framework,Design patterns Concurrent Programming, Multi-threading (Good knowledge in Executor service, Forkjoin pool and other threading concepts)

·       Good knowledge of the JVM with an understanding of performance and memory optimization.

·       Extensive and expert programming experience in JAVA programming language (strong OO skills preferred).

·       Excellent knowledge on collections like, Array List, Vector, LinkedList, Hashmap, HashTable, HashSet is mandate.

·       Exercised exemplary development practices including design specification, coding standards, unit testing, and code-reviews.

·       Expert level understanding of Object Oriented Concepts and Data Structures

Location - Only Bangalore

Notice period - Immediate or Serving

Role - Manager (Paid Social)

About Company :-

Our Client is the world’s largest media investment company and is a part of WPP. In fact, we are responsible for one in every three ads you see globally. We are currently looking for a Manager -Social to join us. As part of the largest media agency in India, you’ll have the opportunity to leverage the scale that comes with the job. You will become an integral part of this growing team and will be working with both internal teams and external parties to ensure campaign delivery objectives are met.

This team is responsible for delivering international solutions, particularly in APAC & EMEA, with some global influence. You will enjoy working in a collaborative team environment and will hold a ‘can do’ attitude with the passion to learn and grow.

At APAC, our people are our strength, which is why fostering a culture of diversity and inclusion is important to us.

Reporting of the role :-

This role reports to the Associate Director -Social

What your day job looks like at Hub:

·        Making Strategies and Planning

·        Execution and Optimization for Paid campaigns across social media platforms

·        Creating Performance reports & review deck for clients

·        Understanding the projects and client’s requirements & deliver accordingly.

What you’ll bring:

·        Should be able to multitask and handle multiple clients at one time

·        Hands on experience in social media advertising and ad creation & optimization 

·        Active interest in digital, Paid media, planning, strategizing, web analytics and other aspects of performance marketing.

·        Team Management

Minimum qualifications:

·        4-6 years of Experience of running paid social campaigns

·        In-depth knowledge of social platforms (Facebook, Twitter, LinkedIn, Snapchat etc.)

·        Have created Media plans for client briefs

·        Excellent communication and interpersonal skills

·        Proficiency in MS-Office and Social Media Management Tools like SocialFlow, Sprinklr, etc.

Required Experience

3 - 8 Years

Skills

Java/J2EE,

Spring,

microservices

+ 1 more

• Develop unit, integration, and functional tests within Grails/Java and contribute to new architectures design for multi-tier Java EE-based products in a SOA environment.
• Interact with Business Analysts to understand software build configuration and testing processes, documenting application functionality and programming accordingly.
• Collaborate with a talented software team to work on various types of applications, ensuring the building of backend APIs using Java-based technologies.
• Stay updated with the latest trends and technologies, conducting POCs on new technical stacks to support and maintain a portfolio of applications.
• Utilize core Java skills to define, design, develop, integrate, test, deploy, maintain, and troubleshoot applications and tools written in Java and other related languages.
• Provide technical expertise in Java development, including Spring, Hibernate, and building scalable solutions for large web application deployments.
• Participate in the full SDLC, from requirements and design to development, testing, and deployment, ensuring the implementation of best practices and industry-standard procedures.
• Possess hands-on experience with Java, J2EE, Spring Boot, microservices, and web services, while also demonstrating proficiency in writing enterprise-strength code and developing backend APIs.
• Work in an agile environment, supporting users by developing documentation and offering assistance with tools, while promoting established development standards and change control procedures.

What is the Role?

• Role is responsible to define requirements and drive success of Ecommerce / Real Estate / Healthcare / Grocery / Food Online centric Tech Products.
• Responsible for overseeing and bringing products to market while meeting key business objectives.

Desired Candidate Profile

• Hands-on experience of building and managing consumer tech products
• Prior experience in Ecommerce / Real Estate / Healthcare / Food Delivery business
• Experience of 3+ years + of which 1.5 years + in product management
• Track record of driving and delivering large, complicated projects on time and within scope
• Entrepreneurial spirit / ability to roll up your sleeves and try different things with minimal direction
• Loves and understands technology. Stays current on competition and disruptors in the market
• Is organized, and can plan, forecast and manage a product backlog
• Possesses a unique blend of business and technical savvy.

Job ID: RP1050

Job Location: Mumbai or Gurugram

Expected Joining: within a month

Job Requirement:

• 4 to 7 years of experience in the lending domain.
• Proficiency with selenium using Java or Python
• Proficiency in Linux, network database, distributed system.
• Develop test plans, identify quality risks and propose reasonable solutions
• Organize and execute test tasks

About Us:

Mobile programming LLC is a US-based digital transformation company. We help enterprises transform ideas into innovative and intelligent solutions, governing the Internet of Things, Digital Commerce, Business Intelligence Analytics, and Cloud Programming. Mobile programming is SAP Preferred Vendor, Apple Adjunct Partner, Google Empaneled Mobile Vendor, and Microsoft Gold Certified Partner.