IT Development Senior Analyst – Informatica REMOTE
UL Advanced Furniture Testing
Milltown, NJ
At UL, we know why we come to work.
Thousands of us around the world wake up every day with a common purpose: to make the world a safer, more secure and sustainable place. Science is in our DNA; we are endlessly curious and passionate about seeking and speaking the truth. We take delight in knowing that our work makes a meaningful contribution to society, and we are proud that our culture is centered on integrity, collaboration, inclusion and excellence. UL stands at the forefront of technological advancement, and we are continually challenged to find new ways to foster innovation and positive change. Satisfying? Yes. Exciting? Absolutely!
What you’ll learn & achieve:
- Work with the Enterprise Data Governance team and with the various analytics teams to build the Enterprise business Glossary for various data domains using Informatica CDGC tool.
- Create Business Glossary resources, associate business terms to the assets in collaboration with Business Data Stewards & SME's.
- Build Approval Workflows, create roles and permissions within CDGC platform.
- Collaborate with various business and technical teams to gather requirements around data quality rules and design and develop these rules with IICS/IDQ.
- Develop mappings, rules, transformations, mapplets, workflow, schedulers using Informatica IDQ 10.x.
- Create & Run data quality specific ETL jobs (address standardization and validation, email cleanups, name cleanup, parsing, etc.) utilizing IDQ and IICS.
- Develop and configure data lineage, custom resources, custom data lineage, relationships, data domains, data domain groups and composite data domains.
- Performing statistical tests, profiling on large datasets to determine data quality and integrity.
#LI- Remote
What makes you a great fit:
- Bachelor’s degree in an analytic- or quantitative-focused field (e.g. statistics, computer science, engineering, information management), or similar.
- At least 5 years of experience in Informatica Data Quality, Informatica Intelligent Cloud Services (Data Quality, Data Cataloging and Data Governance).
- Experience in data profiling and data quality rules development using Informatica Data Quality.
- Hands-on experience in building and consuming webservices from IDQ.
- Hand-on experience in Loading MDM Landing and Staging tables.
- Experience working with Informatica MDM platform, AddressDoctor.
- Ability to develop, and implement functions, stored procedures, and ETL jobs using PL/SQL - Strong RDBMS SQL and troubleshooting skills.
- Good knowledge on writing shell-scripts to invoke mappings or workflows.
- Highly organized. Ability to coordinate effectively across cross-functional teams.
- Excellent communication skills and attention to detail.
- Will provide H1B Sponsorship for this role.
What you’ll experience working at UL:
Mission: For UL, corporate and social responsibility isn’t new. Making the world a safer, more secure and sustainable place has been our business model for the last 125 years and is deeply engrained in everything we do.
People: Ask any UL employee what they love most about working here, and you’ll almost always hear, “the people.” Going beyond what is possible is the standard at UL. We’re able to deliver the best because we employ the best.
Interesting work: Every day is different for us here as we eagerly anticipate the next innovation that our customers’ create. We’re inspired to take on the challenge that will transform how people live, work and play. And as a global company, in many roles, you will get international experience working with colleagues around the world.
Grow & achieve: We learn, work and grow together with targeted development, reward and recognition programs as well as our very own UL University that offers extensive training programs for employees at all stages, including a technical training track for applicable roles.
Total Rewards: The salary range for this position is $100,000-$120,000 of the salary range and is based upon years of experience that is commensurate with the level of the position.
All employees at UL Solutions are eligible for annual bonus compensation. The target for this position is 10% of the base salary offered. Employees are eligible for health benefits such as medical, dental and vision; wellness benefits such as mental & financial health; and retirement savings (401K) commensurate with the standard rewards offered in each individual location or country, for the relevant position level.
We also provide employees with paid time off including vacation (15 days), holiday including floating holidays (12 days) and sick time off (72 hours).
Internal applicants with questions related to the Total Rewards for this position should submit a ticket via askHR for more insights.
Learn More:
Working at UL is an exciting journey that twists and turns daily. We thrive in the twists and revel in the turns. This is our every day. This is our normal.
Curious? To learn more about us and the work we do, visit UL.com.