| SSRS\\ETL Developer || Client State of Washington DC || at Washington, DC, USA |
| Email: [email protected] |
| From: Deepak Thakur, Largeton Inc [email protected] Reply to: [email protected] Job Description Title: SSRS\\ETL Developer || PremierOne CAD\\RMS Certification Duration: 6+ Months project Location: (DC & MD offices) - Remote - Preferred EST Visa: USC and GC Must have 12+ years of exp. Responsibilities SSRS (SQL Server Reporting Services) and ETL (Extract, Transform, Load) develop builds and maintain reports and data from CAD\\RMS system. Modernize and transform data to improve the usability of the reports and dashboards. Designing, developing, and maintaining SSRS reports based on business requirements. Building ETL processes to extract, transform, and load data from various sources into a data warehouse or data mart. Collaborating with business analysts and stakeholders to gather and analyze reporting requirements. Creating and optimizing SQL queries and stored procedures for data extraction and transformation. Developing and implementing data cleansing and validation processes to ensure data accuracy and integrity. Designing and implementing data models and schemas to support reporting and analytics needs. Monitoring and optimizing SSRS report performance and data loading processes. Troubleshooting and resolving issues related to SSRS reports, ETL processes, and data quality. Documenting technical specifications, data mappings, and ETL workflows. Providing technical support and training to end-users on SSRS reports and data access tools Education Minimum of bachelors degree in computer-related field. Expected Experience 10+ years of experience as an SSRS developer, ETL developer, or similar role. Strong proficiency in SQL programming and database concepts, particularly with Microsoft SQL Server. Experience with SSIS (SQL Server Integration Services) for ETL development and data integration. Over 5 years of experience working with Crime data from PremierOne CAD\\RMS. Knowledge of data warehousing concepts, dimensional modeling, and data normalization. Familiarity with data visualization tools and techniques. Certification PremierOne CAD\\RMS Certification Additional Details Most of the work associated is in support of reports, data, and CAD\\RMS. Support for IAPro, BlueTeam, BEAST, LinX, and DIMS DVEU is minimal. The CAD\\RMS system is behind CJIS firewalls and with strong knowledge of firewalls, load balancers, network design, and other infrastructure-related experience. Keywords: green card Maryland SSRS\\ETL Developer || Client State of Washington DC || [email protected] |
| [email protected] View all |
| Wed Aug 21 03:29:00 UTC 2024 |