Job Summary:
We are looking for an experienced ETL Tester with 5 to 7 years of experience and expertise
in the banking domain. The candidate will be responsible for testing ETL processes,
ensuring data quality, and validating data flows in large-scale projects.
Key Responsibilities:
Design and execute ETL test cases, ensuring data integrity and accuracy.
Perform data validation using complex SQL queries.
Collaborate with business analysts to define testing requirements.
Track defects and work with developers to resolve issues.
Conduct performance testing for ETL processes.
Banking Domain Knowledge: Strong understanding of banking processes such as
payments, loans, credit, accounts, and regulatory reporting.
Required Skills:
5-7 years of ETL testing experience.
Strong SQL skills and experience with ETL tools (Informatica, SSIS, etc.).
Knowledge of banking domain processes.
Experience with test management tools (JIRA, HP ALM).
Familiarity with Agile methodologies.
Location – Hyderabad
About Pluginlive
About
Connect with the team
Company social profiles
Similar jobs
- Relevant Experience required 3 to 5 years.
- Strong proficiency in python programming language along with expertise in backend development framework such as
- Django or Flask. (DSA and Design patterns are mandatory).
- Hand on Experience in REST API development and database such as PostgreSQL.
- Good knowledge of versions control systems like GIT, Bitbucket
- Implementation testing strategies such as unit testing (PyTest), integration testing and end to end testing
- Basic knowledge of Docker/Podman and Jenkins.
- Good have if they basic knowledge in Mainframe tech such JCL, and TWs.
About Company
Our client is a well-funded construction Tech Start-up by a renowned group.
Responsibilities
- Gather intelligence from key business leaders about needs and future growth
- Partner with the internal IT team to ensure each project meets a specific need and resolves successfully
- Assume responsibility for project tasks and ensure they are completed in a timely fashion
- Evaluate, test and recommend new opportunities for enhancing our software, hardware and IT processes
- Compile and distribute reports on application development and deployment
- Design and execute A/B testing procedures to extract data from test runs
- Evaluate and conclude data related to customer behavior
- Consult with the executive team and the IT department on the newest technology and its implications in the industry
Requirements :
- Bachelor's Degree in Software Development, Computer Engineering, Project Management or a related field
- 3+ years experience in technology development and deployment
Responsibilities
• Translate concepts into user flows, wireframes, mock-ups, and prototypes that lead to intuitive
user experiences.
• Facilitate the client’s product vision by researching conceiving, sketching, prototyping, and user-
testing experiences for digital products.
• Designing client-specific websites using available content management systems such as
WordPress along with other common web technologies
• Defining information architecture, interactions and hierarchy of content following the user-
centred design (UCD) principles.
• Simplifying complex and ambiguous briefs to arrive at actionable goals with minimal direction.
• Facilitate stakeholder workshops, doing presentations and approaching with a problem-solving
mindset.
• Pitching creative concepts to internal teams and clients, lateral thinking, brainstorming and
ideation.
• Designing for client-specific requirements with a combination of experience across designing for
mobile and web focused applications, as well as complex and information-rich interfaces.
• Design and deliver wireframes, user stories, user journeys, and mock-ups optimized for a wide
range of devices and interfaces.
• Develop projects from creative concept to final deliverable in traditional and new media
(augmented/virtual reality, social media, etc.).
• Ensure a consistent approach to design, employing design systems, bring efficiency in your
process, creating icons and graphics.
• Take a user-centred design approach and rapidly test and iterate your designs.
• Collaborate with other team members and stakeholders.
• Ask smart questions, take risks, and champion new ideas.
Requirement
• Three or more years of UX design experience. Preference will be given to candidates who have
experience designing complex solutions for complete digital environments.
• Expertise in standard UX software such as Sketch, Figma, InVision, UXPin, Balsamiq, Framer, and
the like is a must. Basic HTML5, CSS3, and JavaScript skills are a plus. Experience with Principle,
Webflow, After-Effects and other prototyping and digital design tools is a bonus.
• A solid grasp of user-centred design (UCD), planning and conducting user research, user testing,
A/B testing, rapid prototyping, heuristic analysis, usability, and accessibility concerns.
• Ability to communicate design processes, ideas, and solutions clearly and effectively to teams and
clients.
• A clear understanding of the importance of user-centred design and design thinking.
• Ability to work effectively in a team setting including synthesizing abstract ideas into concrete
design implications.
• Be excited about collaborating and communicating closely with teams and other stakeholders via
a distributed model, to regularly deliver design solutions for approval.
• Be open to receiving feedback and constructive criticism.
• Be passionate about all things UX and other areas of design and innovation. Research and showcase
knowledge in the industry’s latest trends and technologies.
• Ensuring a sharp eye towards attention to details in designing pixel perfect digital interfaces.
• Knowledge of best UI practices and staying updated with upcoming digital trends and new digital
technologies.
• Fluent in English - verbal and written.
Who are we?
HaystackAnalytics is a company working in deep technology of genomics, computing, and data science for creating the first of its kind clinical reporting engine in healthcare. We are a new but well-
funded company with a tremendous amount of pedigree in the team (IIT Founders, IIT & IIM coremteam). Some of the technologies we have created are a global first in infectious disease and chronic
diagnostics. As a product company creating a huge amount of IP, our Technology and R&D team are our crown jewels. With early success of our products in India, we are now expanding to take our
products to international shores.
- We are shaping the future of India by providing end-to-end digital solutions for businesses, institutions, and households. It has a rapidly expanding digital audience with over 800 million mobile connections and over 200 million internet users.-
- It has created an integrated business strategy offering a unique combination of telecom, high speed data, digital commerce, media, and payment services.
- We have a three-pronged focus on broadband networks, affordable smartphones and the availability of rich content and applications.
- Our Platforms focuses on designing, developing, and running end to end Digital Ecosystems in various business domains. Hugely popular products and services have been built under the umbrella of our Platforms.
About the "Quality Engineering Competency Center" (QECC) :
- Building such world-class products, operating at massive scale, requires top-notch product engineering along with deep focus on quality engineering practices. With fast moving development cycles (product releases happening on a weekly basis), the need for automated testing tools and techniques is a necessity.
- We are actively seeking a Lead SDET who will lead a team that specializes in test automation and will bring their expertise to multiple projects and teams within our Platforms.
What you can expect in this role:
1. The Lead SDET role in the QECC team is a highly technical role where you are expected to engage with various Teams, to identify and document the prevailing Quality Engineering practice(s) and their limitations, measure key Quality Engineering metrics to set a baseline, develop a Quality Engineering framework that suggests adoption of practices and tools geared towards improving overall quality and stability of product releases.
2. As a SDET Lead, you will spearhead all the test automation deliverables of your team and provide process and technical guidance on various activities such as:
- Defining and evangelizing overall shift-left based Quality Engineering strategy (focusing on preventive and detection aspects of quality) towards enabling rapid, high quality and stable product releases for Customers.
- Understand the application and create a Testing and Test Automation strategy to get quick and deterministic feedback on quality of the application
- Applying test automation expertise to help different digital platforms within in achieving faster testing cycles, that result in faster product releases
- Define robust test-data management strategy for testing complex systems with multiple moving parts.
- Setting up Build and Release Pipeline using DevOps workflow tools.
- Creating and managing test reports
- Provide detailed and effective bug reports
- Working along with product development teams to help reproduce and debug hard-to-replicate issues.
- Establishing a rigor of learnings from production issues, by way of driving RCA/COE reports, achieving closure on lessons learned/ action items from it.
- Mentoring and helping in on-boarding other team-members
- Manage and review work progress and completion by team members
- Identify bottlenecks, and challenges faced by team, and work with various stakeholders to resolve the same
- Contribute to building and maintaining the test automation frameworks for multiple application platforms and devices, like mobile apps (Android and iOS), web apps, desktop apps, or proprietary set-top-box apps.
- Manage and address tech debt related to automation frameworks and implementation
- Setup appropriate real-time reports and dashboards to understand current state of quality
- Provide holistic view of quality of the product with areas of concerns (and solutions) to stakeholders
- Show and lead-by-example how proper automation implementation looks like.
We think you could be a good fit if:
1. Extensive (overall 10+ years) experience working as SDET Lead (at least 3+ years) with hands on test development background with 5+ years of experience in a technical lead or similar role, leading test automation development efforts. The following skills are must- have for this role.
2. Experience and working knowledge of distributed systems using micro services architecture.
3. Hands on experience with BDD/Cucumber frameworks automation. (MUST)
4. Working knowledge of the technical stacks and practices used in modern distributed architecture systems. Understanding of implementation and deployment architecture of such systems.
5. Extensive daily experience in writing clean and solid code in any modern languages: Java (preferred), Kotlin, JS.
6. Strong working knowledge and understanding of different types of APIs (example: HTTP, JSON, REST, XML, SOAP, sync/async, OpenAPI spec, etc.)
7. Extensive experience in API- test automation- and UI- test- automation:
- API test automation:- Hands on experience with API test automation tools, like Postman,- REST-assured,- Karate etc.-
- UI test Automation:- Hands on experience with UI test automation tools, like Selenium- WebDriver, Appium,- etc.-
8.Experience in developing, enhancing, and maintaining custom test automation frameworks.
9.Experience in managing a team, track and make work visible.
10.Experience in using application life cycle management like Azure DevOps, JIRA, Jenkins.
11.Good Experience and knowledge of design, code, debug, deploy and maintenance.
12.Azure exposure or knowledge will be nice to have.
13.Strong understanding, knowledge of software development and testing life cycle and process.
14.Experience with non-functional testing (NFTs) such as Performance, Load, Scalability, Chaos/Resiliency, Security testing etc. You may/may not be a SME on any of these.
15.Experience working with cross functional teams, dev managers and all the stake holders for the integration and end to end testing.
16.Experience in setting up dashboards and reports to understand current and upcoming work, as well as understand quality of the product under test.
17.Extensive experience in Agile ways of working.
In addition :
1. You are an effective communicator, who has had experience in successfully building and leveraging cross function and cross-team relations to advance team goals.
2. You like to work in a dynamic and fast-paced environment that may require context switching multiple times in a day, while constantly balancing your priorities.
3. You have a strong aptitude for solving complex problems.
Educational Background :
B. Tech/B.E./MS/MTech- in- any Specialization-
Job Description
Function: Product → Product Analytics
Responsibilities:
- Assist product managers in the formulation of the company's product strategy using structured data and insights derived from the same
- Conduct research, create business cases and translate them into meaningful problems to solve
- Measure impact of experiments related to function, analysing and helping in course correction.
- Recommending product improvements based on analytical findings. Defining new metrics, techniques, and strategies to improve performance.
- Constantly monitor and analyse metrics identified, publish insights/any anomalies along with hypothesis
- Translating business requirements and user requests into effective report and dashboard designs in challenging deadlines.
- Assist with performance tuning of dashboards, background data queries as needed
Key Skills Required:
- Bachelor’s degree along with 2+ years experience in product analytics building data sets, reports, and dashboards
- Strong analytics skills and experience in Metabase, Google Analytics, Power BI, or other analytics software
- Proficiency with SQL
- Agile ability to anticipate need, be responsive and adapt to change
- Strong interpersonal and relationship skills, ability to influence decisions and gain consensus
- Excellent time and project management skills, ability to prioritise the most important projects to create business impact
Perks at Oneistox:
- Challenging work, High Product Ownership, and Steep Learning Curve are guaranteed!
- You get to be part of a highly young and energetic team.
- Envisage the growth of a company from 5X to 500X.
- Industry standard compensation and ESOPS.
- Required Good Coding Skills In HTML5, PHP, JS & MYSQL, BOOTSTRAP CSS, JQuery,
- Designing And Building The Website Front-End.
- Creating The Website Architecture.
- Designing And Managing The Website Back-End Including Database And Server Integration.
- Conducting Website Performance Tests.
- Troubleshooting Content Issues.
- Monitoring The Performance Of The Live Website.
- Knowledge Of CMS Have Additional Benefits
- Should Have A Deep Understanding Of UI/UX Frontend
- Should Have A Previous Experience With Landing Page Builders
What roles and responsibilities will be performed by the selected candidate?
§ Should be able to handle all ETL Datawarehouse testing phases (Azure environment).
§ Should be able to test complex SQL scripts including Spark SQL
§ Should be able to apply business and functional knowledge including testing standards, guidelines, and testing
methodology to meet the teams overall test objectives.
§ Should be able to identify business requirements including data sources, target systems, transformations
required, business rules required to be applied and existing data model from the mapping document.
§ Define Testing strategy, Test approach, Test suites and Test cases.
§ Run, test and debug ETL jobs (Azure environment).
§ Identify and track defects to closure and keep defect log.
§ Should be able to produce test result documentation that are clear and concise along with documentation of
tests performed, test coverage, test risks, assumptions, issues, and dependencies.
§ Bringing in industry best practices in ETL Testing.
§ Should be able to test complex SQL scripts including Spark SQL
§ Should be able to test pandas data frame ETL transformations.
What is the expectation from the candidate’s current role/profile?
§ 2-5 years of experience in core ETL testing expertise with strong exposure to agile methodology.
§ Ability to apply business and functional knowledge, to define testing strategy, test approach and test case
design.
§ Should have excellent SQL skills
§ Should have worked on ETL project involving multiple layers/stages of database processing with various kinds
of sources/targets like files, Oracle, SQL Server, Webservices. Delta Lake etc…
§ Should have at least intermediate level knowledge of python scripting and pandas (Python data analysis
library).
§ Knowledge of Software Development Lifecycle including the functional and non-functional test phases
§ Good interpersonal, communication and organizational skills
§ The ability to work and team effectively with team and management personnel across
- Hands-on experience in Development
- 4-6 years of Hands on experience with Python scripts
- 2-3 years of Hands on experience in PySpark coding. Worked in spark cluster computing technology.
- 3-4 years of Hands on end to end data pipeline experience working on AWS environments
- 3-4 years of Hands on experience working on AWS services – Glue, Lambda, Step Functions, EC2, RDS, SES, SNS, DMS, CloudWatch etc.
- 2-3 years of Hands on experience working on AWS redshift
- 6+ years of Hands on experience with writing Unix Shell scripts
- Good communication skills