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 modelling 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 – Be available on-call outside of regular business hours to assist Sev 1 incidents
Knowledge/Skills Required:
 
  • 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
  • Concepts on K8, Databricks, PySpark 
  • 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
  • Excellent Problem-solving capabilities
  • Must have positive attitude and willingness to help team
 
             

Similar Jobs you may be interested in ..