Senior ETL Developer




Morristown, New Jersey

Employment Type



WhiteCap Search is seeking an experienced Senior ETL Developer with 5 to 10 years of IT experience, specializing in the complete Software Development Life Cycle (SDLC) within the Data Warehousing & Business Intelligence (DW&BI) domain.

Compensation : $56 - $72
Job ID : 22983

Job Function:

  • ETL Implementation: Lead end-to-end ETL implementation in projects involving ODS, Data Warehousing, and DataMart, leveraging Extraction, Transformation, and Loading techniques to ensure data accuracy and integrity.
  • Informatica Expertise: Utilize your in-depth experience with Informatica Powercenter and Informatica Cloud (IICS) to design, develop, test, and optimize ETL processes.
  • Data Validation and Comparison: Leverage Informatica DVO for data validation and comparison tasks, ensuring data quality and consistency across multiple sources.
  • Data Integration Technologies: Utilize Informatica BDM, Informatica MDM, and Informatica IDQ to streamline data integration processes and enhance data quality.
  • Leverage your proficiency in databases including Oracle, MS-SQL Server, DB2, NETEZZA, PostgreSQL, and MSQL, along with specialized platforms like Snowflake.

Job Requirements:

  • Bachelor's degree in Information Technology or related field from a recognized university.
  • 5 to 10 years of experience with a strong focus on ETL implementation and data integration.
  • Extensive expertise in Informatica Powercenter and Informatica Cloud (IICS).
  • Strong knowledge of database technologies including Oracle, MS-SQL Server, DB2, NETEZZA, PostgreSQL, MSQL, and Snowflakes.
  • Proficiency in SQL, PL/SQL, Python, Node.js, and UNIX shell scripting.
  • Experience with AWS services such as DynamoDB, S3, and Lambda.


Disclosure: The hourly rates and/or salaries listed may or may not reflect total compensation packages including bonus and fringe benefits, etc., nor are the advertisement(s) posted a guarantee of a certain compensation package for a position or bona fide offer of employment. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, or protected veteran status and will not be discriminated against on the basis of disability.