Job Detail

Benefits

Position Summary:
We are looking for a skilled senior SSIS/SSAS Developer, you will be responsible for designing,
developing, and implementing ETL processes to support the organization's data integration
initiatives and data modelling for Reporting initiatives. He/She should be able to collaborate with
cross-functional teams to gather requirements, analyze data, and ensure the successful delivery
of high-quality data solutions.
Responsibilities:
• Work closely with data architects and business analyststo understand data requirements.
• Design, develop, test, and implement ETL processes using SQL Server Integration Services
(SSIS).
• Create and maintain complex ETL packages to extract, transform, and load data from
various source systems into the target data warehouse
• Perform data profiling and analysis to ensure data quality and accuracy
• Optimize and tune ETL processes for maximum performance and efficiency.
• Identify and resolve performance bottlenecks in SSIS packages.
• Ensure data consistency and integrity across different systems
• Collaborate with data architects, database administrators, and other stakeholders to
ensure seamless data integration
• Provide support for production ETL processes and troubleshoot any issues that may arise.
• Implement monitoring and logging mechanisms to proactively identify and address
potential problems.
• Design and develop multidimensional and tabular data models using SQL Server Analysis
Services (SSAS)
• Enhancement of SSIS reports and the way SQL Server Cubes are formed
• Develop and maintain performance efficient OLAP cubes for efficient data analysis and
reporting
• Optimize SSAS cubes for performance, ensuring fast query response times

Requirements:
• Bachelor’s degree in computer science, Engineering or similar.
• A senior SSIS and SSAS developer with a minimum of 6-8 years of experience in managing
and tuning SQL Server Cubes
• Minimum four years of professional experience as a SSIS/ETL developer.
• Experience in SSAS/ OLAP architecture is a good to have skill
• Background in data warehouse design (e.g. dimensional modeling) and data mining
• In-depth understanding of database management systems, online analytical processing
(OLAP) and ETL (Extract, transform, load) framework
• Knowledge of data quality and data governance principles
• Familiarity with cloud-based data integration solutions
• Knowledge of complex SQL queries
• Minimum 3 months extendable.
• Analytical thinking for converting data into relevant Aggregated KPIs
• Must demonstrate the ability to work effectively as a member of a team, as well as the
maturity to work independently.
• Excellent communication skills to communicate with client and internal teams
successfully