Equity Analyst - Trainee

Must have skills:

1. GCP - GCS, PubSub, Dataflow or DataProc, Bigquery, Airflow/Composer, Python(preferred)/Java

2. ETL on GCP Cloud - Build pipelines (Python/Java) + Scripting, Best Practices, Challenges

3. Knowledge of Batch and Streaming data ingestion, build End to Data pipelines on GCP

4. Knowledge of Databases (SQL, NoSQL), On-Premise and On-Cloud, SQL vs No SQL, Types of No-SQL DB (At least 2 databases)

5. Data Warehouse concepts - Beginner to Intermediate level

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.

• Prepare accurate, timely financial statements in accordance with our established schedule and with input from the rest of the accounting department
• Conduct monthly and quarterly account reconciliations to ensure accurate reporting and ledger maintenance
• Analyze financial statements for discrepancies and other issues that should be brought to the CFO’s attention
• Review all inter-company transactions and generate invoices as necessary
• Reconcile balance sheet accounts
• Delegate financial responsibilities to accounting team
• Coordinate semi-annual audits and assist CFO with conducting audits
• Conduct regular ledger maintenance

QUALIFICATION: MBA

KEY RESPONSIBILITIES

• Building a website based on the given requirements and ensure it’s successfully deployed
• Responsible for designing, planning, and testing new web pages and site features
• A propensity for brainstorming and coming up with solutions to open-ended problems
• Work closely with other teams, and project managers, to understand all stakeholders’ requirements and ensure that all specifications and requirements are met in final development
• Troubleshoot and solve problems related to website functionality
• Takes ownership of initiatives and drives them to completion.
• Desire to learn and dive deep into new technologies on the job, especially around modern data storage and streaming open source systems
• Responsible for creating, optimizing, and managing REST APIs
• Create website content and enhance website usability and visibility
• Ensure cross-browser compatibility and testing for mobile responsiveness
• Ability to integrate payment processing and search functionality software solutions
• Stay up-to-date with technological advancements and the latest coding practices
• Collaborate with the team of designers, content managers, and developers to determine site goals, functionality, and layout
• Monitor website traffic and overall system’s health with Google analytics to ensure high GTmetrix score
• Build the front-end of applications through appealing visual design
• Design client-side and server-side architecture
• Develop server-side logic and APIs that integrate with front-end applications.
• Architect and design complex database structures and data models.
• Develop and implement backend systems to support scalable and high-performance web applications.
• Create automated tests to ensure system stability and performance.
• Ensure security and data privacy measures are maintained throughout the development process.
• Maintain an up-to-date changelog for all new, updated, and fixed changes.
• Ability to document and manage all the software design, requirements, reusable & transferable code, and other technical aspects of the project.
• Create and convert storyboards and wireframes into high-quality full-stack code
• Write, execute, and maintain clean, reusable, and scalable code
• Design and implement low-latency, high-availability, and performant applications
• Implement security and data protection
• Ensure code that is platform and device-agnostic

EDUCATION & SKILLS REQUIREMENT

• B.Tech. / BE / MS degree in Computer Science or Information Technology
• Expertise in MERN stack (MongoDB, Express.js, React.js, Node.js)
• Should have prior working experience of at least 3 years as web developer or full stack developer
• Should have done projects in e-commerce or have preferably worked with companies operating in e-commerce
• Should have expert-level knowledge in implementing frontend technologies
• Should have worked in creating backend and have deep understanding of frameworks
• Experience in the complete product development life cycle
• Hands-on experience with JavaScript, HTML, CSS, JQuery, JSON, PHP, XML
• Proficiency in databases, including analytical (e.g., mySQL, MongoDB, PostgreSQL, DynamoDB, Redis, Hive, Elastic etc.)
• Knowledge of architecting or implementing search APIs
• Great understanding of data modeling and RESTful APIs
• Strong knowledge of CS fundamentals, data structures, algorithms, and design patterns
• Strong analytical, consultative, and communication skills
• Excellent understanding of Microsoft office tools : excel, word, powerpoint etc.
• Excellent organizational and time management skills
• Experience with responsive and adaptive design (Web, Mobile & App)
• Should be a self starter and have ability to work without being supervised
• Excellent debugging and optimization skills
• Experience building high throughput/low latency systems.
• Knowledge of big data systems such as Cassandra, Elastic, Kafka, Kubernetes, and Docker
• Should be willing to be a part of a small team and working in fast-paced environment
• Should be highly passionate about building products that create a significant impact.
• Should have experience in user experience design, website optimization techniques and different PIM tools

Key  Responsibilities :

• Development of proprietary processes and procedures designed to process various data streams around critical databases in the org
• Manage technical resources around data technologies, including relational databases, NO SQL DBs, business intelligence databases, scripting languages, big data tools and technologies, visualization tools.
• Creation of a project plan including timelines and critical milestones to success in support of the project
• Identification of the vital skill sets/staff required to complete the project
• Identification of crucial sources of the data needed to achieve the objective.

Skill Requirement :

• Experience with data pipeline processes and tools
• Well versed in the Data domains (Data Warehousing, Data Governance, MDM, Data Quality, Data Catalog, Analytics, BI, Operational Data Store, Metadata, Unstructured Data, ETL, ESB)
• Experience with an existing ETL tool e.g Informatica and Ab initio etc
• Deep understanding of big data systems like Hadoop, Spark, YARN, Hive, Ranger, Ambari
• Deep knowledge of Qlik ecosystems like  Qlikview, Qliksense, and Nprinting
• Python, or a similar programming language
• Exposure to data science and machine learning
• Comfort working in a fast-paced environment

Soft attributes :

