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 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
location: Valley Forge, Pennsylvania
job type: Contract
salary: $70 - 75 per hour
work hours: 8am to 5pm
education: Bachelors
responsibilities:
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.
qualifications:
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
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.
Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including: medical, prescription, dental, vision, AD&D, and life insurance offerings, short-term disability, and a 401K plan (all benefits are based on eligibility).
This posting is open for thirty (30) days.