ETL Developer

Rutul Shah

**********@*****.***

Cell: 972-***-****

Professional Summary:

Around 13+ years of ETL Design and development experience using Informatica Power Center 10.x/9.x/8.x, Informatica Data Quality (IDQ) 9.x and Informatica Cloud

Proficient in Design and Development of process required to extract, Transform, Load data to the data warehouse using Informatica Power Center 10.x/9.x/8.x/7.x

Knowledge of data warehousing techniques, Star / Snowflake schema, ETL, Fact and Dimension tables, Physical and logica data modeling, OLAP and Report delivery methodologies.

Knowledge of data warehousing techniques, Star / Snowflake schema, ETL, Fact and Dimension tables, Physical and logical data modeling, OLAP and Report delivery methodologies

Have knowledge on Informatica 9.x architecture and have good admin knowledge like configuring various services, taking back up, restoring Backups and user level operations.

Good experience in Production Support, Identifying root causes, Trouble shooting and Submitting Change Control

Experienced in development and data load into Bigdata - Hadoop HDFS using Informatica PowerCenter and Hive

Working knowledge on Oracle 11g, SQL Server, Teradata, Netezza, DB2, MY SQL, Paraccel and UNIX shell scripting

Proficient in writing Oracle complex/analytical queries and PL SQL code

Have Experience on Teradata Utility scripts like BTEQ, FastLoad, MultiLoad and Fast Export to load data from various source systems to Teradata.

Strong experience on Teradata Parallel Transporter (TPT) to extract or loads data using system operators

Strong experience in working with UNIX Shell Script to automate the processes used in ETL, Archiving the Source/Target files, Purging the different directories in the environment.

Strong ETL experience in using Informatica Power Center client tools such as Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager in executing simple, medium and complex logics with minimum transformations with best performance.

Have experience in merging multiple data marts into single data mart as per automation process to reduce ETL process and DB load as well.

Involved in Unit Test Case, Integration Test, User Acceptance Test (UAT)

Strong experience in creating Domains, Relationships, Indexes, Templates, Forward/Reverse Engineering, etc using Erwin Data Modeler

Strong understanding of Software Development Life Cycle (SDLC) and Enterprise Architecture Framework, Agile and Waterfall Methodologies.

Experience with coordinating and leading onsite-offshore development

Excellent team player with very good communication skills and leadership qualities.

Technical Skills:

ETL Tools

Informatica MDM 10.x/9.x, Informatica Power Center 10.x/9.x/8.x, Informatica IDQ 9.1.0 and 9.6.1, Informatica Power Exchange 9.5.1, Informatica Cloud Services (IICS)

Source Code Control

Version Manager, Tracker, SVN and CVS

Databases

Oracle 12C/11g, 10g/9i/8i, MS SQL Server 2005, 2008, 2008R2 and 2012, Netezza 7.x, SAP HANA, SAP BW, Veeva, Teradata 13, 12, DB2 9

Database Utilities

Toad, sql developer, SQL*Loader, Embracedo Rapid SQL, DBArtician

Scheduling Tools

JAMS, DAC, Appworx, CA7 and Autosys.

Scripting

UNIX Shell, Python and Perl

Languages

C, C++, Visual Basic, SQL, PL/SQL.

Operating Systems

Windows HP-UX, UNIX, IBM AIX 4.3/4.2 and Sun Solaris, Red Hat Linux, Ubuntu Linux, Z/OS, Mac OS X

Cloud Computing

Cloud Computing: Amazon Web Services (AWS), S3, Redshift

Education:-

Bachelors in Computer Science JNTU Hyderabad 2004-2008

Professional Experience:

Rivian Feb 2020 – Present

Senior Informatica Cloud Consultant

Phoenix/AZ

Design, Develop, Test and Implement of ETL processes using Informatica Cloud.

Support system and user acceptance testing activities, including issue resolution.

Develop reusable integration components, transformation and logging processes.

Developed Informatica Rest API connectors for ServiceNow and MS Dynamics.

Created API Task Process to integrate MS Dynamics to ServiceNow.

Use PostMan to develop/test Rest API process.

Updated MIT and DST processes to rename and archive objects using PRE & POST processing commands.

Created, tested, and implemented Integration task process which uses MIT & DST to pick up file from client site, rename, archive, and place it in ECC folder for SAP process.

Design and development of Informatica mappings which involves XML files, Flat files, Oracle &AWS Redshift tables.

