IT Data Warehouse Dev Sr Location: Cleveland, OH

IT Data Warehouse Dev Sr Location: Cleveland, OH

  • Posted on : 09-08-2023
  • Job Type : Full Time only
  • Salary : 100,000 - 200,000

Job Description:

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.

  • Latest Jobs
    Featured Jobs
    Trending Jobs
    Share Job: