Jhansirani

469-***-****

adzy5k@r.postjobfree.com

Professional Summary:

Over 8.5 years of Experience in Design, Development, Testing, Deployment and Support of various Data warehouse technologies including Informatica, Oracle, MySQL, UNIX Shell Scripting, PL/SQL, Autosys, and Snowflake. Additionally possesses extensive knowledge of working in Agile methodology and Git, bitbucket, Jenkins, JIRA.

Good experience in Data warehouse concepts, ETL, data modeling experience using Normalization, Business Process Analysis, Dimensional Data Modeling, Physical & Logical data modeling.

Good experience of data integration best practices and demonstrated ability to effectively coordinate diverse data sources.

Design and Development of Data warehousing solutions and in developing strategies for Extraction, Transformation and Loading (ETL) mechanism using Informatica.

Performance tuning and optimization of the complex SQL’s.

Good working experience of ETL/Informatica standards and best practices, Slowly Changing Dimensions (SCD1, SCD2).

Expertise in sourcing the data from various Relational database systems like Oracle and MySQL

Good knowledge in DWH concepts, Dimensional data modeling, Star schema & Snowflake schema

Peer reviews and migrating code from Dev to Test, UAT and Production environments and providing go live support till the system is stabilized.

Learned to use Confluence, Jira, Git, Artifactory and Hudson/Jenkins.

Working with RDBMS including Oracle, MySQL.

Enough experience in AGILE (Scrum) Methodology, participated in daily scrum meetings, and being actively involved in sprint planning and product backlog creation.

Exceptional analytical and problem-solving skills, good team player with excellent interpersonal and communication skills.

Technical Skills:

Data Integration Tools: Informatica Power Center, IICS

Databases: Oracle, SQL server, MySQL

Programming Languages: PL/SQL, Shell scripting

Tools: SQL Developer, Control-M/Autosys, Bitbucket, Confluence, Jira, Putty, WinScp

Analytics: QlikView, Tableau, MS Excel

Project Execution Methodologies: Agile

Operating Systems: Unix, Windows

Educational Qualifications:

Master of Computer Applications (MCA), 2011 from JNTU, Kakinada, Andhra Pradesh

Bachelor of Science (Mathematics), 2008 from Acharya Nagarjuna University, Guntur, Andhra Pradesh.

Professional Experience:

Farm Bureau Insurance of Michigan (FBMI) – Lansing, MI Mar 2022 – Current

Role: Sr ETL Developer

Responsibilities:

Interacted with functional/ end users to gather requirements of core reporting system to understand exceptional features users expecting with ETL and reporting systems and to successfully implement business logic.

Involved in data analysis of source and target systems and good understanding of data warehouse concepts, staging tables, dimensions and facts, star, and snowflake schemas.

Create mappings, mapping tasks, Data tasks, Sub Taskflows and Taskflows to pull data from flat files and Databases like Oracle and SQL Server

Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Warehouse

Good experience with shell scripting in Unix environment.

Extensively used ETL to load data from flat files which involves both fixed width and delimited files and from the relational databases, which was oracle 9i/10g.

Responsible for design reviews with Architects.

Following Agile methodology using Jira for tracking progress.

Keeps track on all the assigned stories and updates all the stories and makes sure they are completed before the sprint.

Experience working with data modelers to translate business rules/requirements into conceptual/logical dimensional models and worked with complex de-normalized data models.

Environment: Informatica, IICS, SQL, Oracle, SQL Developer, Unix, Git, Bitbucket, Control-M, Shell Script, Windows, PuTTY, WinSCP

Northbridge Financial Corporation July 2019 – Mar 2022

Role: Sr ETL Developer

Responsibilities:

Design and Develop Informatica mappings and workflows to load the data from various sources using different transformations like Source Qualifier, Aggregator, Expression, Lookup, Unconnected Lookup, Filter, Normalizer, Router, Joiner, Update, Union, and Rank transformations.

Develop workflows using sessions, command, decision, and control and Email tasks.

Load data from flat files, Oracle databases working with SQL Override in the Source Qualifier and Lookup transformation.

Implementing mapping using Update Strategy DD_INSERT, DD_UPDATE to insert and update data for implementing the Slowly Changing Dimension Logic.

Developing Slowly Changing Dimensions SCD1, SCD2

Performance tuning at ETL level & Database level using various techniques like push down optimization & Session partitioning.

Analyze existing system and develop business documentation on changes required.

Doing peer reviews for deliverables like documentation & Code

Build and deploy application, test and release to next environments, run the loads and monitor till loads stabilized and give support to business in reports

Works on Bugs/Enhancement requests raised by business team

Environment – Informatica Power Center, Oracle, Oracle SQL Developer, JIRA, MS Excel, PuTTY, WinSCP

Wawanesa Mutual Insurance Company Dec 2017 – Jun 2019

Role: ETL Developer

Responsibilities:

Involved in building the ETL Framework, Source to Target mappings to load data into Data warehouse system.

Worked on loading flat files to Informatica as sources.

Co-ordinated with Informatica Admin team to promote code from lower Environment using Informatica Deployment Groups.

Created ETL Mappings, Mapplets, Workflows, Worklets using Informatica PowerCenter and prepare corresponding documentation.

Involved in Root cause Analysis (RCA) and come up with solution for frequent repetitive errors in Production Environment and make the application stable.

Designed and Maintained complex ETL Mappings and performed unit testing on the developed code.

Participated in meetings with cross functional teams and coordinated in fixing bugs in application.

Developing the test plan, conducting testing, and dealing with business partners to perform end-user testing.

Involved in post-production support.

Provide support to the QA team and coordinate for various phases of testing.

Environment – Informatica Power Center, Shell Script, Windows, PuTTY, WinSCP, Oracle, JIRA, TOAD, MS Excel

InsPro Technologies Corporation – Eddystone, PA Nov 2014 – Jun 2017

Role: ETL Developer

Responsibilities:

Interacted with the Technology Risk team and participated in the development of new solutions to further advance the maturity and risk reporting capabilities.

Provided insights about the weekly and monthly updates to the leadership team and gathered functional and non-functional requirements and enhanced the process.

Develop workflows using sessions, command, decision, and control and Email tasks.

Process large volume of Electronic Medical Records(EMR) coming from EPIC to create Dimensions for patients, providers, payers, diagnosis, procedures.

Load data from flat files, Oracle databases working with SQL Override in the Source Qualifier and Lookup transformation.

Implementing mapping to insert and update data for implementing the Slowly Changing Dimension Logic

Developing Slowly Changing Dimensions Mapping Type 2 SCD using MD5

Performance tuning at ETL level & Database level using various techniques like push down optimization & Session partitioning.

Analyze existing system and develop business documentation on changes required.

Doing peer reviews for deliverables like documentation & Code

Environment: Informatica, Oracle, MySQL, PL/SQL, Unix, SQLite, SQL Developer, Shell Script, Windows, PuTTY, WinSCP, Autosys

Contact this candidate