Go Back
IT Data Warehouse Dev Sr Location: Cleveland, OH
2016-05-16 14:08:45
Job Type:
Full Time only
Budget $:
100,000 - 200,000
Role: IT Data Warehouse Dev Sr
Location: Cleveland, OH
ESSENTIAL FUNCTIONS- Develops Data Warehouse Extract, Transformation and Load (ETL) processes using an ETL software tool (e.g. Informatica, DataStage).
- Monitors and tunes data warehouse ETL processes to ensure optimal load performance.
- Provides production support of the data warehouse environment.
- Assists in the maintenance and upgrades of data warehouse software.
- Oversees large and complex projects, including planning, monitoring, and reviewing progress and accuracy of work and evaluating results.
- Provides production support and performance monitoring of critical production systems.
- Coordinates with other departments and/or external vendors to resolve critical system production problems and implementation of software release to production.
- Makes recommendations in product evaluations and buy \'versus\' build recommendations.
- Responsible for developing application architectural design and code for new applications and/or enhancements to existing applications.
- Assists in establishing and maintaining code standards and application development policy procedures.
- Generates complex application code that is traceable to technical specifications.
- Makes recommendations toward the development of new code or reuse of existing code.
- Devises sample input data to test accuracy of the program, writes unit test scripts and debug code using reliable test data, modify steps and sequence as required; obtains end user approval to promote to production.
- Performs critical work of a complex technical and business nature.
- Responsible for providing accurate and timely communication of the status of assignment, job responsibilities, and the resolution of problems to the appropriate parties following established policies and procedures.
- Creates estimates for large and complex assignments and tracks progress against major milestones following software development life cycle methodology and documentation standards.
- Ensures appropriate documentation is created and maintained and adherence to project management methods. Keeps current on new software releases, investigates emerging technologies, and advises management for strategic and tactical planning.
- May lead moderate complex project or development phase of a project; may lead technical review meetings with IT team. Coaches and mentors less experienced developers; performs code reviews.
- Adheres to NYCB policies, procedures and standards. Performs special projects and additional duties and responsibilities as required.
- Where applicable and when performing the responsibilities of the job, employees are accountable to maintain Sarbanes-Oxley compliance and adhere to internal control policies and procedures.
EDUCATION AND EXPERIENCE- Bachelor\'s degree in a computer science, business or finance related field or equivalent relevant experience.
- Seven years or more experience in system analysis, design, coding and testing. Five years of experience in IT data warehouse.
KNOWLEDGE, SKILLS AND ABILITIES- Strong knowledge of data warehouse concepts and methodologies.
- Strong knowledge of database concepts.
- Strong knowledge of multiple structured coding languages and distributed systems development techniques.
- Strong knowledge of system development life cycle concepts, practices and procedures.
- Strong knowledge of business and system workflow documentation methods.
- Strong analytical and organizational skills.
- Strong verbal and written communication skills, good negotiation skills.
- Strong team player. Detail oriented.
- Exercises sound judgment.
- Ability to work well with others, as well as independently.
- Ability to manage multiple tasks simultaneously and meet established deadlines.
- Ability to lead system designs, development projects or problem solving efforts.
- Ability to maintain confidentiality with regard to customer information and employee records.
TECHNOLOGIES- Oracle PL SQL. ETL Tools (e.g. Informatica, DataStage).
- Business Intelligence Reporting Tools (e.g. Cognos BI, Discoverer).
- Knowledge of Control M is a plus.
Key Skills: