Janani

Janani

Senior Data Engineer
India

About Me

Around 8.6 years of IT experience with around 7 years of experience on designing and development of ETL graphs using Ab-initio 4.0.1.1 and 1.5 year of experience in Data Quality tool - IBM Information Analyzer
2.5 years …

Experience

Senior data Engineer

Wells Fargo
Feb 2022 - Present · 4 years 4 months

Work along with the team on development and enhancement of Abinitio graph as per the Business requirements
Unit testing of the code and Validation of data in Oracle database
Production support
Support the devops teams on process execution of the jobs in higher environment

Senior Data Engineer

Wells Fargo International Solutions Private Limited

Wipro Limited.

Mindtree Limited.

Senior Data Engineer

IHUB– Information Hub

Worked on end-to-end from database table creation to development of graphs to deployment to higher environments.
Worked on development and unit-testing of Abinitio graphs.
Worked on enhancement of graphs according to business requirements like modification and addition of logic codes, addition of new columns into various layers.
Worked on production defect fixes of Abinitio graphs.
Unit testing and writing test cases to pass the source query and target query comparison.
Have taken ownership on deployment of DMLs, DDLs, Abinitio graphs and Autosys jobs to higher environments.
Have been worked as a data modeler too on creating the tables and database sync-up with higher environments.
Have been involved in change management activities to create the change request for production releases
Have worked on data refresh and data restoration activities from production and validating the data
Have created the graphs to avoid the manual activities like database sync-ups and data restoration
Have worked on production support

Senior Project Engineer

FEDEX – FAAR

Worked as a senior developer and initiated the project from the scratch on Ab initio perspective
Designed, developed, tested and implemented Ab Initio ETL graphs.
Developed graphs for migrating the data from IMS database to Oracle dB using Ab initio
Worked on reading the binary data from the Mainframe and loaded to the Oracle dB
Developed migration graphs and CDC graphs to migrate the huge millions of data
Worked along with the architect on designing the new system and getting the requirements
Developed generic wrapper scripts to run the graphs using automation tool
Worked on enhancements and development of graphs and fixing defects
Worked on various components like reformat, join, rollup, scan, rollup, sort and partitioning components.
Analyzed functional requirements and converted them to technical requirements and design the graphs
Worked on Production support in shifts while migrating the historical data of around 6 years of data
Providing expertise in technical analysis and solving technical issues during project delivery
Provided support to the testing team
Participate in high-level and low-level design review session with the client
Worked on UNIX shell scripting in automating the Ab Initio graphs in backend and also to sftp the files from the host server
Reviewed the piers code been a lead team to completed the tasks on limited time frame.
Reviewing of test cases written by the testing team and the test execution results.
Worked in analysis, design document and technical solutions on developing the graphs
Provided support to the QA and UAT team in running the Ab Initio jobs from backend
Validate the data in Oracle dB with SQL queries
Worked with the team to provide the deliverables on time with limited supervision
Unit testing based on the requirements
Provide critical thinking to develop creative and innovative solutions to the business problem
Work in On-site/Off-shore Team, Guide other junior ETL Developers
Actively participated and provided feedback constructively during daily Stand up meetings and weekly Iterative review meetings.
Provided KT to new team members and also KT on Ab initio tool for fresher’s
Worked One automation tool to schedule the jobs.

Senior Software Engineer

AIG – REINSURANCE

Worked on GDE (Graphical Development Environment) – Ab Initio, UNIX and Oracle
Designed, developed, tested and implemented Ab Initio ETL graphs.
Developed graphs for batch processing.
Prepared SQL scripts for extraction of data.
Developed shell scripts for many purposes and automation of environment setup and wrapper
Worked on enhancements and development of graphs and fixing defects
Analyzed functional requirements and converted them to technical requirements and design
Providing expertise in technical analysis and solving technical issues during project delivery
Provided L3 support
Participate in high-level and low-level design review session with the client
Worked on UNIX shell scripting in automating the Ab Initio graphs in backend and also to sftp the files from the host server
Worked in analysis, design document and also providing technical solutions in fixing bug and in various enhancements
Provided support to the QA and UAT team in running the Ab Intio jobs from backend
Worked on Oracle database to fetch and validate the results
Worked with the team to provide the deliverables on time with limited supervision
Unit testing based on the requirements
Provide critical thinking to develop creative and innovative solutions to the business problem
Work in On-site/Off-shore Team, Guide other ETL Developers
Actively participated and provided feedback constructively during daily Stand up meetings and weekly Iterative review meetings.
Ability to work with multiple priorities
Scheduling tool – Autosys

Engineer

AIG – TPAIR

Automating the jobs from Backend using UNIX Shell Scripting
Developed shell scripts for many purposes and automation of environment setup and wrapper
Worked on enhancement on Ab initio graphs.
Worked on abinitio graphs to load the Claim and Draft data of the customers and validating the amount to be claimed and recovered.
Worked on SQL to fetch the data and validate the results
Unit testing based on the requirement

Data Analyst

AIG – DATA QUALITY

Development of rules in IBM IA for the client data.
Development of SQL queries for data validation.
Troubleshooting and debugging IA errors.
Testing on built Rules
Issue Monitoring and Resolution (IMR) on data.
Documentation of the outcomes

Skills

Ab Initio Oracle SQL UNIX Oracle SQL Server Ab-initio 4.1.5.3 IBM Information Analyzer Windows Linux UNIX Shell Scripting Autosys One Automation Control center SQL Shell scripting ETL Data Quality Data validation Unit testing Code review Sprint planning Task allocation Estimation Requirement analysis Production support Data modeling Change management Troubleshooting Debugging Technical analysis Design review QA support UAT support Microservices
Report this Profile?