Under limited supervision, a Senior IT Data Warehouse Developer, works closely with business analysts and IT team members to understand complex business requirements to improve and enhance the corporate Data Warehouse. Responsible for product support and maintenance of the Data Warehouse. Participates in the full systems life cycle and data warehouse design and construction including recommendation of code development or reuse and buy versus build solutions. Designs, codes, tests... debugs, maintains, modifies and implements complex application software that is delivered on time. Responsible for application maintenance and production support of multiple applications.
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.TECHNOLOGIESOracle PL SQL. ETL Tools (e.g. Informatica, DataStage). Business Intelligence Reporting Tools (e.g. Cognos BI, Discoverer). Knowledge of Control M is a plus.
NEW YORK COMMUNITY BANK.
Based in Westbury, NY, New York Community Bank is a New York State-chartered savings bank serving customers throughout Metro New York, New Jersey, Ohio, Arizona and Florida. New York Community Bank serves customers through over 200 branches featuring a divisional structure: Queens County Savings Bank, Roslyn Savings Bank, Richmond County Savings Bank, Roosevelt Savings Bank and Atlantic Bank in New York; Garden State Community Bank in New Jersey; Ohio Savings Bank in Ohio; and AmTrust Bank in Florida and Arizona. With a longstanding reputation of strength, stability and service, NYCB is proud to be committed to the communities it serves.
To learn more about the NYCB Family of Banks visit .MyNYCB.com .
Help recruit top talent for NYCB through the employee referral program. All NYCB employees are encouraged to submit referrals. Locate top talent right in the community where you live, work and play. Amazing individuals are all around be sure to let them know how they can become a part of the NYCB family.
NYCB is an equal opportunity employer that prohibits discrimination on the basis of race, color, age, sex, national origin, ethnicity, religion, marital status, disability, military status, veteran status, domestic violence victim status, gender identity or expression, sexual orientation, genetic information and any other classification protected by applicable federal, state, or local law or ordinance.
This policy against discrimination applies to all terms and conditions of employment including, but not limited to: recruitment and selection, promotion and demotion, transfer, training and development, compensation, benefits, leaves of absence and termination. NYCB will consider reasonable accommodations for employees and applicants with disabilities, as well as accommodations that are necessary for an employee to practice their religious faithRead more