Ankit Jain Email & Phone Number

Hyderabad, In

Hyderabad, Telangana, India

Hyderabad, Telangana, India

* Leading a team of 30 members, dedicated for end to end delivery of multiple Bigdata & AWS projects.* Built the teams from scratch and transitioned the multiple projects from vendors to Legato, which is a newly formed subsidiary of Anthem Inc., USA.* Designed the Data Ingestion & Extraction pipelines using pySpark, Spark SQL and Shell scripting for "Anthem Health Cloud" product, serving our external clients "BCBS of Michigan" & "Horizon".* Developed a webpage for "EMR Sync", an in-house solution innovated to perform various EMR activities at one place.

Hyderabad Area, India

# End to end implementation of Data Replication in non-prod and in production.# Task Designing and development in Attunity Replicate and IBM CDC tools.# Interacting with Data Architects and Solution Architects on the Design and identifying any potential architectural gaps if any.# Preparation of the technical design document.# Responsible to manage the data coming from different sources.# Analysis and Reporting of the Data acquired using Splunk Dashboards.# Troubleshooting Production issues, analyzing the root cause, working with all the stakeholders and fixing the issues.# Working with IBM and Attunity vendors on Production issues and new implementations.

Hyderabad Area, India

# Requirement Analysis, Data Analysis & Impact analysis.# Understanding the objective and overall goal of the project by analysing SOW/HLD.# Developing the workflows using Talend Data integration tool.# Developed HQLs to Generate the Impact Intelligence Files from the JSON Data Files.# Automation using Unix Shell Scripting and HQL (Hive Query Language) scripting.# Data Profiling and Data Mock-up to cover all the requirements and test scenarios.# Validating the Structured and Semi-Structured data in Text, XML, JSON and Avro formats.# Production Deployment: Performing Post- Production Checkout and providing sign-off.# Effort Estimation: Providing the Release estimates and Agile Sprint estimates.# Identifying the improvement areas and providing innovative solutions.# To identify the risks that may affect the deliverables and providing the mitigation plan.

Bengaluru Area, India

• Identifying the key scenarios for ETL Mappings, Spotfire and Infosario.• Testing of ETL Mappings to test the Data flow between Source, Staging, ODS and DM Layer of TMDH DataWarehouse built on top of Oracle.• Testing of Visualizations & Reports to test the Data flow from Database to Spotfire Information Links, Infosario Visualizations & IPD OBIEEE Reports.• Writing SQL Test Scripts for ETL Testing, based on the Source to Target data Mapping mentioned in Analytix Mapping Manager.• Test Case Execution & Result Analysis in different cycles : Dry Run, Formal Run, End to End, Regression, Smoke Testing.

Bengaluru Area, India

• Preparation of ETL test plan• Preparation of Test cases for ETL testing based on the Mapping document• Preparation/Review of SQL Test Scripts for ETL testing• Executing ETL Test scripts and performed Result Analysis• Defect logging in QC and tracking it to closure• Involved in the review of the Test Plan and Test Scripts

Bengaluru Area, India

• To understand the business, functional and ETL requirements of the Project.• Understanding the flow of the Project and identifying the key ETL scenarios.• Designing positive and negative test cases based on the identified scenarios.• To test the functionality of ETL Logic using SQL, Unix and Shell script.• Triggering and monitoring DataStage jobs to load data.• Developing automated solutions to boost efficiency of ETL projects.• Logging the defects identified during testing in Rational Clear Quest.• Participation in root cause analysis with the Dev/DBA to close the defect.