Associate Manager - Database Development (PostgreSQL)

Company: IDFC First Bank

About the company:

IDFC Limited was set up in 1997 to finance infrastructure projects in India. With time, the company diversified into asset management, institutional broking and investment banking. In 2014, the Reserve Bank of India granted in-principal approval to IDFC Limited to set up a new bank in the private sector.

Role Overview:

QA Overview: A Quality Analyst with a focus on Automation and Manual Testing is responsible for ensuring the quality of software products across web, mobile, and API platforms. This role involves designing, implementing, and executing test plans, both manually and through automated testing tools, to identify and address defects. The Quality Analyst will also be proficient in database testing, ensuring the integrity and reliability of data interactions within the system.

Job Description

Job Title: QA tester

Location: Chennai

Compensation: Commensurate with Experience

Experience: 5-10 Years

Qualification- Graduation: Bachelor of Science (B.Sc) / Bachelor of Technology (B.Tech) / Bachelor of Computer Applications (BCA)

Post-Graduation: Master of Science (M.Sc) /Master of Technology (M.Tech) / Master of Computer Applications (MCA)

• Proven experience in both manual and automated testing. 
• Strong proficiency in automation tools (e.g., Selenium, Appium) and scripting languages. 
• Experience with web, mobile, API, and database testing.
• Familiarity with agile development methodologies.
• Excellent analytical and problem-solving skills. 
• Key Competencies: - Automation scripting (e.g., Java, Python, JavaScript), SQL and database querying skills - Attention to detail - Collaboration and communication - Analytical thinking

Key Responsibilities: 

1. Test Planning and Design: Develop comprehensive test plans based on project specifications. Design and document test cases for web, mobile, API, and database testing. Collaborate with development teams to understand system requirements. 
2. Automation Testing:  Develop and maintain automated test scripts using industry-standard tools (e.g., Selenium, Appium). - Execute automated test suites and Analyse results. - Identify opportunities for test automation and implement efficient testing strategies. 
3. Manual Testing: Execute manual test cases for functional, regression, and performance testing. - Document and report defects, providing detailed information for developers. - Conduct exploratory testing to identify unforeseen issues. 
4. Web, Mobile, and API Testing: Perform end-to-end testing of web and mobile applications. - Validate API functionality and integration points. - Ensure compatibility across different browsers and mobile devices. 
5. Continuous Integration: Design, implement and maintain CI pipelines for automated testing and deployment - Integrate automated tests into CI workflows to enable early detection of defects - Continuously assess and optimize CI processes for speed, efficiency and reliability
6. Database Testing: Develop and execute SQL queries to validate data integrity. - Verify data transformations and migrations. - Identify and address performance issues related to database interactions. 
7. Collaboration: Work closely with developers, product managers, and other stakeholders to understand requirements and user stories. - Participate in agile ceremonies, providing input on quality-related aspects. 
8. Test Documentation: Maintain detailed and organized documentation of test cases, results, and issues. - Create and update testing documentation as the application evolves. 

Dear Candidate,

Greetings for the day! Hope you are doing well.

Here’s the thing: we at MSys are looking for Python Automation Engineer, someone who can play a pivotal role in shaping our future. This is an opportunity for you to really make a difference, and you’ll gather some incredible learning and benefits along the way. For example, we offer unique benefits, like a more competitive salary than other companies, a flexible working schedule, and so on.

Location: Chennai (Hybrid)

Job description;

We are seeking a skilled Automation Test Engineer to join our dynamic team. The ideal candidate will have a strong background in Python programming and extensive experience in converting manual test cases into automation scripts using PyTest. The candidate should be well-versed in test automation frameworks, particularly Selenium, and possess knowledge of version control systems such as GitHub.

Responsibilities:

1) Develop and maintain automated test scripts using Python and PyTest for both API and UI .

2) Execute automated test scripts to ensure the reliability, stability, and performance of test scripts.

3) Participate in test planning and design.

4) Contribute to the improvement of testing processes and methodologies.

5) Stay updated on industry best practices, tools, and technologies related to test automation.

Qualifications:

1) Bachelor's degree in Computer Science, Engineering, or a related field.

2) Proven experience as an Automation Test Engineer or similar role.

3) Proficient in Python programming language.

4) Strong experience in converting manual test cases into automation scripts using PyTest.

5) Solid understanding of test automation frameworks, particularly Selenium.

6) Knowledge of version control systems and Raising the PR, especially GitHub.

7) Experience with testing web applications, APIs, and mobile applications.

8) Strong analytical and problem-solving skills.

9) Excellent communication and collaboration abilities.

10) Detail-oriented with a commitment to producing high-quality work. 

All we’re asking at this stage is that if this opportunity excites you then please share your resume along with below asked details and you allow us to steal 15 minutes of your time for a quick discussion.

Current CTC:

