ETL - Informatica Architect

ETL - Informatica Architect

23 Dec 2024
Pennsylvania, Philadelphia, 19019 Philadelphia USA

ETL - Informatica Architect

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

Related jobs

  • IT Advisor, Technology Consulting - Digital and Emerging Technologies - Senior Engineer (Integration Architect) (Manager) (Multiple Positions) (1498382), Ernst & Young U.S. LLP, Philadelphia, PA.

  • Java Architect - 117597BR

  • Reference #: R45723 Company Overview At Motorola Solutions, we\'re guided by a shared purpose - helping people be their best in the moments that matter - and we live up to our purpose every day by solving for safer. Because people can only be their best when they not only feel safe, but are safe. We\'re solving for safer by building the best possible technologies across every part of our safety and security ecosystem. That\'s mission-critical communications devices and networks, AI-powered video security & access control and the ability to unite voice, video and data in a single command center view. We\'re solving for safer by connecting public safety agencies and enterprises, enabling the collaboration that\'s critical to connect those in need with those who can help. The work we do here matters.Department OverviewThe Software Enterprise Deployment and Integration team is the team that delivers solutions to the public safety sector. We are committed to providing technology and tools which will allow customers to focus on their mission, and enable them to respond faster with smarter and safer decisions. We deploy and support products such as Computer Aided Dispatch, Records Management Systems, Jail Management Systems and Mobile Data Computing, among other offerings.Job Description This position is remote and candidates can reside anywhere in the US.

  • Reference #: GAFLUS202410839EXTERNALENUS What You Will Do: Gannett Fleming is a global planning, design, and construction management firm with more than 60 offices worldwide. Founded in 1915, Gannett Fleming has fostered a culture of service and innovation with approximately 2,000 diverse and talented professionals. Consistently ranked among the nation\'s most prestigious architectural/engineering firms, we provide architecture and multi-discipline engineering services. We are committed to amaze our clients by providing customized solutions that improve our communities and sustain the world - from award-winning buildings and roadways to vital environmental systems to patented technology. We are currently seeking a Project Architect to join our growing architectural practice in Philadelphia, PA. This is an excellent opportunity for professional growth and to contribute to an expanding portfolio of work, including transit, educational, industrial, and healthcare projects. The candidate will work closely with other architects and engineers, leading multi-discipline teams and supporting project development.

  • Reference #: 2309095 Description EwingCole is a nationally recognized architecture, engineering, interior design and planning firm with offices across the country. Our multi-disciplinary practice is built on the core values of professional excellence, design quality and collaboration. We are seeking a motivated Registered Architect with at least five years of experience to join our Philadelphia office.

  • Are you interested in working in a dynamic environment that offers opportunities for professional growth and new responsibilities? Are you interested in helping clients drive alignment with their business, improve organizational and human resource performance and establish a culture focused on adding business value?

  • Our Mission

Job Details

Jocancy Online Job Portal by jobSearchi.