MANDATORY SKILL - ADVANCE SQL AND INFORMATICA ETL

Produce system requirements and in alignment with standards and frameworks. Work in close partnership with various partners and stakeholders to elicit, analyze, document, communicate and manage functional and non-functional requirements

EXPERIENCE AND / OR EDUCATION

• 7+ years relevant experience
• Informatica Knowledge – Mandatory (Should be able to navigate the ETL Tool for Mappings)
• Advanced SQL knowledge - Mandatory
• Data Analysis, Root Cause Analysis, Impact Analysis Experience – Mandatory
• Hands on experience in BSA artifacts: Business Requirements Document (BRD), Functional Requirements Document (FRD), System Requirements Specification (SRS) , Source to Target Mappings Document (STTM’s)- Mandatory
• Strong knowledge on data mapping, lineage, data validation etc. – Mandatory
• Have experience in Reverse Engineering - Mandatory
• Preference given to candidates who have experience working in Agile
• Azure Databricks and Azure Data factory Knowledge – Good to have
• Azure experience/certification – Preferable (Not Mandatory)
• ETL concepts and Cloud technology — Good to have

Specific Mandatory Requirements for this Role :-

• Candidates should have very good hands-on Advanced SQL knowledge,
• Should be able to navigate through ETL and Informatica Tool (like Informatica PowerCenter).
• Candidates should have good experience in Reverse engineering, Documenting the existing Logic and logic recreation from existing Informatica Mappings.

Job Type: Full-time
Pay: $100,000.00-$110,000.00 per year

Experience:

• Business Analyst : 10 years (preferred)
• Informatica: 7 years (preferred)
• Powercenter: 6 years (preferred)
• Reverse Engineering: 6 years (preferred)
• Advanced SQL: 8 years (preferred)
• Azure Databricks and Azure Data factory: 4 years (preferred)

• Candidates should have very good hands-on Advanced SQL knowledge,
• Should be able to navigate through ETL and Informatica Tool (like Informatica PowerCenter).
• Candidates should have good experience in Reverse engineering, Documenting the existing Logic and logic recreation from existing Informatica Mappings