SUMMARY

• 7 years of extensive experience in Data Extraction, Data Transformation and Loading and 1 year of experience in Data Mining, Machine Learning.
• Experience in transforming business resources and tasks into regularized data and analytical models, designing algorithms, developing data mining and reporting solutions across a massive volume of structured and unstructured data.
• Worked on Natural Language Processing (NLP), Text Mining, Sentiment Analysis, Machine Learning algorithms including Linear Regression, Logistic Regression, Naive Bayes, Decision Tree, Random Forest, Ensemble Models, KNN and K - means clustering.
• Good knowledge in model validation and optimization with Model selection.
• Strong Data Warehousing ETL experience of using Informatica PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor.
• Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor), Power Exchange, Power Connect as ETL tool on Oracle, Netezza Databases.
• Worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Joiner, Update Strategy, Aggregator, Stored Procedure, Sorter, Sequence Generator etc.
• Worked extensively with slowly changing dimensions (SCD Type 1,2).
• Extensively worked with Informatica performance tuning involving source level, target level and map level bottlenecks.
• Understanding of Data warehousing concepts and Dimensional modeling (Star schema and Snowflake schema)
• Experience in working with relational databases such as Oracle and Netezza.
• Experience in writing complex SQL queries, PL-SQL procedures, views etc.
• Well versed in developing various database objects like Packages, Stored Procedures, Functions, Triggers, Tables, Indexes, Constraints, Materialized Views, Analytical and Database collections.
• Created Cursors and Ref Cursors in the PL/SQL Blocks.
• Worked on Dynamic SQL, Exception Handling, performance tuning of SQLQueries.
• Well experienced in writing complex views for the reporting team.
• Proficient in loading data from flat files into database tables using SQL*Loader scripts.
• Involved in SQL performance tuning.
• Worked on DBMS PROFILER to find out the performance bottlenecks in the pl/sql procedures.
• Experience in generating Tableau reports /dashboards.
• Strong experience in providing technical documentation and status reports of the applications as per the requirement.
• Involved in creating detailed Documentation HLD and LLD, which includes all Business requirements and technical specifications, also created Unit Test Plan (UTP) documents.
• Efficient in creating Test cases and performed data validation and process testing for application moving into production.
• Independently perform complex troubleshooting, root-cause analysis and solution development.
• Good communication, interpersonal, analytical skills and strong ability to perform as a part of team.
• Have quickly acquired the additional application skills to complete the Job.
• Worked in fast paced agile teams implementing scrum methodologies and thoroughly used Jira and Rally for sprint planning and tracking.

TECHNICAL SKILLS

Machine Learning Techniques: Linear Regression, Logistic Regression, Decision Trees, Random Forest, Gradient Boosting, Naïve Bayes, KNN,K - means Clustering, NLP

ETL: Informatica 8.6/9.1/9.6

Languages: Python(Pandas, Numpy, sklearn), PLSQL

Database: Oracle, MySql, Netezza, Microsoft SQL server

Data Visulaization Tools: Tableau, Matplotlib, seaborn

Tools: Oracle developer, Toad, Netezza Aginity workbench, Jupyter Notebook, Spyder,Jira

PROFESSIONAL EXPERIENCE

Confidential

ETL Developer

Responsibilities:

• Involved in creating detailed Functional Documentation which includes all Business requirements and Technical specifications.
• Interacted extensively with business users, Business Systems Analyst for requirements gathering and analysis
• Worked on Extraction, Transformation and Loading of data (ETL) using Informatica power center. Designed and developed ETL mappings to extract master and transactional data from heterogeneous data feeds and load.
• Developed Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.
• Created mappings, which involved Slowly Changing Dimensions (SCD 1, SCD2). Used md5 functions for the CDC (Change Data Capture)
• Responsible for the debugging, creating mapping, running maps etc. by using Informatica Power Center. Configured and running test session, workflow using Workflow Manager.
• Writing views, materialized views and generated dashboards, reports using Tableau

Confidential

ETL, PL/SQL Developer

Responsibilities:

• Involved in ETL development for new/enhancement components and prepared respective supporting documents.
• Designed, Developed and Supported Extraction, Transformation and Load Process (ETL) for data migration with Informatica power center.
• Used XML source qualifier and XML parser transformations to parse the data and load into staging tables.
• Involved in extracting the data from the Flat Files and Relational databases into staging area.
• Written stored procedures for validating the customers using KYC norms and used them in transformations. Developed mappings/sessions using Informatica Power Center for initial loading and incremental loading.
• Used web service transformations for currency conversions.
• Developed Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router. Created mappings, which involved Slowly Changing Dimensions.
• Developed reports using Tableau to present analysis to key stakeholders for efficient business decision making.

Confidential

ETL, PL/SQL Developer

Responsibilities:

• Developed procedures in Netezza to load the data from source to target in the current iteration. Developed database objects including tables, views, sequences.
• Created procedures to develop functionality. Created NZLOAD utility to load data from files into temporary staging tables. Created NZLOAD control files to load different data sets.
• Developed detailed Test cases for all Netezza procedures. Created NZSQL utilities to load into files when required.
• Involved in deploying the code to TEST/QA/PROD and supported QA/UAT issues within no time. Tracked defects on regular basis and fixed them without leading to new issues.
• Interacted with data mappers on the client side to get resolution/validate the issues while doing analysis. Involved in peer review of code/UTPs delivered by offshore.
• Helping the team members whenever they struck while doing coding and fixing the defects. KT sessions given to the new team members joined in the team.

Confidential

ETL Developer

Responsibilities:

• Developed PL/SQL procedures in oracle to load the data from source to target and executed them by creating packages in SSIS.
• Tuning the SQL queries for better performance, which are taking long time to load data into target tables.
• Developed detailed Test cases for all plsql procedures.
• Developed mappings/sessions using Informatica Power Center for initial loading and incremental loading.
• Developed Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.
• Created mappings, which involved Slowly Changing Dimensions.
• Involved in deploying the code to TEST/QA/PROD and supported QA/UAT issues within no time.