ETL - Informatica Architect

Cliecon Solutions Inc, (head quartered in central NJ ) is one of the fastest growing and a leading consulting and management firm with 12 years of experience in Staff Augmentation. We handle complete recruiting cycle for fortune 500 clients, major implementing partners and tier -1 vendors. We specialized in recruiting for Application development, Big data, Databases, Infrastructure, Cloud, Mobile and ERP based solutions projects.Position: ETL - Informatica Architect Location: Philadelphia PA remote until Covid restrictions are removed Duration: Permanent Job Description The primary function is providing support and solutions for an Informatica based enterprise middleware system during failure and help maintaining SLA Customisation and support of interfaces with SFDC applications Support interfaces Einstein analytics and other Comcast Partner systems Develop the ETL code from requirements and mapping the fields in source systems Responsible for major project enhancements driven by business needs involves changes at various steps of application Ensure the complete and consistent data flow from source to target. Maintain the integrity of data between the source system by having reconciliation enabled in the code and audit scripts Tune the existing scripts for performance improvement Provide quick workarounds and solutions for the problems encountered in production environment Work with data modeling team to ensure data standards are met Mapping the data from SFDC source system Provide long term solutions for issues occurring frequently to avoid risks due to manual intervention Role must take a logical approach that enables the team to systematically organize and consolidate scripts for workaround and production support Flexibility on work schedule Qualifications 10 + years of experience in Data Warehousing projects 3+ years of experience with Informatica Power Center & Informatica Cloud (IICS). Hand on experience in AWS services such as Lambda, Couldwatch, Glue; experience with Redshift is a plus Informatica Power Centre and Power Mart SFDC and Teradata V2R12 and V2R13 SQL/PL SQL knowledge Excellent Unix Knowledge Shell Scripting Good knowledge in job schedulers, preferably UC4