• Independence: Must have the ability to work on his/her own without constant direction or supervision. He/she must be self-motivated and possess a strong work ethic to strive to put forth extra effort continually
• Creativity: Must be able to generate imaginative, innovative solutions that meet the needs of the organization. You must be a strategic thinker/solution seller and should be able to think of integrated solutions (with field force apps, customer apps, CCT solutions etc.). Hence, it would be best to approach each unique situation/challenge in different ways using the same tools.
• Resilience: Must remain effective in high-pressure situations, using both positive and negative outcomes as an incentive to move forward toward fulfilling commitments to achieving personal and team goals.

• frames and using Agile methodology.
• Basic Azure server administration - Provide technical help during testing, development, and production.
• Discover, evaluate, and implement new technologies to maximize development efficiency - Design and implement complex, optimized algorithms with minimum time and space complexities

Requirements.

• Experience in .Net web development - Experience with C#, Angular Js, Angular2, SQL.

• Sound understanding of MVC design Pattern 

• Strong knowledge/understanding of OOPS concepts

• Experience with tools like Visual Studio, SQL Server, Git

• Good analytical and logical skills.

• Good written and verbal communication skills

• Passion for new technologies and innovations.

• Ability to grasp new concepts quickly.

• Takes initiative to uncover/develop solutions to potential problems

•  Ability to take on new projects and easily transition between tasks

• Team player who is receptive to coaching and adaptive to change

• Desire to excel and grow each day

• Strong knowledge of Web APIs, Typescript, ES6, ngrx

Nice to Have 

• Experience with of LESS, SASS, GULP and GRUNT. 

• Knowledge of VueJS

• .Net Framework and/or .Net Core
• Angular 2+, preferable Angular 10
• Experience with tools like Visual Studio, SQL Server, Git
• Material framework
• SASS
• Good technical aptitude
• Restful APIs
• Data structures and Algorithms
• Azure experience including Azure functions etc.
• Azure Devops

Desired Candidate Profile

• 6+ years of experience in managing rural markets
• Rigour for numbers
• Proven record of managing large teams
• Ability to handle and deliver in challenging environments    

• Develop iPhone and iPad handset clients
• Develop architecture and low-end designs based on customer and product management requirements
• Communication of designs and other development issues to developers and managers
• Design, develop and manage automated unit and acceptance tests
• Peer review of design code and tests
• Participate in the agile development program
• Bug Fixing
• Take ownership of deliverables
• Adhere to development methodologies

ESSENTIAL SKILLS/ATTRIBUTES:

• Minimum 5 years Objective-C development
• Excellent knowledge of Objective-C and the iOS SDK.
• Strong knowledge of Swift 3/4.
• Experience developing Universal apps across iOS9, iOS10 and iOS11
• Proficiency in Xcode, Interface Builder, and Instruments.
• Appreciation for the limitations of handset development, especially networking related issues
• Attention to detail and subtleties of UI design and implementation
• Understanding of design patterns
• Ability to design for scalability and resilience
• Strong application process flow and problem-solving techniques
• Strong focus on refactoring and code quality
• Understanding of software configuration management and release management
• High levels of software engineering literacy and communication skills
• Friendly and professional manner
• Third Level Qualifications in computing, mathematics, or science
• Experience with auto-layout and constraints
• #Experience in building web (PWA)/mobile app using ionic/reactjs (react native)

DESIRED SKILLS:

• Experience of working in an agile (XP) environment
• Experience working with Core Data
• Experience in delivering Libraries / SDK
• Experience of other mobile platforms a plus (Android, Windows Phone/Mobile)
• Product development and lifecycle experience
• Experience in unit testing and Test-Driven Development
• Scripting (JavaScript, Ruby, Python, Shell, etc.)
• Knowledge of build systems such as Maven, Fastlane
• RESTful development
• XML, JSON, HTTP, SyncML, HTML 5, CSS, Groovy, UML
• Experience in writing documentation

• Design, create, test, and maintain data pipeline architecture in collaboration with the Data Architect.
• Build the infrastructure required for extraction, transformation, and loading of data from a wide variety of data sources using Java, SQL, and Big Data technologies.
• Support the translation of data needs into technical system requirements. Support in building complex queries required by the product teams.
• Build data pipelines that clean, transform, and aggregate data from disparate sources
• Develop, maintain and optimize ETLs to increase data accuracy, data stability, data availability, and pipeline performance.
• Engage with Product Management and Business to deploy and monitor products/services on cloud platforms.
• Stay up-to-date with advances in data persistence and big data technologies and run pilots to design the data architecture to scale with the increased data sets of consumer experience.
• Handle data integration, consolidation, and reconciliation activities for digital consumer / medical products.

Job Qualifications:

• Bachelor’s or master's degree in Computer Science, Information management, Statistics or related field
• 5+ years of experience in the Consumer or Healthcare industry in an analytical role with a focus on building on data pipelines, querying data, analyzing, and clearly presenting analyses to members of the data science team.
• Technical expertise with data models, data mining.
• Hands-on Knowledge of programming languages in Java, Python, R, and Scala.
• Strong knowledge in Big data tools like the snowflake, AWS Redshift, Hadoop, map-reduce, etc.
• Having knowledge in tools like AWS Glue, S3, AWS EMR, Streaming data pipelines, Kafka/Kinesis is desirable.
• Hands-on knowledge in SQL and No-SQL database design.
• Having knowledge in CI/CD for the building and hosting of the solutions.
• Having AWS certification is an added advantage.
• Having Strong knowledge in visualization tools like Tableau, QlikView is an added advantage
• A team player capable of working and integrating across cross-functional teams for implementing project requirements. Experience in technical requirements gathering and documentation.
• Ability to work effectively and independently in a fast-paced agile environment with tight deadlines
• A flexible, pragmatic, and collaborative team player with the innate ability to engage with data architects, analysts, and scientists