NAYANA ANGHAN

+1-850-***-****

adwosm@r.postjobfree.com

Public Trust Clearance

PROFESSIONAL PROFILE

A highly Experienced ETL Informatica Developer with 7 + years of IT experience in Data Warehousing technology and all phases of Software Development Life Cycle (SDLC) including Business Requirement Analysis, Application designing, Development, Implementations and Testing of Data warehousing and Database business systems for HealthCare Insurance, Financial and Banking domains, Department of Homeland Security.

Exposure in writing SQL using analytical functions like Ranking, case statement etc., also in writing optimize SQL query using ORACLE SQL Developer 21.2.1/ ORACLE 12c/11g/10g, SQL Server 2014/2017 and Teradata 15.

Excellent experience in designing and development of ETL Methodology using Informatica PowerCenter 10.5,10.4,10.2, 9.6.1/9.1.1

Interacted with end-users to identify and develop Business Requirement Document (BRD) and transform it into technical requirements.

Experience in Debugging and Performance tuning of targets, sources, mappings and sessions in Informatica.

Worked in Change Data Capture (CDC) Methodology using Informatica PowerCenter 10.5, 10.4/10.x/9. x.

Interacted with end-users and functional analysts to identify and develop Business Requirement Document (BRD) and transform it into technical requirements.

Worked extensively in design and analysis of Requirements, Development, Testing and Production deployment.

Prepared various types of documents like requirements gathering, ETL specification, Data Mapping, Test cases, Data dictionary etc.

Expert in writing SQL query using multiple databases like ORACLE, SQL Server, Teradata etc.

Extensive knowledge of Informatica tuning and SQL tuning.

Experience in integration of various data sources into staging area.

Performed Unit testing, System testing, Integration testing and users for UAT and prepared test report in different phases of project.

Extensive experience with Data Extraction, Transformation, and Loading (ETL) from Multiple Sources.

Designed and developed complex mappings, Mapplets, tasks and workflows and tuned it.

Experience in Debugging and Performance tuning of targets, sources, mappings and sessions in Informatica.

Good understanding of the Data modeling concepts like Star-Schema Modeling, Snowflake Schema Modeling.

Experience in optimizing the Mappings and implementing the complex business rules by creating re-usable transformations like Mapplets.

Extensively used Slowly Changing Dimension (SCD) technique in business application.

Experience in Performance tuning of ETL process using pushdown optimization and other techniques. Reduced the execution time for huge volumes of data for a company merger project. Heavily created mapplets, user defined functions, reusable transformations, look-ups.

Conducted Unit tests, Integration tests and Customer Acceptance tests (UAT).

Excellent communication skills, ability to communicate effectively with executive and management team, having strong analytical, problem-solving skills.

Working experience in Agile and Waterfall methodologies.

A natural communicator with strong analytical and organizational skills, constantly seeking new opportunities to learn and keep up with the latest technology.

A highly motivated and capable professional, able to prioritize and manage multiple projects with ease, delivering results under pressure and with minimal supervision.

TECHNICAL SKILLS

Operating Systems: LINUX/UNIX, Windows, Windows server, Mac.

Project Methodologies: Waterfall, Agile (Scrum)

Scheduling Tools Control-M, Informatica scheduler

MS office tool Microsoft Visio, Microsoft Project, Microsoft SharePoint, Microsoft

Project Tracking Tool JIRA, Rally

Databases Teradata, Oracle Database, MS SQL Server, DB2,

ETL Technology Informatica PowerCenter 10.5, 10.4,10.2/9x/8x.

Methodologies Agile (SDLC), Waterfall, JIRA

BI Reporting Tableau 2021.2/2020, Cognos 9

EDUCATION

Bachelor Of Commerce from Saurashtra University Rajkot, Gujrat, India.

Diploma Computer Science from Saurashtra University Rajkot, Gujrat, India.

Bachelor of laws from Saurashtra University Rajkot, Gujrat, India.

Master from Saurashtra University Rajkot, Gujrat, India, 2009

WORK HISTORY / EXPERIENCE

Octo Consulting/An IBM company March 2022 – Present

Department of Homeland Security

Informatica Developer/Data Engineer /Computer Systems Analyst

Description: Department of Homeland Security is the U.S. federal executive department responsible for public security, roughly comparable to the interior or home ministries of other countries. The Department's work includes customs, border, and immigration enforcement, emergency response to natural and manmade disasters, antiterrorism work, and cybersecurity.

Responsibilities:

Involved in all phases of SDLC from requirement gathering, design, development, testing and support for production environment.

Developed Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data of a star schema.

Analysis, requirements gathering, functional/technical specification, development, deploying and testing.

