harshala patil

Intro

Nashville, United States

Datawarehouse developer at Tata Consultancy Services

Joined August 3, 2023

Skills

About

I am Teradata 14 Basics & SQL Certified IT professional with 7+ years in DataStage, Microsoft SQL Server, Teradata ETL development focusing on Design and Developing of ETL methodology for supporting Data Migration, data transformations & processing corporate wide ETL Solution. • Technically competent in the development of complex ETL processes for extracting data from different data sources, data transformation and loading the data using Datastage, Teradata, Oracle, SQL/PL-SQL and NO SQL • Adroit in handling all stages of software/project life cycle including requirement analysis, Design, Build, Testing, implementation and support release using Agile Methodologies • Proficient in UNIX/shell scripting for processing large volumes of data from varied sources and loading into databases like Teradata also developing Automation script using VBA scripting, Python for projects • Strong exposure on Data warehousing with emphasis on Business Requirements Analysis, Application Design, Development, coding, testing, implementation and maintenance along with Data mapping and Data Lineage • Strong exposure on SQL, PL-SQL, stored procedures, triggers and complex query development • Skilled at coding and debugging Teradata utilities like Fast Export, TPT, Fast Load, MLoad etc. for Teradata ETL processing huge volumes of data throughput • Extensive experience on Teradata database, analyzing business needs of clients, developing effective and efficient solutions and ensuring client deliverables with in committed timelines • Experienced in Extraction & Migration of data from heterogeneous data sources like Flat Files, MS Excel, MS Access, MS SQL Server to ORACLE, Teradata • Conversant with technologies & tools like IBM Data Stage 11.5, Teradata, SQL Development, stored procedure writing, Mainframe, Unix, Compuware, Teradata SQL Assistant, Github, DBeaver , Tableau • Skilled in preparing/understanding documents like Entity Relationship, BRD, TDD, Unit test documents, Scheduling documents etc. • Hands on experience on Mainframe and using JCL, SYSIN, COBOL, File-Aid, Endevor and VSAM files • Hands-on experience on Microsoft Azure, Continuous Integration, Continuous Deployment and Agile Methodology using JIRA, ServiceNow and Confluence.

Experience

Tata Consultancy Services

Oct 2022 – Present

Albany,NY

Datawarehouse developer

Project 1: New York Unemployment Insurance Project | Data warehouse/ ETL Datastage Developer | Oct 2022- Till date | Albany, NY (Remote) Client: NY - UISIM Tools/Technology Involved: SQL, T-SQL, Microsoft SQL Server, DB2, Oracle, Azure, Datastage, UNIX, Control-M Responsibilities: • Understand the requirement from Businessperson and plan a best approach and work on Data mapping • Co-ordinate with business and BAs regularly to understand the requirement and prepare mapping sheets. • Build the SQL and creating mapping sheet to implement the business logics. • Perform Data lineage to understand the multiple type of data. • Creating low level designs based on mapping sheet and providing efficient solutions. • After approval, create the high-level designs and create ETL jobs, Azure with SQL, stored procedures and tune SQL jobs. • Implement the multi instance, reusable or generic jobs for extraction and load. • Extracting the data from various sources like Flat Files, tables, Load sets and message queues. • Create the test conditions, do the unit testing and field level validation as well as documented it. • Prepare Technical design document and Unit testing document, support handover document • Work on Implementation Process ( Productionize the code, AR creation, Implementation Support )