ETL Developer-Informatica CDI Apply
Develop and support Informatica ETL jobs within a complex Enterprise Data Warehouse environment in support of financial users and analytical applications. Our DW environment includes 1TB SQL Server 2017-2019 plus numerous environments to integrate (SQL Server 2008r2-2019, Oracle, AWS PostgreSQL, Salesforce, XML, Excel, Azure and Google Big Data).
Ability to create Informatica integration task flows based upon user requirements and data model
Advanced experience with T-SQL, PowerShell, JSON, XMLA, REST API calls, etc. to define methods and best practices for data extraction, interaction, and CRUD operations. NOTE: This position won't be writing Rest APIs. CRUD is accomplished using change data capture on the data source and applying the proper changes to the integrated target environment.
Maintain, support and migrate legacy SSIS jobs to Informatica.
Package deployments and migrate code between Development, Quality Assurance (QA), and Production environments.
Test automation, troubleshooting ETL job functionality, validating data, as well as create test data and table structures through use of SQL.
Configuration of the ETL environments to meet user, security, audit requirements.
Develop a complete set of ETL documentation describing the current jobs, configuration, schedules, etc. of the system.
Performance tune SQL statements executed by ETL code as required for tuning of Informatica, including monitoring, standards, tuning metrics, and alert thresholds.
Perform source system analysis as required.
On-call DBA rotation to assist with after-hours database issues and related deployments.
Assist with upgrades and migrations with SQL Server and related software tools.
Requirements:
Minimum of 10 years ETL and Data Warehousing experience.
Advanced ETL experience extracting data from databases, flat files, Excel, web applications, etc.
Significant database tuning experience.
Ability to lead testing initiatives for releases as needed.
Experience in supporting multiple products/projects simultaneously.
Proven ability to work with customers, managers and executives of varying levels of technical expertise while always maintaining a professional attitude.
Complex problem solving and critical thinking skills.
Excellent verbal and written communications including ability to translate business information into technical design specifications.
Self-motivated, punctual, dependable with ability to prioritize work and succeed despite varying degrees of requirements in a remote work environment.
