Informatica ETL Developer

$100,000 - $140,000

Full Time

  • Work from home
  • No Travel Required

Skills

InformaticaPowercenterSQLPL/SQLAzureAzure DataBricksSnowflakeSnowSQLRedshiftData Lake

Job Description

Please note I have direct access to the Hiring Data Manager on this position. Compensation: Base + 10% Bonus

This is an outstanding opportunity for an Informatica ETL Developer to advance their career and skillset to become exposed to AWS, Azure DataBricks and Snowflake Cloud Data Platforms.

We are a leading Global Financial Services Company in our niche and are looking for an Informatica ETL Developer. We have been in business for 80+ years, are publicly traded, with 2+K employees, recognize $2.8B in revenue (17% increase over Prior Year), $964 million in profit (74+% increase over Prior Year), management of $430+ Billion in Assets (10% increase over Prior Year) and are an active philanthropic institution.

The Informatica ETL Developer will join an elite Data Team responsible that works with very large complex mission critical data sets. The Informatica ETL Developer will be responsible for:

  • Developing new and enhancing existing Informatica ETL solutions utilizing Powercenter v10.x for a mission critical Data Warehouse environment. The Informatica ETL Developer will build brand new high volume reliable, efficient, and maintainable Informatica ETL solutions to handle extremely large data sets of mission critical financial data. The company is in the process of upgrading to Informatica Enterprise Cloud Data Management.
  • PL/SQL Development
  • Developing job schedules using Autosys or comparable job scheduler (control-M or Tivoli)
  • Optimizing ETL processes, programs and functions to improve data quality, data security, data integrity and data consistency

The company is running Informatica PowerCenter v10.5 for ETL. Data is extracted from On Prem Oracle and SQL Server databases, SAP ERP systems and internal and external AWS and Azure Cloud environments. Data is being loaded into Azure Databricks and Snowflake Datawarehouse. PowerBI is utilized for visualization.

The Informatica ETL Developer reports to the Data Manager

Requirements:

  • Must have 4-5+ years experience with Informatica ETL Development with Powercenter
  • PL/SQL Development
  • Experience with any of the following are only a Plus; NOT mandatory: Informatica Enterprise Cloud Data Management, Autosys, Python or Unix Scripting, SQL, AWS Redshift, Azure DataBricks, Snowflake, SnowSQL, Data Lakes, Matillion ETL, PowerBI. Again, these are only a plus; NOT mandatory

Benefits

Company offers a comprehensive benefits package including: 6% matching 401K, 3 Weeks PTO, Employee Stock Purchase Plan/ESPP, HMO/PPO/HSA medical, dental, and vision coverage; generous holiday policies, paid company holidays, paid volunteer time, flexible spending plans, tuition reimbursement, maternal/paternal/family leave, complimentary Headspace subscription, ClassPass fitness membership and a casual work environment.