Sales Manager

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.

Skills: ETL+ SQL

· Experience with SQL and data querying languages.

· Knowledge of data governance frameworks and best practices.

· Familiarity with programming/scripting languages (e.g., SparkSQL)

· Strong understanding of data integration techniques and ETL processes.

· Experience with data quality tools and methodologies.

· Strong communication and problem-solving skills

Detailed JD: Data Integration: Manage the seamless integration various data lake, ensuring that jobs are running as expected, validate the data ingested , track the DQ checks , rerun/reprocess the jobs in case of failures post figuring out the RCAs

Data Quality Assurance: Monitor and validate data quality during and after the migration process, implementing checks and corrective actions as needed.

Documentation: Maintain comprehensive documentation related to data issues encountered during the weekly/monthly processing and operational procedures.

Continuous Improvement: Recommend and implement improvements to data processing, tools, and technologies to enhance efficiency and effectiveness.

• Communicating with hiring managers to identify future job openings and the technical requirements for those jobs.
• Writing job descriptions and posting to relevant media platforms.
• Screening applicants for competency with the job requirements.
• Arranging telephone, video, or in-person interviews.
• Performing background and reference checks.
• Presenting the resumes of the most suitable candidates to the hiring manager.
• Offering job positions and completing the relevant paperwork.
• Keeping track of all applicants as well as keeping applicants informed on the application process.
• Forecasting recruitment budgets.

Role: US IT Recruiter - Freshers/Trainees

Experience: 0-6 months 

Location: Hyderabad (Onsite) 

Technovert is not a typical IT services firm. We have to credit two of our successful products generating $2M+ in licensing/SaaS revenues which is rare in the industry. 

We are Obsessed with our love for technology and the infinite possibilities it can create for making this world a better place. Our clients find us at our best when we are challenged with their toughest of the problems and we love chasing the problems. It thrills us and motivates us to deliver more. Our global delivery model has earned the trust and reputation of being a partner of choice. 

We have a strong heritage built on great people who put customers first and deliver exceptional results with no surprises - every time. We partner with you to understand the interconnection of user experience, business goals, and information technology. It's the optimal fusing of these three drivers that delivers 

Responsibilities: 

• Should understand the requirement in depth to ensure quality sourcing and recruiting
• Should ensure to submit profiles with quick turnaround time for timely submissions to meet sharp deadlines for each of the requisition
• Make use of effective resourcing strategies, such as head hunting, Internet sourcing, networking, employee referrals

Must have: 

• Candidate must have good communication skill
• He/she must have a good attitude
• Proven ability to consistently and positively contribute in a high- paced, changing the work environment
• Excellent communication skills in written and verbal both

Qualification:  

• 0-6 months of experience in US Staffing.
• Should be ready to work 80% of the time on W2 recruitment only.
• Good communication skills.
• Willing to work from office (Hyderabad)
• Experience in using job portals like Career Builder, Dice and LinkedIn would be a plus.

The ideal candidate should be a proactive individual with strong communication skills and a team player.

Should have hands-on experience in the following:

• He or she should have experience of at least 3-5 years in Oracle PL/SQL development.
• Excellent in-depth knowledge in Cursors, Indexes, Stored Procedures, Functions, Packages,
• Triggers, Exception Handling.
• Excellent in-depth knowledge in Collections, Records, Bulk Collect, Views
• Knowledge of Dynamic SQL
• Exposure in Performance Tuning, Explain Plan
• Should have worked in SDLC environment
• Good communication skills
• Experience in working effectively within a team as well as an individual contributor

factorie.io is a digital manufacturing enterprise, connecting disparate data sources to align manufacturing activities in real time, substantially impacting manufacturing throughput. 

Operating in an inherently data-rich environment – we seek to be the source of real time intelligence for manufacturing operations by processing and elevating data from machines, ERP and other IT applications. 

The company is currently being led by four co-founders with a cumulative management, technology and manufacturing experience of more than 100 years. In place is a dedicated strategic consulting for manufacturers to transition to digital enterprise, ISV partners and pilot clients. As we work towards empowering manufacturers at scale, we are looking for a high caliber IIoT / embedded systems engineer to lead data acquisition from machines. This is a leadership position and you'll be a Co-founder of the Company. All Co-founders are compensated from founders' equity in the Company – and, cash compensation will commence only after completing 12 months association as Co-founder.

Nurtured as a product-based technology company, our Co-founder would be someone who considers himself to be a methodical hacker – energized by simply the process of building products that solve meaningful problems. You have a bias for action, taking consistent, incremental and measurable steps towards releases that serve the product’s immediate and long-term needs.

If that person is you, we look forward to experimenting and tinkering with the next generation of IoT and data analytics use cases – together. 

ASK YOURSELF IF YOU ARE: 

Entrepreneurial? Someone who believes it is their time to shine and is tired of operating in a manager's shadow. Have you started-up before – or, even thought about doing so? Tell us your story. 

A hands-on craftsman? Someone who loves to build, understands the architecture of complex software applications and frameworks. Do you contribute to opensource projects and / or have you developed / are you developing certain ‘hobby’ applications? We would love to know about them. Do you have an engineering blog we should be following? We are NOT accepting managers for this position, please. 

Disciplined, passionate and obsessive? Someone who needs to solve REAL problems that have potential network implications on how products are manufactured in the world today – democratizing the hitherto ‘privileged’ power of Industry 4.0.

THE SKILLS YOU NEED / TECHNOLOGIES WE’RE WORKING ON,

CORE:

• Experience of data acquisition, extraction and normalization from PLCs and sensors with open protocols (OPC-UA, Modbus and MTConnect) + proprietary connectors (for Siemens Sinumerik, Fanuc and Mitsubishi)

• Comfortable building the Edge hardware and software infrastructure - IoT Gateways, IoT Servers installed on Linux or Android (Yocto) forks

• Exposure to low latency connectivity architecture using a combination of Wireless (Cellular, Wi-Fi, Bluetooth, and NFC), and wired (Ethernet) interfaces. Consequently, necessary is an understanding of Profinet and MQTT communication standards.

• In depth knowledge of the architecture of smart manufacturing software components - SCADA, Historian, MES etc.

• Have leveraged a cross-section database types - RDS (Postgres) and / or NoSQL (MongoDB, DynamoDB)

• A fanatical level of thoroughness with the OOP such as C++, JAVA (Spring) as well as the more recent Node.js, Go 

FUNDAMENTALS:

• Strong CS fundamentals. Deep knowledge of math, probability, statistics and algorithms. Delivering full-stack projects from conceptualization to production. Iterating, developing and testing MVPs quickly - therefore identifying opportunities to automate the development cycle to the maximum feasible extent.

• Extensive experience of leveraging (opensource) libraries / solutions, frameworks, APIs, AWS IIoT (or similar) etc., to drive efficiencies in product development. We’re NOT planning to reinvent the wheel.

• Familiarity with deploying and developing in a microservices architecture. i.e., deploying on a containerized (Kubernetes, Docker, ECS, EKS etc.) stack that communicates via REST APIs. Developing while religiously following the CI / CD methodology.

• Trade tools such as PLC simulators, IoT device / sensor simulators, Cucumber, Selenium, GIT, IDEs (ex., Eclipse), JIRA etc., would be almost second nature