Informatica Developer Business Analyst

Priya Patel

*****.***.***@*****.*** +1-717-***-****

OBJECTIVE

To pursue a career full of challenges which provides me ample opportunities to learn and grow, at the same allowing me to fully utilize my capabilities to dedicate myself to the organization and add value to it by sincere efforts.

PROFESSIONAL SUMMARY:

● 7+ years of extensive experience includes end-to-end implementation of Data Warehouse/Business Intelligence (BI)/Analytics projects using Informatica PowerCenter 10.x/9.x,

● Hands-on experience in all stages of Software Development Life Cycle (SDLC) using Agile and Waterfall model including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing, deployment and maintenance.

● Experienced in designing logical & physical models of the Data Marts/Data Warehouse with multi-dimensional data models star, snowflake and Databases using relational models with Erwin/Toad Data modeling tool.

● Experience with T-SQL/PL-SQL, SQL Server/Oracle in creating Tables, Views, Scripts, Indexes, Triggers, Complex stored procedures, User Defined Functions, Relational Database Models and Data Integrity in observing Business Rules.

● Extensive experience in data warehousing techniques for Data cleansing, Slowly Changing Dimension (SCD) Type I, II & III and Change Data Capture (CDC).

● Expert in designing and developing Data pipelines for integrating data from heterogeneous sources (Excel, XML, CSV, IBM MQ, Relational databases, flat files) by using multiple transformations/packages provided in Informatica Power Center, SSIS, Python.

● Excellent understanding of Data structures and algorithms.

● Experience in Performance tuning of ETL tools and databases to overcome performance bottlenecks.

● Experience in 24X7 production support, ETL executions, and Defects-root causes analysis.

● Good understanding and knowledge of NOSQL databases like MongoDB.

● Basic understanding with cloud environments like Amazon Web Services (AWS).

● Confident in working independently and proactively. Strong leadership, good communication and excellent interpersonal skills, problem-solving and multi-tasking abilities.

TECHNICAL SKILLS:

Languages Core Java, C#, T-SQL, PL/SQL, Unix and Python 3.6. ETL Tools Informatica 10.x,9.x, SQL Server Integration Service (SSIS) Reporting and Profiling

Tools

Power BI, SQL Server Reporting Service, Tableau, Qlik Sense Operating Systems Windows 7, Windows 10 and Linux

Databases SQL Server 2019/2017/2012/2008R2, My-SQL, Oracle 11g, DB2. Frameworks Apache Spark 1.6/2.00, Python FLASK.

Other Tools XML Spy, MS Office, Subversion, TFS, and SSDT. PROFESSIONAL EXPERIENCE:

The Vitamin Shoppe, NJ Nov 2019 – Present

Informatica Developer

The Vitamin Shoppe (formerly Vitamin Shoppe Industries, Inc., stylized as The Vitamin Shoppe) is an American, New Jersey-based retailer of nutritional supplements. Responsibilities:

● Involved in design, development, and maintenance of star schema for Data warehouse project.

● Participated in the creation of the logical & physical data models of the data warehouse as per the business requirements.

● Involved in Business Users/Architect Meetings to understand their requirements.

● Designed, Developed and Supported Extraction, Transformation and Load Process

(ETL) for data migration with Informatica 10.x and SSIS.

● Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.

● Created complex mappings which involved Slowly Changing Dimensions, implementation of Business Logic and capturing the deleted records in the source systems.

● Worked extensively with the connected lookup Transformations using the dynamic cache.

● Worked with complex mappings having an average of 15 transformations.

● Developed dependencies and scheduled Jobs based on demand, time popped.

● Monitored Workflows and Sessions using Workflow Monitor.

● Performed Unit testing, Integration testing and System testing of Informatica ETL code/Pipelines.

● Designed and tested PL/SQL and T-SQL scripts.

● Designed UNIX shell scripting for ETL Automation.

● Created and maintained a runbook for the production support team.

● Knowledge of version control practices and procedures (GIT) Project Environment:Informatica Power Center, MS SQL Server 2019/2017, SQL server Reporting Services 2017, SQL Integration Services 2017, Microsoft Visual Studio 2017, SQL Server Management Studio 2017, MS Excel, T-SQL.

Dassault Falcon Jet, USA Dec 16– Nov 19

SQL /ETL

Dassault Falcon is the recognized global brand for Dassault business jets that are designed, manufactured and supported by Dassault Aviation and Dassault Falcon Jet Corp. The projects were aimed at building a data warehouse for sales, orders and purchases to better analyze the business processes and to provide a centralized system accessible to the users around the world to generate the reports and other data. Further develop Business Intelligence/Analytics solution on the Data by creating report/dashboard and other maintenance tasks to support DW/BI. Responsibilities:

● Participated in technical solutions design sessions with the team on assigned projects.

● Worked with Project Manager and Business Analyst in understanding the requirement and architect a data flow system.

● Worked on Data Modeling for creating the dimension and fact data structures using Star and Snowflake schema for the Data Mart/Data Warehouse using Toad Data Modeler.

● Conducted data profiling and analyze results (e.g. analyze data quality, identify data gaps) for the source data.

● Developed technical design documents (both low level and high level), mapping specifications (source to target mapping docs) and unit testing documents.

● Involved in building the ETL architecture and STTM to load data into the Data warehouse.

● Extensively used Informatica Power center 9.x, Python and SSIS to extract the data from different sources like Flat files, XML files, IBM MQ Sources and MS SQL Server and Transform them as per business logic and load into Oracle and SQL Server.

● Transformed, cleaned and delivered the source data to the Data Science team as per requirement for their ad-hoc analysis.

● Develop ETL deployment plan and ETL operations manual to coordinate and drive ETL activities in Test and Production environment.

● Designed Error Handling and Audit Framework Architecture for ETL/Data pipelines.

● Worked on the Data Quality certification queries for data marts.

● Automated data pipelines which consume and expose/integrate data to different applications using Python.

● Implement CR/Enhancements of existing DW/Data pipelines.

● Analyzed and resolved defects in Production.

Project Environment: Informatica Power Center, MS SQL Server 2014, Oracle 11g,SSIS, SSRS, SSMS 2014, Web focus, UNIX, and MS-office, Developer Studio 8.2. DatotaHost, India Aug 11 – Jul 13

SQL Developer

Responsibilities:

● Create database objects like Tables, Stored Procedures, Triggers, Functions etc. using T-SQL to provide structure to store data and to maintain the database efficiently.

● Responsible for optimizing all indexes, SQL queries, stored procedures to improve performance.

● Implement the error handling in the stored procedures and SQL objects and modify already existing stored procedures, triggers, view, indexes depending on the requirement.

● Reverse engineer backend database to change the T-SQL scripts, create Views, Index, Stored Procedures, Triggers, CTE, Constraints and, UDF to improve performance drastically.

● Use DDL and DML Triggers, Stored procedures to check the Data Integrity and verification at early stages before calling them.

● Develop a report using SSRS based on the end user’s requirements. Project Environment: MS SQL Server 2012, SSRS, SQL Server Management Studio, Toad, batch scripts, and Excel.

EDUCATIONAL QUALIFICATIONS:

Bachelor’s in Computer Science North Maharashtra University, Maharashtra, India June 2010. References Available Upon Request

Contact this candidate