Senior ETL Developer :: Washington , District of Columbia (Onsite) at Washington, DC, USA |
Email: [email protected] |
Please share resume at [email protected] Job Title: Senior ETL Developer EXP NEEDED:- 10 Yr EXPERIENCE REQUIRED WITH CAD/RMS Job Description : Senior ETL Developer with Premier One CAD RMS Cert (Desired). The ideal candidate will be local to Wash DC, MD or VA or open to relo. Client is looking for an Senior ETL Developer with experience working with Crime data from Premier One CAD\\RMS. About this Position / 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 Qualifications 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. Excellent analytical and problem-solving skills. Ability to work independently and as part of a team in a fast-paced environment. Effective communication skills, both verbal and written. Attention to detail and commitment to delivering high-quality solutions. Premier One CAD\\RMS Certification Bachelors Degree in Comp. Science or related fields. Thanks and Regards!! Akashika Pandey Technical Resource Specialist Ace Technologies Inc 2375 Zanker Road, Suite 250, San Jose, CA 95131 Phone: 1-408-617-7200 | Extn 4286 | Email ID/Hangout : [email protected] ------------------------------------------------------------------------------------------------------- Reporting Manager: Manish Sharma| Email ID : manish @acetechnologies.com | Phone: 1-408-617-7200 Ext 4298 Escalations : [email protected] Note: We respect your Online Privacy. This is not an unsolicited mail. Under Bills.1618 Title III passed by the 105th U.S. Congress this mail cannot be considered unsolicited as long as we include Contact information and a method to be removed from our mailing list. If you are not interested in receiving our e-mails then please reply with a "REMOVE" in the subject line to [email protected] and mention all the e-mail addresses to be removed with any e-mail addresses, which might be diverting the e-mails to you. We are sorry for the inconvenience -- Keywords: information technology California Idaho Maryland Virginia Senior ETL Developer :: Washington , District of Columbia (Onsite) [email protected] |
[email protected] View all |
Fri Sep 06 01:26:00 UTC 2024 |