Expected CTC:

Notice Period:

Total Experience:

We can’t wait to explore this further

Requirements -

• Bachelor’s Degree with 0-3 years of industry experience as an automation tester in Selenium/Python and Appium/Python
• Hands on Experience in designing highly reusable and efficient Automation Test framework design in Selenium/Python and Appium/Python and able to maintain/support an automation framework
• Experience in building and adhering the automation processes/standards and guidelines to meet code quality benchmark and robustness of overall framework for future maintenance
• Experience in developing high-quality test automation suite in a cross-browser environment
• Experienced in working with different Data Types, Variables, Operators, Flow Control Statements, and Methods
• Ability to handle exceptions, File I/O, API interactions and Database Operations
• Good understanding of QA methodologies, software testing life cycle and processes.
• Good knowledge of different types of Element Locators, Inspecting Elements and Selenium WebDriver API Commands or Methods
• Rich experience in failure debugging and writing clean & efficient code with strong SQL skills
• Strong analytical and problem-solving skills
• Experience in building end to end automation scripts with code modularity and reusability

Preferred -

• Experience in Automation development in an agile environment
• Working knowledge of test management tools Visual Studio/JIRA
• Responsible for maintaining latest code artifacts in version control systems like GIT.
• Experience in setting up and configuring test environments is highly preferred
• Ability to effectively articulate technical challenges and solutions
• Expertise in database testing including designing and manipulating test data, validating stored process, jobs, triggers and replication.
• Experience with functional testing of web and Android/iOS App.

• Managing distributors and seller and improve the efficiencies in terms of both- retention (% active, D90 retention etc.) and transaction (% transacting, count and amount of transactions from different user cohorts) of newly acquired and existing base
• Designing promotional pricing schemes, subscription packs, communication plans and taking other tactical and strategic steps to increase transactions and engagement on the platform
• Working across departments(i.e. data science, CX, sales, marketing etc.) to deliver a superior experience for distributors and sellers
• Building the needed infrastructure and continuously innovating on ways to reach new and returning users through a variety of communication channels
• Partnering with product teams throughout the organization to leverage and influence existing internal growth and engagement technologies
• Conducting competitive analysis to understand industry trends for how to engage and convert users
• Working closely with product, marketing and data science to identify the right features essential for growth of business and engagement of users
• Measuring and assessing the impact of experiments, their business impact and sharing them with leadership

Desired Candidate Profile

• B.E./ B.Tech and/or MBA
• 7 to 8 years of total experience and 2 to 5 years of experience in handling sales, business development, city operations in an operations intensive role
• People management experience
• A proactive approach to problem solving with high focus on customer empathy    

Advertising at our client is a fast-growing multi-billion dollar business that spans across desktop, mobile and connected devices; encompasses ads on our clients portal and a vast network of hundreds of thousands of third party publishers; and extends across US, EU and an increasing number of international geographies.The Supply Quality organization in Bangalore has the charter to solve optimization problems for ad programs to ensure high-quality ad-impressions. We develop advanced algorithms and systems to optimize performance for our advertisers and publishers. We are focused on solving a wide variety of problems in computational advertising like traffic quality prediction (robot and fraud detection), Security forensics and research, Viewability prediction, Brand Safety and experimentation. Our team includes experts in the areas of distributed computing, machine learning, statistics, optimization, text mining, information theory and big data systems.

The Supply Quality infrastructure(SQI) team builds large-scale real-time transactional solutions, batch and stream processing systems, internet scale crawling solutions and storage infrastructure. We process bid requests in the orders of tens of billions per day with our real-time, batch and stream processing systems. To handle data at this scale, we use cutting-edge open source technologies like Hadoop, Spark, Redis etc.. We are not tied to one technology. Instead, we use what is best suited for the purpose. All of our systems tend to be loosely coupled, communicating using synchronous and asynchronous messaging, leading to a classic distributed processing architecture. All our systems need to also implement complex machine learning and optimization algorithms at scale. 

We are looking for a talented Engineering Manager to lead a new big-data engineering initiative within SQI. The team will own building highly available, efficient and low latency internet scale infrastructure including web-scale crawler, contextual processing and classification systems that will be used across multiple advertising use cases. As a leader of the team, you will be responsible to evolve the charter of the team, work with stakeholders to set goals and deliver them. To succeed, you need to demonstrate sound technical acumen, excellent project management skills, great communication skills, and hire, build, and develop your team. You will be responsible for fostering a culture of engineering excelllence towards delivering cutting-edge solutions that materially improve customer experience.


Primary responsibilities:

• Provide technical expertise and leadership throughout product life cycles, influence software engineers best practices for your team and own operational metrics
• Work with business leaders and product managers to define product requirements.
• Prioritize, communicate, maintain, and execute roadmaps, project plans, and commitments
• Work with engineers to define technical requirements and architect and execute best-in-class implementations in agile manner
• Build and maintain world-class customer experience and operational excellence for your deliverables
• Hire, manage, mentor and grow a high performance team of Software Engineers

