Job Title #1 ID: 2044
INFORMATICA DEVELOPER With DAC
**Position Comments:The position is for a hands-on Senior (7+ years) level Informatica ETL Developer along with 1 to2+ years current experience with DAC (data Administration Console.
Face to Face final interview required after intial phone interviews. Position can be worked out of Long Island City, NY or Tampa, FL. NY location preferred**
Summary: Capable of designing, developing and implementing ETL maps and schedules using Informatica within packaged data warehousing applications, as well as customized solutions following the full systems development lifecycle (SDLC). The packaged data warehousing solution is OBIEE 11g HR Analytics, and Financial Analytics.
detailed design and development of ETL maps and schedules for applications (delivered, and custom) on the OBIEE 11g platform, primarily for Human Resources
Will work with Business Systems Analysts to ensure that business requirements and functional specifications are comprehensive and consistent and to develop comprehensive test plans.
Will use specifications to design appropriate data models and ETL (Informatica) maps and to translate these designs into technical specifications.
Will work closely with a report metadata (RPD) analyst to enable the creation of efficient meta data layer designs.
Will design ETL schedules and ensure that they are implemented correctly using OBIEE technology (DAC).
Will work with the DBAs and Production Support to improve operating efficiency.
Will maintain records to document program development and revisions.
Will work closely with the HR business customer and IT Business Systems Analyst to obtain clarification on business requirements at the discretion of the project manager; may need to present business team with alternative technical solutions to complex problems.
Job Title #2 ID: 2045
Oracle PL/SQL and SQL Server The Oracle PL/SQL and Microsoft SQL Server Developer will assist in the business analysis, implementation and support of interfaces for Front Office, Middle Office and Back Office systems. Thorough understanding of Oracle database application performance tuning, design, security scalability, analyze and troubleshooting problems and industry best practices for application development Extensive experience in PL/SQL, SQL performance tuning products and utilities. Finance Services Software development background and experience in Microsoft SQL Server and PL/SQL are a must. Job Duties/Responsibilities: Analyzes functional needs that drive the analysis and technical design of quality technical solutions; recommends solutions that are aligned with business / IT strategies and complies with corporate architectural standards. Analyzes performance and capacity issues with systems / applications software and/or application components. Design and develop Stored Procedures, Packages and batch loading process in Oracle. Provide programming and business analysis support for the design, development, and application testing Develop and review deliverables including requirement, design and test documents Collaborate with functional and technical teams to resolve technical database related issues. The candidate will be responsible for all aspects of system development and maintenance, which includes: requirements gathering, system analysis and design, documentation, coding, testing, implementation, researching and resolving production problems and dealing with end users to resolve issues. Must Have Skills: 6+ years of experience in Oracle PL/SQL and SQL Server Displays problem solving and analytical skills, using them to resolve technical problems; possesses a good understanding of business requirements and IT strategies
Job Title #3 ID: 2046
SAP Senior Business Warehouse Developer 5 + years
Expert knowledge of data extraction from SAP modules (ECC, BPC) into BW.
Must have a complete understanding of the entire BW architecture and the data life cycle.
Works with the front-end development team to provide accurate data to the business.
Develops high performing solutions in BW, Works well in a team environment and contributes by sharing ideas and knowledge with the rest of the team
Minimum of 4 years of hands on experience building SAP BW extractors in BW, with PSA, DSO (ODS) and cubes
Must have current knowledge and experience with SAP BW 7.3
Excellent written and verbal communications
Strong analytical skills solving problems outside the norm challenges
Must have knowledge of financial application and processes.
Responsible for developing custom extracts to populate DSOs and Cubes.
Responsible for activating and supporting standard extracts
Works with Data modeler to Develop data models within BW for DSOs and Cubes, may act as data modeler at times
Documents process and extracts, helps front-end team to document cubes
Works with the front end team to provide the data needed by the business
Develops, designs, and implements SAP BW objects