Srikanth K
Westland,MI
Summary
Seasoned Lead/ETL Developer with a proven track record at Bank of America, enhancing data processing and analysis capabilities. Expert in Azure Data Factory and Informatica Power Center, adept at driving significant improvements in data integrity and workflow efficiency. Demonstrates strong analytical skills and a commitment to excellence, contributing to impactful decision-making and strategic planning.
Overview
13
13
years of professional experience
1
1
Certification
Work History
Lead/ETL Developer
Adient
, USA
08.2023 - Current
- Company Overview: Oculus Application
- Production Module in Oculus handles all the production and downtime related activity in the plant
- We capture all the production related activity from source system and involved in reporting statistical findings to work colleagues and senior managers
- Designing and building scalable data pipelines using Databricks Spark for data ingestion, transformation, and loading (ETL/ELT).
- Optimizing pipeline performance for large datasets and complex data processing tasks.
- Creating Stored Procedure and scheduled them in ADF
- Worked with various Linked services on the source as well the destination servers
- Strong skills in Logics apps, Storage account, Blob, Data base creation, Data sets, Private and public end points processes
- Hands on experience in tuning Pipelines, identifying and resolving performance bottlenecks in various levels like sources, targets, transformation and sessions
- Providing the support of Oculus application by trouble-shooting issues, and developing, testing and migration of data base
- Involved in the creation of Trigger Jobs to execute Pipelines
- Involved in the Unit testing from source to target and target to source by developing sql queries
- Worked on high critical incident through Snow (P2 and P3) to fix the issue on demand in production
- Oculus Application
- Production Module in Oculus handles all the production and downtime related activity in the plant
- We capture all the production related activity from source system and involved in reporting statistical findings to work colleagues and senior managers
- Environment: Azure data Factory v2, SQL, Snowflake, Devops, Trigger schedule
Lead/ETL Developer
PWC
, USA
08.2018 - 07.2023
- Company Overview: myMetrics Application
- Collecting, collating, and carrying out complex data analysis in support of management & customer requests
- Also involved in reporting statistical findings to work colleagues and senior managers
- Worked Extensively on Designer, Workflow Manager and Workflow Monitor
- Replicated various mappings, sessions, and workflows to extract and load data from GFS, MDM, Salesforce, and API’s call to Oracle DB
- Worked with various transformations such as
- Lookups, Aggregator, Update Strategy, Sequence Generator and reusable mapplets
- Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes
- Hands on experience in tuning mappings, identifying, and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions
- Experienced at Creating effective Test data and development thorough Unit test cases to ensure successful execution of the data
- Involved in the creation of Tivoli workload scheduler Jobs to execute workflows
- Involved in the Unit testing from source to target and target to source by developing SQL queries
- Worked on high critical incident through Snow (P2 and P3) to fix the issue on demand in production
- MyMetrics Application
- Collecting, collating, and carrying out complex data analysis in support of management & customer requests
- Also involved in reporting statistical findings to work colleagues and senior managers
- Environment: Azure data factory v2, Informatica PowerCenter 10.5.0, Unix/Linux, Korn Shell Script, TOAD datapoint, Oracle19g, Windows7, Tivoli workload schedule
Lead/ETL Developer
Bank of America
, USA
01.2016 - 03.2018
- Company Overview: GDH Application
- Collecting, collating, and carrying out complex data analysis in support of management & customer requests
- Also involved in reporting statistical findings to work colleagues and senior managers
- Worked Extensively on Designer, Workflow Manager and Workflow Monitor
- Replicated various mappings, sessions, and workflows to extract and load data from Unix files to Netezza DB through SFTP
- Worked with various transformations such as
- Lookups, Update Strategy, Sequence Generator and reusable mapplets
- Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes
- Hands on experience in tuning mappings, identifying, and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions
- Experienced at Creating effective Test data and development thorough Unit test cases to ensure successful execution of the data
- Involved in the creation of Autosys Jobs to execute workflows
- Involved in the Unit testing from source to target and target to source by developing SQL queries
- GDH Application
- Collecting, collating, and carrying out complex data analysis in support of management & customer requests
- Also involved in reporting statistical findings to work colleagues and senior managers
- Environment: Linux, Teradata, Informatica Power Center 9.5.0, TOAD datapoint, Windows7, Autosys(iXp), Netezza
Sr.ETL Developer
Bank of America
, USA
01.2015 - 12.2015
- Company Overview: RegW Compliance Surveillance Technology
- The Federal Reserve regulates specific transactions between Bank of America depository institutions and subsidiaries
- Worked Extensively on Designer, Workflow Manager and Workflow Monitor
- Replicated various mappings, sessions, and workflows to extract and load data from flat files to Oracle DB
- Worked with various transformations such as
- Lookups, Update Strategy, Sequence Generator and reusable mapplets
- Involved in the creation of Autosys Jobs to execute workflows
- Involved in the Unit testing from source to target and target to source by developing SQL queries
- RegW Compliance Surveillance Technology
- The Federal Reserve regulates specific transactions between Bank of America depository institutions and subsidiaries
- Environment: Linux, Oracle, Informatica Power Center 9.5.0, TOAD, Windows7, Autosys(iXp)
ETL Developer
Bank of America
, USA
08.2011 - 12.2014
- Company Overview: W’ Midrange (EPE)
- The main objective is to manage, track and document early engagement activities with project and development teams installing new development and maintenance processes associated with enterprise Data warehouse
- Code walkthrough activities as per BOA Teradata standards
- Analysis of code to resolve issues from clients and users
- Handle EPE related activities, understand the project requirements and engage the project team in all activities until the code is deployed in PROD
- Analysing Requirements and seeking functional clarifications
- Handling SLA related activities, working up with project teams and understand the project requirements and approving SLA
- Working on TRB and Maximo tickets by gathering all the information from project team for the approval process
- Writing the test cases and working on SPM testing
- W’ Midrange (EPE)
- The main objective is to manage, track and document early engagement activities with project and development teams installing new development and maintenance processes associated with enterprise Data warehouse
- Environment: Teradata, Informatica Power Center 6.1.0 & 9.5.0, SQL Developer, Windows7, Mainframes
Education
B. Tech - Electrical & Electronics Engineering
SHCST
01.2006
Skills
- Unix
- Linux
- Dimensional Data Modelling
- Star Schema Modelling
- Snow-flake Schema Modelling
- Oracle SQL
- MSQL
- Neteeza
- Teradata
- Snowflake
- Azure Data Factory
- Informatica Power Center 1041
- Azure DataBricks
- Power BI
- PL/SQL
- Apache Spark, Delta Lake, Databricks SQL, Databricks Notebooks
- Python, Scala
Certification
- Microsoft AZ-500 Azure Security Engineer Associate, 06/22
- Microsoft Certified DP-203: Azure Data Engineer Associate, 04/23
Timeline
Lead/ETL Developer
Adient
08.2023 - Current
Lead/ETL Developer
PWC
08.2018 - 07.2023
Lead/ETL Developer
Bank of America
01.2016 - 03.2018
Sr.ETL Developer
Bank of America
01.2015 - 12.2015
ETL Developer
Bank of America
08.2011 - 12.2014
B. Tech - Electrical & Electronics Engineering
SHCST
Similar Profiles
Jeffrey KizerJeffrey Kizer
Production Associate at AdientProduction Associate at Adient
CINDY HARRISONCINDY HARRISON
Human Resources Coordinator at AdientHuman Resources Coordinator at Adient
Taspin ZidanTaspin Zidan
Material Supervisor at AdientMaterial Supervisor at Adient
Mawilliam SealieteMawilliam Sealiete
Assistant Payroll Administrator at AdientAssistant Payroll Administrator at Adient
Marta MossMarta Moss
Flight Attendant at Delta Air Lines, Inc.Flight Attendant at Delta Air Lines, Inc.