Complete technical documentation to ensure system is fully documented.

Informatica cloud (IICS) to design and developed complex ETL mappings making use of transformations like Source Qualifier, Joiner, Update Strategy, Connected Lookup and unconnected Lookup, Expression, Router, Filter, Aggregator and Sequence Generator.

Participate in the design standard discussions with Architects and team members.

Worked in AWS Redshift database for designing tables, loading data.

Used Amazon S3 for loading data from flat files/ Sql Server to AWS Redshift.

Integrated IICS with other applications like salesforce, AWS S3 and databases like MongoDb, Oracle, DB2, SQL server, Teradata.

Developed mapping using the Informatica Cloud Services for synchronizing customer data with the SFDC account object.

Extract Transform and Load data from sources Systems to Azure Data Storage services using a combination of Azure Data factory, T-SQL, Spark SQL, and U-SQL Azure Data Lake Analytics. Data ingestion to one or more Azure services (Azure Data Lake, Azure Storage, Azure SQL, Azure DW) and processing the data in Azure Data bricks

Develop Spark applications using pyspark and spark SQL for data extraction, transformation, and aggregation from multiple file formats for analyzing and transforming the data uncover insight into the customer usage patterns

Hands on experience on developing SQL Scripts for automation

Responsible for estimating the cluster size, monitoring, and troubleshooting of the azure data bricks cluster

Working as Sr Informatica /MDM architect in Analysis, Design, Development and Implementation of Enterprise Information Management solutions using Informatica MDM/MDM SaaS, IDMC/Informatica Intelligent Cloud Services, CDQ/Informatica Data Quality, CDI/Informatica ETL Power center, Repository Admin Console, Repository Manager, Designer, Datamart, OLAP, OLTP. Experience in all phases of Software Development Life Cycle (SDLC).

Installation of Control M Servers / Agents version on UNIX and Windows environment. Consulting & Configuration of the Control-M Agent / Server based upon the need of the Application Team And Project for which Control M was being implemented.

Maintaining Control-M database, Control-M server and Control-M EM server.

Performing Troubleshooting of various Control-M Gateway Issues.

Successfully led the upgrade project from Informatica Power Center 10.2 to 10.6.

Conducted a thorough analysis of the new features and enhancements in version 10.6 to leverage the benefits for the organization.

Developed a detailed upgrade plan outlining the steps, timelines, and resources required for a smooth transition.

Collaborated with cross-functional teams to ensure minimal disruption during the upgrade process.

Implemented and tested the upgrade in a sandbox environment to identify and resolve any compatibility issues.

Executed the upgrade process following best practices and ensuring data integrity and security.

Provided training and support to end-users to familiarize them with the new features and functionalities of Informatica Power Center 10.6.

Documented the upgrade process, including any challenges faced and solutions implemented, for future reference and knowledge sharing.

Ensured post-upgrade support and troubleshooting to address any issues that arose after the transition to version 10.6.

Demonstrated strong technical skills and expertise in Informatica Power Center by successfully completing the upgrade project.

I have extensive knowledge and experience in using ETL tools such as Informatica, IICS/IDMC

Extensively worked with Informatica products Informatica Intelligent Cloud Services (IICS/IDMC), Informatica Power Center, Data Quality, Power Exchange

Extensively worked on building Service Connectors, application connection and process objects that are used for the development of ICRT/IICS/IDMC processes

Experience with Informatica’ s Data Governance products (e.g. Informatica Axon, Informatica Data Quality)

Developed and managed Product 360 solutions to ensure comprehensive and accurate product data management.

Deployed and managed cloud infrastructure on AWS, ensuring high availability and scalability.

Utilized AWS services such as EC2, S3, RDS, and Lambda for various data integration and processing tasks.

Implemented security best practices on AWS, including IAM roles, VPC configurations, and data encryption.

Designed and implemented data warehousing solutions using Snowflake, optimizing performance and storage.

Developed ETL processes to load data into Snowflake from various sources, ensuring data integrity and accuracy.

Utilized Snowflake's features such as time travel, cloning, and data sharing for efficient data management.

Monitored and maintained system performance and reliability using tools like Nagios, Prometheus, and Grafana.

Facilitated collaboration between development and operations teams to improve software delivery and quality.

Collaborated with cross-functional teams to deliver high-quality software solutions in iterative cycles.

Adapted to changing requirements and priorities, ensuring timely delivery of project milestones.

Proficient in using Informatica Intelligent Data Management Cloud (IDMC) for comprehensive data integration and management solutions.

