Etl Developer Data Warehousing

Govindarajan Soundarrajan

SUMMARY:

Sr. ETL developer with 16+ years of total IT experience with 14 years in development and support of ETL and Data warehouse solutions with Informatica

Have very good experience in creating ETL Solutions using Informatica PowerCenter tool

Strong experience and understanding of Data warehousing concepts and ETL techniques

Extensive experience in writing SQL queries and has very good understanding of shell scripting and UNIX commands

Have very good hands on experience in creating and debugging Procedures and functions in Oracle

Proficient in Informatica Power Center, Repository Manager, Workflow Manager, Mapping Designer, Transformation Designer to extract, transform and load the data

Rich experience in extracting data from various sources like Oracle, CSV files, flat-files, xml file

Experience in performance tuning of sources, mappings, targets and sessions

Very good understanding of Data warehousing concepts

Experienced with complete application development life-cycle including requirements gathering, analysis and design, implementing, testing and deployment

Excellent problem-solving skills with a strong technical background and good interpersonal skills

Provided various process improvements and automations to reduce the manual effort

Good knowledge of SDLC concepts and worked on end-to-end project implementation

Have good hands on experience in SAP Business object tool and good understanding in Microstrategy

Good hands on experience on Agile methodology and CI/CD using IBM URelease,UDeploy and GITHUB

Have very good knowledge on AWS Redshit, AWS Glue, AWS Athena, AWS S3, AWS Data migration services, AWS Lamda, IAM, AWS Cloud watch, AWS SCT, AWS RDS and other cloud services

SKILLS:

ETL and Reporting Tools: Informatica PowerCenter, SAP Business Objects, Tableau, Salesforce, OBIEE, OAS, PowerBI

Databases: Oracle, SQL Server, DB2,Snowflake

Languages: SQL /PLSQL, Shell Scripting, Python

Cloud Technologies: AWS

Other Tools: TOAD for Oracle, SQL Developer, Putty, Tectia, IPSWITCH, TES Scheduling tool, Rally, Jira, Remedy, Workday, IBM Data studio, WINSCP, Azure Devops, Autosys Scheduling tool, IBM URelease, IBM UDeploy, GITHUB

Domain Knowledge: HR, Banking, Pharma, Insurance, Finance

PROFESSIONAL EXPERIENCE:

Softsol Inc. Jan 2024-Present

Senior Database developer and Analyst

Client: Fidelity Investments

Project: Plan Sponsor WebStation Reporting

Responsibilities:

Design and develop database objects using Oracle PL/SQL and ETL Informatica.

Prepare data mapping and data lineage documentation.

Write complex SQL queries to perform analysis to identify the root cause of the issue.

Perform impact analysis and prepare the implementation document to onboard new changes into the system.

Prepare maintain and execute test plans and test scripts for ETL, Database and reporting.

Work with upstream and downstream teams to identify root cause of the issue and resolve it at the earliest and apply the changes in production with proper approvals and plans

Deploy codes using GITHUB to maintain the version history for CI/CD.

Interact with Business and End Users to understand the design and development requirements and adhoc service requests.

Perform extensive testing on the reports created using Oracle OBIEE in different environments to make sure it matches to the requirements.

Validate data and data structures between Oracle and Snowflake as part of modernization activity.

Update Mapping documents based on Snowflake tables to rebuild the existing reports in PowerBI.

Softsol Inc. October 2022-December 2023

Lead Data Engineer

Client: Metlife

Project: Global Party Management

Responsibilities:

Created reusable process to improve data quality. Native match and merge and group records into the cluster using various attributes. Worked on high priority incidents and resolved within SLA

Performed impact analysis and prepared the implementation document to onboard new data into the system

Written scripts in Python to extract data from XML files. Requirement gathering for preparing TDD

Preparing project execution plan. Perform code review and provide support on migration activities

Design and develop Informatica Mappings and Sessions based on user requirements and ETL rules to load data from source relational tables to target tables. Schedule jobs using Autosys scheduler tool

Created dependencies and monitored scheduled jobs using Autosys tool

Deploy codes using Artifactory and UDeploy/Urelease tools

