smo excutive

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.

A.    Key Activities (Critical activities of the job)

1. Obtain all the necessary approvals / NOCs from respective departments of Municipal Corporation, METRO, regulatory authorities etc.
2. Ensure all requisite No Objection Certificates (NOCs) are in place for necessary approvals within defined timelines.
3. Submit all relevant documents and follow up with the various government / regulatory departments of the stage of approval.
4. Establish, maintain and enhance working relationships across levels within the concerned government agencies / department.
5. Work closely with the Management, Legal and Sales teams to enable closures of the transaction through a structural, legal, and commercial due diligence process.
6. Collaborate with engineers, architects, 3D rendering companies etc. to determine the specifications of the project and implement accordingly.
7. Work towards any internal premise modifications and execute the same. 

EWar is looking for a Design Lead who can help drive the Design Team at the company. This is a role for a creative individual with excellent aesthetic judgment and willingness to collaborate within a team environment. You'll help not only lead the EWar experience but inspire and elevate the team by producing work that is always raising the bar and taking a user experience first approach to solving problems. Your work will allow our customers to feel delighted every time they use our product.

Responsibilities:

• Lead design projects and contribute to product strategy: visually and linguistically.
• Plan and design memorable user interfaces that are iconic and usable across our iOS, Android, and web platforms.
• Deliver wireframes and prototypes to help people visualize your design ideas.
• Push the bounds of creativity using the latest design techniques and languages.
• Good knowledge of graphic/visual design.
• Work closely with the Engineering team to get crazy ideas to life.

• Penchant for learning and building with new design tools and frameworks.
• No challenge is too big to solve; love thinking about products and am excited to ideate & build all by yourself.

Requirements:

• Proficiency in Sketch (Component system), Adobe XD, Illustrator, or any other tool that helps you churn out a great design.
• Awesome design portfolio.
• People who can solve problems & create engaging experiences.
• If you want things just like you imagined and are obsessed with those small details.
• If you don't stop at the design step but go forward and look after it until it's perfect.
• If you bring new ideas, try many things and bring a fresh perspective.
• People who speak out their minds, but we love thinkers and doers.
• Knowledge of front-end development.
• Anything else that can surprise us.

What You'll Do:

• Understand the upcoming development requirement of product in depth.
• Design product architecture as per vision, insights and concurred direction.
• Design and develop the APIs using Java, Spring, and Hibernate required for the product and expose them to be used by the front-end developers.
• Design the database and tables in MySQL/PostGreSQL/NoSQL (whichever is suitable for the need of the product) and guide the team to utilize them in the best possible way.
• Get involved in continuous maintenance of the product and get the bugs fixed in time.
• Coordinate the workflow between the UX Designers and front-end developers.
• Work on integrating flows with external tools - Segment, Branch, Clevertap.

Ideal Profile:

• Proficiency in Core Java & Spring framework.
• Expertise in Web Service technologies.
• Experience in building the architecture as per the product’s need.
• Experience in building REST APIs using Java/Spring.
• Excellent knowledge in Databases and code integrations such as Postgres SQL, SQL Server, MySQL.
• Experience in full life cycle development of a product (specifically mobile products) is a plus.
• Experience with Java/Spring-Boot, Hibernate Cloud Services, AWS.
• Experience with security principles and frameworks.
• Knowledge of modern authorization mechanisms, such as JSON Web Token and OAuth2 - Familiarity with code versioning tools (primarily Git).
• Essential skills are Core Java/J2EE, functional aspects, Spring Framework, Tomcat, SVN, Git, Postman/Newman.
• Should have worked in Agile methodologies.
• Good object-oriented and problem-solving skills.
• Strong communication skills along with the ability to work in a highly collaborative environment.

• Setting KPIs, monitoring key trends, and helping stakeholders by generating insights from the data delivered.
• Understanding user behaviour and performing root-cause analysis of changes in data trends across different verticals.
• Get answers to business questions, identify areas of improvement, and identify opportunities for growth.
• Work on ad-hoc requests for data and analysis.
• Work with Cross functional Teams as when required to automate reports and create informative dashboards based on problem statements.

• 1-2 years of experience working in Analytics as a Business or Data Analyst.
• Analytical mind with a problem-solving aptitude.
• Familiarity with Microsoft Azure & AWS PySpark, Python, Data Bricks, Metabase, Understanding of APIs, data warehouse and ETL etc.
• Proficient in writing Complex Queries in SQL.
• Experience in Performing hands-on analysis on data and across multiple datasets and databases primarily using Excel, Google Sheets and R.
• Ability to work across cross-functional teams proactively.

Job Overview:

We are looking for a Specialist who can post advertisements, run campaigns, and can held our seller accounts.

Our company is looking for an E-Commerce specialist to join our online marketing and sales team. Our ideal applicant is organised enough to manage our online inventory and creative enough to help design social media campaigns to increase our digital sales. You will optimise our campaigns using marketing and SEO strategies and measure how much they increase web traffic by using analytics tools. While we prefer applicants who have a bachelor’s degree, it is more important that you have some experience managing a digital store or inventory of products.

E-Commerce Specialist Duties and Responsibilities

Manage our online inventory Develop campaigns to increase digital sales Optimise paid advertising campaigns using SEO and other tools Help manage our online marketing presence, including on social media platforms Monitor changes in website traffic or increases in sales Assist with forming our company’s overall digital marketing strategy

E-Commerce Specialist Requirements and Qualifications Bachelor’s degree in marketing (preferred) Experience managing digital product inventory Experience using web analytics and optimisation tools Analytical skills Communication skills.