• Job Description

  Req#: 22-90475
  
  
  Job Description
  
  
  Hi ,
  Hope you are doing well..
  
  ROLE : Senior ETL Developer Sap Bods AWS
  Duration : Long Term Contract
  Location : Remote
  
  JD:
  Minimum 6-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..
  u Experience in implementing AWS technologies like AWS S3, Glue, AWS RDS, PySpark, Python, Confluent Kafka, etc
  u 2+ years of experience in Master Data Management, Data Governance, Data Quality is a plus
  u Expertise in Java, J2EE Spring Boot, Spring Cloud, Eureka, Spring Cloud Gateway, Spring Security, AWS and Microservices design
  u Experience with creating and consuming RESTful, Query, and hybrid APIs using OAuth 2.0
  u 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.
  u Restful APIs HTTP methodologies like GET, PUT, POST, DELETE
  u Deep Understanding of service design for Cloud environment and related technologies Dockers, Kubernetes, AWS and OpenShift
  u Collibra integration knowledge
  u IDQ experience, moving business rules from Collibra to IDQ, integration with IDQ.
  Roles and Responsbility
  Design, develop and maintain Informatica cloud data integration processes using the appropriate data load technique, including Push-Down Optimization for performance optimization
  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
  Document all mappings mapplets and rules in detail and hand over documentation to the customer
  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
  Should be able to create and load data into Aggregate Tables using transformations. Should be able to perform tasks individually and independently
  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
  
  
  Thanks,
  HARBHAJAN
  Senior Technical Recruiter
  DIVERSE LYNX LLC.
  Contact No- 7324521006 ext : 473
  EMAIL:harbhajan@diverselynx.com
  300 Alexander Park Suite # 200
  Princeton, NJ 08540
  
  
  
  
  
  
  Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.
  
  
  
  

• About the company

  We provide Consulting Services for our customer’s project and staffing needs. We also provide Data Management for Clinical Trials.

Notice