Experienced in leveraging IDMC for cloud-native data integration, data quality, and data governance.

Skilled in utilizing IDMC's AI-driven automation to streamline data workflows and enhance efficiency.

Hands-on experience with IDMC's data integration capabilities, including ETL (Extract, Transform, Load) processes.

Expertise in managing and orchestrating data pipelines using IDMC for real-time and batch data processing.

Knowledgeable in implementing data quality rules and monitoring data health through IDMC's advanced tools.

Brookdale Senior Living April 2018 –Feb 2020

Senior Informatica Lead Consultant

Brentwood, TN

As an Informatica Administrator, involved in designing system solutions, implementing new features and resolving complex incidents and problems.

Upgraded Informatica PowerCenter and PowerExchange CDC from 9.6.1 to 10.2.

Installation and Configuration of Informatica Products on Redhat Linux 6.x (PowerCenter 9.x, BDM 10.x, EDC, Power Exchange, CDC Publisher on Linux Servers).

Did the Informatica Enterprise data catalog (EDC) and Axon installation in both embedded and external clustered environments.

Configured SSL and also enabled Kerberos on Informatica Enterprise data catalog (EDC) and Axon in both embedded and external clustered environments.

Installed and configured Informatica monitoring tools such as Proactive Monitoring tool and Operational Insights.

Build self-service pages for developers for creating connection, adding users to group and adding folders in Informatica using the HPOO tool.

Created shell script for monitoring Informatica nodes and services and implemented Auto Healing and Auto ticketing in case of failures.

Created scripts to backup repositories, truncate the logs in repository, cleanup the old files from the file systems and purging the old versions of code.

Used Informatica Analyst for data profiling, Score carding to bring data quality issues upfront and then developed Informatica BDM jobs/workflows to operationalize the data delivery to data scientists.

Created dynamic BDM mappings to take care of dynamic schemas on read and write.

Executed BDM jobs on various execution engines like spark, Hive/Map-Reduce and Blaze

Extensively worked on performance tuning of long running workflows.

Worked with Offshore teams on tuning the file system I/O and resource usages on the Informatica servers.

Worked on improving the stability and monitoring of Informatica RC environment.

Worked on Audit item by creating formal process to review personal and non-personal ID’s, to verify that they still have a valid need to for access.

Implemented BCP/DR plan for Informatica.

Installed database drivers and testing connections to external systems from Informatica.

Gathering the requirements for the Informatica Power Center Install on Servers.

Responsible for Power Center and Power Exchange installations, configuring Power Center Domain, nodes, Grids and Create Different services in the Domain.

Configure the Security (LDAP), enabling the OS profiles and Applying Patches on the base install.

Creating Users, Groups, Roles and grant privileges to the users. Create folders, Relational and Application connections and to configure the various connections.

Participated in team meetings and proposed ETL Strategy and provide them best practices.

Trained and mentored team members on IDMC functionalities and best practices, fostering a knowledge-sharing environment.

Optimized data pipelines in IDMC, leveraging cloud-native features for increased efficiency and reduced operational costs.

GE Aviation Aug 2015 – Mar 2018

Senior Informatica Consultant

Cincinnati, OH

Involved in the Requirements gathering, Analysis and support of Data Warehousing efforts.

Responsible for Business Analysis and Requirements Collection.

Created profiles to analyze the structure of source data. Created and applied rules in profiles.

Captured DQ metrics (like Total record count, Distinct record count, Count of a distinct

field, Count of null, Referential checks etc.) on the inbound/raw data (i.e., HAL or Stage), and then again on the processed/output data (i.e., STAGE or HYB).

Design, Development and implementation of Informatica Developer Mappings for data cleansing using Address validator, Labeler, Association, Parser, Expression, Filter, Router, Lookup transformations etc.

Wrote UNIX shell Scripts & PMCMD commands for FTP of files from remote server and backup of repository and folder.

Used debugger to validate the mappings and gain troubleshooting information about data and error conditions.

Worked on Webservice Hub to process request and send response using SOAP.

Redesigned some of the mappings in the system to meet new functionality.

Used Informatica Power Center to create mappings for extracting data from various systems.

Used workflow Monitor to monitor the performance of the Jobs.

Extensively worked in the performance tuning of the ETL process at mapping and transformation level.

Used SQL tools like TOAD and SQL Assistant to run SQL queries and validate the data in the database.

Create scorecards to review data quality.

