SEO Specialist

• · 3+ years of software engineering experience primarily leveraging ReactJS. · Strong engineering and technical background with demonstrable enterprise development experience using ReactJS and RESTful APIs. · Deep understanding of JavaScript/Typescript, HTML5 and CSS. · Experience using Redux, Web Workers and PWAs. · Experience with continuous integration and build (CI/CD) process & tools. · Proven ability to quickly understand functional requirements and technical concepts. · Experience with TDD and familiarity with testing frameworks, ideally Cypress, Selenium and PACT. · Exposure to mobile development via React Native an advantage. GitHub portfolio an advantage.

Role Overview

We are seeking a Senior SQL Developer & ETL Engineer with 5+ years of experience for a 100% remote opportunity.

Please Note: This is not a pure Data Engineering role. We are looking for a true SQL Specialist. Your core strength must lie in relational database development, schema design, and writing high-performance database logic with Python, ETL, Cloud. SQL mastery and database architecture are the absolute heart of this role.

If you are a database developer who loves diving into query execution plans, refactoring messy stored procedures for 10x performance, and building clean data models from scratch, this role is for you.

Key Responsibilities

1. Database Architecture & Schema Design

• Design, implement, and maintain robust relational database schemas.
• Architect optimal data models for both operational (OLTP) and analytical (OLAP/Data Warehousing) workloads.
• Implement Normalization (3NF) and dimensional modeling (Star/Snowflake schemas) as required.

2. Advanced Database Programmability

• Write, debug, and optimize highly complex Stored Procedures, Functions, Triggers, and Views to handle core business logic at the database level.
• Utilize advanced SQL techniques such as CTEs, Window Functions, and complex analytical queries to solve business problems.

3. Performance Tuning & Indexing

• Analyze query execution plans, identify performance bottlenecks, and implement advanced indexing strategies (B-Tree, Clustered/Non-Clustered, Partitioning).
• Refactor legacy SQL code and manage statistics, locking, and concurrency mechanisms to ensure sub-second response times.

4. Python & Cloud ETL/ELT Pipelines

• Develop, schedule, and maintain scalable data ingestion and transformation pipelines to connect disparate data sources.
• Leverage Cloud Data Platforms alongside modern Python libraries to build efficient data movement workflows.

5. Data Integrity & Governance

• Establish strict database constraints, data validation routines, and automated quality checks to guarantee absolute data accuracy.

Required Technical Skills

• Expert-Level SQL & DB Programmability (5+ Years): Mastery of writing server-side logic (Stored Procedures/Functions) and complex queries in enterprise platforms like PostgreSQL, SQL Server, Oracle, or MySQL.
• Advanced Database Optimization: Deep, under-the-hood understanding of database engines, execution plans, indexing strategies, and concurrency/locking control.
• Python for Data Engineering (3+ Years): Proficient in writing clean, modular Python scripts for API integration, data manipulation, and ETL processing (using libraries like Pandas, SQLAlchemy, or custom database connectors).
• Cloud Data Experience: Hands-on experience working with, migrating to, or developing within major cloud environments (AWS, Azure, GCP) and modern cloud data warehouses (Snowflake, BigQuery, or Redshift).
• Data Modeling Methodologies: Practical experience designing Star/Snowflake schemas, handling Slowly Changing Dimensions (SCD), and balancing normalization vs. denormalization.

Remote & Soft Skills

• Legacy Refactoring Mindset: You genuinely enjoy opening up a massive, poorly optimized 500-line legacy stored procedure and refactoring it for maximum efficiency.
• Autonomous Execution: Proven ability to manage your own time, architecture tasks, and deliverables without micromanagement in a fully remote setup.
• Asynchronous Communication: Exceptional written and verbal English communication skills to collaborate seamlessly across time zones.

Nice-to-Haves

• Experience migrating legacy on-premise infrastructure and stored procedures to modern cloud data warehouses.
• Familiarity with workflow orchestration tools like Apache Airflow or Prefect.
• Hands-on experience with dbt (data build tool) for in-warehouse transformations.

We’re looking for passionate and skilled professionals who:

✅ Have deep understanding of the Fiserv Signature platform

✅ Come from BA, Dev, or QA background

✅ Can contribute to high-impact banking & fintech projects

✅ Are ready to take their career to the next level with a collaborative team

Job Description:

• Monitor entire field and DC network, ensure smooth operations for various NMS systems
• Ensure timely alerts in case of any events or parameters crossing threshold
• Ensure timely publishing of relevant reports and statistics
• Keep NMS database updated as per network evolution
• Plan and upgrade HW capacity, SW version, redundancy, connectivity with network elements and other applications as required
• Test and deploy bug fixes, new features/products related to NMS applications
• Quickly troubleshoot any issues with NMS systems and provide RCA, implement AIs
• Analyse and assist business and tech teams with new data analytics
• Vendor relationship management for issues, upgrade, new product evaluation etc.
• Manage connectivity, capacity and redundancy for all applications & network
• Prepare and Maintain SOPs of critical Process; perform Process Correction on requirement basis.

Requirements:

