Sr. Application Systems Developer (ETL)

Columbia University – Manhattanville, NY

  • Requisition no: 499914
  • Work type: Full Time
  • Location: Manhattanville
  • School/Department: Columbia University Information Technology
  • Grade: Grade 13
  • Categories: Information Technology
  • Reporting to the Associate Director, Data Integration, the Sr. Application Systems Developer will be responsible for technical design and implementation of lifecycle activities associated with the extract, transform and loading (ETL) of database tables with automated utilities, ETL tools (i.e. Business Objects Data Services BODS) and SQL programs.

    Please note that this is a project funded finite role with a duration of 2 years.


  • Deploys code across Dev, QA and Production environments using central repositories
  • Develops/Maintains/Supports new and existing data flows from multiple source systems
  • Develops/Maintains/Supports business rules and process around data cleansing, consolidation and validation, etc.
  • Troubleshoots/debugs ETL and SQL query issues and provides solutions
  • Develop views and ad hoc/scheduled SQL queries to analyze data, produce exception reports, validate data and as required by the functional team
  • Creates ETL solutions using data warehouse design best practices, such as Star-Schema design and Change Data Capture, etc.
  • Assists in the design and creation of logical and physical data models for reporting databases
  • Produces data flow diagrams and other documentations and diagrams as needed
  • Works with Director and Project Manager to develop and follow project plans and resource estimates. Works with Reporting team and data integration team to define and develop user data requirements
  • Integrates, collaborates and leads projects, working hand in hand with Business Analysts, Data Warehouse team and DBA and the infrastructure team
  • Works with functional team to assist in the preparation of source to target data maps. Work with project team and collaborate with both reporting application developers and OLTP technical leads.
  • Assists in gathering/reviewing business requirements, partnering with business analysts, providing feedback on functional request feasibility and scope
  • All other duties as assigned.

  • Bachelor s degree and/or its equivalent required. Advanced degree desirable.
  • Minimum 4-6 years related experience.

  • 4+ years working in SAP Business Objects Data Services (BODS) or, one of the leading enterprise ETL tools, such as Informatica PowerCenter, Microsoft SSIS, IBM InfoSphere DataStage, Pentaho or Talend for designing and development ETL solutions.
  • SAP Business Objects Data Services (BODS) proficiency needs to include:
  • Audit Rules
  • Built-in Functions
  • Interactive Debugger
  • Transforms, such as Query, Key Generation, Table Comparison, History Preserving and Validation
  • Develop ETL logic utilizing various features available in the Data Integrator component, including:
  • Expert in SQL and stored procedure for development, debugging and implementing complex transformation
  • Needs to be a self-starter and able to lead ETL projects or ETL activities within a project
  • Familiarity with Systems Development Life Cycle (SDLC) and software development best practices
  • Development experience with two ore more of the following: SQL, PL/SQL, TSQL, PERL, SQL Server, Oracle
  • Experience in the implementation of Web applications in a Unix/Linux environment, including knowledge of scripting languages and standard tools and utilities
  • Demonstrated ability to work in a fast-paced, deadline driven environment
  • Demonstrated excellence in a variety of competencies including teamwork/collaboration, analytical thinking, communication and influencing skills, and technical expertise
  • Experience collaborating with DevOps, Security, Network, Systems and other IT teams
  • Excellent written and verbal communication skills
  • Ability to work with changing priorities and with multiple projects
  • Ability to be precise and attentive to detail is essential
  • Ability to work with minimal supervision
  • Ability to work weekend and off-hour work

  • Experience in Higher Education a plus
  • Knowledge in Perl, C or Python to create ETL solutions
  • Knowledge in SAP Business Objects Web Intelligence and Crystal Reports
  • Knowledge in emerging technologies, such as Big Data, Cloud computing (AWS or Azure)
  • Experience in agile software development methodology
  • Experience with Django framework
  • Utilizes SDLC, Change Management best practices:
  • Exposure to ITIL methodology
  • Experience in best practices established in application development auditing standards
  • Experience in Version Control tools, such as GIT or a similar enterprise version control software
  • Exposure to Process Control Tools such as Service Now, Jira, or a similar enterprise process control software
  • Applications open: May 20 2019 Eastern Daylight Time
    Applications close:

    Columbia University - 27 days ago - save job - original job

    All Jobs in Manhattanville, NY

    • Technology Engineer Sr

      PNC Financial Services Group New York, NY

      View Job
    • Technology Engineer Sr

      PNC Financial Services Group New York, NY

      View Job
    • Technology Engineer Sr

      PNC Financial Services Group West Paterson, NJ

      View Job
    • Technology Engineer Sr

      PNC Financial Services Group East Orange, NJ

      View Job
    • Sr Business Analyst

      S&P Global Ratings New York, NY

      View Job
    • Sr Business Analyst

      S&P Global New York, NY

      View Job
    • Senior Salesforce Developer

      Conduent Secaucus, NJ

      View Job
    • Sr. Manager, IT Business Analysis

      ConnectiveRx Hanover, NJ

      View Job
    • Sr. Database Administrator

      PointsBet Jersey City, NJ

      View Job
    • Senior Data Engineer

      Northwestern Mutual Life Insurance Company New York, NY

      View Job
    • Sr. Data Engineer_____ Full time ($145K + Benefits)____ Jersey city, N

      Maven Workforce Jersey City, NJ

      View Job

    Featured Articles

    Top Computer Science Universities in USA | Computer Science Careers

    22 March 2018

    Careers in Computer Science - Why study computer science in USA? Computer Science is one of the most popular and lucrative fields of study among international students is today’s era and is also one of the best-funded and most internationally renowned fie

    read more..

    Quality Assurance Training And Placement For USA Candidates

    25 February 2019

    ❯  What is QA Training? QA stands for Quality Assurance. It includes activities that ensure the implementation of procedures, processes, and standards in terms to verification of developed software. It focuses on procedures rather than conducting actual testing on the system. It perform

    read more..

    Tips and Importance of effective communication skills for International Students

    30 May 2019

    Importance of effective communication skills for international student and in fact for everyone should be very high. The average number of international students studying in different parts of the world are mostly aware of the English language. Though there are a majority of international students w

    read more..

    Everything you need to know about Day 1 CPT Universities in USA

    27 September 2018

    Day 1 CPT Universities is probably what you are searching for as a freshman. However, before enrolling to Day 1 CPT Program here are some necessary things that you simply need to know. CPT or Curricular Practical Training allows F1

    read more..

    Thanks For Your Feedback

    Attach A Resume First