Discuss with Clients to understand the criticality of a change request and prioritize the requests based on team’s bandwidth and criticality of the change. Performed data manipulations using various Informatica PowerCenter Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union. Experience in Working with Oracle PL/SQL, UNIX Shell Scripting in UNIX environment. Perform tests, validate all data flows, and prepare all ETL processes according to business requirements. Work with upstream and downstream teams to identify root cause of the issue and resolve it at the earliest and apply the changes in production with proper approvals and plans

Interact with Business and End Users to understand the design and development requirements and adhoc service requests. Allocation and monitoring of tasks to team members

Softsol Inc. June 2021-September 2022

Senior Informatica Developer and Data Modular

Client: Cisco

Project Name: Datahub

Responsibilities:

Prepared LLD and project execution plan documents based on the requirements

Design and develop Informatica Mappings and Sessions based on user requirements and ETL rules to load data from source relational tables to target tables

Ensuring top-quality deliverables to the client

Fixed and enhanced existing Python scripts which extracts data from XML sources

Discuss with Clients to understand the criticality of a change request and prioritize the requests based on team’s bandwidth and criticality of the change

Used various Informatica PowerCenter Transformations like Filter, Expression, Connected Lookups, Unconnected lookups, Aggregator, Normalizer, Joiner, Router, Update Strategy, Sorter and Union while developing mappings. Experience in Working with Oracle PL/SQL, UNIX Shell Scripting in UNIX environment

Performed tuning of Informatica sessions by using optimizing techniques such as database partitioning, increasing block size, data cache size, sequence buffer length, target based commit interval and SQL overrides. Identify the Bottlenecks in mappings

Developed end user reports using Tableau which will help the manager identify the worker’s Blueprint and Span of control report which will help manager to do forecasting

Designed error handling techniques to direct the rejected rows into an error table

Perform code review and provide support on migration activities

Work with upstream and downstream teams to identify root cause of the issue and resolve it at the earliest and apply the changes in production with proper approvals and plans

Interact with Business and End Users to understand the design and development requirements and adhoc service requests. Allocation and monitoring of tasks to team members

Artech, NC. July 2019-June 2021

Senior Informatica Developer

Client: Wells Fargo

Project: Auto Digital Platform

Responsibilities:

Analyze user needs and software requirements; design, develop and modify software applications as needed; and participate in multiple phases of project life cycle development including requirement gathering, software design, development, and testing of computer applications

Provide technical evaluation estimates on technology initiatives; formulate cutting-edge product breakthroughs, defining architecture and product functionality; and design and customize software for client use with the aim of optimizing. Understand the requests for change and implement the changes while understanding and addressing the side effects of the proposed changes on existing software; ensure that performance parameters expected from the module being developed are in acceptable limits; and monitor the application under production for potential performance loss and required changes over a period of time

Liaise with management to develop and create technology and cost proposals; serve as the primary point of contact for company in creating various business applications and modules using cutting edge technologies; and design and develop custom programs, interfaces, and reports for these modules to meet the business requirements. Utilize a thorough understanding of available technology, tools, and existing designs; work on the most complex problems where analysis of situations or data requires evaluation of intangible variance factors; and plan, perform, and act as the escalation point for complex platform designs, coding, and testing

Lead most complex multiple modeling, simulations, and analysis efforts and act as an expert technical resource to programming staff in the program development, testing, and implementation process

Accenture, NC April 2016-July 2019

Senior Informatica Developer and Data Modular

Client: Cisco

Project: Datahub

Responsibilities:

Requirement gathering for preparing LLD. Preparing project execution plan

Design and develop Informatica Mappings and Sessions based on user requirements and ETL rules to load data from source relational tables to target tables. Ensuring top-quality deliverables to the client

Discuss with Clients to understand the criticality of a change request and prioritize the requests based on team’s bandwidth and criticality of the change

Good hands on experience in using various Informatica PowerCenter Transformations like Filter, Expression, Lookups, Aggregator, Update Strategy, Normalizer, Joiner, Router, Sorter and Union

Experience in Working with Oracle PL/SQL, UNIX Shell Scripting in UNIX environment

Created TES jobs to schedule the workflows to run as per the dependencies

Perform tests, validate all data flows, and prepare all ETL processes according to business requirements

Performed tuning of Informatica sessions by using optimizing techniques such as database partitioning, increasing block size, data cache size, sequence buffer length, target based commit interval and SQL overrides. Identify the Bottlenecks in mappings. Involved in Error handling (Ignore, rejecting bad records, loading and reviewing them). Perform code review and provide support on migration activities