Responsibilities

• You will be part of a growing high functional team, responsible for delivering various frontend products to the end-users. Simplifying complex workflow and make it easy for the end-users.
• The team designs and develops various products from - financial apps targeted to invoice users, data-heavy app oriented to operational and support teams, a productivity app for sales teams,
• SDK that will be integrated into third-party apps, etc.
• You will work with business, product, and backend teams to work on new features and products.
• You are expected to drive the products to maximize its business impact and customer delight.
• You are expected to stay on top of tech innovations in the Web development space, experiment them and make suitable suggestions to enhance tech stack. Research and propose software programs that are compatible with future technologies.

• Design and implement Single Page Applications (SPAs) using modern JavaScript frameworks
• Integrating data from various back-end services
• Develop a simple-to-use user interface for a complex product, apply new technologies, best design practices and usability patterns
• Contribute to end-to-end system architecture, working with/as cross-functional teams
• Collaborate with UX teams, product managers and other technical teams to create optimized and delightful user experiences
• Apply expertise of HTML5, bootstrap/foundation CSS frameworks
• Analyze the performance of layers in the frontend, backend and engineer designs/code to solve them
• Work with the product team to build flow and detail out the requirements
• Conversant with development for desktop and mobile browsers and hybrid apps.

• Proven working experience in web programming
• Top-notch programming skills and in-depth knowledge of modern HTML/CSS
• Solid understanding of how web applications work including security, session management, and best development practices
• Working with respectable size Single Page Application (SPA) project
• Expert in MVC like design patterns, modern JavaScript frameworks
• Hands-on experience with network diagnostics, network analytics tools
• Solid CS, OOP/OOD, design patterns
• Good grasp on usability and interaction design
• Track record in large-scale system software development
• Aggressive problem diagnosis and creative problem-solving skills
• Ability to work and thrive in a fast-paced environment, learn rapidly and master diverse web technologies and techniques

• An​y framework - ReactJS (Must Have), AngularJS, Backbone, Ember, VueJS
• DOM and Virtual DOM understanding
• API Integration. Understanding of session management. 

• Experience with server-side processing such as templating, packaging and delivery
• Some end-to-end system design experience, sensitive to ​ security
• Experience working with webviews on Android and iOS
• Exposure to React Native
• Demonstrated visual design and layout skills
• Design and development of backend REST endpoint applications

Description

• Plan, coordinate, and execute projects to deliver accurate, effective, and timely information solutions that empower readers and solve business problems.
• Design, write, and edit technical content for a variety of audiences, with an emphasis on usability, effectiveness, maintainability, and reusability.
• Understand and use authoring systems, content management tools, databases, social media (wikis and other collaboration systems,microblogs, etc.), and SEO to develop systems that collect, organize, and publish findable, useful information.
• Employ authoring tools to produce professional documentation from a single source for a variety of media and devices including mobile platforms, online help, electronic publications, and PDF.
• Contribute to the development and achievement of organizational goals and objectives.
• Represent the team and the Cytel organization on project assignments and when working with clients.
• Lead efforts to assess, research, analyze, organize, design, develop, and maintain information products, processes, and systems.

Required Skills and Experience

• Demonstrated strong writing and editing skills and ability to plan and execute content delivery projects.
• Ability to collaborate with teams across all parts and levels of the organization including product development, IT, product management,compliance, services, customer support, marketing, training, and senior management.
• Flexibility to change directions and tasks when necessary to accommodate shifting priorities.
• Excellent planning, scheduling, communication, and interpersonal skills.
• Experience working with content management and single-sourcing authoring platforms.
• Familiarity and comfort with source code mgmt. and document mgmt., and with 'DevOps' concepts and systems.
• Two+ years of experience planning and producing technical documentation for online delivery.

Helpful Skills and Experience

• Experience with authoring platforms, Atlassian and Microsoft collaboration tools, and MS Word.
• Proven experience documenting complex healthcare, biostatistics, or clinical trial mgmt. concepts.
• Experience with LaTeX mark-up and related systems, and with MathML and constructing complex equations for print and online presentation.
• Experience with GxP compliance concepts and processes.
• Knowledge of 'industrial-strength' software product development tools and roles, and experience with software development
• methodologies in a large-company environment.
• Knowledge of basic principles and components of user experience (UX) design.
• Exposure to concepts and tools relating to continuous integration/continuous deployment.
• Understanding of basic coding concepts, and ability to read and edit CSS3, HTML5, and SQL. Experience with R programming is very desirable.

Education

• College degree in biostatistics, software engineering, computer science, technical communications, journalism, or related field, or equivalent experience is desirable.