SUMMARY
- 15+ years of broad experience in Analysis, Design, Development, Implementation and Testing of Data Warehousing and Client /Server Applications
- Extensive experience in Data Warehousing using various ETL tools (Informatica 6.x/7.1.x/8.6.x/9.1/10).
- Designed and Developed Strategies for Extraction Transformation Loading (ETL) mechanism.
- Teradata certified professional.
- Experience in using Teradata utilities - Bteq, Mload, Fast Load, Fast Export and TPT.
- Created Teradata procedures.
- Extensive experience in Performance Tuning of ETL Processes in Informatica.
- Extensive knowledge of Dimensional Data modeling, Star Schema/Snowflake schema, Fact and Dimension tables.
- Experience in Data Profiling
- Extensive database experience in Oracle 7/8/8i/9i and Oracle 10g database analysis, design, development, and integration
- Proficient in PL/SQL programming, writing Stored Procedures and Database Triggers.
- Experience in data integration using DB2, Teradata, SQL Server, XML, COBOL Sources and Web Services.
- Experience with Workload Automation using Auto Sys, Tidal, UNIX and PowerShell Scripting.
- Extensive experience in Oracle Forms 6i, Report 6i, Developer 2000, Toad, SQL Assistant
- Experience in Azure and AWS cloud
- Experience in Bigdata technology Apache Spark
- Strong experience in building data integration process using Azure, SAP BW/HANA and BI Platforms
- Extensive experience doing BI solution Implementations for Pharma Sales and Marketing
- Excellent leadership, verbal and written communication skills.
TECHNICAL SKILLS
ETL Tools: Informatica (6.x/7.1.x/8.6.x/10), LWE, Data Factory
GUI Tools: Developer 2000, Forms 6i, Report 6i
RDBMS: Oracle 8/Oracle 8i/Oracle 9i/Oracle10g, Teradata 15
Languages: SQL, PL/SQL, Pro*C, LINC, UNIX Shell Script, Python
Operating Systems: Windows NT 4.0, 98, 2000, XP, UNIX- HP, Digital, SCO, AIX and Solaris, MS-DOS
Cluster Computing Framework: Apache Spark Databricks
Version Control: Visual Source Safe (VSS), GitHub
CLOUD: Azure, AWS
Data Modeling: Erwin 4.0/3.5.5/3.3.2 , Microsoft Visio, Oracle Designer
Domain Knowledge: Supply Chain, Health Care and Pharma - BI solution Implementations for Pharma Sales and Marketing, Banking & Finance - Core Banking Solution Implementation, Reporting, and Transaction initiation, Auto & Credit Financing, Transportation - Shipping
PROFESSIONAL EXPERIENCE
Confidential, OR
Sr. Data Engineer
Responsibilities:
- Developed Databricks notebook to stage data in SQL DW MPP database.
- Developed Datafactory pipelines
- Developed AAS model for reporting
- Migrated code using CI/CD process
Environment: Teradata 12, HP-UNIX, SQL Assistant, Informatica Power Center 9.1, Windows Shell Scripting, SQL Server, Windows XP, AWS, SAP BW/HANA
Confidential
Sr. Data Engineer
Responsibilities:
- Involved in developing Functional/Mapping document
- Designed and developed informatica workflows by extracting data from sources like MySQL, SQL Server, AWS S3 data lake, snowflake to Teradata
- Created Mappings to load the data from various sources using different transformations like Source Qualifier, Lookup, Aggregator, Expression, Stored Procedure, Filter, Joiner, Router, Sequence Generator, and Update Strategy and Transaction Control transformations
- Enhancement to existing application as per new requirement
- Interacting with client’s Subject Matter Experts (SME) for Requirement and Design Related Issues for CLOO application
- Involved in Performance Tuning for optimizing the session Performance and Teradata queries
- Converting Alteryx workflows to Nextgen technology python3.0
- Analyzing inventory data present in AWS S3 data lake using Apache Spark
Environment: Teradata 12, HP-UNIX, SQL Assistant, Informatica Power Center 9.1, Windows Shell Scripting, SQL Server, Windows XP, AWS, SAP BW/HANA
Confidential, OR
Sr. Data Engineer
Responsibilities:
- Closely worked with DAs for modeling changes
- Developed Data Integration strategies for SAP Implementation through 6 regional release
- Developed TIDAL jobs
- Involved in database table and index design
- Interacting with client’s Subject Matter Experts (SME) for Requirement and Design Related Issues
- Involved in Performance Tuning for optimizing the session Performance
- Worked as informatica admin
Environment: Teradata 15, SQL Assistant, Informatica Power Center 10, PowerShell Scripting, SQL Server, Windows 10
Confidential
Sr. ETL Developer
Responsibilities:
- Involved in the developing Mapping document
- Created mappings and sessions by extracting data from sources like XML, flat files, SQL Server, Oracle, Teradata, Fixed width and Delimited Flat files
- Created Mappings to load the data from various sources using different transformations like Source Qualifier, Lookup, Aggregator, Expression, Stored Procedure, Filter, Joiner, Router, Sequence Generator, and Update Strategy and Transaction Control transformations
- Extensive experience in loading data using XML
- Interacting with client’s Subject Matter Experts (SME) for Requirement and Design Related Issues
- Involved in Performance Tuning for optimizing the session Performance
Environment: Oracle, Teradata 12, HP-UNIX, SQL Assistant, Informatica Power Center 8.6, UNIX Shell Scripting, SQL Server, Windows XP
Confidential, OR
Sr. ETL/Teradata Developer
Responsibilities:
- Involved in the requirements gathering from users and translated them into technical specifications
- Created mappings and sessions to implement technical enhancements for data warehouse by extracting data from sources like SQL Server, DB2, Fixed width and Delimited Flat files
- Created Mappings to load the data from various sources using different transformations like Source Qualifier, Lookup, Aggregator, Expression, Stored Procedure, Filter, Joiner, Router, Sequence Generator, and Update Strategy transformations
- Extensive experience in loading data using Bteq, Mload, Fast Load, Fast Export and TPT
- Involved in development of Stored Procedures, Triggers, database table and index design
- Interacting with client’s Subject Matter Experts (SME) for Requirement and Design Related Issues
- Involved in Performance Tuning for optimizing the session Performance
Environment: Teradata 12, SQL Assistant, Informatica Power Center 8.6, PowerShell Scripting, SQL Server, Windows XP
Confidential
Sr. ETL/Teradata Developer
Responsibilities:
- Involved in enhancement to the existing application
- Extensive experience in writing Teradata scripts using Bteq, Mload, Fast Load and Fast Export
- Involved in development of Stored Procedures, Triggers, database table design, indexes
- Interacting with client’s Subject Matter Experts (SME) for Requirement and Design Related Issues
- Extensive Work on Autosys for Automated Job Scheduling.
- Development of Informatica Mappings & Workflows using Informatica to transport data to Oracle and Teradata targets.
- Worked on Mercury IT Governance center 6.0 (Kintana) for managing IT Processes including Change Management.
- Enhancement to the existing applications developed in Teradata.
- Involved in Performance Tuning for optimizing the jobs
- Conduct code walkthroughs and review peer code and documentation
- Involved in Performance Tuning for optimizing the session Performance
Environment: Teradata, HP-UNIX, Autosys for Automated Job Scheduling, SQL Assistant, Informatica Power Center 8.6, UNIX Shell Scripting, PL/SQL, Mercury IT Governance Center 6.0, SAP-BW
Confidential
Sr. ETL/Teradata Developer
Responsibilities:
- Involved in Informatica migration from 7.x to 8.5 to 8.6
- Provide on-call support to production system to resolve any issues.
- Extensive experience in writing Teradata scripts using Bteq, Mload, Fast Load and Fast Export
- Involved in development of Stored Procedures, Triggers, database table design, indexes and performance tuning based on the business requirements in Oracle.
- Developed various complex stored procedures, packages, and triggers in PL/SQL
- Interacting with client’s Subject Matter Experts (SME) for Requirement and Design Related Issues
- Extensive Work on Autosys for Automated Job Scheduling.
- Development of Informatica Mappings & Workflows using Informatica to transport data to Oracle and Teradata targets.
- Transport of data using XML through Informatica to Oracle Target system.
- Created utility programs for file manipulations using UNIX Shell scripting.
- Worked on Mercury IT Governance center 6.0 (Kintana) for managing IT Processes including Change Management.
- Prepared Technical Specifications Document, Scope Verification Document and High Level & Low Level Design Documents based on thorough Understanding the Requirement Document.
- Enhancement to the existing applications developed in Oracle and Informatica.
- Involved in Performance Tuning for optimizing the jobs
- Conduct code walkthroughs and review peer code and documentation
- Work with developers, DBAs, and systems support personnel in elevating and automating successful code to production.
- Involved in Performance Tuning for optimizing the session Performance.
Environment: Oracle9i/10g, Teradata, HP-UNIX, Autosys for Automated Job Scheduling, TOAD, SQL Assistant, Informatica Power Center 7.1.2 and 8.5.1, UNIX Shell Scripting, PL/SQL, COBOL, Mercury IT Governance Center 6.0, SQL Navigator, SAP R/3, SAP-BW and XML.
