• Snapboard
  • Activity
  • Reports
  • Campaign
Welcome ,

Chat with the recruiter

...Minimize

Hey I'm Online! Leave me a message.
Let me know if you have any questions.

ETL Developer-Informatica CDI

In Ohio / United States

Save this job

ETL Developer-Informatica CDI   

Click on the below icons to share this job to Linkedin, Twitter!

JOB TITLE:

ETL Developer-Informatica CDI

JOB TYPE:

JOB SKILLS:

JOB LOCATION:

Dayton Ohio / United States

JOB DESCRIPTION:

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.

Position Details

POSTED:

Aug 24, 2021

EMPLOYMENT:

INDUSTRY:

SNAPRECRUIT ID:

S16174658669021050

LOCATION:

Ohio / United States

CITY:

Dayton

Job Origin:

CEIPAL_ORGANIC_FEED

A job sourcing event
In Dallas Fort Worth
Aug 19, 2017 9am-6pm
All job seekers welcome!

ETL Developer-Informatica CDI    Apply

Click on the below icons to share this job to Linkedin, Twitter!

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.


Please wait..!!