SSRS Power BI Developer

Job Title - Sr SSRS PBI DeveloperLocation - Studio City, CA 91604 (Onsite Local)Duration – FTENote: Must have Updated LinkedIn id.Job description:Summary:The desired profile should have hands-on experience in designing, establishing, and maintaining data management and storing systems. Skilled in collecting, processing, cleaning, and deploying large datasets, understanding ER data models, and integrating with multiple data sources. Efficient in analyzing, communicating, and proposing different ways of building Data Warehouses, Data Lakes, End-to-End Pipelines, and Big Data solutions to clients, either in batch or streaming strategies.Technical Proficiencies:SQL:Data Definition Language, Data Manipulation Language, Intermediate/advanced queries for analytical purpose, Subqueries, CTEs, Data types, Joins with business rules applied, Grouping and Aggregates for business metrics, Indexing and optimizing queries for efficient ETL process, Stored Procedures for transforming and preparing data, SSMS, DBeaverSSRS/Power BI:Design and develop ETL processes using SQL Server Reporting Services (SSRS) to extract, transform, and load data from various source systems into target databases.Strong hands-on with PBI and SSRS with good communication and technical expertiseExperience in SQL queriesPerform data source integration from diverse platforms, such as relational databases, flat files, web services, and cloud-based storageOptimize data integration processes for performance, identifying and resolving bottlenecks, and utilizing best practices.Provide expertise in troubleshooting and resolving data integration issues, ensuring data accuracy and consistency.