HR executive

Senior ETL developer in SAS

We are seeking a skilled and experienced ETL Developer with strong SAS expertise to join

our growing Data Management team in Kolkata. The ideal candidate will be responsible for

designing, developing, implementing, and maintaining ETL processes to extract, transform,

and load data from various source systems into Banking data warehouse and other data

repositories of BFSI. This role requires a strong understanding of Banking data warehousing

concepts, ETL methodologies, and proficiency in SAS programming for data manipulation

and analysis.

Responsibilities:

• Design, develop, and implement ETL solutions using industry best practices and

tools, with a strong focus on SAS.

• Develop and maintain SAS programs for data extraction, transformation, and loading.

• Work with source system owners and data analysts to understand data requirements

and translate them into ETL specifications.

• Build and maintain data pipelines for Banking database to ensure data quality,

integrity, and consistency.

• Perform data profiling, data cleansing, and data validation to ensure accuracy and

reliability of data.

• Troubleshoot and resolve Bank’s ETL-related issues, including data quality problems

and performance bottlenecks.

• Optimize ETL processes for performance and scalability.

• Document ETL processes, data flows, and technical specifications.

• Collaborate with other team members, including data architects, data analysts, and

business users.

• Stay up-to-date with the latest SAS related ETL technologies and best practices,

particularly within the banking and financial services domain.

• Ensure compliance with data governance policies and security standards.

Qualifications:

• Bachelor's degree in Computer Science, Information Technology, or a related field.

• Proven experience as an ETL Developer, preferably within the banking or financial

services industry.

• Strong proficiency in SAS programming for data manipulation and ETL processes.

• Experience with other ETL tools (e.g., Informatica PowerCenter, DataStage, Talend)

is a plus.

• Solid understanding of data warehousing concepts, including dimensional modeling

(star schema, snowflake schema).

• Experience working with relational databases (e.g., Oracle, SQL Server) and SQL.

• Familiarity with data quality principles and practices.

• Excellent analytical and problem-solving skills.

• Strong communication and interpersonal skills.

• Ability to work independently and as part of a team.

• Experience with data visualization tools (e.g., Tableau, Power BI) is a plus.

• Understanding of regulatory requirements in the banking sector (e.g., RBI guidelines)

is an advantage.

Preferred Skills:

• Experience with cloud-based data warehousing solutions (e.g., AWS Redshift, Azure

Synapse, Google BigQuery).

• Knowledge of big data technologies (e.g., Hadoop, Spark).

• Experience with agile development methodologies.

• Relevant certifications (e.g., SAS Certified Professional).

What We Offer:

• Competitive salary and benefits package.

• Opportunity to work with cutting-edge technologies in a dynamic environment.

• Exposure to the banking and financial services domain.

• Professional development and growth opportunities.

• A collaborative and supportive work culture.

About OnGrid

OnGrid is a leading digital trust platform offering digital KYC, verifications, and background checks for onboarding employees, contractors users, merchants, customers, etc. Founded by IIT-B alumni, OnGrid has completed more than 500+ million checks across 3000+ happy clients. 

At OnGrid, we are focused on redefining and reimagining trust, safety, compliance, and accountability through our platforms OnGrid, eLockr, and Gridlines. Having built these basic pillars of trust (and creating a profitable venture with 400+ full-time people in the process), we now want our imagination to be let loose think of avenues never explored, and execute in ways never implemented before.

In this pursuit, we are looking for a motivated Information Security Analyst who is a self-starter, has an eye for detail, is analytical in approach, loves solving problems, and someone who can take initiative to build and improve the company’s information security, identify risks and act on the required changes quickly.

What you will do:

• Develop efficient strategies to protect the system, the networking infrastructure, data, and information systems against potential threats/cyber risks
• Routinely performing threat analysis, system checks, and security tests
• Defining and updating information security criteria and validation procedures
• Effectively discuss to understand safety and security and fix the problems along with different stakeholders
• To be a security representative or point of contact for all technical deliveries, initiatives, and project implementations.
• To develop technical processes and procedures and promote compliance in line with regulations, corporate policies, or standards as per ISO27001
• Assess technical security risks in terms of impact on systems and service confidentiality, integrity, and availability, and report and escalate results of risk assessments.
• Report any real or potential security breaches/vulnerabilities to various stakeholders and provide technical support during incident response
• Monitor security tools to detect security events & incidents Report and escalate any security breaches to the Information Technology Security Officer
• Operate vulnerability scanning and compliance tools to identify system weaknesses
• Represent IT Security matters at technical and business forums

Requirements: 

• 5+ years of relevant experience in the information security field.
• Team handling/Mentoring experience
• Relevant experience working with ISO Policies, and GDPR guidelines.
• Strong knowledge of network architecture and security concepts related to routing
• Exceptional attention to detail
• Excellent analytical and problem-solving skills
• Great team player and able to work efficiently with minimal supervision
• Excellent communication skills, both written and verbal, work with the different stakeholders on strengthening the security risks
• Able to handle and cope with stressful situations and understand the pressures of a start-up environment

What we offer:

Our team practices agile methodologies and the communication channel with the team lead is always open. Teammates are encouraged to bring their ideas forward ensuring the team’s overall development and we provide the best of facilities in terms of infrastructure and other benefits such as paid holidays, maternity and paternity leave, health insurance, flexible work hours, and many more. Our teams are close-knit and often contribute to each other’s professional and personal growth.

As a Staff Full-stack engineer, you will work across the Acceldata platform products. We’re looking for people with a strong background or inclination towards data engineering and systems; you’re comfortable in dealing with lots of moving pieces and can work at the  intersection of Databases, API's and Frontends

You will:          

• Be actively involved in strategic direction and product decisions.
• Design, build and maintain APIs, user-facing experiences, and services.
• Work closely with our customers and sales teams on a regular basis to carve out new features and use cases
• Work with MVC frameworks such as React or Angular 
• Work with database systems, RDBMS, Mongo, Elastic Search.
• Develop shared front-end components (JavaScript & CSS) for use across all of our products, enabling other UI engineers to build better products faster.

You need:      

• 8+ years of significant of web-application development experience in one or more JS frameworks. You care about building better products.
• Strong Computer Science fundamentals in data structures, algorithm design, and problem-solving.
• You're as comfortable writing plain JavaScript as working with modern frameworks like Angular. You've built your own controls and widgets in JavaScript. 
• You write unit tests for your JavaScript (really, you do). You've probably used Node. You have built complex JS web applications.
• Organized, thorough, and detail-oriented 

Good to have:

• Contribution to open-source projects.
• Background in enterprise software
• JVM performance tuning and debugging

Skills & Experience:

• 3 to 10 Years of experience in Ruby on Rails
• Knowledge on Active Admin
• Experience using RSpec
• worked on various third-party integrations.
• Knowledge on AWS/Azure would be a plus
• Hands on AngularJs/ReactJs/NodeJS with AWS Exposure is a Plus.