York Solutions, LLC
Informatica and SnapLogic Developer
York Solutions, LLC, Aurora, Colorado, United States, 80012
DescriptionResponsibilities:
Promote and apply ETL development best practices.Participate on (and may lead) projects where analysis of systems or data requires an in-depth evaluation of complex business processes, system processes, and industry standards.Experience with database design, querying, stored procedures, views, joins, and performance tuning.Understand Client Business Objectives and perform technical analysis responding to the needs.Develop, document, and test ETL interfaces.Design & Develop Workflows, Sessions, Mappings in Informatica & Snaplogic.Develop Data Replication/Synchronization Tasks in AWS Cloud (Cloud Application Integrations).Post deployment support and defect resolutions.Evaluate all functional requirements and map documents and perform troubleshooting on all development processes.Collaborate with application groups to prepare effective solutions for all programs.Document all technical specifications and associate project deliverables.Design all test cases to provide support to all systems and perform unit tests.Technical Skills:
Informatica and SnapLogic.Integration experience working with AWS data services such as RedShift, Aurora, S3, etc.SQL & PL-SQL expertise working with Oracle database.Performance tuning of data jobs and pipelines.Minimum 7-10 years of IT Experience working in ETL and data domain.Qualifications:
Experience working with Informatica and SnapLogic toolset.Understand the existing ETL jobs and mappings, sessions, and workflows.Ability to provide sporadic production support if any issues are reported.Troubleshoot ETL jobs and fix the issues based on priorities.Analyze and understand the data at source and target systems to fix the issues within the specified timelines.Tune the Informatica mappings.
#J-18808-Ljbffr
Promote and apply ETL development best practices.Participate on (and may lead) projects where analysis of systems or data requires an in-depth evaluation of complex business processes, system processes, and industry standards.Experience with database design, querying, stored procedures, views, joins, and performance tuning.Understand Client Business Objectives and perform technical analysis responding to the needs.Develop, document, and test ETL interfaces.Design & Develop Workflows, Sessions, Mappings in Informatica & Snaplogic.Develop Data Replication/Synchronization Tasks in AWS Cloud (Cloud Application Integrations).Post deployment support and defect resolutions.Evaluate all functional requirements and map documents and perform troubleshooting on all development processes.Collaborate with application groups to prepare effective solutions for all programs.Document all technical specifications and associate project deliverables.Design all test cases to provide support to all systems and perform unit tests.Technical Skills:
Informatica and SnapLogic.Integration experience working with AWS data services such as RedShift, Aurora, S3, etc.SQL & PL-SQL expertise working with Oracle database.Performance tuning of data jobs and pipelines.Minimum 7-10 years of IT Experience working in ETL and data domain.Qualifications:
Experience working with Informatica and SnapLogic toolset.Understand the existing ETL jobs and mappings, sessions, and workflows.Ability to provide sporadic production support if any issues are reported.Troubleshoot ETL jobs and fix the issues based on priorities.Analyze and understand the data at source and target systems to fix the issues within the specified timelines.Tune the Informatica mappings.
#J-18808-Ljbffr