Who we are: Cloud and Things is building a platform to allow you to build your career! Our goal is to solve problems and deliver results for our clients. At Cloud and Things, you can be a part of the transformation of the public sector’s IT environment. Our team is on the forefront of helping to solve the government's most complex IT challenges. If you are seeking a role that offers you the opportunity to work on rewarding projects, consider a career with Cloud and Things. Position: Informatica Data Quality Developer Location: Albany, NY/ Remote Duration: 12 Months Duties:
Experience in IDQ development around data profiling, cleansing, parsing, standardization, verification, matching and data quality exception monitoring and handling
Designing, developing, testing, deploying, and documenting a project's data quality procedures and its outputs.
Profile the project source data, define or confirm the definition of the metadata, cleanse and accurately check the project data, check for duplicate or redundant records, and provide information on how to proceed with backend ETL processes.
Experiences with creating SQL procedures, views, subqueries, multiple SQL joins, unions to perform various data extraction tasks and developing PL/SQL triggers for updating or inserting new records
Required Skills:
Minimum 4-6 years of hands-on experience with Informatica Data Quality (IDQ) toolset (Version 10.x preferred)
Working experience in Informatica PowerCenter
Strong SQL skills with the ability to tune and optimize complex queries
Experience in Tableau will be added advantage
Education:
Bachelor's Degree (BS/BA) or equivalent
Cloud and Things 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, sex, sexual orientation, gender identity, national origin, age, disability, protected veteran status, or any other category protected by applicable federal, state, or local laws.