PROFESSIONAL SUMMARY:

• 13 years of experience in Development in Data warehousing using informatica Power Center, Informatica IDQ, Oracle and Teradata and Big data technologies Hadoop and Hive.
• Currently working as a Tech Lead.
• Has good amount of experience in Coding on Informatica, IBM DataStage, Oracle PL/SQL and Teradata, batch scripting and
• UNIX shell scripting.
• Strong skills in Data Analysis, Data Requirement Analysis, Data gaps, data migration, data governance, root cause analysis and Data Mapping for ETL processes
• In - depth knowledge in the Teradata cost-based query optimizer, identifying potential bottle necks with queries from the aspects of query writing, skewed redistributions, join order, optimizer statistics, physical design considerations (PI/USI/NUSI/JI etc.) etc.
• Strong hands on experience using Teradata utilities (SQL, BTEQ, Fast Load, MultiLoad, FastExport, Tpump, Viewpoint), TPT.
• Experienced in working with design and architecting projects for Data warehouse, executed complete re-design of architecture and stabilized the architecture.
• Experience in working with Azure Blob Storage, Data Lake, ADF and Databricks.
• Good understanding of Spark Architecture
• Expertise in handling complex requirements and projects, build design and develop the ETLs for it.
• Experience in interacting with client directly for specific requirements to understand the requirement exactly and providing solution with first time right approach
• Good skill in identifying root cause for issues in production and quickly provide fixes
• Good working and practical knowledge in all aspects of SDLC like requirement analysis, design, development, testing, implementation, and maintenance of Projects, agile projects using scaled Agile.
• Exposure with Teradata, Hive and Oracle
• Possess excellent Communication, Interpersonal & Analytical skills. Abilities in working in strict deadlines and diverse conditions.

TECHNICAL PROFILE

Databases: Oracle 10g, Teradata, Hive

ETL: Data Ware Housing Concepts, Informatica Power Center, Informatica Developer (BDE), IBM DataStage

Tools: Autosys, PVCS, Dollar Universe, Kintana, TES, Artifactory

Scripting: Shell scripting

DOMAIN SKILLS: Domain Knowledge:

PROFESSIONAL EXPERIENCE:

Programmer Analyst

Confidential, South Plainfield, NJ

Responsibilities:

• Work with the Product Owners, Business Analysts, and client areas to prepare functional specification during the project requirements stage.
• Design, development, and unit testing of mappings using informatica Power Center and IDQ for the requirements.
• Creation of stored procedures for complex design like handling temporal and bi temporal table in Teradata.
• Design and develop integrated solutions for complex requirements like handling multiple source windows, member, and group address from Facets.
• Implementation of Address Doctor for address standardization using Informatica IDQ.
• Automation of PBM loads by designing adjustment process for the existing manual adjustment process and handling the file loads validation through automated audit.
• Design and development of archive and purge mechanism for incremental data tables for easier trouble shooting with flexible retention period of data at each table level.
• Performance tuning of long running queries through redesign reducing batch run time by 40% to meet SLA.
• Quick root cause analysis and fix for production issues.
• Automation of DB objects deployment process using batch script.
• Consolidation of control-m jobs through automation saving customer $160K in licensing cost.
• Oversee design reviews to proactively identify potential problems and suggest alternate design.
• Created Pipelines in ADF using Linked Services/Datasets/Pipeline/ to load files to Data lake and copy to Teradata.

Confidential

Technology Analyst

Responsibilities:

• Creation of mappings, workflows as per the requirement.
• Analysis of legacy data sources and converting them to ETL structure.
• Creation of PL/SQL objects and building reports.
• Fixing issues in mapping and workflows.
• Performance tuning of ETL.
• Creation of Autosys jobs.

Confidential

Technology Analyst

Responsibilities:

• Gathering requirements from client.
• Helped senior data modeller in designing the data model for the requirement.
• Creating design documents for the data model.
• Helped teammates with ETL design for development in IBM DataStage.

Confidential

Sr Software Engineer

Responsibilities:

• Creation of the Audit Jobs in the Data flux tool
• Query writing in Teradata for data retrieval and updating the data.
• Supporting the Quality runs.
• Uproc and Session creation and modifications.
• Issue Fixing in the Informatica Mappings and Sessions.
• Supporting the FPR and issue fixing in the FPR.
• Performing Unit Testing and Integration Testing in Dollar Universe.
• Scheduling of the Informatica and Data flux jobs using the $U.
• Root cause analysis for the missing and mismatch records in the Source and target tables.

Confidential

Sr. Software Engineer

Responsibilities:

• Modified Informatica mappings and workflows as per the requirement.
• Creating CRs to resolve issues in the existing ETLs or data issue.
• Resolving Issues while loading the data to database through utilities.
• Performance tuning for the workflows which are taking longer time for execution.
• Finding out Root Cause for the Mismatches in the table amount columns and fixing them.
• Checking the logic in EDW and EDW2B and solving the issues if there are any present.

Confidential

Software Engineer

Responsibilities:

• The Enterprise Data Warehouse "To Be" (a.k.a. EDW2B, Next Generation EDW) is an initiative that will move Confidential 's EDW to the Next-Generation Data Warehouse platform on Teradata solution.
• The vision is to establish a centralized Enterprise Data Warehouse which will contain the Enterprise wide integrated data, and which will be used for all Business Intelligence and Analytical capabilities. As part of EDW2B having multiple projects (a.k.a. data tracks): Order Data Track, Reference and Hierarchy Data Track, GL Data Track and Marketing Data Track.
• This Project is related to the Sales Orders Data Track and the high-level scope of this is as follows: ERP Order Entry data, POS data, Bookings Adjustments, CARBT Adjustments, Bookings Measure and Channels Bookings Measure. This release provides the integrated POS data, Bookings Adjustments and Bookings Measure to the end-users.