Tiffany & Co.

Returning Candidate?

Lead Applications Developer - ETL

Lead Applications Developer - ETL

Req # 
Posted Date 
Information Technology

More information about this job


Tiffany and Company is currently seeking a Lead Applications Developer - ETL in Parsippany, NJ.  The key focus of this position is to deliver Information Technology solutions for new and changing business processes. S/He will assist in the ongoing development and administration of best practices for data movement, data quality, data cleansing and other ETL-related activities to meet business needs while providing technical knowledge of Extract/Transform/Load (ETL) solutions assigned projects.


The Lead Applications Developer will develop new programs and enhancements to existing programs at the mid-level in both size and complexity while providing updates appropriately. Development includes unit testing and may involve configuring of third party or packaged application software and/or custom development.  S/He will participate in or lead design efforts for new, mid-level programs and integrated processes. Design may be custom or involve adaptation of or integration to third party or packaged applications software. Design activities may involve learning package software and evaluating configuration options of the application against business requirements.  The Lead Developer will ensure the quality of developed and delivered IT capabilities.  This role will coordinate/support functional and user testing and ensure proper change control procedures are followed. While evaluating system integration impacts beyond the scope of specified change, the Lead Developer will participate in the planning, creating and coordinating of test plan efforts.


The Lead Applications Developer will provide support as necessary to applications and users within a functional area while proactively looking for tools and methods to improve the operation of the supported area ensuring operational readiness of systems.  This position will participate in requirements definition efforts at the program, process and system levels for projects that are at the mid-level in both size and complexity.  S/He may guide the work of applications developers.



  • Bachelor’s degree or equivalent job related experience
  • 6 to 8 years of ETL experience using Informatica software including Power Center 9.6 and above within a structured systems development life cycle
  • Experience with integration between DB2 on iSeries, Oracle and SQL Server utilizing Web Services and MQ/JMS
  • Skilled in ETL tool suite to design and develop work flows, transformation mappings, and UNIX scripting
  • Strong skills in ETL design and development - understanding the tradeoffs of various design options on multiple platforms using multiple protocols
  • Experience with versioning and team based options in Informatica Power Center, Informatica Power Exchanges (SQL, Oracle, DB2, CDC), and Data Quality tools
  • Strong understanding of Informatica architecture and repositories
  • Experience in Informatica Administration Access and Code Deployment best practices
  • Excellent written and verbal communication skills with the ability collaborate with technical peers
  • Strong problem solving skills with abilities to work independently and in a team environment
  • Ability to convert ETL design into specific development activities


  • Certifications with Informatica and ETL related tools
  • Experience with Informatica BDM strong plus
  • Experience with ETL tools in AWS or Azure
  • Experience in implementing best practices, performance tuning, and optimization techniques
  • Lead ETL development project team working collaboratively with Business Analyst, Data Modeler, and BI Lead
  • Conduct code review with EAS Architecture team to ensure standards and best practices are followed
  • Strong project lead skills with ability to accurately estimate development and testing efforts, identify tasks on the critical path, and asses risk in the overall project
  • Strong knowledge in Microsoft Office, MS Project, and Visio