Vacancy expired!
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