Apex Systems
Overview
Apex Systems 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 will ideally be located in PA, but can be fully remote.
Base pay range $70.00/hr - $75.00/hr
Job#: 2090760
Summary The candidate should have strong SQL database query knowledge working with applications and thorough experience in developing IDMC REST API interfaces with CDI and CAI. The candidate should have expertise with testing REST APIs using a software tool such as Bruno or an equivalent, and a strong understanding of JSON data formatting. The developer should have expertise in building ETL/ELT mappings and workflows using CDI, experience loading a Data Warehouse, and knowledge of Star Schema and 3rd normal form design. The role involves contributing throughout the data management lifecycle, including data acquisition, management, manipulation, and implementing integrations between SaaS vendors, on-premise applications, and the Enterprise Data Warehouse environment.
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 the 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
Minimum of a Bachelor’s degree with 5+ years of experience in information technology
5+ years of experience in Enterprise Data Warehouse, Business Intelligence, analytic computing, data analysis, and pattern identification
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 in documenting and mapping interaction (source-to-target, source-to-ETL mapping) for medium to high complexity projects
Experience with SaaS vendors such as Salesforce, Workday, Unanet
Experience with Snowflake
Familiarity with Agile, Waterfall, and Systems Engineering methodologies
Equal Employment Opportunity Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex, age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, marital status, disability, veteran status, political affiliation, union membership, or any other characteristic protected by law. Qualified applicants with criminal histories will be considered in accordance with applicable law. For accommodations in the application process, contact our Employee Services Department.
Company information Apex Systems is part of the Commercial Segment of ASGN Incorporated. NYSE: ASGN. Address: 4400 Cox Road, Suite 200, Glen Allen, Virginia 23060. Apex provides a range of benefits and resources including health coverage, 401K, ESPP, HSA, EAP, and professional development opportunities. See the Welcome Packet for full details.
#J-18808-Ljbffr
Base pay range $70.00/hr - $75.00/hr
Job#: 2090760
Summary The candidate should have strong SQL database query knowledge working with applications and thorough experience in developing IDMC REST API interfaces with CDI and CAI. The candidate should have expertise with testing REST APIs using a software tool such as Bruno or an equivalent, and a strong understanding of JSON data formatting. The developer should have expertise in building ETL/ELT mappings and workflows using CDI, experience loading a Data Warehouse, and knowledge of Star Schema and 3rd normal form design. The role involves contributing throughout the data management lifecycle, including data acquisition, management, manipulation, and implementing integrations between SaaS vendors, on-premise applications, and the Enterprise Data Warehouse environment.
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 the 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
Minimum of a Bachelor’s degree with 5+ years of experience in information technology
5+ years of experience in Enterprise Data Warehouse, Business Intelligence, analytic computing, data analysis, and pattern identification
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 in documenting and mapping interaction (source-to-target, source-to-ETL mapping) for medium to high complexity projects
Experience with SaaS vendors such as Salesforce, Workday, Unanet
Experience with Snowflake
Familiarity with Agile, Waterfall, and Systems Engineering methodologies
Equal Employment Opportunity Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex, age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, marital status, disability, veteran status, political affiliation, union membership, or any other characteristic protected by law. Qualified applicants with criminal histories will be considered in accordance with applicable law. For accommodations in the application process, contact our Employee Services Department.
Company information Apex Systems is part of the Commercial Segment of ASGN Incorporated. NYSE: ASGN. Address: 4400 Cox Road, Suite 200, Glen Allen, Virginia 23060. Apex provides a range of benefits and resources including health coverage, 401K, ESPP, HSA, EAP, and professional development opportunities. See the Welcome Packet for full details.
#J-18808-Ljbffr