1. Should have years of work experience in Telco / ISP background
2. Must have hands on experience in network monitoring and managing corresponding systems/tools
3. Must have in depth understanding of SNMP and various parameters to be monitored for smooth network operations and troubleshooting
4. Should have good understanding of TCP/IP, networking, switching and routing
5. Should have good understanding of MSSQL, MySQL DB, Windows server, basic OS & virtualization concepts
6. Should be good in at least one scripting language like Python
7. Should have work experience on Solarwinds or similar leading NMS system
8. Should have experience in planning and operations of distributed L3 network
9. Should be available 24*7 for emergency situations
10. Should be able to work in very late night for planned activities
11. CCNA/CCNP Certification is Preferred.
12. Understanding of FTTH, GPON & Wifi concepts is an advantage
13. Must have done BE/B.Tech or equivalent in Computer Engineering/Electronics & Communication Engineering/Electronics & Electrical Engineering

• Design, build and maintain efficient, reusable, and reliable Java code. 
• Providing technical oversight to the team, involved in design and code review.
• You would also be spending most of the time in development activities in varied technologies and should have a passion to write code.
• Should be able to create good technical documents.
• Translate application storyboards and use cases into functional applications.
• Ensure the best possible performance, quality, and responsiveness of the applications.
• Identify bottlenecks and bugs, and devise solutions to these problems - Help maintain code quality, organization, and automatization. 
• Prepare the technical design of complex technology components as well as suggest the pros and cons of using a certain technology stack or component or design pattern versus another, to the clients.
• Team Management.

• Qualifications: BTECH/MTECH/MCA/MSc.
• Proficient in Java, with a good knowledge of its ecosystems with a knack for writing clean, readable Java code, writing reusable Java libraries along with knowledge of multithreading, concurrency patterns, and collections in Java. 
• Solid understanding of object-oriented programming along with various design and architectural patterns.
• Hands on experience with JMS, JPA, Spring (MVC, Boot & Cloud preferred) & Hibernate.
• Familiarity with concepts of MVC, JDBC, and RESTful.  Experience with Presentation Layer (JSP/Servlets), JS Frameworks (Angular, jQuery, react, etc.).
• Creating database schemas that represent and support business processes and experience with both external and embedded databases. Implementing automated testing platforms and unit tests.
• Proficient understanding of code versioning tools, such as Git, Ant, Maven, and Gradle; continuous integration.
• Knowledge in xml based mappings, SAML, rest clients, CAS authentication and Jetty.
• Knowledge of Apache Camel and Kafka and Drools Rule Engine is preferred.

• 4+ years of experience with Node.js
• Expertise in Typescript, AWS, Firebase, MongoDB, and Express

You will be bringing:

• Hands-on experience in writing applications using Node.js (including Socket.io and Express or similar)
• Excellent knowledge of a few of the available databases such as MySQL, MongoDB, etc.
• Proficiency in application deployment on Linux or Ubuntu environments
• Proficiency in JavaScript languages like React and/or Angular, along with a comprehensive experience in open-source frameworks
• Experience in server-client architecture project(s)
• Ability to prioritize in a chaotic and ambiguous environment
• An open, growth mindset when giving and receiving feedback

We are looking for a coding Engineering Manager based in Chennai. This is a new role within the growing Engineering function, where you will be responsible for leading a team of talented professionals, assisting them to deliver complex technical solutions across a range of teams. The successful candidate will be comfortable directing, planning and coordinating the team, as well as developing overall concepts for new and existing products and processes. Reporting into the Head of Engineering for our Chennai team, this role is integral to the successful growth of the team as well as wider company performance. 

What You’ll Be Doing:

Play the role of a servant leader in helping the team to excel in the areas of ownership and help to continuously raise the bar on performance.

Perform your responsibilities through delegation, empowerment and influence aimed at delivering long term outcomes for the team and business.

Build, manage and grow one or more engineering team(s), foster Agile practices and continuous improvement, enable engineers to build, test, deliver and operate high-level software products across the company

A hands-on technical approach to management, leveraging your software engineering experience to assist product needs and build

Work with our Product, DevOps, and Data Science functions on articulating roadmaps & ensure a high quality and timely implementation to support our mission and help eliminate identity fraud

Join a mission-orientated company, solving real-world fraud and identity based challenges

Facilitate career growth and success for all team members.

What You’ll Bring:

6+ years of demonstrated deep technical design and programming skills (in individual capacity) designing and delivering enterprise grade distributed systems in the following tooling; Web applications (Java/PHP/.NET/Python) or Mobile applications (SDK, Android/iOS)

2+ years prior experience managing one or more Agile engineering team(s); contributing to a track record of building complex and technical products, ideally within a start-up or fast scaling environment

Track record of having managed performance cycles of engineers of varying experience levels directly reporting to you.

Experience with building software with Agility and in conformity to security standards.

Willingness to “roll-up your sleeves and get your hands dirty” when required

Experience delivering and operating complex software solutions - understanding the end-to-end needs of what is involved within this process.

•  5-10 years of experience in building API services using NodeJS Express and related frameworks
• Expert level understanding of NodeJS asynchronous runtime
• Expert level understanding of Javascript concepts on callbacks and closures
• Experience with Postgres, NoSQL, Redis, and Firebase real-time database
• Experience with AWS services like Elastic Beanstalk, Cloudfront, S3, EC2, Lambda, API Gateway, SQS, etc
• Understanding of patterns and techniques for building scalable back-end infrastructure including caching, rate limiting, authentication, and authorization schemes.
• Experience in building highly scalable and high throughput services with millisecond response times
• Experience working in a collaborative team environment
• Excellent communication & interpersonal skills
• Willingness to learn and pick up new technology along with patience to mentor

Bonus skills – 

• Experience with Elastic Search, Puppeteer
• Experience writing unit test