Sarthak Jaiswal

Worked on a high-impact government project for the Central Board of Indirect Taxes and Customs (CBIC), contributing to the processing and integration of large-scale GST and Customs data. Designed and maintained robust ETL pipelines to extract, transform, and load data from diverse sources, ensuring high accuracy and compliance with regulatory requirements. Collaborated with cross-functional teams to support data warehousing and reporting needs, enabling data-driven decision-making for tax and customs enforcement.
Key Responsibilities:
· Developed and optimized ETL processes for ingesting GST and Customs datasets using tools such as IBM Infosphere Datastage, Sql (DB2,Oracle)
Ensured data integrity, quality, and validation across all stages of the ETL workflow.
· Automated data extraction from various government systems.
· Coordinated with stakeholders, including government officials and technical teams, to gather requirements and deliver scalable data solutions.

• Client: Financial Service(Bank Project)
• Role: Application Developer (ETL Developer)
• Responsible for ingestion of data from different sources.
• Datastage job creation as per the project needs.
• Close collaboration with clients.

• Worked collaboratively with Operations and Enhancement Team
• Client: Pharmaceutical Industry
• Divided responsibilities included processing Sales data for reporting purposes, enhancing codes as per client requirements, creating Datastage jobs for transforming data, and delivering it to the Target system.

• Worked collaboratively with Operations and Enhancement Team
• Client: Pharmaceutical Industry
• Divided responsibilities included processing Sales data for reporting purposes, enhancing codes as per client requirements, creating Datastage jobs for transforming data, and delivering it to the Target system.

• Client: Financial Service(Bank Project)
• Role: Application Developer (ETL Developer)
• Project 1: People Data and Analytics(Project Ansatt Data)
  
  In this project, the bank required the different type of data of Associates working with them in the Datawarehouse for analysis and reporting purpose. Data contains: Associate employment, position, personal info, pension, language skills, education, training, etc.
  It involved many process like data from a system in the form of source file(csv, txt) to be loaded in the Datawarehouse, or from one Datawarehouse to other.

• Client: Financial Service(Bank Project)
• Role: Application Developer (ETL Developer)
• Project 1: Y2K Decommission
  In this project, the mediator Routine Y2K(which provide transformed data to the target systems) is decommissioned. Previously the PAGA database(contains data of organization, customer, associate, authorization, etc.), main DB provided the data to Y2K system for processing and then data being loaded to Teradata via Datastage Jobs. However, now the bank has introduced a new system, Zalaris, that sends the same data as PAGA DB. So the now exchange of data between Zalaris and The BANK will be done via 1219 routine(that include Data warehouse, Datastage, RDM).
• Project 2: Unsecured Debt(PublicDebtCollection)
  In this project, we built ETL job which took csv as source file from different sources to perform transformation as per requirement and load data to Teradata tables. Here, the data of the Users of the bank who have taken Unsecured debts is used.
• Project 3: GDPR Implementation
  In this project, the implementation of rules as per the organization were done in the system to set what sort access to be given to a particular person to see a part data. So the RBA(Role Based Access) and Masking of data were done. Views were created at different
  levels to implement this.

• Completed Generic training, which contains Python Programming, Data Structure, and Algorithm.
• Completed Stream training of Big Data, Hadoop framework Tools (Hive, Pig, Hbase) and NoSQL(MongoDB)
• Infosys Training Project: Capstone Project.
• The project included the analysis, cleansing and removing the unnecessary data of IPL Matches(10 years) on the basis of User stories created to award the players and represent all user stories in the form of reports.
• Roles: Involved in the creation of user stories.
• Loading and cleansing the data.
• Report the data via Power BI.