Informatica ETL Developer Job Listing at Teach For America in New York, NY (Job ID a0xd0000000OAtqAAG)

Teach For America

Teach For America

Location: New York, NY
Application deadline: None
Type: Not specified
Career Level: Associate
Salary Range: Not specified
Number of Jobs: 1
Relocation Available: No
Show all jobs for Teach For America
Nonprofit, Technology

Information Technology is actively searching for an experienced Informatica ETL Developer who will leverage technology to develop data integration solutions within the organization.  Candidates should have extensive application lifecycle experience developing, coding, testing, and debugging new, or enhancements to existing software and enterprise applications.


·                     Complete integration development assignments for the ETL Team

·                     Perform technical problem assessment, resolution and documentation

·                     Build Informatica mappings, transformations and Data Quality rules

·                     Participate in requirements gathering and design for ongoing development projects

·                     Recommend and implement improvements to the ETL Development process

·                     Support production code for issues, failures and maintenance



  • At least 7 years experience working in a similar capacity with proven database  design and development experience
  • SQL Server 2005 and 2008/2012, development experience
  • Must have a record of creating and maintaining large, scalable databases supporting both custom built and third party applications
  • Must have intermediate experience developing ETL/Integrations  using Informatica
  • Proven capabilities providing database base programming support and troubleshooting to multiple IT projects
  • Expert level SQL programming, T-SQL, triggers and store procedure capabilities
  • Database administration experience including import, export, data transformation, backup and restore is a plus
  • Must be detail-oriented, extremely organized and have exceptional writing and communicating skills

Knowledge, Skills and Abilities                                                                                                                                                     
  • A minimum of seven  years of Development DBA experience using SQL Server

·         Experience working in an Agile environment (preferably XP), working in short iterations and using test driven development.

  • Experience in iterative system design, development and implementation, a plus
  • Experience working with open source solutions
  • Experience programming in Java a plus
  • Experience in Business Objects universe design a plus
  • Must be detail-oriented, extremely organized, and will have exceptional writing and communication skills
  • Demonstrated a record of developing successful applications that are highly integrated and reliable
  • Ability to operate effectively, and with a sense of possibility, in a fast-paced, deadline-driven environment



·                     Exposure to all phases of data integration and/or warehousing life cycle including planning, analysis, design, development, implementation and maintenance of data and meta-data

·                     Strong experience in designing and developing of mappings, transformations, sessions and workflows in PowerCenter

·                     Good exposure to working with the multiple file formats, relational database systems and different application platforms

·                     Good exposure in Data Analysis, Data Profiling, Data Management, Troubleshooting, Reverse Engineering and Performance tuning in various level of  the ETL Process

·                     Strong experience in performance tuning for Informatica processing

·                     Strong experience in SQL and its stored-procedure derivatives (e.g. PL/SQL, etc.)

·                     Proficiency in relational database design and database administration

·                     Proficiency with Linux/Unix environments, file manipulations and shell scripting

·                     Experience working with Informatica 9.x a plus

·                     Must be self-directed and motivated

·                     Must be able manage individual workload and deliver to agreed upon project milestones

·                     2- 3 years Informatica Experience

·                     Exceptional mapping and workflow development skills, administration and configuration and deployment and code management experience

·                     At least 8 years overall technology experience

·                     Knowledge of IT concepts, strategies, and methodologies, architectures and technical standards


Academic Qualifications                                                                                                                      

At least a four-year degree in Computer Science, MIS or a related field

Apply on Company Website