2+ Snow flake schema Jobs in Kolkata | Snow flake schema Job openings in Kolkata

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.