Position: ETL Developer
Location: Brooklyn, NY
SCOPE OF SERVICES
o Work closely under the direction of the Project Manager with stakeholders from the Mayors Office, FDNY, DOB, DEP, ECB, DCP, DOF, DOHMH, DOT, HPD, LPC including managers, line employees, and IT staff.
o Responsible for designing and maintain ETL code using Informatica
o Work with the Team Lead to ensure that the right solution is put in place as per design
o Should be able to understand and follow the technical design documents and update them, if needed, during the development phase.
o Execute development plans and revise as appropriate to meet changing needs and requirements.
o Modify existing programs to confirm to system changes or to make improvements in the existing program.
o Write and maintain documentation to describe program development, logic, coding, testing changes and corrections.
MANDATORY SKILLS / EXPERIENCE: Note: candidates who do not have the mandatory skills will not be considered. At least 4 years of overall development experience Must have 3+ years of ETL experience and Business Intelligence experience. Must have Informatica PowerCenter development experience Must have Informatica B2B Data Transformation development experience Ability to Design, Develop and Deploy the ETL processes and performance tune ETL programs/scripts Strong knowledge of XML, XML Schema, XSD, XSLT/XPath and BI and Data Warehousing concepts Strong experience in Oracle, PL/SQL Knowledge of Java/J2EE (including EJB, JSP, JDBC), Websphere MQ Unix shell scripting Experience developing, deploying and implementing on NT and UNIX environments Excellent oral and written communication skills and the ability to clearly articulate to all project members and stakeholders; must be a team player who works well with technical and non-technical resources; Must be able to take strategic direction from executive management and participate in strategic planning activities throughout the lifetime of the project; Must be able to see tasks through to completion without significant guidance. Must be able to provide documentation on their work.
DESIRABLE SKILLS/EXPERIENCE :
o A Bachelors or Masters degree in MIS, Computer Science, or equivalent experience is desired;
o Knowledge of Java/J2EE is a plus
o Experienced with formal SDLCs and business analysis methodologies; Working knowledge of business analysis documentation standards;
Universal Technologies is a equal oppportunities employer