Requisition Id: 4-858-9143A
Title: Architecting DataBridge Analytics Developer
client: state client
Duration: 12 months
location: Brooklyn, NY
Hours: Up to 95/hr for a 7 hour day
Description:
The successful candidate will serve as Analytics Developer Consultant reporting to the Data Management and Integration Division’s Analytics Manager.
Responsibilities will include:
- Conduct technical POCs to determine optimal new Databridge implementation
- Implement and set up new Databridge environments
- Migrate existing schemas from Oracle
- Migrate existing schemas from MS SQL Server
- Change existing Informatica and SSIS ETL workflows
SCOPE OF SERVICES:
Consultant will work as an Analytics Developer conducting POCs and implementing business intelligence solutions for the new DataBridge platform.
- Conduct technical POCs to determine optimal new Databridge implementation
- Implement and set up new Databridge environments
- Migrate existing schemas from Oracle
- Migrate existing schemas from MS SQL Server
- Change existing Informatica ETL flows
MANDATORY SKILLS/EXPERIENCE :
Note: Candidates who do not have the mandatory skills will not be considered
- At least 8 years of experience as an Analytics Developer.·
- Experience in writing SQL.
- Experience using Oracle 10g/11g, SQL Server and/or a database appliance.
- Exposure to data modeling techniques and implementing complex ETL operations of varying degrees of volume, breadth and size.
- Knowledge of metadata driven enterprise reporting platforms.
- Experience interacting and communicating with business stakeholders to understand business needs and requirements.
- Ability to work in cross-functional teams to provide practical solutions.
Demonstrated experience working with technical and non-technical staff.
Strong written and verbal communication skills; excellent analytic, organization, presentation and facilitation skills; and the ability to manage multiple tasks under tight deadlines.
DESIREABLE SKILLS/EXPERIENCE:
- Experience working with cloud based SaaS solutions, CRM, ERP, and integrating with various platforms that have an API interface.
- Experience with UNIX shell scripting; Windows batch or power shell scripting
- Knowledge of client/server architecture.
- SSIS, Pentaho Kettle, Talend, Datastage, Ab Initio, Scribe experience is a plus, but not required.