- Work closely with data architects and business analysts to 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 - 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 ( 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 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
-
Radical Technologies Bavdhan, IndiaSQL Developer · Post : Developer (SQL) · Salary : 3-5lp.a · Experience : 1-2 years · No. of requirement : 2.4 · Education Qualification : BE or Computer Graduate (preferred from Pune University ) · Work Environment : Work From office · Job Location : Bavdhan Pune · Interview : Of ...
-
Msbi (Ssis & SQL) 6 to 12 Years Pan India
2 weeks ago
Capgemini Pune, Maharashtra, India**Job Description**: · - Ability to troubleshoot and debug. · - SQL Development: Write complex queries, optimize performance, and manage database structures. · - Strong knowledge and experience with T-SQL, functions, Stored procedures, views. · - Strong SSIS Development: Design, ...
-
SQL Production and Application Support
1 week ago
Datafortune Pune, Maharashtra, IndiaPune- Onsite*** · **About Us** · Datafortune is a cutting edge IT Services Company headquartered in Atlanta, Georgia, with development centres in Pune and Hyderabad, India. With a proven track record of being totally client focused, Datafortune promises efficient, high quality, a ...
-
Intern
2 weeks ago
Ecolab Pune, IndiaPreferred Qualifications · Data science or advanced analytics experience - Python, R, Azure, Spark, VBA, Hadoop · History of managing and delivering multiple projects, tasks, and initiatives simultaneously · Ability to create, implement and continuously improve processes in a cha ...
-
Power Bi
2 weeks ago
Zensar Technologies Pune, India**POWER BI** · **-** · **(** · **0094203** · **)** · **Description** · - 3+ years of hands on experience with Power BI report development and publishing in cloud · - Hands on experience in developing Power BI report with row level security implemented · - Expertise in building hi ...
-
Ms SQL Administrator/ Dba
2 weeks ago
XECOM Information Technologies Pvt. Ltd. Pune, Maharashtra, IndiaHaving Experience as **SQL Administrator** as well as Application DBA (Performance Tuning, working with Dev team Etc)**Manage **SQL Server database, Configure and maintain database servers and processes. · **Monitor **system's health and performance and troubleshooting problems. ...
-
SQL Administrator
2 weeks ago
Evolent Health Pune, Maharashtra, IndiaYour Future Evolves Here · Evolent Health has a bold mission to change the health of the nation by changing the way health care is delivered. Our pursuit of this mission is the driving force that brings us to work each day. We believe in embracing new ideas, challenging ourselves ...
-
Power BI Expert
2 weeks ago
Client of Techno Wise Pune, IndiaOur client which is a Great Place to Work certified MNC is looking for a self-motivated and dynamic Power BI (MSBI) Experts. · **Responsibilities**: · Provide data, analysis and insights to support strategy development and data-driven business decisions · Perform analyses and rep ...
-
Oracle Database Administrator
3 weeks ago
Dimension Pune, India**Responsibilities**: · - Installation of RDBMS software and creation of Oracle databases on windows/Linux platform · - Good knowledge of exp-imp, data pump utility. · - Maintaining physical and logical backups via user managed & RMAN backup recoveries. · - Checking Alert Log fil ...
-
NET Microsoft Stack
2 weeks ago
Hitachi Vantara Pune, India**JD - hands on.Net/Azure Architect.** · **Meet our Team** · We represent Hitachi Vantara to enterprise clients across industries, establishing business relationships to understand customer challenges so that we can deliver profitable business for Hitachi products, services and s ...
-
Ms - Ssis
1 week ago
Yash Technologies Pune, IndiaDate: May 27, 2023- Job Requisition Id: Location: Hyderabad, TG, IN Indore, MP, IN, Pune, MH, INYASH Technologies is a leading technology integrator specializing in helping clients reimagine operating models, enhance competitiveness, optimize costs, foster exceptional stakeholder ...
-
SQL Server Database Administrator
1 week ago
Quess IT Staffing Pune, India**About Us** · "Magna Infotech, now Quess IT Staffing, is India's largest IT staffing company with over 20 years of experience in staffing IT professionals in 300+ companies across levels and skillsets. Our 10,000+ associates deployed in 80+ cities and towns are proficient in ove ...
-
Power Bi
2 days ago
PRI India IT Services Pvt Ltd Pune, India**Job Duties/Roles**: · - Identify and participate in process improvement initiatives that improve the internal customer experience, enhance work flow, and/or improve the work environment. · - Develop scripts, perform database support activities, and conduct performance tuning an ...
-
Architect - Data Modelling
1 week ago
Yash Technologies Pune, IndiaDate: Apr 27, 2023- Job Requisition Id: Location: Indore, IN Bangalore, KA, IN Pune, MH, IN Hyderabad, TG, IN Gurgaon, IN Pune, INYASH Technologies is a leading technology integrator specializing in helping clients reimagine operating models, enhance competitiveness, optimize cos ...
-
SQL Database
3 days ago
Quess IT Staffing Pune, India**About Us** · "Magna Infotech, now Quess IT Staffing, is India's largest IT staffing company with over 20 years of experience in staffing IT professionals in 300+ companies across levels and skillsets. Our 10,000+ associates deployed in 80+ cities and towns are proficient in ove ...
-
Db Administrator
3 days ago
amdocs Pune, India**Job ID**:176194 · **Required Travel**: Minimal · **Managerial - No** · **Location**:India · - Pune (Amdocs Site)** · **Who are we?**: · **In one sentence**: · The DB administrator is handling physical and applicative database administration activities supporting end 2 end life ...
-
Database Administrator
4 days ago
Appriffy - Digital IT Hub Private Limited Pune, IndiaA professional Database Administrator (DBA) will keep the database up and running · smoothly 24/7. The goal is to provide a seamless flow of information throughout the · company, considering both backend data structure and frontend accessibility for end · - users. · Key Responsib ...
-
Data Base Administrator- SQL
6 days ago
Dätwyler Pune, IndiaDatwyler IT Services is the IT wing of the Datwyler Group. We work alongside the Datwyler group companies and Business units to ensure Datwyler has an IT strategy that allows us to transform our Information infrastructure to keep abreast with the digital needs of our group compan ...
-
Project Engr Ii
4 days ago
Honeywell Pune, India**Join a team recognized for leadership, innovation and diversity**: · COMPANY SUMMARY · Honeywell International Inc. is a Fortune 100 industrial technology company that makes a variety of commercial and consumer solutions, engineering services and aerospace systems for a wide va ...
-
Contractor - Dynamics 365
3 days ago
Yash Technologies Pune, Maharashtra, India FreelanceDate: Jan 17, 2024- Job Requisition Id: Location: Pune, IN Indore, INYASH Technologies is a leading technology integrator specializing in helping clients reimagine operating models, enhance competitiveness, optimize costs, foster exceptional stakeholder experiences, and drive bus ...
Senior Developer – SSIS/ SSAS - Pune, India - Global Pharma Tek
Description
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: