Sr.ETL QA

The Client is the world’s largest media investment company. Our team of experts support clients in programmatic, social, paid search, analytics, technology, organic search, affiliate marketing, e-commerce and across traditional channel We are currently looking for a Manager Analyst – Analytics to join us. In this role, you will work on

various projects for the in-house team across data management, reporting, and analytics.

Responsibility:

•       Serve as a Subject Matter Expert on data usage – extraction, manipulation, and inputs for analytics

•       Develop data extraction and manipulation code based on business rules

•       Design and construct data store and procedures for their maintenance  Develop and maintain strong relationships with stakeholders  Write high-quality code as per prescribed standards.

•       Participate in internal projects as required

Requirements:

•       2-5 years for strong experience in working with SQL, Python, ETL development.

•       Strong Experience in writing complex SQLs

•       Good Communication skills

•       Good experience of working with any BI tool like Tableau, Power BI.

•       Familiar with various cloud technologies and their offerings within the data specialization and Data Warehousing.

•       Snowflake, AWS are good to have.

Minimum qualifications:

•       B. Tech./MCA or equivalent preferred

Excellent 2 years Hand on experience on Big data, ETL Development, Data Processing.  

About Company

Our client is one of India's finest luxury real estate brands. Renowned for leadership and excellence in real estate development, the prime focus is on planned development, creating value assets, and crafting lifestyle experiences through design and architecture.

Roles and Responsibilities

1.Developing visual concepts and ideas to conceptualize designs that meet client requirements and project objectives.

2.Create various design elements such as logos, illustrations, icons, typography, layouts, and other visual assets.Use of design software like Adobe Photoshop, Illustrator, or InDesign to create high-quality designs.

3.Work on visual identities for the company, designing logos, selecting color schemes, creating brand guidelines, and ensuring brand consistency across different platforms.

4.Create designs for both print and digital media. They design materials such as brochures, business cards, posters, packaging, websites, social media graphics, and other digital assets.

5.Collaborate with clients, marketing teams, copywriters, and other stakeholders to understand project requirements, provide design recommendations, and incorporate feedback. 

6.Responsible for preparing design files for print or digital production. Candidate Should know file formats, color modes, and resolution requirements to ensure the quality and accuracy of the final output.

Competencies and Required Skills

1.Proficiency in design software -includes Adobe Photoshop, Illustrator, InDesign, Sketch, or other design tools. 

2.Should have a good understanding of different typefaces, font pairings, and how to use typography to enhance the overall visual impact of their designs.

3.The ability to work well in a team, listen to feedback, and incorporate input from others is important for successful project execution.

4.The ability to create well-balanced layouts and compositions is essential. Ensure accuracy and consistency in their designs. 

5.Strong communication skills are crucial for understanding project requirements, presenting design concepts, and incorporating feedback effectively.

6.Being able to manage time effectively, prioritize tasks, and work efficiently is essential for delivering projects on time. Should be adaptable and willing to learn new design trends, techniques, and tools to stay relevant and provide fresh design solutions.

Job Description - Sr. SDET

Creator of frameworks and tools that help engineering move fast. Advocates best practices. Metric & Data-driven in

decisions.

Do you thrive to help ship awesome software, not just prevent poor software from being released?

At TestVagrant we believe that shipping awesome software requires more than just testing and test automation. It

involves constant improvements to processes, tools, testing techniques, and approaches. It involves collaborating

with engineering & business teams, collecting metrics, analysing data, and innovating constantly.

If you're someone who champions & advocates quality, understands risks, and is courageous to drive the change,

then this position was made for you!

More about TestVagrant

We are a team of software consultants specializing in test engineering. We partner with our clients in their ambitious digital missions & integrate business, engineering, and technology to deliver quality software faster and safer.

As consultants, our goal is to ship awesome software. By expanding our identities and playing overlapping roles

across business, engineering & technology, we bring a deeper and more positive impact in amplifying business growth for our clients.

Our engineers have been building and contributing to open-source projects. Ekam.Studio and Optimus are a few to mention. Our thoughts and opinions are reflected in articles, blogs, and books.

You’ll spend time on the following:

● You will proactively seek out ways to avoid common software-testing problems such as test case duplication,

flaky tests, and maintainability

● You will pair including but not limited to devs, business analysts, engineering managers and operations to

identify gaps & improve team efficiencies

● Strive for quality to be baked-in and aspire to shift quality to the left

● Extend your passion for quality assurance practices to enable the engineering teams & coaches to adopt a