Work with upstream and downstream teams to identify root cause of the issue and resolve it at the earliest and apply the changes in production with proper approvals and plans

Interact with Business and End Users to understand the design and development requirements and adhoc service requests. Allocation and monitoring of tasks to team members

Developed Tableau reports to monitor the daily weekly and monthly data refresh statuses

Accenture September 2014-April 2016

Senior Informatica Developer

Client: Cisco

Project: Work Place Resource

Responsibilities:

Gathering the deliverables and making sure, they are completed as per the deadlines

Understanding the requirements

Prepare project execution plan

Design, Build, Testing, Deployment of Projects which includes Informatica PowerCenter, Business Objects, Unix Scripting and Stored Procedures

Perform tests, validate all data flows, and prepare all ETL processes according to business requirements

Interact with Business and End Users to understand the design and development requirements and adhoc service requests. Work with upstream and downstream teams to identify root cause of the issue and resolve it at the earliest and apply the changes in production with proper approvals and plans

Experience in Working with Oracle PL/SQL, UNIX Shell Scripting in UNIX environment

Created TES jobs to schedule the workflows to run as per the dependencies. Guiding new team members during their initiation process and helping juniors with technical as well as the functional knowledge

Providing support on migration activities. Performed tuning of Informatica sessions by using optimizing techniques such as database partitioning, increasing block size, data cache size, sequence buffer length, target based commit interval and SQL overrides. Identify the Bottlenecks in mappings

Involved in Error handling (Ignore, rejecting bad records, loading and reviewing them)

Perform Problem management tasks such as Root Cause Analysis to identify the defect and resolve the code defects during the testing phase

HCL Technologies May 2010-December 2013

Informatica/BO support Engineer

Client: Merck

Project: Prescriber DataMart- Support/Enhancements

Responsibilities:

Enhancing the code based on the requirement to add the new functionality

Understanding of the existing functionality and preparing design for the new requirements by performing impact analysis. Make sure that all the schedule and adhoc loads are completed in timely manner

Keep the business and other stakeholders informed in case of any issues

Perform Problem management tasks such as Root Cause Analysis to identify the defect and resolve the code defects during the testing phase. Interact with Business and End Users to understand the design and development requirements and adhoc service requests

Work extensively with Informatica PowerCenter – Source Analyzer, Target Designer, Transformation developer, Mapplet Designer, Mapping Designer, Workflow Manager, and Workflow

Perform tests, validate all data flows, and prepare all ETL processes according to business requirements

Provide solutions on performance tuning to accelerate the time taken by jobs to complete

HCL Technologies May 2010-December 2013

Informatica/BO Support Engineer

Client: Merck

Project: Field Activity and Customer Tracking System DSS Production

Responsibilities:

Enhancing the code based on the requirement to add the new functionality

Work extensively with Informatica PowerCenter – Source Analyzer, Target Designer, Transformation developer, Mapplet Designer, Mapping Designer, Workflow Manager, and Workflow

Solving issues, which occur during production cycle

Providing reports to business according to their requirements

Carry out impact analysis for any new changes being pushed to production

Coordinating meetings between offshore and onshore

Interact with Business and End Users to understand the design and development requirements and adhoc service requests. Perform Problem management tasks such as Root Cause Analysis to identify the defect and resolve the code defects during the testing phase

Technical support to business system analyst and customers to assist them with resolution of business incidents/tickets. Provide solutions on performance tuning to accelerate the time taken by jobs to complete

Lionbridge Technologies December 2009-May 2010

Informatica support Engineer

Client: Merck

Project: Merck-Production Support

Responsibilities:

First level of support for the incidents raised through the Incident management tool

Monitor Informatica production jobs and fix failures as per SLA. Perform data validations and inform users on the data availability

Handling access issues for the end users on the reporting tool

Generate monthly and quarterly reports for business users

Jeevan Technologies April 2009-December 2009

Associate Consultant

Client: Yahoo

Project: Yahoo Arcturus

Responsibilities:

Optimizing Yahoo search engine. Rank the queries searched on Yahoo search engine

Understanding dominant user intention and correlate the query based on geographical location and order them in the best possible order

EDUCATION:

Madras University, Vel’s College of Science, TN, INDIA

BSc Computer Science, 2008

Contact this candidate