SOC
Informatica Developer - REMOTE Technology Systems
SOC, Phila, Pennsylvania, United States, 19117
REMOTE Informatica Developer
is needed for a
contract
opportunity with SOC's client.
Job Description:
Our Client is seeking an Informatica Developer to design and develop application integrations via Informatica IDMC APIs using Cloud Application Integration (CAI) and Cloud Data Integration (CDI) services.
The candidate should have strong SQL database query knowledge working with applications. The developer should also have thorough experience in developing IDMC REST API interfaces with CDI and CAI. The candidate should also have expertise with testing REST APIs using a software tool such as Bruno or an equivalent. Additionally, the candidate should also have a strong understanding of JSON data formatting.
The developer should have expertise in building ETL/ELT mappings and workflows using CDI. The candidate should have experience loading a Data Warehouse and be knowledgeable with Star Schema and 3rd normal form design. The candidate will contribute throughout the data management lifecycle process areas such as data acquisition, management, manipulation, and implement integrations between SaaS vendors, on-premise applications, and the Enterprise Data Warehouse environment.
Essential duties & responsibilities are: Work with Informatica Tech Lead, IT database administrators, systems administrators, and data warehousing development teams
Support development, migration of data through Informatica IDMC API integrations, procedure development, troubleshooting, system configuration, security administration, and account setup.
Support the lifecycle of physical data models and data maps for data warehouse system.
Aid end users and programmers regarding data warehouse related problems and issues.
Provide technical expertise to end-users who create complex queries and reports.
Coordinate, schedule, and tests upgrades to the data warehouse system.
Required Qualifications :
A minimum of a bachelor's degree coupled with 5+ years' experience in the information technology arena
5+ years' experience in Enterprise Data Warehouse, Business Intelligence, analytic computing, data analysis, and pattern identification with various forms of data.
3+ years' experience in Informatica IICS using REST/JSON/APIs.
2+ years' experience with Oracle RDBMS, PL/SQL & SQL Server platforms
Excellent communication and organizational skills.
Ability to perform data analysis, troubleshoot data integrity issues and strong analytical/problem solving skills.
Desired Qualifications:
Prior experience with Informatica IDMC prebuilt connectors with Salesforce
Experience in documenting and mapping interaction (source-to-target, source-to-ETL mapping) between business processes, information, and data for projects which are of medium to high complexity and moderate to high risk.
Experience with SaaS vendors such as Salesforce, Workday, Unanet
Experience with Snowflake
Familiarity with development methodology such as Agile, Waterfall and Systems Engineering
Employment Pre-requisites
The following requirements must be met to be eligible for this position: successful completion of a background investigation, and drug urinalysis.
SOC, a Day & Zimmermann company, is an Equal Opportunity Employer, EOE AA M/F/Vet/Disability.
#DZFED
#INDSOC Estimated Min Rate : $56.95
Estimated Max Rate : $81.36
is needed for a
contract
opportunity with SOC's client.
Job Description:
Our Client is seeking an Informatica Developer to design and develop application integrations via Informatica IDMC APIs using Cloud Application Integration (CAI) and Cloud Data Integration (CDI) services.
The candidate should have strong SQL database query knowledge working with applications. The developer should also have thorough experience in developing IDMC REST API interfaces with CDI and CAI. The candidate should also have expertise with testing REST APIs using a software tool such as Bruno or an equivalent. Additionally, the candidate should also have a strong understanding of JSON data formatting.
The developer should have expertise in building ETL/ELT mappings and workflows using CDI. The candidate should have experience loading a Data Warehouse and be knowledgeable with Star Schema and 3rd normal form design. The candidate will contribute throughout the data management lifecycle process areas such as data acquisition, management, manipulation, and implement integrations between SaaS vendors, on-premise applications, and the Enterprise Data Warehouse environment.
Essential duties & responsibilities are: Work with Informatica Tech Lead, IT database administrators, systems administrators, and data warehousing development teams
Support development, migration of data through Informatica IDMC API integrations, procedure development, troubleshooting, system configuration, security administration, and account setup.
Support the lifecycle of physical data models and data maps for data warehouse system.
Aid end users and programmers regarding data warehouse related problems and issues.
Provide technical expertise to end-users who create complex queries and reports.
Coordinate, schedule, and tests upgrades to the data warehouse system.
Required Qualifications :
A minimum of a bachelor's degree coupled with 5+ years' experience in the information technology arena
5+ years' experience in Enterprise Data Warehouse, Business Intelligence, analytic computing, data analysis, and pattern identification with various forms of data.
3+ years' experience in Informatica IICS using REST/JSON/APIs.
2+ years' experience with Oracle RDBMS, PL/SQL & SQL Server platforms
Excellent communication and organizational skills.
Ability to perform data analysis, troubleshoot data integrity issues and strong analytical/problem solving skills.
Desired Qualifications:
Prior experience with Informatica IDMC prebuilt connectors with Salesforce
Experience in documenting and mapping interaction (source-to-target, source-to-ETL mapping) between business processes, information, and data for projects which are of medium to high complexity and moderate to high risk.
Experience with SaaS vendors such as Salesforce, Workday, Unanet
Experience with Snowflake
Familiarity with development methodology such as Agile, Waterfall and Systems Engineering
Employment Pre-requisites
The following requirements must be met to be eligible for this position: successful completion of a background investigation, and drug urinalysis.
SOC, a Day & Zimmermann company, is an Equal Opportunity Employer, EOE AA M/F/Vet/Disability.
#DZFED
#INDSOC Estimated Min Rate : $56.95
Estimated Max Rate : $81.36