We provide IT Staff Augmentation Services!

Etl Team Lead/sr.ab Initio Developer Resume

5.00/5 (Submit Your Rating)

TampA

SUMMARY

  • Over 10 years of IT experience in Designing and Developing Major Applications using Ab Initio tools to cater data warehousing needs of major Banking & Finance and Insurance clients.
  • 10 years of overall experience in Ab initio.
  • 2 years of overall experience in Mainframes and Java
  • Worked as a Senior Lead and Developer on Multiple ETL applications catering Data mapping, Data Transformation and Data loading from Source to Target systems in a complex, high volume environment.
  • Extensively worked in all phases of the Software Development Lifecycle (SDLC) - Analysis, Design and Modeling, Development, System Testing, System Implementation, Acceptance and Maintenance.
  • Have been involved in Lead Designer role along with development for banking compliance critical projects.
  • Good experience in end-to-end implementation of DW BI projects, especially in data warehouse and mart developments
  • Work exposure in Agile projects.
  • Strong knowledge and Hands-on experience on Abinitio ETL, Metadata hub with various application metadata
  • Experience in Oracle, Teradata, SQL, DB2 and Hive Databases.
  • Experience in scheduling tools like Autosys, Control Center
  • Good Experience in Abinitio DQE
  • Developed the subscribe and publish components for implementation of Abinitio Continuous flows.
  • Good Experience in Abinitio Express>It (ACE and BRE).
  • Experience in working with Oracle using SQL, PL/SQL, SQL loader and solid expertise in oracle stored procedures, Triggers, Index, Table Partitions.
  • Experience in providing End-to-End production support to Ab Initio.
  • Good experience in providing immediate solutions to the business users on Adhoc Requests.
  • Handled the code in different environments (UAT, PROD) and created the docs for code promotions.
  • Client interaction for requirement gathering, system analysis, Impact analysis, technical / functional specifications of the project, liaising extensively with offshore/onsite model.
  • Excellent Analytical, Communication skills, working in a team and ability to communicate effectively at all levels of the development process.
  • Quick learner and excellent team player, ability to meet tight deadlines and work under pressure.
  • Experienced in data profiling of operational data to get better understanding of the data that can be used for analytical purpose for business analysts.
  • Expertise in preparing code documentation in support of application development, including High level and detailed design documents, unit test specifications, interface specifications.
  • Excellent Communication skills in interacting with various people of different levels on all projects and playing an active role in Business Analysis.
  • Manage multiple projects/tasks within Banking and Financial Service industry in a high transaction processing environment with excellent analytical, business process, written and verbal communication skills.

PROFESSIONAL EXPERIENCE

Confidential, Tampa

ETL Team Lead/Sr.Ab Initio Developer

Responsibilities:

  • Interacting with Client and BA’s to get the requirements as require for new Development and supporting User Level (UAT) to validate the data based on requirements and getting sign-offs in time.
  • Build Ab-Initio graphs from high level design document.
  • Designed/Developed Domain like Continuous flow Graph to Publish into MQ-queue that Subscribes Messages from Ab-Initio Queue and Publishes messages into MQ-queue, which relays to a centralized Web based E-mail Generating System.
  • Involved in Unit Testing (Development), ETL Testing (QA) and User Acceptance Testing (UAT).Getting the Post-Production sign-offs from BA’s or User’s as required.
  • Attended project meetings and communicated the project architecture and design to other team members.
  • Created high level design and detailed design documents for user requirements.
  • Extensively used various Ab initio components like Reformat, Join, Partition by Key, Gather, Sort, Dedup Sort, Rollup, Scan, Lookup, Normalize components etc to create the graphs.
  • Designed and build Ab Initio generic graphs for Extracting, Production defects Handling
  • Resolved technical issues faced by the team during the development phase.
  • Coordinating with different levels of people in the client’s organization to ensure accesses to different systems and quick resolution to various issues.
  • Developed Ab Initio XFR’s to derive new fields and solve various business requirements
  • Created Sandbox and edited Sandbox parameters as per requirement and worked extensively in other EME processes.
  • Involved in creating configurations and writing BRE rules.
  • Various inbuilt functions like lookup, lookup local, string filter out, datetime add were effectively used in various transform functions. Developed and tested subscribe and publish components for successful implementation of Abinitio continuous flow.
  • Prepared Unit and Integration testing plans. Involved in Unit and Integration testing using the testing plans.
  • Used Ab Initio features like check points, phases etc and implemented Ab Initio parallelism techniques and Multi file system techniques.
  • Developed re-usable generic / dynamic Ab Initio graphs and psets for the quality check of the source data.
  • Implemented Oracle utilities SQL loaded, Utility and API based loading from Ab Initio.
  • Used AIR commands to do dependency analysis for all ABI objects.
  • Reverse engineered existing graphs to create the necessary design documents like high level and detailed level technical designs, mapping documents and then updated them for additional new functionality.
  • Extensively used Enterprise Meta Environment (EME) for version control.
  • Designed migration documents for PROD, PRE-PROD and UAT rehearsals.
  • Responsible for End-to-end validation when project migration to higher environments (SIT, UAT). Co-ordinate with SUPPORT teams for on-time and error free CODE migration.
  • Used the sub graphs to increase the clarity of graph and to impose reusable business restrictions. Capacity of designing solutions and advanced skills with high performance in Ab Initio.
  • Performed validations, data quality checks and Data profiling on incoming data.
  • Implemented underlying graphs for Meta Data Framework and common components with PDL.
  • Developed graphs for serving the Business Users ADHOC requests.
  • Provided 24*7 extended supports during the production rollout and bug fixes.
  • Tracking the metrics such as productivity, project status and defects.

