A fortune 100 client is looking to add an IDMC Developer to their team. This group is focused on data quality mainly in IDQ but will be moving completely into the IDMC within the next few months. As an IDMC Developer you will be pioneering the IDQ Data Quality team as the on-prem to cloud migration is completed. In order to achieve this, resources on this team must be well versed in IDMC and programming languages such as Python or Java as well as come from a strong technical SQL background.
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to
HR@insightglobal.com.
To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy:
https://insightglobal.com/workforce-privacy-policy/ .
5+ Years of experience with ETL, specifically Informatica PowerCenter
At least 1 yr of work experience with ETL Informatica Cloud Services (IICS)
Working knowledge to convert PowerCenter workflows to IICS platform
Prior programming expertise in: Java, Python or PySpark
Expertise in ETL data management areas such as ETL and database architecture and design, data warehouse design and implementation, administration
Extensive experience interacting with business users to analyze their business processes and requirements. Gather and validate those requirements into database and ETL mapping ad designs to ingest and transform the data and help the user visualize the data and key insights through the reports
Develop, maintain, and test all IICS workflows. Conduct the testing process and resolve all defects
Creating the Unit test cases and test queries for testing the IICS code
Candidate should have experience with troubleshooting Informatica session failures and the ability to performance tune mappings.
Candidate must have strong SQL experience and an understanding of dimensional data models to design a robust and secure Data modeling experience to design Data warehouse
Performance tuning experience in IICS, Informatica, and SQL
Strong skills in all phases of the Software Development Life Cycle (SDLC) using Agile methodologies
Bachelor's degree, preferably in Computer Science, Information Technology, Computer Engineering, or related IT experience
Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.