• Comprehensive knowledge of ETL process standards, Cloud database concepts and Devops framework management including Complex Data validation and SQL Performance tuning with Explain plan analysis in Teradata Data-warehouse, Data modelling and BI Reporting in GCP BigQuery databases.• Exposure on developing Teradata utilities Multiload, Fastload, Fast Export, TPT and Tpump scripts to load business data and manufactured test data from Mainframe Partitioned Data Sets and Flat files into… Show more • Comprehensive knowledge of ETL process standards, Cloud database concepts and Devops framework management including Complex Data validation and SQL Performance tuning with Explain plan analysis in Teradata Data-warehouse, Data modelling and BI Reporting in GCP BigQuery databases.• Exposure on developing Teradata utilities Multiload, Fastload, Fast Export, TPT and Tpump scripts to load business data and manufactured test data from Mainframe Partitioned Data Sets and Flat files into Teradata Datawarehouse as per the Extraction and Transformation Business Data mapping logic requirement.• Experience in generating Teradata BTEQ scripts and SQL mapping scripts as per the transformation data mapping logic and loading of Historical / Incremental Claims and Accounting data to enable the data integration into Teradata EDW.• Invoked Unix commands and shell scripts during the Control M job execution / monitoring of Abinitio ETL batch jobs.• Involved in Dev Ops automation of ETL data validation testing using Dev Ops tools such as Fitnesse, Jenkins and GIT Bash in GIT repository. Show less

• Designated as Technical Consultant with Financial Services - Credit Card Payments domain expertise at Trans-Union llc, the Credit Bureau Management client at US.• Expertised in ETL testing process standards and associated batch framework management including performance tuning in Oracle 10g Database, Decision system and BI Reporting.• Exposure to design, development and generation of Standard and Adhoc reports in Microsoft SQL Server Reporting Services - SSRS.

Role(s): Senior Test AnalystDomain/Application: Enterprise Data Warehouse - Core Banking DomainTechnical Tools: IBM Data stage 8.1, Teradata V 13, SQL Server 2005, Oracle 10g, Mainframe JCL, CLIST, ISPF / PDF utility and HP Quality Center 10.Responsibilities:• Handled data migration projects for loading data from SQL Server to Oracle 10g and ETL DW BI projects for extraction, transformation, loading of data from Enterprise DW in Teradata to Extract feeds / Reports for… Show more Role(s): Senior Test AnalystDomain/Application: Enterprise Data Warehouse - Core Banking DomainTechnical Tools: IBM Data stage 8.1, Teradata V 13, SQL Server 2005, Oracle 10g, Mainframe JCL, CLIST, ISPF / PDF utility and HP Quality Center 10.Responsibilities:• Handled data migration projects for loading data from SQL Server to Oracle 10g and ETL DW BI projects for extraction, transformation, loading of data from Enterprise DW in Teradata to Extract feeds / Reports for business validation.• Worked on Mainframe MVS / TSO/E session using ISPF utility for validation and execution of Teradata BTEQ scripts and Teradata Multi load, Fast load, Fast export utilities invoked by batch processing of JCL jobs.• Worked on IBM Data Stage 8.1 - Designer / Director to develop ETL processes for extracting, cleansing, transforming, integrating and loading data into Teradata EDW and its run-time engine to schedule the jobs invoked by Unix commands / scripts, debugging the job components and monitoring the results generated in logs and validation of data in target feeds. Show less