Environment: Ab Initio Co >Op 4, GDE 4, Express>It, Oracle 12g, Teradata 14, Shell scripting, SQL Developer, Share point, Autosys Scheduler, HP Quality Center, Service Now.

Confidential, NC/Charlotte

Sr. ETL Engineer

Responsibilities:

  • On boarding of all new applications based on sprints and releases.
  • Build Ab-Initio graphs from high level design document.
  • Developed app configurations and BRE rules using ETL technologies such as BRE tool.
  • Involved in Business Tagging process in Express>It.
  • Interacted with Business team to resolve their issues.
  • Developed Ab Initio XFR’s to derive new fields and solve various business requirements.
  • Involved in SDLC and Agile Methodology.
  • Created high level design and detailed design documents for user requirements.
  • Involved in Unit Testing (Development), ETL Testing (QA) and User Acceptance Testing (UAT). Getting the Post-Production sign-offs from BA’s or User’s as required.
  • Worked on Integration test plans and executed.
  • Attended project meetings and communicated the project architecture and design to other team members.
  • Technical setup and on boarding of all applications.
  • Monitored Ab Initio jobs within and also in deployment environments using Ab Initio Commands and Schedules
  • Supporting all ethical issues raised by Business users in agile methodology based on sprints.
  • Defect aging and Query>It POC was done this year 2020.
  • Deployment of Data lakes and non-data lakes applications and setup done in DEV/SIT/UAT.
  • Teradata, Oracle, db2, oracle databases are getting used in this project.

Environment: Ab Initio Co >Op 3.2.6.3, Express>It, Metadata Hub, Oracle 12g, Teradata 14, Hive, Shell scripting, Autosys Scheduler

Confidential, NJ/Tampa

ETL Team Lead/Sr.Ab Initio Developer

