Vishesh Pratap Singh

ETL Developer-
• I have expertise in building pipeline for data processing using spark. Worked in developing batch jobs(historical and incremental).
• Used Stonebranch as orchestration tool for job dependency, and scheduling,
• I have hands on experience on databases like Postgress, Redshift.
• Used Postgress for ABC entries (audit processing for tables).

ETL Tester-
• Worked in understanding the business requirements and validating if development happens in sync with the STM
(source target mappings) specified.
• Worked on SIT testing, prepared testcases to evaluate the development issues.
• Worked in extensive debugging of spark jobs and finding impact points in SQL queries leading to data quality issues.
• Ensured the architecture work for application meets the requirement and suggested changes to make it robust.
• Regarding testing with runs before and after data load ensured all moving parts of application are working in sync with
the standards.

• Worked on Data analysis, Datawarehousing and Reporting.
• Used SQL for Data analysis reporting and worked with Data visualization tools like Power BI, Tableau, Qlikview and
  QlikSense.
• Worked with team and delivered project in reporting
  dashboards made in Tableau.

• Develop Data archival solutions using IBM Infosphere Optim V11.0.6 and/ or SOLIX CDP.
• Data table analysis and Query Assistance.
  Design access definitions required for archival and creating archive requests.
• Data analysis based on the relationship of tables.
• Creation, Execution and Validation of archive jobs and archived data.
• Use of AWS services like EMR,S3,data catalog and database engines like MYSQL, IBM DB2 LUW and Hadoop.
• Worked and coordinated with multiple teams, with deliverable approach based on agile mindset