**Business Title:** Informatica Cloud Integration Manager
**Requisition Number:** 85536 - 66
**Function:** Audit
**Area of Interest:**
**State:** NY
**City:** New York
**Description:**
Known for being a great place to work and build a career, KPMG provides audit, tax and advisory services for organizations in today's most important industries. Our growth is driven by delivering real results for our clients. It's also enabled by our culture, which encourages individual development, embraces an inclusive environment, rewards innovative excellence and supports our communities. With qualities like those, it's no wonder we're consistently ranked among the best companies to work for by Fortune Magazine, Consulting Magazine, Working Mother Magazine, Diversity Inc. and others. If you're as passionate about your future as we are, join our team.
KPMG is currently seeking an Informatica Cloud Integration Manager to join our Audit Technology organization.
Responsibilities:
+ Build/configure ETL tools for successful data extraction and transformation from multiple sources hosted On-prem/Cloud; design, code, verify, test, document, amend and refactor moderately complex programs/scripts; Apply agreed standards and tools, to achieve a well-engineered result; review own work
+ Apply data analysis, design, modelling, and quality assurance techniques, based upon a detailed understanding of business processes, to establish, modify or maintain data structures and associated components
+ Engage in the design, development and implementation of fixes and enhancements to existing modules or new modules; partake in development of high-level technical specifications, solution design; build and implement of fixes and enhancements to existing modules or new modules
+ Support in the development of operational and/or engagement team related; routines in the chosen technology; Lead development and testing of sub-modules for new product releases; working with the ERP functional and testing teams
+ Assist clients with data extraction remotely with medium to high complexity and medium to large data size; support Audit engagement teams in data extraction process by coordinating with the Client's IT teams and other technical leads; work with engagement teams to interpret the results and provide meaningful audit insights from the reports
+ Debug, optimize and performance tune and resolve issues, if any, with limited guidance, when processing large data sets and propose possible solutions; maintain the accurate and up to date project status for self and any assigned team member; prepare and review required documents supporting the engagement with utmost attention to details
Qualifications:
+ Minimum five years of experience working on Informatica Intelligent cloud services (IICS), preferably in a Big Four or enterprise environment
+ Bachelor's degree in Computer Science or Information Technology from an accredited college/university; MBA or MCA are preferred; Informatica Cloud (IICS) certification is a plus
+ Must have experience in IICS client components like Data Integration, Mass ingestion, Administrator and monitor services; good experience and knowledge in transformations like source qualifier, Joiners/Unions, Aggregator, expressions and lookups; strong knowledge around IICS features like error handling, In/out parameters
+ Prior experience in building high level technical specifications, solution design, build and test - Mappings, task flows, MCT and application requirements in IICS; involvement in at least one end to end ETIL development project cycle is preferred; experienced in advanced concepts like Partitioning, optimization, and performance tuning; hands on experience in integrating multiple source systems (ERPs) hosted on both Cloud and On-Prems using IICS services
+ Working knowledge on how to configure the properties/connections at systems, environment, and secure agent level for IICS Objects is preferred; previous experience in writing SQL queries and/or database management skills in Oracle/SQL server; data warehousing working knowledge is desired
+ IICS with Azure cloud computing experience is preferred; working experience on cloud technologies/platforms (Azure services); experience working with connectors, extracting data from ERPs such as SAP, Oracle, PeopleSoft, JD Edwards, NetSuite, Dynamic and Workday; proven technical expertise in development of SSIS packages and/or Alteryx (Alteryx Designer Core certified); proficient in Database architecture and data modeling; data management and data analysis skills; experience working in Waterfall as well as Agile methodologies; ability to travel up to 25%
+ Applicants must be currently authorized to work in the United States without the need for visa sponsorship now or in the future
KPMG LLP (the U.S. member firm of KPMG International) offers a comprehensive compensation and benefits package. KPMG is an affirmative action-equal opportunity employer. KPMG complies with all applicable federal, state and local laws regarding recruitment and hiring. All qualified applicants are considered for employment without regard to race, color, religion, age, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other category protected by applicable federal, state or local laws. The attached link (https://assets.kpmg.com/content/dam/kpmg/us/pdf/2018/09/eeo.pdf) contains further information regarding the firm's compliance with federal, state and local recruitment and hiring laws. No phone calls or agencies please.
KPMG does not currently require partners or employees to be fully vaccinated or test negative for COVID-19 in order to go to KPMG offices, client sites or KPMG events, except when mandated by federal, state or local law. In some circumstances, clients also may require proof of vaccination or testing (e.g., to go to the client site).
**GL:** 4
**GF:** 15312