Debug the sessions by utilizing the logs of the sessions.

Extensively created mapping/Mapplets, reusable transformations using all the transformations like Joiner, lookup, filter, expression, stored procedure, aggregator, update strategy, worklets etc.

Developed Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored the results using workflow monitor.

Created various tasks like Session, Command, Timer and Event wait.

Modified several of the existing mappings based on the user requirements and maintained existing mappings, sessions and workflows.

Automatic Data Processing, Inc April 2012 to July 2015

Senior Informatica Consultant

Parsippany, NJ

Responsibilities:

Working with Business Analysis team in gathering the requirements and created Functional and ETL specification documents.

Lead analysis sessions, gather requirements and write specification and functional design documents for enhancements and customization.

Understand the existing subject areas, source systems, target system, operational data, jobs, deployment processes and Production Support activities.

Created the High Level and low-level Design Document for the DQ Services.

Build profiling, cleansing and validation plans.

Analyze profiling results and make recommendations for improvements.

Establishes data quality dimensions, such as data completeness, conformance, consistency, validity, and timeliness.

Worked on scorecards and trend charts for data issues.

Used Informatica data quality tool to cleanse and standardize the data while loading to staging tables.

Developing the Mappings to move the data loaded from Landing to Stage by using various cleanse functions.

Creating Connections, Task flows and Schedule information for the Informatica Cloud Data Synchronization/Replication tasks

Working on Informatica Cloud to integrate the various data Source like Oracle, Amazon Redshift and Saleforce

Extensively worked with Informatica – Source Analyzer, Warehouse Designer, Transformation developer, Mapplet Designer, Mapping Designer, Workflow Manager, and Workflow Monitor to develop various complex mappings, mapplets, reusable transformations, session tasks and Workflows.

Performed extraction, transformation and loading of data from various heterogeneous sources like Oracle, SQL Server, MY SQL, Flat Files, etc and loaded into Data Marts (Oracle, Teradata, Paraccel) using Informatica

Used workflow monitor to monitor the jobs, reviewed session/workflow logs that were generated for each session to resolve issues, used Informatica debugger to identify issues in mapping execution.

Created mappings using pushdown optimization to achieve good performance in loading data into Oracle and Teradata.

Working on Teradata Utility scripts like BTEQ, FastLoad and MultiLoad to load data from various source systems to Teradata.

UPS May 2009 to Mar 2012

Senior Informatica Consultant

Mahwah, NJ

Responsibilities:

Extensively used Informatica 9.x/8.x ETL tool for data transfers from Legacy systems to Oracle warehouse.

Profiled the data using Informatica Data Explorer (IDE) and performed Proof of Concept for Informatica Data Quality (IDQ).

Worked closely with project management and assisted in ensuring timely and effective implementation.

Created the test cases and assisted in UAT testing.

Actively participated in code reviewing and assists to ensure developers follow the standards. Provide quality reviews for the work of other team members when required.

Assist DBA and Architect to identify proper distribution keys for Netezza tables

Used Informatica power center 9.x to Extract, Transform and Load data into Teradata Data Warehouse from various sources like Oracle and flat files

Automated few scripts using Bash and Python.

Identify opportunities to improve processes and cost effectiveness.

Worked as an ONCALL production specialist with primary and secondary duties.

Analyzed and resolved the incidents raised by the application users on priority (low, medium and high) through JIRA.

Modified and implemented the existing applications mappings, workflows, design documents and test cases as per the incident raised by users and internal Data issues.

Experience with Netezza Database integration with Informatica and load process with Netezza Bulk load utilities like Netezza Bulk reader and Bulk writer.

Created and Configured Workflows, Worklets, and Sessions to transport the data to target warehouse Netezza tables using Informatica Workflow Manager.

Used Informatica power center 9.x to Extract, Transform and Load data into Netezza Data Warehouse from various sources like Oracle and flat files.

Implemented Supply Chain, Order Management and Procurement modules.

Involved in implementing Oracle Pre-built modules of Oracle BI Apps

Consult with Business Analysts in analyzing Functional Requirements, and with Business Users in Prototyping Dashboard User Interface.

Worked extensively on customizing.

Customizing OBI Repository (Physical, Business and Presentation layers).

Coordinated with Technical product administration and Operations team in implementation of production break-fix, production error and production maintenance issues.

Involved and completed new production applications Knowledge transfer and application turn over process as a part of Application management services.

References are available upon request.

Contact this candidate