• US Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• H1B Work Permit

• Corp-Corp

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 29th Apr 2022

 

SN

Required Information

Details

1

Role

Senior ETL Developer

2

Required Technical Skill Set

Any ETL Tool tools (SAP BODS / Informatica / Data Stage / Abinitio), with IICS & AWS Technologies

3

 

4

Desired Experience Range

7-10 Yrs.

 

Desired Competencies (Technical/Behavioral Competency)

Must-Have

• Minimum 7-10 years of ETL/ Datawarehouse development experience working with SAP BODS or related ETL tools (Informatica / Data Stage / Abinitio)
• Minimum 2-3 years of experience hands-on development in the implementation of Informatica Intelligent Cloud Services (IICS) components - application integration, data integration, Informatica data quality and Informatica power center, and CRM application – Salesforce
• Expertise in scripting technologies like Python/PySpark
• IICS Data Integration and having knowledge on Cloud Application Integration
• Should have experience in developing application integration using SOAP/REST APIs, APIs leveraged to integrate multiple systems
• Strong in writing complex queries with nested joins and derived tables.
• Candidate should have good knowledge of Oracle database.
• Candidate should have good knowledge of designing data warehouse schema,
• Experience in Agile, Scrum, Kanban methodologies

Good-to-Have

• Experience in implementing AWS technologies like AWS S3, Glue, AWS RDS, PySpark, Python, Confluent Kafka, etc
• 2+ years of experience in Master Data Management, Data Governance, Data Quality is a plus
• Expertise in Java, J2EE Spring Boot, Spring Cloud, Eureka, Spring Cloud Gateway, Spring Security, AWS and Microservices design
• Experience with creating and consuming RESTful, Query, and hybrid APIs using OAuth 2.0
• Strong knowledge in Microservices Architecture in a Cloud environment. Java microservices in Spring Boot is required along with security. Web development using React Spring Framework.
• Restful APIs HTTP methodologies like GET, PUT, POST, DELETE.
• Deep Understanding of service design for Cloud environment and related technologies Dockers, Kubernetes, AWS and OpenShift
• Collibra integration knowledge
• IDQ experience, moving business rules from Collibra to IDQ, integration with IDQ.

 

SN

Responsibility of / Expectations from the Role

1

Design, develop and maintain Informatica cloud data integration processes using the appropriate data load technique, including Push-Down Optimization for performance optimization

2

Debug and tune data integration processes; analyze data warehouse architecture, normalized/de-normalized, star schemas and snowflakes, slowly changing dimensions, dimensional surrogate key handling, exception data processing, troubleshoot and recommend improvements and alternate methodologies

3

Document all mappings mapplets and rules in detail and hand over documentation to the customer

4

Responsible to transfer data from Oracle, SQL Server tables and Web Services either Incrementally (Delta Load) or full Load to the Data warehouse on periodic basis

5

Should be able to create and load data into Aggregate Tables using transformations. Should be able to perform tasks individually and independently

6

Responsible for Planning, Developing, Implementing and Managing Data Warehouse Project Deliverables, Design Documents and High-Level Data Mapping for ETL Specifications. Create transformations in ETL jobs to achieve data cleansing and standardizations during initial data load