Sales Lead - BMS

Sr. ETL Developer 

Job Id: QX033 

Role Overview 

We are seeking a detail-oriented ETL Developer with deep expertise in SQL and stored procedures to design, build, optimize, and maintain data integration pipelines. This role focuses on transforming and loading data from multiple source systems into data warehouses and reporting platforms while ensuring data accuracy, performance, and reliability. 

Key Responsibilities 

• Design, develop, and maintain ETL processes using SQL and database stored procedures 
• Build efficient data transformations, aggregations, and validations for large datasets 
• Optimize SQL queries, indexes, and stored procedures for performance and scalability 
• Collaborate with data analysts, BI developers, and application teams to understand data requirements 
• Implement error handling, logging, and monitoring for ETL workflows 
• Perform data quality checks and troubleshoot data discrepancies 
• Support scheduled batch loads and incremental data refresh processes 
• Document ETL logic, data mappings, and technical designs 
• Assist with production deployments and ongoing maintenance. 

Required Skills & Qualifications 

• Bachelor’s degree in computer science, Information Systems, or a related field (or equivalent experience) 
• 5+ Years of Expert Level Experience and Proficiency in SQL (complex joins, CTEs, window functions, performance tuning) 
• 5+ Years of Extensive experience writing and maintaining stored procedures, functions, and triggers 
• Hands-on experience with ETL concepts (extraction, transformation, loading) 
• Experience working with relational databases (e.g., SQL Server, Oracle, MySQL) 
• Solid understanding of data warehousing concepts (fact tables, dimensions, star schemas) 
• Ability to debug and optimize existing ETL processes 
• Experience handling large datasets and batch processing 
• Strong analytical and problem-solving skills 

Preferred Qualifications 

• Experience with ETL tools, Azure Data Factory, etc. 
• Experience with Azure Cloud  
• Familiarity with BI/reporting tools, Power BI 
• Experience with incremental loads, CDC, and data reconciliation 
• Exposure to cloud data platforms (Azure SQL, AWS RDS, Redshift, Snowflake) 
• Basic scripting experience (PowerShell, Python, or Bash) 
• Knowledge of data governance and security best practices. 

Competencies: 

• Tech Savvy - Anticipating and adopting innovations in business-building digital and technology applications. 
• Self-Development - Actively seeking new ways to grow and be challenged using both formal and informal development channels. 
• Action Oriented - Taking on new opportunities and tough challenges with a sense of urgency, high energy, and enthusiasm. 
• Customer Focus - Building strong customer relationships and delivering customer-centric solutions. 
• Optimize Work Processes - Knowing the most effective and efficient processes to get things done, with a focus on continuous improvement. 

Why Join Us? 

• Be part of a collaborative and agile team driving cutting-edge AI and data engineering solutions. 
• Work on impactful projects that make a difference across industries. 
• Opportunities for professional growth and continuous learning. 
• Competitive salary and benefits package. 

Application Details 

Ready to make an impact? Apply today and become part of the QX Impact team! 

Who Are We?

ALTRES, headquartered in Honolulu, Hawaii (USA) and in existence since 1969, is working on industry leading products for the HR industry. We are looking for web developers with the right skills and experience to join our growing team. Altres Technologies is looking for techies that will appreciate a dynamic, creative and competitive work environment, that pairs perfectly with the stability and support of a successful organization with 4 decades of satisfied customers in the market.

Website- www.altres.in / www.altres.com

LinkedIn: https://www.linkedin.com/company/altres-technologies-india

Facebook: https://www.facebook.com/altrestechnologies

About the Role:

You will contribute to our continually evolving HR platform by working as developer on the in-house product development team. It requires experience of working on HTML5, CSS, Javascript, MySQL, and Java (very important) in an agile environment. Mobile experience is a big plus. You will collaborate with locally based team members and remote Product/Project Managers and will contribute to the design and implementation of new features.

What Would You Do At Altres?

1.    Translate software requirements into workable programming code.

2.    Work with Team members, discuss technical solutions with them

3.    Participate actively in scrum meetings

4.    Conduct code reviews for peers.

5.    Perform coding, get it reviewed by other members of the team.

6.    Collaborate with Development, QA, and Product Management teams for implementation

7.    Mentor team members and guide them when needed.

8.    Ability to self-direct, work without supervision and balance multiple duties.

What Do You Need For The Job?

1.    Strong technical background with good understanding of product development life cycle.

2.    Expertise in full stack application design and development across all relevant form factors – smartphone, tablet, laptop, desktop, etc.

3.    7+ years of experience building web applications using J2EE (JSP, Servlets) and Core Java.

4.    Detailed understanding of front-end Web application technologies like HTML5, Javascript, CSS.

5.    Proficient in MySQL or another RDBMS variant with 2+ years of experience building and interfacing with the database.

6.    Good know-how of modern frameworks.

7.    Keen understanding of user experience and user interface design.

8.    Familiarity with Agile software development processes including Scrum.

9.    Experience with JIRA or similar issue & project tracking tool.

What’s In It for You?

1.    Competitive salary and benefits

2.    Opportunity to work for both front end and back end processes

3.    Great learning and development opportunities

4.    Working with an organisation that keeps up to date with industry best benchmarking in every aspect

• Apply knowledge of Javascript (ES6) including all the latest features
• Usage of third party libraries for Maps, UI scaling, Styles, Secure storage, Permissions, Navigation, Splash screen, Network. Analytics. Push notifications, Localization, Calendar, etc.
• Build and run apps using Xcode, and Android Studio
• Persistence support using frameworks like Realm
• Comprehend performance issues and solve them
• Knowledge of Git (including merging, branching and resolving merge conflicts)

• Ability to create flexbox driven UI layout
• Configuring ESLint for JS code linting
• Being aware of alternate state management mechanisms like MobX
• Is proficient in either iOS or Android programming too.

• Knowledge of all aspects of React framework
• Components, containers, JSX specification of component UI layout, Component lifecycle
• Props and State mechanism used for data flow
• Various kinds of views (text, button, scroll view, flat list, etc.)
• Navigation
• RN animations and gesture system fundamentals
• Redux state management library
• React Router usage
• JSON/XML parsing

Experience - 2.0 - 6.0 Year(s)

Location : Bangalore/Gurgaon

Qualification : Any Graduation

Candidate should either be from Tier 1 college/working in a Tier 1 product based company

Looking for Candidates having 2 to 6 Year(s) of experience in Frontend Development and atleast 1.5 to 2 years of experience in React.js

Individual contributor role

Reporting to Tech Lead Directly