ETL architect

Amand Singh

EXPERIENCE

**/**** – Present COMCAST Philly, PA

Informatica LEad

Managing the integration team to provide end to end integration

Developed various integration for the client both on real-time and batch solutions

Selecting appropriate Cloud services to design and deploy an application based on given

Requirements

Designed a solution to send WhatsApp message through the IICS based on the triggered received from the third part system.

Developed various integrations between in-house applications and salesforce using change data capture, platform events

Managing the gitHUB solutioning for the continuous improvement/continuous development (CI/CD )

Env - IICS, GitHub

10/2021 – 02/2023 Hill ROM, Newyork, NY

Sr Developer

Built tested and deployed salable and highly available modular software products

Created a solution using oracle and IICS platform to extract the data from JD Edwards

Created integration between SAP and MDM (C360) where for initial data

Env - Python,Java,Pyspark,Spark Straming,Aws,Hive,Hortonworks,Kafka, Devops

09/2020 –10/2021

Cvent

Informatica Lead

Piscataway, NJ

Developed a CAI process for the hospitality and event cloud solution using application integration

Designed and developed jobs for the account deduplication in salesforce using informatica cloud

For parallel processing, programmed a python code to hit the informatica.

Developed a mix of cloud data integration and application integration process (CAI) from SQL server

Involved in Technical and Functional reviews.

Unit testing and integration testing of owned use cases

Env – CAI, Informatica, SQL

03/2019 – 09/2020

Collette Consultant

ParkRidge, NJ

Worked directly with clients on the solutioning to involve informatica cloud as a middleware between several client web applications and salesforce

Developed CAI process for Lumi (clients web application for car rental) integration to bring account

Developed CAI process for EBE (clients web application for booking) integration where a nested json was read and 4 different objects of salesforce

Modified the existing CDI job for HUB (Client web app for flights and Hotels) bookings to CAI

involved in writing SQL & PL/SQL – Stored procedures, functions, triggers etc.

Involved in Technical and Functional reviews.

Unikt testing and support SIT, UAT

Env – Informatica cloud, Salesforce, Oracle 11g, Log4J, SVN, Maven, Tomcat 6.0, Agile

05/2018– 03/2019

Mckesson

Senior Software Engineer

Involved in the requirement analysis, design, and development of the project Development and implementation of Informatica Cloud mapping for different connectors like Salesforce, oracle, Sql server

Designed the ICS mappings for various applications like mailroom, Innerworking and assistRx

Worked to produce the message into active MQ

Env – Informatica cloud, SQL

Deerfield, IL

EDUCATION

2004 – 2007

Lovely Professional University

Punjab India

BTech Technology

TECHNICAL

SKILLS Hardware / Platforms - Windows, Unix,Linux

Technology – Informatica, IICS, AWS, Pyspark, Python,,Json,Xml

Programming Languages – PL/SQL, Python,

Databases - Cassandra, Oracle DB, MS SQL.

Scripting Languages -Shell Script

Tools JIRA, ServiceNow.

Version Control Systems - Git Bitbucket,SVN,Accurev.

EXPERIENCE SUMMARY

Client Summary

Around 16+ years of IT experience,including 8 years of experience in dealing with Apache Hadoop Ecosystem like HDFS,YARN, Pyspark 3.2.1,Scala 2.12.0,Spark,Hive 2.1.1,MapReduce,AWS,Cloudformation,Aws Glue,Aws Lambda,Sqoop 1.99.7,Cassandra and Big Data Analytics and 8 years of experience in Development and Support of Core Java,Spring,SOA,SOAP,REST Web services,JSP,Servlet,JavaScript,XML and Json

8 Years’ Experience in a Big Data technology,Experience in designing,developing and delivering large-scale Big Data projects

1 Years’ Experience in Python and Machine Learning

8 Years’ Experience in java and complete project life cycle(design, development,testing and implementation)of Client Server and Web applications

Work with product owners,business SME and data ingestion and reporting architects to identify requirements and consolidate enterprise data model consistent with business processes

Involved in projects implementing Data Lake Architecture,Big Data Analytics and Modern Data warehouse application

Architecting,Solutioning and Modeling DI(Data Integrity)Platforms using Spark,kafka,Spark

Streaming and Cassandra,Expertise and work Experience in Amazon web service

Exposure and working expertise in Spark, PySpark, Python, Scala and Java Experience with AWS such Cloudformation,As Glue,Aws lambda,Rds,Redis

Strong experience in writing applications using python using different data science libraries like Pandas,numpy,matplotlib,seaborn and scikit

Used Sqoop to efficiently transfer data between Oracle,Netezza,Teradata databases and HDFS

Ingesting wide variety of data like structured, unstructured and semi structured into the Big data eco systems with batch processing, real time streaming

Experience in NOSQL databases like Cassandra

Have good understanding and implementation of UML and Java Design Patterns

Build AWS Lambda Function in Python and Built the Api Gateway

Managed Docker orchestration and Docker containerization using Kubernetes

Deploy and Run Spark Application in AWS EMR and have experienced with S3,EC2,

AWS VPC and subnet,Public and private Gateway

Nexus recommendation Engine

Credit and compliance Risk Core Banking

AIG is an insurance Company. Providing policy Health benefits for customers.

PHR - Patient health Record Portal aetna

Aig Companies offer a variety of term life insurance products that fit your needs, time frame, and budget

BT - HQNS is a SOA oriented application. It’s a label management system for telecommunication. Big service provider for telecom. Doing the B2B service between EE to BTWLMS and integrating the trend system like PCM, RBM, Netllynk and Orange. Customer can get the Line, Calls and broadband connections and all related service.

UBS The UBS Group is a worldwide group of independent financial service providers, comprised of

International banks trust and fund services companies. UBS Group companies provide corporate/fiduciary, fund administration and banking as well as data processing services. UBS intends to develop a “Next Generation Application for Custodial Services” that can cater to the growing demands of. the online banking and custodial services industry

Contact this candidate