testing mindset.

● Spike, Compare and choose the right tools and eco-system for scalable and fast test automation

● Drive the creation of reliable automated testing frameworks with strong reporting capabilities that ensures

simple, effective analysis of failures for your team to use

● Capture metrics to measure the quality and make decisions that improve quality

The outcomes of this role include:

● The team is able to get faster feedback for changes and express confidence in safety-net

● The team is able to measure and gain insights into improvements to the product quality

● Team expresses increased confidence and trust in test assets

You’ll also spend time on the following:

● Storytelling and socializing the tech and engineering success stories across TestVagrant

● Take initiative and participate in others, that move organization forward, aligning with tech and engineering first culture

● Mentor the SDETs to grow in the direction of Sr. SDETs

● To achieve the above, most of the following experience is a must:

● You have worked as a Quality Analyst as part of a distributed engineering team, pairing with Devs, Business Analysts, and Infra teams

● You have championed the quality domain and are proficient in functional, non-functional, and exploratory testing techniques

● You have championed the testing domain and applied wisdom to prevent common mistakes

● You have collaborated with business and engineering teams to arrive at non-functional requirement

● You have contributed to various layers of the test pyramid

● You have designed, developed, and evolved scalable test automation frameworks from scratch

● You have proficiency in automation tools and techniques, including but not limited to Web, Mobile, and APIs

● You have the ability to pick up new tech stack and contribute to developing test assets

● You have worked with code coverage tools, linting, and static code analysers

• Drive and own sales and revenue targets from ecommerce operations for the brand marketing campaign on marketplaces and offer management
• Monitor, measure and maintain reports on performance to drive attainment of defined objectives by optimisation
• Plan and execute promotional schemes and campaigns to maximise growth
• Providing insights into latest consumer and shopping trends to identify assortment gaps & selection and plan effective branding strategies Performance marketing Inventory management Catalogue mapping ,listing
• Plan the AOP business closely with the customer and the internal teams – to help deliver the toplines at a quarterly and annual level
• Keep track of all the health and hygiene measure – Stock holding of the e-tailers in terms of the number of days as well as the quality of the stock, ensure correct PO execution, track and ensure availability of our SKUs Work on monthly offtake plan for all brands – tracking the same periodically  and ensuring the right inputs are planned both on-platform and off-platform to drive business
• Manage the e-tailer PnL and ensure that we keep a close track on the profitability of the account and keep a check on the promotional expense
• Opening new platforms for the brand
• 3-4 years of handling ecommerce platforms - Amazon Flipkart,Big Basket

• Conducting analysis of website and application requirements.
• Writing back-end code and building efficient PHP modules.
• Developing back-end portals with an optimized database.
• Troubleshooting application and code issues.
• Integrating data storage solutions.
• Responding to integration requests from front-end developers.
• Finalizing back-end features and testing web applications.
• Updating and altering application features to enhance performance.

• Bachelor’s degree in computer science or a similar field.
• Knowledge of PHP web frameworks including Yii, Laravel, and CodeIgniter.
• Knowledge of front-end technologies including CSS3, JavaScript, and HTML5.
• Understanding of object-oriented PHP programming.
• Previous experience creating scalable applications.
• Proficient with code versioning tools including Git, Mercurial, CVS, and SVN.
• Familiarity with SQL/NoSQL databases.
• Ability to project manage.
• Good problem-solving skills.

• Designing, architecting, developing and driving the technology roadmap
• Defining standards in coding, system design and architecture
• Delivering solutions according to user requirements while meeting development, quality and documentation standards
• Building data-driven applications applying clean code and architecture principles
• Working with the team to ensure deadlines are met

What you need to have:

• Relevant experience of 2 to 5 years as .net developer
• Hands on experience in Web forms, MVC, bootstrap, java script, windows application, crystal reports    
• Good in writing SQL, GIT
• Good in OOPs concept
• Knowledge of .net core 3.1 or above    

Skills Required:
 

• Candidate should be able to generate business through online portal likes Upwork, Freelancer, People Per Hour and etc.
• Candidate Should be able to Understand client's requirements.
• Excellent written and spoken communication skills.
• Candidates must have knowledge about IT services.
• Candidates should be able to write creative proposals.
• Should be Professional and excellent at time management.
• Responsible to prepare use cases, Business Requirements Documents(BRD), System Requirements.
• Specification (SRS) documents, Wire framing of the finalized projects and other functional documents.