VINOTH RAJENDRAN

Client: PNC Bank

Project: Mortgage Information delivery (AUG 2020 – Till Date)

• Developed scalable data pipelines in BigQuery using advanced SQL and IICS to support reporting and analytics for supply chain data.
• Migrated 10+ on-premise Oracle database to Google BigQuery as part of a cloud modernization initiative.
• Designed and maintained reusable views (including materialized views) to standardize access to financial KPIs that helps reporting logic across the enterprise.
• Built streaming pipelines using Pub/Sub and Dataflow to ingest real-time financial transactions.
• Designed optimized partitioned and clustered tables in BigQuery, improving query performance by 40%.
• Implemented incremental data load and CDC patterns from Cloud Storage to BigQuery using Informatica IICS.
• Collaborated with analytics teams to create materialized views and scheduled queries for business dashboards.
• Created reusable IICS parameterized mappings and taskflows, ensuring standardization and reusability across projects.

Client: Ameren Corp

Project: Data Lake Hydration (DEC 2019 – Aug 2020)

• Involved in developing Informatica ETL jobs for the data management teams in various data sources.
• Developing the Teradata fast export scripts to extract data files and push to AWS S3.
• Creating a Lambda scripts to transfer the file to a different S3 buckets.
• Improved performance of various slow mappings, especially for historical load related jobs.

Client: Wells Fargo N.A.

Project: BDW to ODS Migration (Mar 2018 – Dec 2019)

• Oracle data migration from legacy systems (DB2, SQL Server) to Oracle 19c for a financial client.
• Designed and developed PL/SQL scripts for data extraction, transformation, and loading.
• Performed schema comparison, metadata mapping, and data validation using SQL and ETL tools.
• Optimized data load processes using partitioning, bulk collect, and parallel execution.
• Worked with business analysts to ensure migration accuracy and completeness.
• Migrated over 50+ TB of data with less than 0.5% variance post-validation.
• Implemented end-to-end Informatica Data Quality solutions to support regulatory report.
• Designed data profiling and scorecards to evaluate customer and transactional data quality.
• Built reusable cleansing and standardization rules for names, phone numbers, SSNs, and addresses using Content Sets and Address
• Developed match and merge logic to eliminate duplicates from 10M+ customer records for MDM onboarding.

Client: Morningstar Indexes (Chicago, Illinois, U.S.A.)

Project: Indexes Factset ETL Enhancement (Dec 2016 – Mar 2018)

• Involved in preparation of design documents (DD) based on conceptual design (CD) produced by Client.
• Also involved in creating the mappings in Informatica based on the current system ETLs and review.
• Involved in Validation, Standardization and cleansing of data will be done in the process of implementing the business rules.
• Created business rules in Informatica Developer and imported them to Informatica power center to load the standardized and good format of data to staging tables.
• Involved in creating the batch files that will help in post and pre-session command execution in Informatica.
• Correction of Unix scripts in Factset system to validate the source files.

Client: Russell Investments

Project: CIB to Managed Services (Jan 2015 – Nov 2016)

• Involved in developing 120 Informatica workflows/mappings (developed using Informatica 9) that loads risk index data from various source system.
• Involved in developing the oracle and SQL Server source query to facilitate the Informatica workflows that loads stage and ODS data in to warehouse.
• Worked with Teradata 14 utilities like Fast export, Multi Load and Query man.
• Involved in Sql scripts Macros, stored procedures in Teradata to implement business rules.

Client : Russell Investments

Project: Russell Risk Metrics

• Involved in preparation of detailed design documents (DD) based on conceptual design (CD) produced by Client.
• Played a primary spokes person role from offshore team, in the client calls and helps in requirement gathering and estimation.
• Also involved in creating the mappings in Informatica based on the design document and writing unit test cases and reviews.
• Developed unit test cases for Unit Testing and performed unit testing.
• Involved in creating the batch files that will help in post and pre-session command execution in Informatica.
• Coding & Unit Testing of batch programs.
• Involved in automating the XML file validation as a part of value added for the project.
• Involved in creating the implementation document for all the deployment to the higher environment and coordinating the deployment team to implement the change.