Job Details

ID #21586759
State New York
City New york city
Job type Contract
Salary USD TBD TBD
Source QED National
Showed 2021-10-23
Date 2021-10-23
Deadline 2021-12-21
Category Et cetera
Create resume

HRO Sr. Data Warehouse Developer

New York, New york city, 10008 New york city USA

Vacancy expired!

A NYC agency located in New York, NY is looking for an HRO Sr. Data Warehouse Developer for a 5 month contract.

Requirements and skills

  • 8 years of experience in client server architecture.
  • Worked with Business Analysts and Business Users to analyze the business process and user requirements to cater their needs for reports
  • Lead infrastructure solution design and reviews using design process and industry best practices.
  • Excellent communication skills.
  • Extensive project experience in development and support of DW and Reporting Platforms
  • SQL Development & SSIS Development experience for city agency integration experience is crucial
  • Microsoft Integration technology experience along with SQL SSRS/SSIS skills are crucial for RNAV data backbone creation

Desirable Skills

  • Java/J2EE Web Developer in HRO Team to manage Custom Web application
  • Expertise in writing complex PL/SQL queries, triggers, Stored Procedures
  • Involved in improving the performance of the reports by tuning the SQL queries.
  • Extensive experience in Server-Side Java, J2EE, JDBC, EJB, JSP, Servlets, Struts, Ant and XML Beans.
  • Expertise in SOA- Web Services and related technologies like XML, DTD, XSLT, and XPATH.
  • Hands on Experience in C#,.NET, ADO.NET Datasets, ASP.NET 3.5 Master Pages, HTML, JavaScript, SQL Server 2016 and Transact-SQL, Web Services.

Responsibilities

  • Successfully integrate Java web application with Microsoft ADFS using Spring Security SAML Extension.
  • Work on Apache Ant build scripts to package and generate war file for deployment to Apache Tomcat Server.
  • Work on documenting all the steps involved, technical specifications, configuration changes required, technical problems and steps taken to resolve and successfully complete the migration process to Azure. Custom programming to accommodate client requests.
  • Work on JavaScript, JQuery, Google Maps API, AJAX, HighCharts API, DataTables API, HTML and CSS on the front end.
  • Work on JQuery UI Components - Widgets (Tabs, Accordion, Auto Complete, Button, Dialog, menu, Select menu, Progress Bar, Tooltip), Effects (Animations, Style, Toggle), Interactions (Resizable, Select, Sort) and many other Utilities provided.
  • Develop server side components in Java\J2EE and middleware Service/DAO components using Spring Framework Modules - Spring Core, Spring MVC, Spring JDBC and Spring Security LDAP.
  • Considering the need for dynamic and interactive behavior, implemented RESTful Web Service using AJAX/JSON with Spring Framework for client and server communication. Worked on designing JSON format used as a data exchange format between front end and server.
  • Perform Unit Testing using JUnit.
  • Data Modeling and Database design assisted in transforming the logical database model to physical schema.
  • Informatica Power Center Client Tools - Designer, Workflow Manager, Monitor and Repository Manager to extract data received in flat files, apply transformations to meet business needs and load processed data to Oracle Database.
  • Extensively work on JasperSoft Studio.
  • Develop Jasper Reports with multiple datasets, sub repots, charts, graphic elements, labels, text fields, used Report Expression in Java.
  • Develop custom code in Java to validate data extracted using complex SQL queries from multiple data sources, to customize bar chart colors used to generate the report.
  • Write and maintain documentation to describe application technical design and development, design logic and SQL database columns/logic for Jasper Reports.
  • Effectively communicate with management, finding optimal solutions to open issues quickly.
  • Create technical design documentation.
  • Participate in code implementation
  • Work closely with Technical Lead, project manager and business analyst to turn business requirements into coding specifications.
  • Works as Data modelling and Warehousing SME and developer at HRO
  • Leverage existing HRO data platform toolkit (SQL+SSIS) to create comprehensive data source system for RNAV reporting

About us: QED National is a leading IT consulting, solutions and staff augmentation firm, serving both the public and private sectors for over 28 years. Headquartered in midtown Manhattan, QED National's team is comprised of the brightest minds in the industry with the skills to solve the most complex technological problems.?

Vacancy expired!

Subscribe Report job