Randstad Digital Americas
Informatica Developer
Randstad Digital Americas, King Of Prussia, Pennsylvania, United States, 19406
Base pay range
$70.00/hr - $75.00/hr Job Summary
We are 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 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
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 test upgrades to the data warehouse system. Required Qualifications
Bachelor's degree with 5+ years\' experience in information technology 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 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 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 methodologies such as Agile, Waterfall and Systems Engineering Location: Valley Forge, Pennsylvania Job type: Contract Salary: $70 - $75 per hour Work hours: 8am to 5pm Education: Bachelors This posting is open for thirty (30) days. Equal Opportunity
Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status. At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact HRsupport@randstadusa.com.
#J-18808-Ljbffr
$70.00/hr - $75.00/hr Job Summary
We are 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 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
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 test upgrades to the data warehouse system. Required Qualifications
Bachelor's degree with 5+ years\' experience in information technology 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 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 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 methodologies such as Agile, Waterfall and Systems Engineering Location: Valley Forge, Pennsylvania Job type: Contract Salary: $70 - $75 per hour Work hours: 8am to 5pm Education: Bachelors This posting is open for thirty (30) days. Equal Opportunity
Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status. At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact HRsupport@randstadusa.com.
#J-18808-Ljbffr