Responsibilities:

  • Interacting with Client and BA’s to get the requirements as require for new Development and supporting User Level (UAT) to validate the data based on requirements and getting sign-offs in time.
  • Build Ab-Initio graphs from high level design document.
  • Designed/Developed Domain like Continuous flow Graph to Publish into MQ-queue that Subscribes Messages from Ab-Initio Queue and Publishes messages into MQ-queue, which relays to a centralized Web based E-mail Generating System.
  • Involved in Unit Testing (Development), ETL Testing (QA) and User Acceptance Testing (UAT).Getting the Post-Production sign-offs from BA’s or User’s as required.
  • Attended project meetings and communicated the project architecture and design to other team members.
  • Created high level design and detailed design documents for user requirements.
  • Extensively used various Ab initio components like Reformat, Join, Partition by Key, Gather, Sort, Dedup Sort, Rollup, Scan, Lookup, Normalize components etc to create the graphs.
  • Designed and build Ab Initio generic graphs for Extracting, Production defects Handling
  • Resolved technical issues faced by the team during the development phase.
  • Coordinating with different levels of people in the client’s organization to ensure accesses to different systems and quick resolution to various issues.
  • Developed Ab Initio XFR’s to derive new fields and solve various business requirements
  • Created Sandbox and edited Sandbox parameters as per requirement and worked extensively in other EME processes.
  • Involved in creating configurations and writing BRE rules.
  • Various inbuilt functions like lookup, lookup local, string filter out, datetime add were effectively used in various transform functions. Developed and tested subscribe and publish components for successful implementation of Abinitio continuous flow.
  • Prepared Unit and Integration testing plans. Involved in Unit and Integration testing using the testing plans.
  • Used Ab Initio features like check points, phases etc and implemented Ab Initio parallelism techniques and Multi file system techniques.
  • Developed re-usable generic / dynamic Ab Initio graphs and psets for the quality check of the source data.
  • Implemented Oracle utilities SQL loaded, Utility and API based loading from Ab Initio.
  • Used AIR commands to do dependency analysis for all ABI objects.
  • Reverse engineered existing graphs to create the necessary design documents like high level and detailed level technical designs, mapping documents and then updated them for additional new functionality.
  • Extensively used Enterprise Meta Environment (EME) for version control.
  • Designed migration documents for PROD, PRE-PROD and UAT rehearsals.
  • Responsible for End-to-end validation when project migration to higher environments (SIT, UAT). Co-ordinate with SUPPORT teams for on-time and error free CODE migration.
  • Used the sub graphs to increase the clarity of graph and to impose reusable business restrictions. Capacity of designing solutions and advanced skills with high performance in Ab Initio.
  • Performed validations, data quality checks and Data profiling on incoming data.
  • Implemented underlying graphs for Meta Data Framework and common components with PDL.
  • Developed graphs for serving the Business Users ADHOC requests.
  • Provided 24*7 extended supports during the production rollout and bug fixes.
  • Tracking the metrics such as productivity, project status and defects.

Environment: Ab Initio Co >Op 3.2.6.3, GDE 3.2.7, Express>It,Oracle 12g, Teradata 14, Shell scripting, SQL Developer, Share point, Autosys Scheduler, HP Quality Center, Service Now.

Confidential

ETL Team Lead/Sr.Ab Initio Developer

Responsibilities:

  • Created complex queries for validating the data from source to target systems in the acceptance and prod environments.
  • Worked in Coding, Code Review and Code Delivery
  • Used Different Ab Initio Components like transform, Partition by Key and Sort, Dedup, Rollup, Scan, Reformat, Join, lookup, etc. in various graphs.
  • Designed and build Ab Initio generic graphs for unloading data from source systems.
  • Defects Handling
  • Understanding and analyzing the requirements to make project estimates, setting up timelines, doing impact analyses according to the scale of the changes whenever requested, preparing/reviewing HLDs, LLDs, and other design documents
  • Co-ordinating with different levels of people in the client’s organization to ensure accesses to different systems and quick resolution to various issues.
  • Extensively used string functions, date functions and error functions for source to target data transformations.
  • Created DMLs based on the COBOL copybooks using the Cobol-to-dml utility.
  • Implemented phasing and checkpoint approach in ETL process to prevent data loss and to maintain uninterrupted data flow against process failures.
  • Modified the Ab Initio components parameters, utilize data parallelism and thereby improve the overall performance to fine-tune the execution times.
  • Written several Unix Control Scripts specific to application to pass the Environment variables.
  • Involved in Project Code Promotions for test and production environments.
  • Designed and Developed graphs for serving the Business Users ADHOC requests.
  • Involved in product administration covers installation, setup, configuration, production support, developer support, monitoring batch jobs, investigating and resolving the problems
  • Used different EME Air Commands in Project promotion like air tag create, air load, air save, air load, air project export etc.
  • Developed and worked on numerous SQL scripts, making changes to the existing scripts and completed unit and system testing.
  • Involved in System Integration Testing (SIT) and User Acceptance Testing (UAT).
  • Prepared Unit Test cases and executed test scripts successfully.
  • Involved in Environment and frame work setup in SIT, UAT and PROD.
  • Supported during QA/UAT/PROD deployments and bug fixes.

