| Job Title: Database Developer||Location: New jersy || 100% Interview !! at Remote, Remote, USA |
| Email: [email protected] |
| From: Anuj, Vyze inc [email protected] Reply to: [email protected] Job Description - Job Title: Database Developer Location: New jersy Matawan need Candidates from these location only or 20 miles from the given location Duration: 12 months Moi: SKype Must have. SQL,SQL DBA,SSIS,SSRS, .Net code in SSIS packages and familiar with Cloud database as well. Job description: Bachelors degree in computer science, Information Technology, or commensurate work experience. Proven experience as an SSIS/SSRS Developer, with a minimum of 7 years experience developing and deploying SSRS reports. Strong proficiency in SQL, T-SQL, and database concepts. Extensive knowledge of SQL Server Integration Services (SSIS). Experience with data warehousing and data modeling techniques. Proficiency in SQL, T-SQL, and database design principles. Strong knowledge of SSRS, including report design, parameterization, and deployment. Experience with data visualization tools and techniques. Ability to write efficient, optimized SQL queries. Knowledge of data warehousing concepts is a plus. Report Development: Design, develop, and maintain SSRS reports, ensuring high-quality, scalable, and efficient solutions. Data Modeling: Work with data analysts and database administrators to design data models and schemas that support reporting needs. Query Optimization: Write and optimize complex SQL queries to retrieve and transform data for reporting purposes. Data Visualization: Create visually appealing and insightful reports and dashboards that effectively communicate data to business stakeholders. Performance Tuning: Monitor and optimize the performance of SSRS reports and data queries to ensure responsiveness and efficiency. Data Integration: Collaborate with ETL developers to integrate data from various sources into SSRS reports. Security: Implement and maintain data security and access controls for SSRS reports, ensuring compliance with company policies and regulations. Documentation: Maintain comprehensive documentation of report specifications, data sources, and development processes. Testing and QA: Conduct thorough testing of reports to identify and resolve issues or discrepancies. ETL Development: Design, develop, and maintain ETL (Extract, Transform, Load) processes using SSIS to move, transform, and integrate data from various sources into target systems. Data Transformation: Create complex data transformation packages and workflows to cleanse, enrich, and validate data as it moves through the ETL pipeline. Performance Optimization: Monitor and optimize the performance of SSIS packages to ensure data processing efficiency and reliability. Data Modeling: Collaborate with data architects and database administrators to design and maintain data models that support ETL processes. Error Handling: Implement error handling and logging mechanisms to track and resolve data integration issues. Data Integration: Work with APIs, web services, and external data sources to streamline data integration processes. Documentation: Maintain detailed documentation of ETL processes, including data mappings, transformations, and dependencies. Security: Ensure data security and compliance with data governance policies during data integration. Testing and QA: Conduct thorough testing and validation of ETL processes to identify and address issues. Training and Mentoring: Provide guidance and mentorship to junior developers and assist in their professional growth. Keywords: quality analyst information technology |
| [email protected] View all |
| Thu Feb 01 01:57:00 UTC 2024 |