Extensive use of Informatica Tools like Designer, Workflow Manger and Workflow Monitor.

Designed and created mappings to extract data from different data sources (Oracle, PostgreSQL, and SQL server DB’s, flat file loads) to a staging Data warehouse for reporting.

Developed the 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 Sessions and extracted data from various sources, transformed data according to the requirement and loading into data warehouse.

Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mappings in the Informatica Power Center Designer.

Developed several reusable transformations and mapplets that were used in other mappings.

Prepared Technical Design documents and Test cases.

Extensively worked on Unit testing for the Informatica code using SQL Queries.

Implemented various Performance Tuning techniques.

Designed and developed complex ETL mappings making use of transformations like Source Qualifier, Joiner, Update Strategy, Lookup, Sorter, Expression, Router, Filter, Aggregator and Sequence Generator transformations.

Wrote SQL queries to view and validate the data loaded into the warehouse.

Developed transformation logic as per the requirement, created mappings and loaded data into respective targets.

Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning.

Used PMCMD command to run workflows from command line interface.

Improved performance testing in Mapping and the session level.

Involved in testing and migration of Informatica ETL mappings from Development and Test environments into the Production environment (using SDLC methodologies)

Monitor Informatica jobs using Informatica Workflow Monitor to ensure successful completion of loads.

Built the Data Warehouse Staging and Target tables and created views for reporting.

Tested and migrated ETL mappings from Development and Test environments to the Production environment, following SDLC methodologies.

Monitored jobs using the Workflow Monitor to ensure successful completion of loads.

Troubleshot and resolved any broken or failed loads.

Modified and optimized current mappings for efficient data loads.

Designed and created mappings to extract data from different data sources (Oracle, PostgreSQL, and SQL server DB’s, flat file loads) to a staging Data warehouse for reporting.

Developed Informatica sessions using Informatica workflow manager to run PowerCenter mappings/mapplets.

Identifies and fixes bottlenecks with issues regarding email notifications in Informatica.

Provides production support and fixes delays and failures in Informatica sessions and workflows.

Creates technical validation rules that are used to create data models in ETL mappings.

Performs peer code review for projects developed by other developers.

Makes extensive use of workflow manager for session management, database connection management and scheduling of jobs.

Creates high-level, low-level design, ETL specification, data model, and test document.

Actively participates in deployment activities and ensures the user expectations are met.

Adheres to the Informatica naming convention in all object definitions and ensures Informatica standards are maintained.

Identifies and fixes bottlenecks with issues regarding email notifications in Informatica.

Creates technical validation rules that are used to create data models in ETL mappings.

Develops workflows in Informatica to query necessary views in the Oracle database and generates a file that serves as a baseline for analysis.

Updates data sources using TabCMD in Informatica along with the rest of other data sources so that the most recent data set can be viewed and refreshed in Tableau.

Performs extensive debugging to identify mapping bottlenecks.

Performs Unit Testing, System testing to ensure accuracy of data loads from different databases and flat files into target tables.

Continuously provides helping hands to other developers on development issues as needed.

Performs peer code review for projects developed by other developers.

Environment: Informatica PowerCenter 10.5, Oracle SQL Developer 21.2.1, Tableau 2021.2.2, Shell Scripting, SharePoint, Informatica scheduler

Client: Anthem, Inc, Chicago, IL Mar 2020 to Mar 2022

Role: ETL Informatica Developer

Description: Anthem provides health insurance services. The company offers a variety of insurance products for all segments of the population including large employer groups, small businesses and individuals.

As a part of this project data is being collected from all servicing originations Application systems, databases like oracle, flat files, mainframe files. Data is migrated from all various sources into ingested to Teradata staging table, and then pushed to the target system, Data is cleansed, and transformed based on the business rules thru ETL tools Informatica.

Responsibilities:

Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.

Actively involved in interacting with business users to record user requirements and Business Analysis.

Outlined the complete process flow and documented the data conversion, integration and load mechanisms to verify specifications for this project.

Parsing high-level design spec to simple ETL coding and mapping standards.

Worked with PowerCenter Designer tools in developing mappings and Mapplets to extract and load the data from flat files and SQL server database.

Maintained warehouse metadata, naming standards and warehouse standards for future application development.

Created the design and technical specifications for the ETL process of the project.

Used Informatica as an ETL tool to create source/target definitions, mappings and sessions to extract, transform and load data into staging tables from various sources.

Responsible for mapping and transforming existing feeds into the new data structures and standards utilizing Router, Lookups Using Connected, Unconnected, Expression, Aggregator, Update strategy & stored procedure transformation.

Worked with various complex mapping, designed slowly changing dimension Type1 and Type2.

Performance tuning of the process at the mapping level, session level, source level, and the target level.

