Jhansi Rani

ETL Developer

adycxk@r.postjobfree.com

469-***-****

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, UNIX shell scripting

Tools SQL Developer, Autosys, Bitbucket, Confluence, Jira, Putty, WinScp

Analytics QlikView, Tableau, MS Excel

Project Execution Methodologies Agile

Operating Systems Unix, Windows

EDUCATION

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:

Client: Farm Bureau Insurance of Michigan Mar 2022 – Current

Role: Sr ETL Developer

Technologies: Informatica, SQL, Oracle, SQL Developer, Putty, WinScp, Unix, Git, Bitbucket, Control-M

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 the progress.

Keeps track on all the assigned stories and updating all the stories and making 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.

Capgemini Nov 2014 – Mar 2022

Role: ETL Developer

Client: InsPro Technologies Corporation

Technologies: Informatica, Oracle, MySQL, PL/SQL, Unix, SQLite, SQL Developer, Putty, WinScp

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 gather functional and non-functional requirements and enhance 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

Contact this candidate