Environment: Ab Initio Co >Op 3.0.2.0, GDE 3.0.2, EME, Oracle, SQL server, UNIX Shell scripting, SharePoint, Quality Center, Tivoli

Confidential, Chicago

Sr. Abinitio Developer

Responsibilities:

  • Used Ab Initio as ETL tool to pull data from source systems, cleanse, transform, and load data into databases.
  • Worked with offshore team to build the project and undertook responsibilities of working closely with users for requirements gathering and providing the offshore team with detailed requirements documents.
  • Involved in creating high level design and detailed design documents for Ab Initio graphs.
  • Analyzed business requirements and developed metadata mappings andAb InitioDMLs.
  • Extensively involved in Ab Initio Graph Design, development and Performance tuning.
  • Developed various graphs to process business requirements utilizing functionalities like Join-with-DB, Read-Excel, Rollup, Lookup, Reformat, Scan etc., generate reports and CSV’s.
  • Implemented Data parallelism by using Multi-File System, Partition and De-partition components and preformed repartition to improve the overall performance.
  • Performed validations, Data Quality checks and Data profiling on incoming data.
  • Used Enterprise Meta Environment (EME) for version control, Maestro for scheduling purposes.
  • Worked on improving the performance of Ab Initio graphs by using various performance techniques like using lookups instead of joins, In-Memory Joins etc.
  • Implemented phasing and checkpoint approach in ETL process to prevent data loss and to maintain uninterrupted data flow against process failures.
  • Developed various adhoc graphs for serving the Business Users ADHOC requests.
  • Provided 24*7 extended supports during the production rollout and bug fixes.
  • Involved in Unit testing, System testing and debugging during testing phase and used Quality center to keep track of defects.
  • Managing and Guiding the offshore Team and validating the outputs of Offshore.
  • Tracking the metrics such as productivity, project status and defects.

Environment: Abinitio, EME, Oracle, SQL server, UNIX Shell scripting, SharePoint, Quality Center, Tivoli

Confidential, Chicago

Sr. Abinitio Developer

Responsibilities:

  • Extensively interacted with business users to understand the business requirements and designed and developed Strategies for ETL processes.
  • Created high level design and detailed design documents for user requirements.
  • Extensively used various Ab initio components like Reformat, Join, Partition by Key, Gather, Sort, Dedup Sort, Rollup, Scan, Lookup, Normalize components etc to create the graphs.
  • Developed Ab Initio XFR’s to derive new fields and solve various business requirements
  • Created Sandbox and edited Sandbox parameters as per requirement and worked extensively in other EME processes.
  • Used Ab Initio features like check points, phases etc and implemented Ab Initio parallelism techniques and Multi file system techniques.
  • Developed re-usable generic / dynamic Ab Initio graphs and psets for the quality check of the source data.
  • Used AIR commands to do dependency analysis for all ABI objects.
  • Involved in monitoring Ab Initio jobs using AB REPORT options.
  • Used phases, check points. Also used effective watcher and debugging mode while debugging the graphs.
  • Used the sub graphs to increase the clarity of graph and to impose reusable business restrictions. Capacity of designing solutions and advanced skills with high performance in Ab Initio.
  • Validate Autosys BOX’s and CMD’s deployed to schedule Ab Initio graphs and scripts to automate jobs and co-ordinate with Autosys Admin team to ensure Job dependencies are set as expected.
  • Automated a series of jobs, also improved the efficiency by reducing the total time taken for the jobs by running the jobs in parallel after checking the dependencies.
  • Used the sub graphs to increase the clarity of graph and to impose reusable business restrictions.
  • Developed graphs for serving the Business Users ADHOC requests.
  • Reverse engineered existing graphs to create the necessary design documents like mapping documents and then updated them for additional new functionality.
  • Prepared Unit and Integration testing plans. Involved in Unit and Integration testing using the testing plans.
  • Responsible for End-to-end validation when project migration to higher environments (SIT, UAT). Co-ordinate with SUPPORT teams for on-time and error free CODE migration.
  • Designed migration documents for PROD, PRE-PROD and UAT rehearsals.
  • Provided 24*7 extended supports during the production rollout and bug fixes.
  • Tracking the metrics such as productivity, project status and defects.

Environment: Abinitio, EME, Oracle, SQL server, UNIX Shell scripting, SharePoint, Quality Center, Tivoli

We'd love your feedback!