Senior Informatica Architect

Senior Informatica Architect for Randstad Digital, LLC. Multiple openings. Headquarters: Woburn, MA. Develop, design, and architect data warehousing solutions, pipelines, mappings, sessions, workflows, queries, schema and data modeling, reusable frameworks, scripts. Review performance, scalability, stability, data processing, data profiling, data quality, source system structures, data transformation logic, business requirements, auditing and optimization techniques, code, deployment, parameterization, dynamic configurations, components, data from heterogeneous systems, centralized data platforms, data enrichments, rules, metrics, exception handling logic, QA, partitioning, data lineage tracking, indexing strategies, security, compliance, jobs. Confer with business analysts and stakeholders, translate technical specifications, troubleshoot, and perform unit, integration, UAT testing. Document technical designs and specifications, automate tasks, participate in sprints, estimate tasks. Identify problems, analyze client/user needs, recommend modifications, and formulate validation plans. Use ETL, Informatica PowerCenter, Informatica CDI, IICS, SQL, Oracle, SQL Server, APIs, CDC, PL/SQL, SCD, Autosys, Control-M, Unix, Linux, Python, Perl, Shell, Agile, Jira, Star, Snowflake, Toad for DataPoint, Teradata. 40 hrs/wk. Must have Master's degree or foreign equivalent in Computer Science, Computer Engineering, Electronic Engineering, or a related field, and 2 years experience in the proffered position or as a Developer, Software Engineer, Technology Analyst, Programmer Analyst, or related occupation. In the alternative, will accept a Bachelor's degree or foreign equivalent in the specified fields plus 5 years of progressive, post-baccalaureate experience in the specified occupations. Must have 2 years of experience working with data; developing pipelines, mappings, queries, data modeling, scripts; reviewing requirements, auditing, optimization techniques, code, components, rules, jobs; performing troubleshooting, testing, automation; using ETL, Informatica, SQL, Unix, Python, Perl, Agile, Teradata. Must be willing to travel/relocate to unanticipated locations throughout the US on short notice for extended periods of time. Telecommuting permitted. $184,996 to $185,000 /yr. Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad offers a comprehensive benefits package, including: medical, prescription, dental, vision, AD&D, and life insurance offerings, short-term disability, and a 401K plan (all benefits are based on eligibility). To apply, email resume to rd-apply.rits@randstaddigital.com. Reference job title Senior Informatica Architect and Ref ID#428474 in the subject line. This position is eligible for incentives pursuant to Randstad Digital, LLC Employee Referral Program.