Created Workflows containing command, email, session, decision and a wide variety of tasks.

Tuning the mappings based on criteria, creating partitions in case of performance issues.

Performed data validation after the successful End to End tests and appropriate error handling in ETL processes.

Resolving the tickets based on the priority levels raised by QA team.

Developed Parameter files for passing values to the mappings as per requirement.

Scheduled batch and sessions within Informatica using Informatica scheduler and also customized prewritten shell scripts for job scheduling.

Environment: Informatica PowerCenter 10.2, Tableau 2020.3, Unix, TOAD, Microsoft SQL Server 2018, Control M, Shell Scripting, SharePoint, Confluence

Client: Edward Jones, Chicago, IL Sept 2017 to Mar 2020

Role: Sr. Informatica Developer

Description: Edward Jones helps clients achieve their long-term financial goals by understanding their needs and implementing tailored solutions. To ensure a personal client experience, they have located 14,000+ branch offices. The objective of this project is to enrich data from new sources into existing IDW i.e., integrated data warehouse to enable improved decision-making, strategic plans, support and solutions that favorably impact costs, quality of care, outcomes, and customer satisfaction through an information-driven environment that leverages their integrated data assets for competitive advantage.

Responsibilities:

Worked with the business team to gather requirements for projects and created strategies to handle the requirements.

Documented Data Mappings/ Transformations as per the business requirement.

Worked on project documentation which included the Technical and ETL Specification documents.

Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.

Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.

Involved in extracting the data from the Flat Files and Relational databases into staging area.

Mappings, Sessions, Workflows from Development to Test and then to UAT environment.

Developed Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data of a star schema.

Developed the 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 Sessions and extracted data from various sources, transformed data according to the requirement and loading into data warehouse.

Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mappings in the Informatica Power Center Designer.

Imported various heterogeneous files using Informatica Power Center 8.x Source Analyzer.

Developed several reusable transformations and mapplets that were used in other mappings.

Prepared Technical Design documents and Test cases.

Extensively worked on Unit testing for the Informatica code using SQL Queries.

Implemented various Performance Tuning techniques.

Designed and developed complex ETL mappings making use of transformations like Source Qualifier, Joiner, Update Strategy, Lookup, Sorter, Expression, Router, Filter, Aggregator and Sequence Generator transformations.

Wrote SQL queries to view and validate the data loaded into the warehouse.

Developed transformation logic as per the requirement, created mappings and loaded data into respective targets.

Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning.

Used PMCMD command to run workflows from command line interface.

Improved performance testing in Mapping and the session level.

Environment: Informatica PowerCenter 9.6, SQL Server 2016, MySQL, Shell Scripts, SQL, UNIX, Toad, SQL Developer, tableau, Control M

Client: Stericycle, Bannockburn, IL Jun 2016 to Sept 2017

Role: Informatica Developer

About Client: Stericycle is the industry-leading compliance company for healthcare organizations, patients, and commercial businesses of every size – serving customers in the U.S. and countries worldwide. The company serves healthcare businesses, including hospitals, physician and dental practices, outpatient clinics, long-term care facilities, etc.; retailers and manufacturers; financial and professional service providers; governmental entities; and other businesses. The objectives and outcomes of this programs is to build a data warehouse by consolidating data from a variety of systems into a central data warehouse and storing historical information for building executive report and dashboards.

Responsibilities:

Analysis, requirements gathering, functional/technical specification, development, deploying and testing.

Extensive use of Informatica Tools like Designer, Workflow Manger and Workflow Monitor.

Extensively used Informatica client tools like Source Analyzer, Mapping designer, Mapplet Designer, Transformation Developer, and Informatica Server Manager.

Used transformations like Aggregators, Sorter, Dynamic lookups, Connected & unconnected lookups, Filters, Expression, Router, Joiner, Source Qualifier, Update Strategy, sequence Generator.

Created reusable transformations and mapplets to use in multiple mappings.

Used Workflow Manager/Monitor for creating and monitoring workflows and worklets.

Designed and coded the automated balancing process for the feeds that goes out from data warehouse.

Extensively used mapping parameters, mapping variables and parameter files

Analyzed the query performance and designed the loading process schedules.

Wrote the shell scripts to process the PL/SQL procedures and wrote the PL/SQL program units for data extracting, transforming and loading.

Involved in troubleshooting the loading failure cases, including database problems.

Worked on tuning SQL statements.

Environment: Informatica PowerCenter 8.6.1, Tableau 9.2, Cognos 9, SQL Server 2012, Oracle 11g, TOAD, Putty, Control M, UNIX, Teradata 15, Erwin 7.5, WinSCP

REFERENCES

Available upon request.

Contact this candidate