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 …
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 in Wipro Limited.,
4.4 years in Mindtree Limited.,
Have worked on various activities in ETL projects:
Requirement Understanding
Designing and Development of Graphs
Unit testing of the Graphs
Code Review
Validating the data using SQL queries
Shell scripting to automate the process
Task allocation and estimation for tasks
Sprint planning for next upcoming development
Experience
Senior data Engineer
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
Senior Data Engineer
<p>Worked on end-to-end from database table creation to development of graphs to deployment to higher environments.<br>
Worked on development and unit-testing of Abinitio graphs.<br>
Worked on enhancement of graphs according to business requirements like modification and addition of logic codes, addition of new columns into various layers.<br>
Worked on production defect fixes of Abinitio graphs.<br>
Unit testing and writing test cases to pass the source query and target query comparison.<br>
Have taken ownership on deployment of DMLs, DDLs, Abinitio graphs and Autosys jobs to higher environments.<br>
Have been worked as a data modeler too on creating the tables and database sync-up with higher environments.<br>
Have been involved in change management activities to create the change request for production releases<br>
Have worked on data refresh and data restoration activities from production and validating the data<br>
Have created the graphs to avoid the manual activities like database sync-ups and data restoration<br>
Have worked on production support</p>
Senior Project Engineer
<p>Worked as a senior developer and initiated the project from the scratch on Ab initio perspective<br>
Designed, developed, tested and implemented Ab Initio ETL graphs.<br>
Developed graphs for migrating the data from IMS database to Oracle dB using Ab initio<br>
Worked on reading the binary data from the Mainframe and loaded to the Oracle dB<br>
Developed migration graphs and CDC graphs to migrate the huge millions of data<br>
Worked along with the architect on designing the new system and getting the requirements<br>
Developed generic wrapper scripts to run the graphs using automation tool<br>
Worked on enhancements and development of graphs and fixing defects<br>
Worked on various components like reformat, join, rollup, scan, rollup, sort and partitioning components.<br>
Analyzed functional requirements and converted them to technical requirements and design the graphs<br>
Worked on Production support in shifts while migrating the historical data of around 6 years of data<br>
Providing expertise in technical analysis and solving technical issues during project delivery<br>
Provided support to the testing team<br>
Participate in high-level and low-level design review session with the client<br>
Worked on UNIX shell scripting in automating the Ab Initio graphs in backend and also to sftp the files from the host server<br>
Reviewed the piers code been a lead team to completed the tasks on limited time frame.<br>
Reviewing of test cases written by the testing team and the test execution results.<br>
Worked in analysis, design document and technical solutions on developing the graphs<br>
Provided support to the QA and UAT team in running the Ab Initio jobs from backend<br>
Validate the data in Oracle dB with SQL queries<br>
Worked with the team to provide the deliverables on time with limited supervision<br>
Unit testing based on the requirements<br>
Provide critical thinking to develop creative and innovative solutions to the business problem<br>
Work in On-site/Off-shore Team, Guide other junior ETL Developers<br>
Actively participated and provided feedback constructively during daily Stand up meetings and weekly Iterative review meetings.<br>
Provided KT to new team members and also KT on Ab initio tool for fresher’s<br>
Worked One automation tool to schedule the jobs.</p>
Senior Software Engineer
<p>Worked on GDE (Graphical Development Environment) – Ab Initio, UNIX and Oracle<br>
Designed, developed, tested and implemented Ab Initio ETL graphs.<br>
Developed graphs for batch processing.<br>
Prepared SQL scripts for extraction of data.<br>
Developed shell scripts for many purposes and automation of environment setup and wrapper<br>
Worked on enhancements and development of graphs and fixing defects<br>
Analyzed functional requirements and converted them to technical requirements and design<br>
Providing expertise in technical analysis and solving technical issues during project delivery<br>
Provided L3 support<br>
Participate in high-level and low-level design review session with the client<br>
Worked on UNIX shell scripting in automating the Ab Initio graphs in backend and also to sftp the files from the host server<br>
Worked in analysis, design document and also providing technical solutions in fixing bug and in various enhancements<br>
Provided support to the QA and UAT team in running the Ab Intio jobs from backend<br>
Worked on Oracle database to fetch and validate the results<br>
Worked with the team to provide the deliverables on time with limited supervision<br>
Unit testing based on the requirements<br>
Provide critical thinking to develop creative and innovative solutions to the business problem<br>
Work in On-site/Off-shore Team, Guide other ETL Developers<br>
Actively participated and provided feedback constructively during daily Stand up meetings and weekly Iterative review meetings.<br>
Ability to work with multiple priorities<br>
Scheduling tool – Autosys</p>
Engineer
<p>Automating the jobs from Backend using UNIX Shell Scripting<br>
Developed shell scripts for many purposes and automation of environment setup and wrapper<br>
Worked on enhancement on Ab initio graphs.<br>
Worked on abinitio graphs to load the Claim and Draft data of the customers and validating the amount to be claimed and recovered.<br>
Worked on SQL to fetch the data and validate the results<br>
Unit testing based on the requirement</p>
Data Analyst
<p>Development of rules in IBM IA for the client data.<br>
Development of SQL queries for data validation.<br>
Troubleshooting and debugging IA errors.<br>
Testing on built Rules<br>
Issue Monitoring and Resolution (IMR) on data.<br>
Documentation of the outcomes</p>